Integracja Shopify z BigQuery
Dowiedz się, jak utworzyć własną aplikację w Shopify i połączyć Shopify z Google BigQuery w WitCloud, aby pobierać zamówienia, produkty, zwroty płatności, zwroty towarów, nawigację sklepu, stany magazynowe i zgody marketingowe.
Aktualizacja
Wprowadzenie
Ten moduł łączy WitCloud z Twoim sklepem Shopify i zapisuje jego dane w Google Cloud BigQuery: zamówienia, produkty, zwroty płatności, zwroty towarów, menu nawigacyjne sklepu, stany magazynowe w poszczególnych lokalizacjach oraz zgody marketingowe klientów. Dzięki temu możesz analizować wyniki e-commerce obok danych reklamowych.
WitCloud łączy się z Shopify za pomocą Client ID i Client secret własnej aplikacji, którą tworzysz na swoim koncie Shopify. W pierwszej części tej strony pokazujemy, jak ją utworzyć. W drugiej – jak skonfigurować integrację w WitCloud.
Zanim zaczniesz: konfiguracja własnej aplikacji
Kroki w tej sekcji wykonujesz w interfejsie Shopify (Shopify Dev Dashboard i panel administracyjny sklepu), a nie w WitCloud. Shopify może z czasem zmieniać swoje ekrany; obrazy pokazują, jak wyglądały w chwili pisania tej strony. Nie zawierają żadnych prawdziwych danych sklepu.
Krok 1: Otwórz Dev Dashboard
Wejdź do Shopify Dev Dashboard i otwórz sekcję Apps. Kliknij Create app w prawym górnym rogu. Jeśli nie masz jeszcze konta Shopify Partners, możesz je założyć na partners.shopify.com.

Krok 2: Utwórz aplikację
Na ekranie Create an app wybierz Start from Dev Dashboard (karta po prawej). Wpisz App name, na przykład „WitCloud Connector”, i kliknij Create.

Krok 3: Utwórz wersję
W aplikacji otwórz sekcję Versions i kliknij Create a version.

Krok 4: Dodaj uprawnienia (scopes) i opublikuj wersję
W sekcji Access wklej do pola Scopes uprawnienia, których potrzebuje WitCloud.
| Uprawnienie | Wymagane | Do czego służy |
|---|---|---|
read_orders | Tak | Zamówienia, zwroty płatności i zwroty towarów |
read_all_orders | Tak | Zamówienia starsze niż 60 dni |
read_products | Tak | Produkty |
read_discounts | Tak | Kody rabatowe użyte w zamówieniach |
read_returns | Tak | Zwroty towarów |
read_inventory | Tak | Stany magazynowe |
read_locations | Tak | Stany magazynowe w poszczególnych lokalizacjach |
read_customers | Tak | Dane klienta w zamówieniach i zgody marketingowe |
read_online_store_navigation | Nie | Menu nawigacyjne sklepu |
Przy zapisie danych dostępowych WitCloud sprawdza, czy przyznano wszystkie wymagane uprawnienia. Bez read_online_store_navigation integracja działa, ale tabela store_navigation pozostaje pusta albo zgłasza błąd.
Wklej wszystkie uprawnienia naraz, oddzielone przecinkami: read_all_orders,read_customers,read_discounts,read_inventory,read_locations,read_orders,read_products,read_returns,read_online_store_navigation
Tabele zamówień i zgód marketingowych zawierają imiona i nazwiska, adresy e-mail i numery telefonów klientów. Shopify udostępnia je aplikacji dopiero wtedy, gdy w ustawieniach aplikacji poprosisz o dostęp do chronionych danych klientów (protected customer data – pola imienia i nazwiska, e-maila i telefonu). Bez tego dostępu te pola pozostają puste.
Następnie kliknij Release u góry strony.
Krok 5: Potwierdź publikację
W oknie Release this new version? możesz opcjonalnie wpisać nazwę i opis wersji. Kliknij Release, aby potwierdzić.

Shopify jest już połączone, a dodajesz nowe uprawnienia? Dodaj je w aplikacji, opublikuj nową wersję i zaakceptuj nowe uprawnienia w sklepie. W tym czasie integracja działa dalej – błąd zgłaszają tylko tabele, które potrzebują nowych uprawnień.
Krok 6: Zainstaluj aplikację w sklepie
Otwórz sekcję Home aplikacji i kliknij Install app. Shopify poprosi o wybór sklepu (jeśli masz ich kilka) i pokaże uprawnienia, o które prosi aplikacja. Kliknij Install, aby potwierdzić.

Po instalacji Shopify może otworzyć stronę Example Domain. To normalne: aplikacja używa zastępczego adresu URL. Zamknij tę kartę i wróć do Dev Dashboard.
Krok 7: Skopiuj Client ID i sekret
W aplikacji otwórz sekcję Settings. W Credentials skopiuj Client ID, a potem kliknij ikonę oka obok Secret, aby odsłonić sekret, i skopiuj go również. Obie wartości wkleisz w WitCloud. Traktuj sekret jak hasło i nikomu go nie udostępniaj.
Gotowe! Masz Client ID i Client secret potrzebne do autoryzacji Shopify w WitCloud.
Przewodnik konfiguracji
Wykonaj poniższe kroki, aby połączyć Shopify z BigQuery. Po zakończeniu konfiguracji dane ze Shopify są przesyłane do Twojego projektu BigQuery.
Konfiguracja modułu
Przejdź do Integracje w menu i kliknij Dodaj integrację.

Wybierz Shopify z listy dostępnych integracji.

Wpisz Nazwę źródła danych, np. „Shopify PL”. Dobra nazwa pomoże Ci później rozpoznać źródło danych.

Wpisz Adres sklepu: adres swojego sklepu w domenie myshopify.com, razem z https://, np. https://your-store.myshopify.com (nie własną domenę). Przycisk Autoryzuj jest nieaktywny, dopóki nie wpiszesz poprawnego adresu.

Autoryzacja
Jeśli Shopify jest już autoryzowane w WitCloud, wybierz istniejący token z listy Autoryzacja Shopify i pomiń dwa kolejne kroki.
Kliknij Autoryzuj.

W oknie Autoryzuj wpisz Identyfikator klienta (Client ID) i Sekret klienta (Client secret) skopiowane ze Shopify i kliknij Utwórz. Jeśli Shopify nie przyjmie danych albo aplikacji brakuje wymaganego uprawnienia, powód zobaczysz pod formularzem.

Zapisany token zostanie wybrany automatycznie. Token możesz też wybrać z listy Autoryzacja Shopify.

Ustawienia zaawansowane
Kliknij Pokaż ustawienia zaawansowane, aby zobaczyć dwa dodatkowe pola.
W polu Odświeżanie danych (produkty, stany magazynowe) wpisz, co ile godzin mają być odświeżane tabele przechowujące cały katalog (produkty, stany magazynowe w lokalizacjach i nawigacja sklepu). Wartość musi mieścić się między 4 a 12 godzin; domyślnie jest to 4.

W polu Tabele do pobrania możesz usunąć tabele, których nie potrzebujesz: products, orders, returns, refunds, store_navigation, inventory_levels i marketing_consents. Domyślnie wszystkie są zaznaczone, a co najmniej jedna musi pozostać zaznaczona. Pobieranie mniejszej liczby tabel przyspiesza pobieranie danych.

W integracji utworzonej wcześniej nowe tabele nie są dodawane do Tabel do pobrania automatycznie. Edytuj integrację i zaznacz je, aby zacząć je pobierać.
Kliknij Dalej.

Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni, za które dane zostaną pobrane przy pierwszym uruchomieniu – maksymalnie 365.

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.

Gotowe! Dane ze Shopify będą teraz synchronizowane z BigQuery, dając Ci szczegółowy wgląd w wyniki Twojego sklepu.
Schemat danych
Rozwiń poniższe tabele, aby zobaczyć pełny schemat danych pobieranych ze Shopify.
- Zamówienia, zwroty towarów i zwroty płatności są pobierane dzień po dniu, według daty utworzenia. Dzień to dzień kalendarzowy w strefie czasowej harmonogramu integracji.
- Zgody marketingowe też są pobierane dzień po dniu, według daty ostatniej aktualizacji klienta. Dzień zawiera klientów utworzonych tego dnia oraz tych, których zgoda e-mail lub SMS zmieniła się tego dnia, więc najnowszy wiersz każdego klienta to jego aktualna zgoda. Kolumny
is_new,email_consent_changedisms_consent_changedmówią, dlaczego klient znalazł się w danym dniu. - Produkty, stany magazynowe w lokalizacjach i nawigacja sklepu są pobierane jako pełna kopia bieżącego stanu i odświeżane zgodnie z ustawieniem Odświeżanie danych.
Aby poznać aktualną zgodę każdego klienta, weź jego najnowszy wiersz:
SELECT *
FROM `your_project.your_dataset.shopify_marketing_consents_<collect_id>`
WHERE TRUE
QUALIFY ROW_NUMBER() OVER (PARTITION BY admin_graphql_api_id ORDER BY updated_at DESC) = 1
Z zamówieniami połączysz ją po customer.admin_graphql_api_id. Możliwe stany zgody to SUBSCRIBED, NOT_SUBSCRIBED, UNSUBSCRIBED, PENDING, REDACTED i INVALID; zgodę na marketing wyrazili tylko klienci w stanie SUBSCRIBED.
Schemat danych tabeli shopify_orders
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| order_number | NULLABLE | INTEGER |
| number | NULLABLE | INTEGER |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
| processed_at | NULLABLE | TIMESTAMP |
| cancelled_at | NULLABLE | TIMESTAMP |
| currency | NULLABLE | STRING |
| tags | REPEATED | STRING |
| note | NULLABLE | STRING |
| financial_status | NULLABLE | STRING |
| fulfillment_status | NULLABLE | STRING |
| discount_codes | REPEATED | STRING |
| payment_gateway_names | REPEATED | STRING |
| taxes_included | NULLABLE | BOOLEAN |
| subtotal_price_set | NULLABLE | RECORD |
| subtotal_price_set.shop_money | NULLABLE | RECORD |
| subtotal_price_set.shop_money.amount | NULLABLE | FLOAT |
| subtotal_price_set.shop_money.currency_code | NULLABLE | STRING |
| subtotal_price_set.presentment_money | NULLABLE | RECORD |
| subtotal_price_set.presentment_money.amount | NULLABLE | FLOAT |
| subtotal_price_set.presentment_money.currency_code | NULLABLE | STRING |
| total_tax_set | NULLABLE | RECORD |
| total_tax_set.shop_money | NULLABLE | RECORD |
| total_tax_set.shop_money.amount | NULLABLE | FLOAT |
| total_tax_set.shop_money.currency_code | NULLABLE | STRING |
| total_tax_set.presentment_money | NULLABLE | RECORD |
| total_tax_set.presentment_money.amount | NULLABLE | FLOAT |
| total_tax_set.presentment_money.currency_code | NULLABLE | STRING |
| total_price_set | NULLABLE | RECORD |
| total_price_set.shop_money | NULLABLE | RECORD |
| total_price_set.shop_money.amount | NULLABLE | FLOAT |
| total_price_set.shop_money.currency_code | NULLABLE | STRING |
| total_price_set.presentment_money | NULLABLE | RECORD |
| total_price_set.presentment_money.amount | NULLABLE | FLOAT |
| total_price_set.presentment_money.currency_code | NULLABLE | STRING |
| tax_lines | REPEATED | RECORD |
| tax_lines.title | NULLABLE | STRING |
| tax_lines.price_set | NULLABLE | RECORD |
| tax_lines.price_set.shop_money | NULLABLE | RECORD |
| tax_lines.price_set.shop_money.amount | NULLABLE | FLOAT |
| tax_lines.price_set.shop_money.currency_code | NULLABLE | STRING |
| tax_lines.price_set.presentment_money | NULLABLE | RECORD |
| tax_lines.price_set.presentment_money.amount | NULLABLE | FLOAT |
| tax_lines.price_set.presentment_money.currency_code | NULLABLE | STRING |
| tax_lines.rate | NULLABLE | FLOAT |
| tax_lines.rate_percentage | NULLABLE | FLOAT |
| tax_lines.channel_liable | NULLABLE | BOOLEAN |
| customer | NULLABLE | RECORD |
| customer.admin_graphql_api_id | NULLABLE | STRING |
| customer.first_name | NULLABLE | STRING |
| customer.last_name | NULLABLE | STRING |
| customer.email | NULLABLE | STRING |
| billing_address | NULLABLE | RECORD |
| billing_address.name | NULLABLE | STRING |
| billing_address.address1 | NULLABLE | STRING |
| billing_address.address2 | NULLABLE | STRING |
| billing_address.city | NULLABLE | STRING |
| billing_address.province | NULLABLE | STRING |
| billing_address.province_code | NULLABLE | STRING |
| billing_address.country | NULLABLE | STRING |
| billing_address.zip | NULLABLE | STRING |
| billing_address.phone | NULLABLE | STRING |
| shipping_address | NULLABLE | RECORD |
| shipping_address.name | NULLABLE | STRING |
| shipping_address.address1 | NULLABLE | STRING |
| shipping_address.address2 | NULLABLE | STRING |
| shipping_address.city | NULLABLE | STRING |
| shipping_address.province | NULLABLE | STRING |
| shipping_address.province_code | NULLABLE | STRING |
| shipping_address.country | NULLABLE | STRING |
| shipping_address.zip | NULLABLE | STRING |
| shipping_address.phone | NULLABLE | STRING |
| shipping_lines | REPEATED | RECORD |
| shipping_lines.title | NULLABLE | STRING |
| shipping_lines.original_price_set | NULLABLE | RECORD |
| shipping_lines.original_price_set.shop_money | NULLABLE | RECORD |
| shipping_lines.original_price_set.shop_money.amount | NULLABLE | FLOAT |
| shipping_lines.original_price_set.shop_money.currency_code | NULLABLE | STRING |
| shipping_lines.discounted_price_set | NULLABLE | RECORD |
| shipping_lines.discounted_price_set.shop_money | NULLABLE | RECORD |
| shipping_lines.discounted_price_set.shop_money.amount | NULLABLE | FLOAT |
| shipping_lines.discounted_price_set.shop_money.currency_code | NULLABLE | STRING |
| shipping_lines.tax_lines | REPEATED | RECORD |
| shipping_lines.tax_lines.title | NULLABLE | STRING |
| shipping_lines.tax_lines.price_set | NULLABLE | RECORD |
| shipping_lines.tax_lines.price_set.shop_money | NULLABLE | RECORD |
| shipping_lines.tax_lines.price_set.shop_money.amount | NULLABLE | FLOAT |
| shipping_lines.tax_lines.price_set.shop_money.currency_code | NULLABLE | STRING |
| shipping_lines.tax_lines.price_set.presentment_money | NULLABLE | RECORD |
| shipping_lines.tax_lines.price_set.presentment_money.amount | NULLABLE | FLOAT |
| shipping_lines.tax_lines.price_set.presentment_money.currency_code | NULLABLE | STRING |
| shipping_lines.tax_lines.rate | NULLABLE | FLOAT |
| shipping_lines.tax_lines.rate_percentage | NULLABLE | FLOAT |
| shipping_lines.tax_lines.channel_liable | NULLABLE | BOOLEAN |
| fulfillments | REPEATED | RECORD |
| fulfillments.admin_graphql_api_id | NULLABLE | STRING |
| fulfillments.created_at | NULLABLE | TIMESTAMP |
| fulfillments.status | NULLABLE | STRING |
| fulfillments.tracking_info | REPEATED | RECORD |
| fulfillments.tracking_info.company | NULLABLE | STRING |
| fulfillments.tracking_info.number | NULLABLE | STRING |
| fulfillments.tracking_info.url | NULLABLE | STRING |
| line_items | REPEATED | RECORD |
| line_items.admin_graphql_api_id | NULLABLE | STRING |
| line_items.title | NULLABLE | STRING |
| line_items.quantity | NULLABLE | INTEGER |
| line_items.taxable | NULLABLE | BOOLEAN |
| line_items.tax_lines | REPEATED | RECORD |
| line_items.tax_lines.title | NULLABLE | STRING |
| line_items.tax_lines.price_set | NULLABLE | RECORD |
| line_items.tax_lines.price_set.shop_money | NULLABLE | RECORD |
| line_items.tax_lines.price_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.tax_lines.price_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.tax_lines.price_set.presentment_money | NULLABLE | RECORD |
| line_items.tax_lines.price_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.tax_lines.price_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.tax_lines.rate | NULLABLE | FLOAT |
| line_items.tax_lines.rate_percentage | NULLABLE | FLOAT |
| line_items.tax_lines.channel_liable | NULLABLE | BOOLEAN |
| line_items.discounted_total_set | NULLABLE | RECORD |
| line_items.discounted_total_set.shop_money | NULLABLE | RECORD |
| line_items.discounted_total_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discounted_total_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discounted_total_set.presentment_money | NULLABLE | RECORD |
| line_items.discounted_total_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discounted_total_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.original_total_set | NULLABLE | RECORD |
| line_items.original_total_set.shop_money | NULLABLE | RECORD |
| line_items.original_total_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.original_total_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.original_total_set.presentment_money | NULLABLE | RECORD |
| line_items.original_total_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.original_total_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.discount_allocations | REPEATED | RECORD |
| line_items.discount_allocations.allocated_amount_set | NULLABLE | RECORD |
| line_items.discount_allocations.allocated_amount_set.shop_money | NULLABLE | RECORD |
| line_items.discount_allocations.allocated_amount_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discount_allocations.allocated_amount_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discount_allocations.allocated_amount_set.presentment_money | NULLABLE | RECORD |
| line_items.discount_allocations.allocated_amount_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discount_allocations.allocated_amount_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_after_all_discounts_set | NULLABLE | RECORD |
| line_items.discounted_unit_price_after_all_discounts_set.shop_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_after_all_discounts_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_after_all_discounts_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_after_all_discounts_set.presentment_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_after_all_discounts_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_after_all_discounts_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_set | NULLABLE | RECORD |
| line_items.discounted_unit_price_set.shop_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_set.presentment_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.variant | NULLABLE | RECORD |
| line_items.variant.admin_graphql_api_id | NULLABLE | STRING |
| line_items.variant.title | NULLABLE | STRING |
| line_items.variant.sku | NULLABLE | STRING |
| line_items.variant.price | NULLABLE | FLOAT |
| line_items.variant.product | NULLABLE | RECORD |
| line_items.variant.product.admin_graphql_api_id | NULLABLE | STRING |
| line_items.variant.product.title | NULLABLE | STRING |
| line_items.variant.product.handle | NULLABLE | STRING |
| line_items.variant.inventory_item | NULLABLE | RECORD |
| line_items.variant.inventory_item.admin_graphql_api_id | NULLABLE | STRING |
| line_items.variant.inventory_item.measurement | NULLABLE | RECORD |
| line_items.variant.inventory_item.measurement.weight | NULLABLE | RECORD |
| line_items.variant.inventory_item.measurement.weight.value | NULLABLE | FLOAT |
| line_items.variant.inventory_item.measurement.weight.unit | NULLABLE | STRING |
Schemat danych tabeli shopify_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| title | NULLABLE | STRING |
| handle | NULLABLE | STRING |
| status | NULLABLE | STRING |
| tags | REPEATED | STRING |
| vendor | NULLABLE | STRING |
| product_type | NULLABLE | STRING |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
| published_at | NULLABLE | TIMESTAMP |
| body_html | NULLABLE | STRING |
| category_name | NULLABLE | STRING |
| is_bundle | NULLABLE | BOOLEAN |
| bundle_components | REPEATED | RECORD |
| bundle_components.product_id | NULLABLE | STRING |
| bundle_components.admin_graphql_api_id | NULLABLE | STRING |
| bundle_components.product_title | NULLABLE | STRING |
| bundle_components.quantity | NULLABLE | INTEGER |
| collections | REPEATED | RECORD |
| collections.admin_graphql_api_id | NULLABLE | STRING |
| collections.title | NULLABLE | STRING |
| collections.handle | NULLABLE | STRING |
| image | NULLABLE | RECORD |
| image.admin_graphql_api_id | NULLABLE | STRING |
| image.alt | NULLABLE | STRING |
| image.src | NULLABLE | STRING |
| images | REPEATED | RECORD |
| images.admin_graphql_api_id | NULLABLE | STRING |
| images.alt | NULLABLE | STRING |
| images.src | NULLABLE | STRING |
| options | REPEATED | RECORD |
| options.admin_graphql_api_id | NULLABLE | STRING |
| options.name | NULLABLE | STRING |
| options.values | REPEATED | STRING |
| variants | REPEATED | RECORD |
| variants.admin_graphql_api_id | NULLABLE | STRING |
| variants.title | NULLABLE | STRING |
| variants.sku | NULLABLE | STRING |
| variants.price | NULLABLE | FLOAT |
| variants.compare_at_price | NULLABLE | FLOAT |
| variants.barcode | NULLABLE | STRING |
| variants.created_at | NULLABLE | TIMESTAMP |
| variants.updated_at | NULLABLE | TIMESTAMP |
| variants.position | NULLABLE | INTEGER |
| variants.inventory_quantity | NULLABLE | INTEGER |
| variants.selected_options | REPEATED | RECORD |
| variants.selected_options.name | NULLABLE | STRING |
| variants.selected_options.value | NULLABLE | STRING |
| variants.inventory_item | NULLABLE | RECORD |
| variants.inventory_item.admin_graphql_api_id | NULLABLE | STRING |
| variants.inventory_item.measurement | NULLABLE | RECORD |
| variants.inventory_item.measurement.weight | NULLABLE | RECORD |
| variants.inventory_item.measurement.weight.value | NULLABLE | FLOAT |
| variants.inventory_item.measurement.weight.unit | NULLABLE | STRING |
Schemat danych tabeli shopify_refunds
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
| note | NULLABLE | STRING |
| order | NULLABLE | RECORD |
| order.admin_graphql_api_id | NULLABLE | STRING |
| order.name | NULLABLE | STRING |
| order.order_number | NULLABLE | INTEGER |
| total_refunded_set | NULLABLE | RECORD |
| total_refunded_set.shop_money | NULLABLE | RECORD |
| total_refunded_set.shop_money.amount | NULLABLE | FLOAT |
| total_refunded_set.shop_money.currency_code | NULLABLE | STRING |
| total_refunded_set.presentment_money | NULLABLE | RECORD |
| total_refunded_set.presentment_money.amount | NULLABLE | FLOAT |
| total_refunded_set.presentment_money.currency_code | NULLABLE | STRING |
| refund_line_items | REPEATED | RECORD |
| refund_line_items.admin_graphql_api_id | NULLABLE | STRING |
| refund_line_items.quantity | NULLABLE | INTEGER |
| refund_line_items.subtotal_set | NULLABLE | RECORD |
| refund_line_items.subtotal_set.shop_money | NULLABLE | RECORD |
| refund_line_items.subtotal_set.shop_money.amount | NULLABLE | FLOAT |
| refund_line_items.subtotal_set.shop_money.currency_code | NULLABLE | STRING |
| refund_line_items.total_tax_set | NULLABLE | RECORD |
| refund_line_items.total_tax_set.shop_money | NULLABLE | RECORD |
| refund_line_items.total_tax_set.shop_money.amount | NULLABLE | FLOAT |
| refund_line_items.total_tax_set.shop_money.currency_code | NULLABLE | STRING |
| refund_line_items.line_item | NULLABLE | RECORD |
| refund_line_items.line_item.admin_graphql_api_id | NULLABLE | STRING |
| refund_line_items.line_item.title | NULLABLE | STRING |
| refund_line_items.line_item.sku | NULLABLE | STRING |
| transactions | REPEATED | RECORD |
| transactions.admin_graphql_api_id | NULLABLE | STRING |
| transactions.gateway | NULLABLE | STRING |
| transactions.kind | NULLABLE | STRING |
| transactions.status | NULLABLE | STRING |
| transactions.amount_set | NULLABLE | RECORD |
| transactions.amount_set.shop_money | NULLABLE | RECORD |
| transactions.amount_set.shop_money.amount | NULLABLE | FLOAT |
| transactions.amount_set.shop_money.currency_code | NULLABLE | STRING |
Schemat danych tabeli shopify_returns
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| status | NULLABLE | STRING |
| decline_reason | NULLABLE | STRING |
| order | NULLABLE | RECORD |
| order.admin_graphql_api_id | NULLABLE | STRING |
| order.name | NULLABLE | STRING |
| order.order_number | NULLABLE | INTEGER |
| return_line_items | REPEATED | RECORD |
| return_line_items.admin_graphql_api_id | NULLABLE | STRING |
| return_line_items.quantity | NULLABLE | INTEGER |
| return_line_items.return_reason | NULLABLE | STRING |
| return_line_items.return_reason_note | NULLABLE | STRING |
| return_line_items.customer_note | NULLABLE | STRING |
| reverse_fulfillment_orders | REPEATED | RECORD |
| reverse_fulfillment_orders.admin_graphql_api_id | NULLABLE | STRING |
| reverse_fulfillment_orders.status | NULLABLE | STRING |
Schemat danych tabeli shopify_store_navigation
| Field Name | Mode | Type |
|---|---|---|
| menu_handle | NULLABLE | STRING |
| menu_title | NULLABLE | STRING |
| collection_handle | NULLABLE | STRING |
| collection_title | NULLABLE | STRING |
| breadcrumb | NULLABLE | STRING |
| level1_title | NULLABLE | STRING |
| level1_handle | NULLABLE | STRING |
| level2_title | NULLABLE | STRING |
| level2_handle | NULLABLE | STRING |
| level3_title | NULLABLE | STRING |
| level3_handle | NULLABLE | STRING |
Schemat danych tabeli shopify_inventory_levels
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| sku | NULLABLE | STRING |
| variant_admin_graphql_api_id | NULLABLE | STRING |
| variant_title | NULLABLE | STRING |
| product_admin_graphql_api_id | NULLABLE | STRING |
| product_title | NULLABLE | STRING |
| location | NULLABLE | RECORD |
| location.id | NULLABLE | STRING |
| location.admin_graphql_api_id | NULLABLE | STRING |
| location.name | NULLABLE | STRING |
| available | NULLABLE | INTEGER |
| on_hand | NULLABLE | INTEGER |
| committed | NULLABLE | INTEGER |
| incoming | NULLABLE | INTEGER |
| updated_at | NULLABLE | TIMESTAMP |
Schemat danych tabeli shopify_marketing_consents
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| NULLABLE | STRING | |
| phone | NULLABLE | STRING |
| email_marketing_state | NULLABLE | STRING |
| email_marketing_opt_in_level | NULLABLE | STRING |
| email_marketing_updated_at | NULLABLE | TIMESTAMP |
| sms_marketing_state | NULLABLE | STRING |
| sms_marketing_opt_in_level | NULLABLE | STRING |
| sms_marketing_updated_at | NULLABLE | TIMESTAMP |
| data_sale_opt_out | NULLABLE | BOOLEAN |
| is_new | NULLABLE | BOOLEAN |
| email_consent_changed | NULLABLE | BOOLEAN |
| sms_consent_changed | NULLABLE | BOOLEAN |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
