Integracja Amazon z BigQuery
Dowiedz się, jak połączyć Amazon Seller Central z Google BigQuery w WitCloud i automatycznie pobierać zamówienia, oferty, stany magazynowe, zwroty i dane finansowe.
Aktualizacja
Wprowadzenie
Ten moduł łączy się z Amazon Selling Partner API i pozwala pobierać dane z marketplace’ów — zamówienia, oferty, stany magazynowe, zwroty i zdarzenia finansowe — oraz zapisywać je w Google Cloud BigQuery. Lepiej poznaj swoje dane i zoptymalizuj działanie swojej sprzedaży na marketplace’ach.
Przewodnik konfiguracji
Wykonaj poniższe kroki, aby połączyć Amazon z BigQuery. Po zakończeniu konfiguracji dane będą automatycznie trafiać do Twojego projektu BigQuery.
Zanim zaczniesz konfigurację, upewnij się, że masz dostęp administratora do swojego konta Amazon Seller Central.
Konfiguracja modułu
Przejdź do sekcji Integracje w menu > kliknij Dodaj integrację.

Wybierz Amazon z listy dostępnych integracji.

W polu Nazwa źródła danych wpisz nazwę, np. "Amazon EU".

Autoryzacja
Jeśli masz już token Amazon z odpowiednimi uprawnieniami, wybierz go z listy Wybierz konto Amazon i pomiń ten krok.
Kliknij Autoryzuj.

Zostaniesz przekierowany do Amazon Seller Central, gdzie zalogujesz się i autoryzujesz połączenie:
- Zaloguj się na swoje konto Amazon Seller Central.
- Na ekranie "Authorise WitCloud" sprawdź żądane uprawnienia: Amazon Fulfilment, Selling Partner Insights, Finance and Accounting, Inventory and Order Tracking, Product Listing i Brand Analytics.
- Zaznacz pole zgody i kliknij Confirm.

Po powrocie do WitCloud otwórz Wybierz marketplace’y i wybierz marketplace’y Amazon, które chcesz eksportować.

Możesz wybrać kilka marketplace’ów naraz — WitCloud utworzy osobny konektor dla każdego z nich, nazwany od nazwy źródła danych i kodu kraju marketplace’u (na przykład "Amazon EU - FR").

Opcjonalnie kliknij Pokaż ustawienia zaawansowane, aby ustawić Odświeżanie danych (produkty) — jak często, w godzinach, mają być odświeżane tabele takie jak produkty (minimum 4, maksimum 12 godzin) — oraz zawęzić Tabele do pobrania, jeśli nie potrzebujesz wszystkich (co najmniej jedna tabela musi pozostać wybrana).

Kliknij Dalej, aby kontynuować.

Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni, z których chcesz pobrać dane historyczne.

Podczas pierwszej konfiguracji możesz pobrać dane z okresu do 365 dni (12 miesięcy) wstecz.
Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.

Gotowe! Dane z Amazon będą teraz synchronizowane z BigQuery, dzięki czemu dokładnie zobaczysz, jak działa Twoja sprzedaż na marketplace’ach.
Schemat danych
Rozwiń poniższe tabele, aby zobaczyć pełny schemat danych pobieranych z Amazon.
Schemat danych tabeli amazon_orders
| Field Name | Mode | Type |
|---|---|---|
| AmazonOrderId | NULLABLE | STRING |
| SellerOrderId | NULLABLE | STRING |
| PurchaseDate | NULLABLE | TIMESTAMP |
| LastUpdateDate | NULLABLE | TIMESTAMP |
| OrderStatus | NULLABLE | STRING |
| FulfillmentChannel | NULLABLE | STRING |
| SalesChannel | NULLABLE | STRING |
| OrderChannel | NULLABLE | STRING |
| ShipServiceLevel | NULLABLE | STRING |
| OrderTotal | NULLABLE | RECORD |
| OrderTotal.CurrencyCode | NULLABLE | STRING |
| OrderTotal.Amount | NULLABLE | FLOAT |
| NumberOfItemsShipped | NULLABLE | INTEGER |
| NumberOfItemsUnshipped | NULLABLE | INTEGER |
| PaymentMethod | NULLABLE | STRING |
| PaymentMethodDetails | REPEATED | STRING |
| MarketplaceId | NULLABLE | STRING |
| ShipmentServiceLevelCategory | NULLABLE | STRING |
| OrderType | NULLABLE | STRING |
| EarliestShipDate | NULLABLE | TIMESTAMP |
| LatestShipDate | NULLABLE | TIMESTAMP |
| EarliestDeliveryDate | NULLABLE | TIMESTAMP |
| LatestDeliveryDate | NULLABLE | TIMESTAMP |
| IsBusinessOrder | NULLABLE | BOOLEAN |
| IsPrime | NULLABLE | BOOLEAN |
| IsPremiumOrder | NULLABLE | BOOLEAN |
| IsGlobalExpressEnabled | NULLABLE | BOOLEAN |
| IsReplacementOrder | NULLABLE | BOOLEAN |
| ReplacedOrderId | NULLABLE | STRING |
| IsSoldByAB | NULLABLE | BOOLEAN |
| IsIBA | NULLABLE | BOOLEAN |
| IsISPU | NULLABLE | BOOLEAN |
| IsAccessPointOrder | NULLABLE | BOOLEAN |
| HasRegulatedItems | NULLABLE | BOOLEAN |
| DefaultShipFromLocationAddress | NULLABLE | RECORD |
| DefaultShipFromLocationAddress.Name | NULLABLE | STRING |
| DefaultShipFromLocationAddress.City | NULLABLE | STRING |
| DefaultShipFromLocationAddress.StateOrRegion | NULLABLE | STRING |
| DefaultShipFromLocationAddress.PostalCode | NULLABLE | STRING |
| DefaultShipFromLocationAddress.CountryCode | NULLABLE | STRING |
| ShipTo | NULLABLE | RECORD |
| ShipTo.City | NULLABLE | STRING |
| ShipTo.StateOrRegion | NULLABLE | STRING |
| ShipTo.PostalCode | NULLABLE | STRING |
| ShipTo.CountryCode | NULLABLE | STRING |
| items | REPEATED | RECORD |
| items.asin | NULLABLE | STRING |
| items.sku | NULLABLE | STRING |
| items.title | NULLABLE | STRING |
| items.quantity | NULLABLE | INTEGER |
| items.item_status | NULLABLE | STRING |
| items.currency | NULLABLE | STRING |
| items.item_price | NULLABLE | FLOAT |
| items.item_tax | NULLABLE | FLOAT |
| items.shipping_price | NULLABLE | FLOAT |
| items.shipping_tax | NULLABLE | FLOAT |
| items.gift_wrap_price | NULLABLE | FLOAT |
| items.gift_wrap_tax | NULLABLE | FLOAT |
| items.promotion_discount | NULLABLE | FLOAT |
| items.ship_promotion_discount | NULLABLE | FLOAT |
| items.promotion_ids | NULLABLE | STRING |
Schemat danych tabeli amazon_products
| Field Name | Mode | Type |
|---|---|---|
| item_name | NULLABLE | STRING |
| item_description | NULLABLE | STRING |
| listing_id | NULLABLE | STRING |
| seller_sku | NULLABLE | STRING |
| price | NULLABLE | FLOAT |
| quantity | NULLABLE | INTEGER |
| open_date | NULLABLE | STRING |
| image_url | NULLABLE | STRING |
| item_is_marketplace | NULLABLE | STRING |
| product_id_type | NULLABLE | STRING |
| zshop_shipping_fee | NULLABLE | STRING |
| item_note | NULLABLE | STRING |
| item_condition | NULLABLE | STRING |
| zshop_category1 | NULLABLE | STRING |
| zshop_browse_path | NULLABLE | STRING |
| zshop_storefront_feature | NULLABLE | STRING |
| asin1 | NULLABLE | STRING |
| asin2 | NULLABLE | STRING |
| asin3 | NULLABLE | STRING |
| will_ship_internationally | NULLABLE | STRING |
| expedited_shipping | NULLABLE | STRING |
| zshop_boldface | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| bid_for_featured_placement | NULLABLE | STRING |
| add_delete | NULLABLE | STRING |
| pending_quantity | NULLABLE | STRING |
| fulfillment_channel | NULLABLE | STRING |
| merchant_shipping_group | NULLABLE | STRING |
| status | NULLABLE | STRING |
| minimum_order_quantity | NULLABLE | STRING |
| sell_remainder | NULLABLE | STRING |
| marketplace_id | NULLABLE | STRING |
Schemat danych tabeli amazon_inventory
| Field Name | Mode | Type |
|---|---|---|
| asin | NULLABLE | STRING |
| fnSku | NULLABLE | STRING |
| sellerSku | NULLABLE | STRING |
| condition | NULLABLE | STRING |
| lastUpdatedTime | NULLABLE | TIMESTAMP |
| productName | NULLABLE | STRING |
| totalQuantity | NULLABLE | INTEGER |
| stores | REPEATED | STRING |
| marketplace_id | NULLABLE | STRING |
| inventoryDetails | NULLABLE | RECORD |
| inventoryDetails.fulfillableQuantity | NULLABLE | INTEGER |
| inventoryDetails.inboundWorkingQuantity | NULLABLE | INTEGER |
| inventoryDetails.inboundShippedQuantity | NULLABLE | INTEGER |
| inventoryDetails.inboundReceivingQuantity | NULLABLE | INTEGER |
| inventoryDetails.reservedQuantity | NULLABLE | RECORD |
| inventoryDetails.reservedQuantity.totalReservedQuantity | NULLABLE | INTEGER |
| inventoryDetails.reservedQuantity.pendingCustomerOrderQuantity | NULLABLE | INTEGER |
| inventoryDetails.reservedQuantity.pendingTransshipmentQuantity | NULLABLE | INTEGER |
| inventoryDetails.reservedQuantity.fcProcessingQuantity | NULLABLE | INTEGER |
| inventoryDetails.researchingQuantity | NULLABLE | RECORD |
| inventoryDetails.researchingQuantity.totalResearchingQuantity | NULLABLE | INTEGER |
| inventoryDetails.researchingQuantity.researchingQuantityBreakdown | REPEATED | RECORD |
| inventoryDetails.researchingQuantity.researchingQuantityBreakdown.name | NULLABLE | STRING |
| inventoryDetails.researchingQuantity.researchingQuantityBreakdown.quantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity | NULLABLE | RECORD |
| inventoryDetails.unfulfillableQuantity.totalUnfulfillableQuantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity.customerDamagedQuantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity.warehouseDamagedQuantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity.distributorDamagedQuantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity.carrierDamagedQuantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity.defectiveQuantity | NULLABLE | INTEGER |
| inventoryDetails.unfulfillableQuantity.expiredQuantity | NULLABLE | INTEGER |
| inventoryDetails.futureSupplyQuantity | NULLABLE | RECORD |
| inventoryDetails.futureSupplyQuantity.reservedFutureSupplyQuantity | NULLABLE | INTEGER |
| inventoryDetails.futureSupplyQuantity.futureSupplyBuyableQuantity | NULLABLE | INTEGER |
Schemat danych tabeli amazon_categories
| Field Name | Mode | Type |
|---|---|---|
| asin | NULLABLE | STRING |
| marketplace_id | NULLABLE | STRING |
| item_name | NULLABLE | STRING |
| brand | NULLABLE | STRING |
| classifications | REPEATED | RECORD |
| classifications.display_name | NULLABLE | STRING |
| classifications.classification_id | NULLABLE | STRING |
| classifications.parent | NULLABLE | RECORD |
| classifications.parent.display_name | NULLABLE | STRING |
| classifications.parent.classification_id | NULLABLE | STRING |
| classifications.parent.parent | NULLABLE | RECORD |
| classifications.parent.parent.display_name | NULLABLE | STRING |
| classifications.parent.parent.classification_id | NULLABLE | STRING |
| classifications.parent.parent.parent | NULLABLE | RECORD |
| classifications.parent.parent.parent.display_name | NULLABLE | STRING |
| classifications.parent.parent.parent.classification_id | NULLABLE | STRING |
Schemat danych tabeli amazon_returns
| Field Name | Mode | Type |
|---|---|---|
| return_date | NULLABLE | STRING |
| order_id | NULLABLE | STRING |
| sku | NULLABLE | STRING |
| asin | NULLABLE | STRING |
| fnsku | NULLABLE | STRING |
| product_name | NULLABLE | STRING |
| quantity | NULLABLE | INTEGER |
| fulfillment_center_id | NULLABLE | STRING |
| detailed_disposition | NULLABLE | STRING |
| reason | NULLABLE | STRING |
| status | NULLABLE | STRING |
| license_plate_number | NULLABLE | STRING |
| customer_comments | NULLABLE | STRING |
| marketplace_id | NULLABLE | STRING |
Schemat danych tabeli amazon_financial_events
| Field Name | Mode | Type |
|---|---|---|
| event_type | NULLABLE | STRING |
| posted_date | NULLABLE | TIMESTAMP |
| amazon_order_id | NULLABLE | STRING |
| seller_order_id | NULLABLE | STRING |
| marketplace_name | NULLABLE | STRING |
| charges | REPEATED | RECORD |
| charges.type | NULLABLE | STRING |
| charges.currency | NULLABLE | STRING |
| charges.amount | NULLABLE | FLOAT |
| fees | REPEATED | RECORD |
| fees.type | NULLABLE | STRING |
| fees.currency | NULLABLE | STRING |
| fees.amount | NULLABLE | FLOAT |
| details | NULLABLE | STRING |
