# Shopify
# Wprowadzenie
Moduł Shopify pozwala na automatyczne zbieranie danych Twojego sklepu.
# Przykład działania
- Konfigurujemy moduł w platformie udzielając dostępu do sklepu Shopify.
- Ustawiamy moduł w harmonogramie - dane będą gromadzone i przechowywane w zbiorze danych WitCloud.
- Po przetworzeniu tabeli można skorzystać z innych modułów raportowych które są z nią zintegrowane.
# Schemat danych
Po uruchomieniu modułu w zbiorze danych WitCloud pojawią się dwie nowe tabele:
- shopify_orders
Rozwiń aby zapoznać się ze schematem danych
Field name | Type | Mode |
---|---|---|
id | INTEGER | NULLABLE |
admin_graphql_api_id | STRING | NULLABLE |
app_id | INTEGER | NULLABLE |
browser_ip | STRING | NULLABLE |
buyer_accepts_marketing | BOOLEAN | NULLABLE |
cancel_reason | STRING | NULLABLE |
cancelled_at | STRING | NULLABLE |
cart_token | STRING | NULLABLE |
checkout_id | STRING | NULLABLE |
checkout_token | STRING | NULLABLE |
closed_at | STRING | NULLABLE |
confirmed | BOOLEAN | NULLABLE |
contact_email | STRING | NULLABLE |
created_at | TIMESTAMP | NULLABLE |
currency | STRING | NULLABLE |
current_subtotal_price | STRING | NULLABLE |
current_subtotal_price_set | RECORD | NULLABLE |
current_subtotal_price_set. shop_money | RECORD | NULLABLE |
current_subtotal_price_set.shop_money. amount | STRING | NULLABLE |
current_subtotal_price_set.shop_money. currency_code | STRING | NULLABLE |
current_subtotal_price_set. presentment_money | RECORD | NULLABLE |
current_subtotal_price_set.presentment_money. amount | STRING | NULLABLE |
current_subtotal_price_set.presentment_money. currency_code | STRING | NULLABLE |
current_total_discounts | STRING | NULLABLE |
current_total_discounts_set | RECORD | NULLABLE |
current_total_discounts_set. shop_money | RECORD | NULLABLE |
current_total_discounts_set.shop_money. amount | STRING | NULLABLE |
current_total_discounts_set.shop_money. currency_code | STRING | NULLABLE |
current_total_discounts_set. presentment_money | RECORD | NULLABLE |
current_total_discounts_set.presentment_money. amount | STRING | NULLABLE |
current_total_discounts_set.presentment_money. currency_code | STRING | NULLABLE |
current_total_duties_set | STRING | NULLABLE |
current_total_price | STRING | NULLABLE |
current_total_price_set | RECORD | NULLABLE |
current_total_price_set. shop_money | RECORD | NULLABLE |
current_total_price_set.shop_money. amount | STRING | NULLABLE |
current_total_price_set.shop_money. currency_code | STRING | NULLABLE |
current_total_price_set. presentment_money | RECORD | NULLABLE |
current_total_price_set.presentment_money. amount | STRING | NULLABLE |
current_total_price_set.presentment_money. currency_code | STRING | NULLABLE |
current_total_tax | STRING | NULLABLE |
current_total_tax_set | RECORD | NULLABLE |
current_total_tax_set. shop_money | RECORD | NULLABLE |
current_total_tax_set.shop_money. amount | STRING | NULLABLE |
current_total_tax_set.shop_money. currency_code | STRING | NULLABLE |
current_total_tax_set. presentment_money | RECORD | NULLABLE |
current_total_tax_set.presentment_money. amount | STRING | NULLABLE |
current_total_tax_set.presentment_money. currency_code | STRING | NULLABLE |
customer_locale | STRING | NULLABLE |
device_id | STRING | NULLABLE |
STRING | NULLABLE | |
financial_status | STRING | NULLABLE |
fulfillment_status | STRING | NULLABLE |
gateway | STRING | NULLABLE |
landing_site | STRING | NULLABLE |
landing_site_ref | STRING | NULLABLE |
location_id | INTEGER | NULLABLE |
name | STRING | NULLABLE |
note | STRING | NULLABLE |
number | INTEGER | NULLABLE |
order_number | INTEGER | NULLABLE |
order_status_url | STRING | NULLABLE |
original_total_duties_set | STRING | NULLABLE |
payment_gateway_names | STRING | REPEATED |
phone | STRING | NULLABLE |
presentment_currency | STRING | NULLABLE |
processed_at | TIMESTAMP | NULLABLE |
processing_method | STRING | NULLABLE |
reference | STRING | NULLABLE |
referring_site | STRING | NULLABLE |
source_identifier | STRING | NULLABLE |
source_name | STRING | NULLABLE |
source_url | STRING | NULLABLE |
subtotal_price | STRING | NULLABLE |
subtotal_price_set | RECORD | NULLABLE |
subtotal_price_set. shop_money | RECORD | NULLABLE |
subtotal_price_set.shop_money. amount | STRING | NULLABLE |
subtotal_price_set.shop_money. currency_code | STRING | NULLABLE |
subtotal_price_set. presentment_money | RECORD | NULLABLE |
subtotal_price_set.presentment_money. amount | STRING | NULLABLE |
subtotal_price_set.presentment_money. currency_code | STRING | NULLABLE |
tags | STRING | NULLABLE |
taxes_included | BOOLEAN | NULLABLE |
test | BOOLEAN | NULLABLE |
token | STRING | NULLABLE |
total_discounts | STRING | NULLABLE |
total_discounts_set | RECORD | NULLABLE |
total_discounts_set. shop_money | RECORD | NULLABLE |
total_discounts_set.shop_money. amount | STRING | NULLABLE |
total_discounts_set.shop_money. currency_code | STRING | NULLABLE |
total_discounts_set. presentment_money | RECORD | NULLABLE |
total_discounts_set.presentment_money. amount | STRING | NULLABLE |
total_discounts_set.presentment_money. currency_code | STRING | NULLABLE |
total_line_items_price | STRING | NULLABLE |
total_line_items_price_set | RECORD | NULLABLE |
total_line_items_price_set. shop_money | RECORD | NULLABLE |
total_line_items_price_set.shop_money. amount | STRING | NULLABLE |
total_line_items_price_set.shop_money. currency_code | STRING | NULLABLE |
total_line_items_price_set. presentment_money | RECORD | NULLABLE |
total_line_items_price_set.presentment_money. amount | STRING | NULLABLE |
total_line_items_price_set.presentment_money. currency_code | STRING | NULLABLE |
total_outstanding | STRING | NULLABLE |
total_price | STRING | NULLABLE |
total_price_set | RECORD | NULLABLE |
total_price_set. shop_money | RECORD | NULLABLE |
total_price_set.shop_money. amount | STRING | NULLABLE |
total_price_set.shop_money. currency_code | STRING | NULLABLE |
total_price_set. presentment_money | RECORD | NULLABLE |
total_price_set.presentment_money. amount | STRING | NULLABLE |
total_price_set.presentment_money. currency_code | STRING | NULLABLE |
total_price_usd | STRING | NULLABLE |
total_shipping_price_set | RECORD | NULLABLE |
total_shipping_price_set. shop_money | RECORD | NULLABLE |
total_shipping_price_set.shop_money. amount | STRING | NULLABLE |
total_shipping_price_set.shop_money. currency_code | STRING | NULLABLE |
total_shipping_price_set. presentment_money | RECORD | NULLABLE |
total_shipping_price_set.presentment_money. amount | STRING | NULLABLE |
total_shipping_price_set.presentment_money. currency_code | STRING | NULLABLE |
total_tax | STRING | NULLABLE |
total_tax_set | RECORD | NULLABLE |
total_tax_set. shop_money | RECORD | NULLABLE |
total_tax_set.shop_money. amount | STRING | NULLABLE |
total_tax_set.shop_money. currency_code | STRING | NULLABLE |
total_tax_set. presentment_money | RECORD | NULLABLE |
total_tax_set.presentment_money. amount | STRING | NULLABLE |
total_tax_set.presentment_money. currency_code | STRING | NULLABLE |
total_tip_received | STRING | NULLABLE |
total_weight | INTEGER | NULLABLE |
updated_at | TIMESTAMP | NULLABLE |
user_id | INTEGER | NULLABLE |
line_items | RECORD | REPEATED |
line_items. id | INTEGER | NULLABLE |
line_items. admin_graphql_api_id | STRING | NULLABLE |
line_items. fulfillable_quantity | INTEGER | NULLABLE |
line_items. fulfillment_service | STRING | NULLABLE |
line_items. fulfillment_status | STRING | NULLABLE |
line_items. gift_card | BOOLEAN | NULLABLE |
line_items. grams | INTEGER | NULLABLE |
line_items. name | STRING | NULLABLE |
line_items. price | STRING | NULLABLE |
line_items. price_set | RECORD | NULLABLE |
line_items.price_set. shop_money | RECORD | NULLABLE |
line_items.price_set.shop_money. amount | STRING | NULLABLE |
line_items.price_set.shop_money. currency_code | STRING | NULLABLE |
line_items.price_set. presentment_money | RECORD | NULLABLE |
line_items.price_set.presentment_money. amount | STRING | NULLABLE |
line_items.price_set.presentment_money. currency_code | STRING | NULLABLE |
line_items. product_exists | BOOLEAN | NULLABLE |
line_items. product_id | INTEGER | NULLABLE |
line_items. quantity | INTEGER | NULLABLE |
line_items. requires_shipping | BOOLEAN | NULLABLE |
line_items. sku | STRING | NULLABLE |
line_items. taxable | BOOLEAN | NULLABLE |
line_items. title | STRING | NULLABLE |
line_items. total_discount | STRING | NULLABLE |
line_items. total_discount_set | RECORD | NULLABLE |
line_items.total_discount_set. shop_money | RECORD | NULLABLE |
line_items.total_discount_set.shop_money. amount | STRING | NULLABLE |
line_items.total_discount_set.shop_money. currency_code | STRING | NULLABLE |
line_items.total_discount_set. presentment_money | RECORD | NULLABLE |
line_items.total_discount_set.presentment_money. amount | STRING | NULLABLE |
line_items.total_discount_set.presentment_money. currency_code | STRING | NULLABLE |
line_items. variant_id | INTEGER | NULLABLE |
line_items. variant_inventory_management | STRING | NULLABLE |
line_items. variant_title | STRING | NULLABLE |
line_items. vendor | STRING | NULLABLE |
refunds | RECORD | REPEATED |
refunds. id | INTEGER | NULLABLE |
refunds. admin_graphql_api_id | STRING | NULLABLE |
refunds. created_at | TIMESTAMP | NULLABLE |
refunds. note | STRING | NULLABLE |
refunds. order_id | INTEGER | NULLABLE |
refunds. processed_at | TIMESTAMP | NULLABLE |
refunds. restock | BOOLEAN | NULLABLE |
refunds. total_duties_set | RECORD | NULLABLE |
refunds.total_duties_set. shop_money | RECORD | NULLABLE |
refunds.total_duties_set.shop_money. amount | STRING | NULLABLE |
refunds.total_duties_set.shop_money. currency_code | STRING | NULLABLE |
refunds.total_duties_set. presentment_money | RECORD | NULLABLE |
refunds.total_duties_set.presentment_money. amount | STRING | NULLABLE |
refunds.total_duties_set.presentment_money. currency_code | STRING | NULLABLE |
refunds. user_id | INTEGER | NULLABLE |
refunds. transactions | RECORD | REPEATED |
refunds.transactions. id | INTEGER | NULLABLE |
refunds.transactions. admin_graphql_api_id | STRING | NULLABLE |
refunds.transactions. amount | STRING | NULLABLE |
refunds.transactions. authorization | STRING | NULLABLE |
refunds.transactions. created_at | TIMESTAMP | NULLABLE |
refunds.transactions. currency | STRING | NULLABLE |
refunds.transactions. device_id | STRING | NULLABLE |
refunds.transactions. error_code | STRING | NULLABLE |
refunds.transactions. gateway | STRING | NULLABLE |
refunds.transactions. kind | STRING | NULLABLE |
refunds.transactions. location_id | STRING | NULLABLE |
refunds.transactions. message | STRING | NULLABLE |
refunds.transactions. order_id | INTEGER | NULLABLE |
refunds.transactions. parent_id | INTEGER | NULLABLE |
refunds.transactions. processed_at | TIMESTAMP | NULLABLE |
refunds.transactions. source_name | STRING | NULLABLE |
refunds.transactions. status | STRING | NULLABLE |
refunds.transactions. test | BOOLEAN | NULLABLE |
refunds.transactions. user_id | INTEGER | NULLABLE |
refunds. refund_line_items | RECORD | REPEATED |
refunds.refund_line_items. id | INTEGER | NULLABLE |
refunds.refund_line_items. line_item_id | INTEGER | NULLABLE |
refunds.refund_line_items. location_id | INTEGER | NULLABLE |
refunds.refund_line_items. quantity | INTEGER | NULLABLE |
refunds.refund_line_items. restock_type | STRING | NULLABLE |
refunds.refund_line_items. subtotal | INTEGER | NULLABLE |
refunds.refund_line_items. subtotal_set | RECORD | NULLABLE |
refunds.refund_line_items.subtotal_set. shop_money | RECORD | NULLABLE |
refunds.refund_line_items.subtotal_set.shop_money. amount | STRING | NULLABLE |
refunds.refund_line_items.subtotal_set.shop_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items.subtotal_set. presentment_money | RECORD | NULLABLE |
refunds.refund_line_items.subtotal_set.presentment_money. amount | STRING | NULLABLE |
refunds.refund_line_items.subtotal_set.presentment_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items. total_tax | INTEGER | NULLABLE |
refunds.refund_line_items. total_tax_set | RECORD | NULLABLE |
refunds.refund_line_items.total_tax_set. shop_money | RECORD | NULLABLE |
refunds.refund_line_items.total_tax_set.shop_money. amount | STRING | NULLABLE |
refunds.refund_line_items.total_tax_set.shop_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items.total_tax_set. presentment_money | RECORD | NULLABLE |
refunds.refund_line_items.total_tax_set.presentment_money. amount | STRING | NULLABLE |
refunds.refund_line_items.total_tax_set.presentment_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items. line_item | RECORD | NULLABLE |
refunds.refund_line_items.line_item. id | INTEGER | NULLABLE |
refunds.refund_line_items.line_item. admin_graphql_api_id | STRING | NULLABLE |
refunds.refund_line_items.line_item. fulfillable_quantity | INTEGER | NULLABLE |
refunds.refund_line_items.line_item. fulfillment_service | STRING | NULLABLE |
refunds.refund_line_items.line_item. fulfillment_status | STRING | NULLABLE |
refunds.refund_line_items.line_item. gift_card | BOOLEAN | NULLABLE |
refunds.refund_line_items.line_item. grams | INTEGER | NULLABLE |
refunds.refund_line_items.line_item. name | STRING | NULLABLE |
refunds.refund_line_items.line_item. price | STRING | NULLABLE |
refunds.refund_line_items.line_item. price_set | RECORD | NULLABLE |
refunds.refund_line_items.line_item.price_set. shop_money | RECORD | NULLABLE |
refunds.refund_line_items.line_item.price_set.shop_money. amount | STRING | NULLABLE |
refunds.refund_line_items.line_item.price_set.shop_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items.line_item.price_set. presentment_money | RECORD | NULLABLE |
refunds.refund_line_items.line_item.price_set.presentment_money. amount | STRING | NULLABLE |
refunds.refund_line_items.line_item.price_set.presentment_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items.line_item. product_exists | BOOLEAN | NULLABLE |
refunds.refund_line_items.line_item. product_id | INTEGER | NULLABLE |
refunds.refund_line_items.line_item. quantity | INTEGER | NULLABLE |
refunds.refund_line_items.line_item. requires_shipping | BOOLEAN | NULLABLE |
refunds.refund_line_items.line_item. sku | STRING | NULLABLE |
refunds.refund_line_items.line_item. taxable | BOOLEAN | NULLABLE |
refunds.refund_line_items.line_item. title | STRING | NULLABLE |
refunds.refund_line_items.line_item. total_discount | STRING | NULLABLE |
refunds.refund_line_items.line_item. total_discount_set | RECORD | NULLABLE |
refunds.refund_line_items.line_item.total_discount_set. shop_money | RECORD | NULLABLE |
refunds.refund_line_items.line_item.total_discount_set.shop_money. amount | STRING | NULLABLE |
refunds.refund_line_items.line_item.total_discount_set.shop_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items.line_item.total_discount_set. presentment_money | RECORD | NULLABLE |
refunds.refund_line_items.line_item.total_discount_set.presentment_money. amount | STRING | NULLABLE |
refunds.refund_line_items.line_item.total_discount_set.presentment_money. currency_code | STRING | NULLABLE |
refunds.refund_line_items.line_item. variant_id | INTEGER | NULLABLE |
refunds.refund_line_items.line_item. variant_inventory_management | STRING | NULLABLE |
refunds.refund_line_items.line_item. variant_title | STRING | NULLABLE |
refunds.refund_line_items.line_item. vendor | STRING | NULLABLE |
- shopify_products
Rozwiń aby zapoznać się ze schematem danych
Field name | Type | Mode |
---|---|---|
id | INTEGER | NULLABLE |
title | STRING | NULLABLE |
body_html | STRING | NULLABLE |
vendor | STRING | NULLABLE |
product_type | STRING | NULLABLE |
created_at | TIMESTAMP | NULLABLE |
handle | STRING | NULLABLE |
updated_at | TIMESTAMP | NULLABLE |
published_at | STRING | NULLABLE |
template_suffix | STRING | NULLABLE |
status | STRING | NULLABLE |
published_scope | STRING | NULLABLE |
tags | STRING | NULLABLE |
admin_graphql_api_id | STRING | NULLABLE |
variants | RECORD | REPEATED |
variants. id | INTEGER | NULLABLE |
variants. product_id | INTEGER | NULLABLE |
variants. title | STRING | NULLABLE |
variants. price | STRING | NULLABLE |
variants. sku | STRING | NULLABLE |
variants. position | INTEGER | NULLABLE |
variants. inventory_policy | STRING | NULLABLE |
variants. compare_at_price | STRING | NULLABLE |
variants. fulfillment_service | STRING | NULLABLE |
variants. inventory_management | STRING | NULLABLE |
variants. option1 | STRING | NULLABLE |
variants. option2 | STRING | NULLABLE |
variants. option3 | STRING | NULLABLE |
variants. created_at | TIMESTAMP | NULLABLE |
variants. updated_at | TIMESTAMP | NULLABLE |
variants. taxable | BOOLEAN | NULLABLE |
variants. barcode | STRING | NULLABLE |
variants. grams | INTEGER | NULLABLE |
variants. image_id | STRING | NULLABLE |
variants. weight | INTEGER | NULLABLE |
variants. weight_unit | STRING | NULLABLE |
variants. inventory_item_id | INTEGER | NULLABLE |
variants. inventory_quantity | INTEGER | NULLABLE |
variants. old_inventory_quantity | INTEGER | NULLABLE |
variants. requires_shipping | BOOLEAN | NULLABLE |
variants. admin_graphql_api_id | STRING | NULLABLE |
options | RECORD | REPEATED |
options. id | INTEGER | NULLABLE |
options. product_id | INTEGER | NULLABLE |
options. name | STRING | NULLABLE |
options. position | INTEGER | NULLABLE |
options. values | STRING | REPEATED |
image | STRING | NULLABLE |
# Konfiguracja
# Zanim zaczniesz
TIP
Upewnij się, że masz odpowiedni dostęp do sklepu Shopify
# Rozpocznij tworzenie modułu
Z menu po lewej stronie wybierz zakładkę Collect, następnie kliknij w przycisk Add new Data Collect.
Z listy dostępnych modułów wybieramy Shopify
# Początkowe ustawienia
W pierwszym kroku mamy tylko jedno pole do wypełnienia.
Collect name - nazwa naszego modułu. Będzie on widoczny pod tą nazwą w innych miejscach w platformie.
# Autoryzacja z Shopify
W następnym kroku musimy przyznać WitCloud dostęp do Shopify. Konieczne jest, aby WitCloud mógł pobierać dane.
Aby to zrobić, naciśnij przycisk Click here to authorize
Wpisz adres swojego sklepu bez prefiksu http / https.
Następnie wypełnij formularz logowania na platformie Shopify.
Po prawidłowej autoryzacji wybierz swoje konto z listy i kliknij przycisk Finish
# Ustawienie modułu w harmonogramie
Twój moduł Shopify jest już utworzony w WitCloud 📊. Ostatnim krokiem jest ustalenie harmonogramu i uwzględnienie w nim naszego modułu. O tym jak to zrobić możesz przeczytać tutaj link (opens new window).
← Shoper TikTok Ads →