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.

Integrations list with the Add integration button

Select Amazon from the list of available integrations.

Integration catalog with Amazon selected

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

Collect name field filled in with an example name

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.

Authorize button next to the Select Amazon account field

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.

Amazon Seller Central Authorise WitCloud consent screen

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

Select marketplaces drop-down open with example Amazon marketplaces

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").

Select marketplaces field with two example marketplaces selected

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).

Advanced settings with Data freshness (products) and Tables to collect

Click Next to continue.

Collect settings filled in with the Next button

Historical data and scheduling

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

Historical Data field with the number of days

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.

Historical Data filled in with the Create button

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 NameModeType
AmazonOrderIdNULLABLESTRING
SellerOrderIdNULLABLESTRING
PurchaseDateNULLABLETIMESTAMP
LastUpdateDateNULLABLETIMESTAMP
OrderStatusNULLABLESTRING
FulfillmentChannelNULLABLESTRING
SalesChannelNULLABLESTRING
OrderChannelNULLABLESTRING
ShipServiceLevelNULLABLESTRING
OrderTotalNULLABLERECORD
OrderTotal.CurrencyCodeNULLABLESTRING
OrderTotal.AmountNULLABLEFLOAT
NumberOfItemsShippedNULLABLEINTEGER
NumberOfItemsUnshippedNULLABLEINTEGER
PaymentMethodNULLABLESTRING
PaymentMethodDetailsREPEATEDSTRING
MarketplaceIdNULLABLESTRING
ShipmentServiceLevelCategoryNULLABLESTRING
OrderTypeNULLABLESTRING
EarliestShipDateNULLABLETIMESTAMP
LatestShipDateNULLABLETIMESTAMP
EarliestDeliveryDateNULLABLETIMESTAMP
LatestDeliveryDateNULLABLETIMESTAMP
IsBusinessOrderNULLABLEBOOLEAN
IsPrimeNULLABLEBOOLEAN
IsPremiumOrderNULLABLEBOOLEAN
IsGlobalExpressEnabledNULLABLEBOOLEAN
IsReplacementOrderNULLABLEBOOLEAN
ReplacedOrderIdNULLABLESTRING
IsSoldByABNULLABLEBOOLEAN
IsIBANULLABLEBOOLEAN
IsISPUNULLABLEBOOLEAN
IsAccessPointOrderNULLABLEBOOLEAN
HasRegulatedItemsNULLABLEBOOLEAN
DefaultShipFromLocationAddressNULLABLERECORD
DefaultShipFromLocationAddress.NameNULLABLESTRING
DefaultShipFromLocationAddress.CityNULLABLESTRING
DefaultShipFromLocationAddress.StateOrRegionNULLABLESTRING
DefaultShipFromLocationAddress.PostalCodeNULLABLESTRING
DefaultShipFromLocationAddress.CountryCodeNULLABLESTRING
ShipToNULLABLERECORD
ShipTo.CityNULLABLESTRING
ShipTo.StateOrRegionNULLABLESTRING
ShipTo.PostalCodeNULLABLESTRING
ShipTo.CountryCodeNULLABLESTRING
itemsREPEATEDRECORD
items.asinNULLABLESTRING
items.skuNULLABLESTRING
items.titleNULLABLESTRING
items.quantityNULLABLEINTEGER
items.item_statusNULLABLESTRING
items.currencyNULLABLESTRING
items.item_priceNULLABLEFLOAT
items.item_taxNULLABLEFLOAT
items.shipping_priceNULLABLEFLOAT
items.shipping_taxNULLABLEFLOAT
items.gift_wrap_priceNULLABLEFLOAT
items.gift_wrap_taxNULLABLEFLOAT
items.promotion_discountNULLABLEFLOAT
items.ship_promotion_discountNULLABLEFLOAT
items.promotion_idsNULLABLESTRING
Data schema for amazon_products
Field NameModeType
item_nameNULLABLESTRING
item_descriptionNULLABLESTRING
listing_idNULLABLESTRING
seller_skuNULLABLESTRING
priceNULLABLEFLOAT
quantityNULLABLEINTEGER
open_dateNULLABLESTRING
image_urlNULLABLESTRING
item_is_marketplaceNULLABLESTRING
product_id_typeNULLABLESTRING
zshop_shipping_feeNULLABLESTRING
item_noteNULLABLESTRING
item_conditionNULLABLESTRING
zshop_category1NULLABLESTRING
zshop_browse_pathNULLABLESTRING
zshop_storefront_featureNULLABLESTRING
asin1NULLABLESTRING
asin2NULLABLESTRING
asin3NULLABLESTRING
will_ship_internationallyNULLABLESTRING
expedited_shippingNULLABLESTRING
zshop_boldfaceNULLABLESTRING
product_idNULLABLESTRING
bid_for_featured_placementNULLABLESTRING
add_deleteNULLABLESTRING
pending_quantityNULLABLESTRING
fulfillment_channelNULLABLESTRING
merchant_shipping_groupNULLABLESTRING
statusNULLABLESTRING
minimum_order_quantityNULLABLESTRING
sell_remainderNULLABLESTRING
marketplace_idNULLABLESTRING
Data schema for amazon_inventory
Field NameModeType
asinNULLABLESTRING
fnSkuNULLABLESTRING
sellerSkuNULLABLESTRING
conditionNULLABLESTRING
lastUpdatedTimeNULLABLETIMESTAMP
productNameNULLABLESTRING
totalQuantityNULLABLEINTEGER
storesREPEATEDSTRING
marketplace_idNULLABLESTRING
inventoryDetailsNULLABLERECORD
inventoryDetails.fulfillableQuantityNULLABLEINTEGER
inventoryDetails.inboundWorkingQuantityNULLABLEINTEGER
inventoryDetails.inboundShippedQuantityNULLABLEINTEGER
inventoryDetails.inboundReceivingQuantityNULLABLEINTEGER
inventoryDetails.reservedQuantityNULLABLERECORD
inventoryDetails.reservedQuantity.totalReservedQuantityNULLABLEINTEGER
inventoryDetails.reservedQuantity.pendingCustomerOrderQuantityNULLABLEINTEGER
inventoryDetails.reservedQuantity.pendingTransshipmentQuantityNULLABLEINTEGER
inventoryDetails.reservedQuantity.fcProcessingQuantityNULLABLEINTEGER
inventoryDetails.researchingQuantityNULLABLERECORD
inventoryDetails.researchingQuantity.totalResearchingQuantityNULLABLEINTEGER
inventoryDetails.researchingQuantity.researchingQuantityBreakdownREPEATEDRECORD
inventoryDetails.researchingQuantity.researchingQuantityBreakdown.nameNULLABLESTRING
inventoryDetails.researchingQuantity.researchingQuantityBreakdown.quantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantityNULLABLERECORD
inventoryDetails.unfulfillableQuantity.totalUnfulfillableQuantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantity.customerDamagedQuantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantity.warehouseDamagedQuantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantity.distributorDamagedQuantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantity.carrierDamagedQuantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantity.defectiveQuantityNULLABLEINTEGER
inventoryDetails.unfulfillableQuantity.expiredQuantityNULLABLEINTEGER
inventoryDetails.futureSupplyQuantityNULLABLERECORD
inventoryDetails.futureSupplyQuantity.reservedFutureSupplyQuantityNULLABLEINTEGER
inventoryDetails.futureSupplyQuantity.futureSupplyBuyableQuantityNULLABLEINTEGER
Data schema for amazon_categories
Field NameModeType
asinNULLABLESTRING
marketplace_idNULLABLESTRING
item_nameNULLABLESTRING
brandNULLABLESTRING
classificationsREPEATEDRECORD
classifications.display_nameNULLABLESTRING
classifications.classification_idNULLABLESTRING
classifications.parentNULLABLERECORD
classifications.parent.display_nameNULLABLESTRING
classifications.parent.classification_idNULLABLESTRING
classifications.parent.parentNULLABLERECORD
classifications.parent.parent.display_nameNULLABLESTRING
classifications.parent.parent.classification_idNULLABLESTRING
classifications.parent.parent.parentNULLABLERECORD
classifications.parent.parent.parent.display_nameNULLABLESTRING
classifications.parent.parent.parent.classification_idNULLABLESTRING
Data schema for amazon_returns
Field NameModeType
return_dateNULLABLESTRING
order_idNULLABLESTRING
skuNULLABLESTRING
asinNULLABLESTRING
fnskuNULLABLESTRING
product_nameNULLABLESTRING
quantityNULLABLEINTEGER
fulfillment_center_idNULLABLESTRING
detailed_dispositionNULLABLESTRING
reasonNULLABLESTRING
statusNULLABLESTRING
license_plate_numberNULLABLESTRING
customer_commentsNULLABLESTRING
marketplace_idNULLABLESTRING
Data schema for amazon_financial_events
Field NameModeType
event_typeNULLABLESTRING
posted_dateNULLABLETIMESTAMP
amazon_order_idNULLABLESTRING
seller_order_idNULLABLESTRING
marketplace_nameNULLABLESTRING
chargesREPEATEDRECORD
charges.typeNULLABLESTRING
charges.currencyNULLABLESTRING
charges.amountNULLABLEFLOAT
feesREPEATEDRECORD
fees.typeNULLABLESTRING
fees.currencyNULLABLESTRING
fees.amountNULLABLEFLOAT
detailsNULLABLESTRING