Integration of Amazon with BigQuery
Learn how to connect Amazon Seller Central to Google BigQuery using WitCloud and automatically fetch orders, listings, inventory, returns, and financial data.
Updated
Introduction
This module integrates with the Amazon Selling Partner API, enabling you to collect marketplace data — orders, listings, inventory, returns and financial events — and store it in Google Cloud BigQuery. Gain deeper insights into your data and optimize the performance of your marketplace operations.
Configuration guide
Follow the steps below to connect Amazon with BigQuery. Once the setup is complete, your data will be automatically transferred to your BigQuery project.
Make sure you have admin access to your Amazon Seller Central account before starting the configuration.
Module setup
Go to the Integrations section in the menu > Click Add integration.

Select Amazon from the list of available integrations.

Enter the Collect name, e.g., "Amazon EU".

Authorization
If you have already created an Amazon token and it still has the correct permissions, simply pick it from the Select Amazon account drop-down and skip this step.
Click Authorize.

You'll be redirected to Amazon Seller Central to log in and authorize the connection:
- Log in to your Amazon Seller Central account.
- On the "Authorise WitCloud" screen, review the requested access: Amazon Fulfilment, Selling Partner Insights, Finance and Accounting, Inventory and Order Tracking, Product Listing, and Brand Analytics.
- Check the consent box and click Confirm.

Back in WitCloud, open Select marketplaces and choose the Amazon marketplaces you wish to export.

You can select multiple marketplaces at once — WitCloud creates a separate data collect for each one, named after your collect name and the marketplace's country code (for example "Amazon EU - FR").

Optionally, click Show advanced settings to set the Data freshness (products) — how often, in hours, tables like products should be refreshed (minimum 4, maximum 12 hours) — and to narrow down the Tables to collect if you don't need every table (at least one table must stay selected).

Click Next to continue.

Historical data and scheduling
In Historical Data, enter the number of days for which you want to fetch historical data.

During the initial setup, you can retrieve data going back up to 365 days (12 months).
A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your Amazon data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your marketplace operations.
Data schema
Expand the tables below to view the full data schema collected from Amazon.
Data schema for 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 |
Data schema for 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 |
Data schema for 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 |
Data schema for 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 |
Data schema for 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 |
Data schema for 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 |
