Amazon Selling Partner connector

Kaivo is a fully managed data platform that syncs your Amazon Selling Partner data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your e-commerce data instead of moving it.

What is the Amazon Selling Partner connector

Sync your Amazon Selling Partner orders, financial events, and FBA reports into BigQuery with Kaivo to track marketplace sales, fees, and fulfilment.

Category	E-commerce
Authentication	OAuth
Setup	On request, contact us to enable it

Getting started with the Amazon Selling Partner connector

1. Sign up for Kaivo and create a workspace.
2. Ask us to enable the Amazon Selling Partner connector for your workspace. You can reach our team from the chat in the app.
3. Choose which tables to sync.
4. Wait for the initial sync to finish.
5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Amazon Selling Partner

Connect by signing in to your Amazon Seller Partner account. Kaivo runs the connection for you, so you never share a password.

Configuring the Amazon Selling Partner connector

When you set up the connector, you provide:

Field	Description
AWS Environment
Select the AWS Environment.

| | AWS Region |

Select the AWS Region.

| | Account Type |

Whether this is a Seller or Vendor account.

| | Start Date |

Any data before this date will not be fetched.

| | Sales and Traffic Report ASIN Granularity |

The level of ASIN granularity for the Sales and Traffic report streams.

| | Report Options |

Additional information passed to reports. This varies by report type.

| | Include PII |

When enabled, the connector requests access to PII fields such as buyer info and shipping address. Requires an approved Restricted Data Token.

|

Tables and columns synced from Amazon Selling Partner

Kaivo syncs 53 tables from Amazon Selling Partner into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

GET_AFN_INVENTORY_DATA (9 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
seller_sku	STRING	The Seller SKU for the item, which is unique within the seller’s inventory.
fulfillment_channel_sku	STRING	The SKU assigned to the item by the fulfillment network.
asin	STRING	The unique identifier for the product in the Amazon catalog.
condition_type	STRING	The condition type of the item, such as ‘New’, ‘Used’, or ‘Refurbished’.
warehouse_condition_code	STRING	The warehouse code indicating the storage location and condition of the item.
quantity_available	STRING	The total quantity of this item available in the fulfillment center.
data_end_time	DATE	The end time for the data provided, formatted as a date.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_AFN_INVENTORY_DATA_BY_COUNTRY (9 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
seller_sku	STRING	Unique SKU assigned by the seller for the product
fulfillment_channel_sku	STRING	Unique SKU assigned by the seller for fulfillment
asin	STRING	Unique Amazon Standard Identification Number assigned to the product
condition_type	STRING	Type of condition (new, used, refurbished, etc.) of the product
country	STRING	Country code identifying the country the inventory data pertains to
quantity_for_local_fulfillment	STRING	Quantity of the product available for local fulfillment
data_end_time	DATE	Timestamp indicating when the data was last updated
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL (51 columns), Amazon Fulfilled Data General Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amazon_order_id	STRING	The unique identifier for the Amazon order.
merchant_order_id	STRING	The unique identifier for the merchant’s order.
shipment_id	STRING	The unique identifier for the shipment.
shipment_item_id	STRING	The unique identifier for the shipment item.
amazon_order_item_id	STRING	The unique identifier for the Amazon order item.
merchant_order_item_id	STRING	The unique identifier for the merchant’s order item.
purchase_date	TIMESTAMP	The date when the purchase was made.
payments_date	TIMESTAMP	The date when payments were made.
shipment_date	TIMESTAMP	The date when the shipment is made.
… and 41 more columns

GET_BRAND_ANALYTICS_ALTERNATE_PURCHASE_REPORT (8 columns), Brand Analytics Alternate Purchase Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
start_date	DATE
end_date	DATE
asin	STRING
purchased_asin	STRING
purchased_rank	INT64
purchased_pct	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_BRAND_ANALYTICS_ITEM_COMPARISON_REPORT (8 columns), Brand Analytics Item Comparison Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
start_date	DATE
end_date	DATE
asin	STRING
compared_asin	STRING
compared_rank	INT64
compared_pct	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT (8 columns), Brand Analytics Market Basket Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
start_date	DATE
end_date	DATE
asin	STRING
purchased_with_asin	STRING
purchased_with_rank	INT64
combination_pct	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT (11 columns), Brand Analytics Repeat Purchase Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
start_date	DATE
end_date	DATE
asin	STRING
orders	INT64
unique_customers	INT64
repeat_customers_pct_total	FLOAT64
repeat_purchase_revenue__amount	FLOAT64
repeat_purchase_revenue__currency_code	STRING
repeat_purchase_revenue_pct_total	FLOAT64
… and 1 more columns

GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT (9 columns), Brand Analytics Search Terms Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
department_name	STRING
search_term	STRING
search_frequency_rank	FLOAT64
clicked_asin	STRING
click_share_rank	FLOAT64
click_share	FLOAT64
conversion_share	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA (37 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku	STRING	Stock Keeping Unit representing the product
fnsku	STRING	Fulfillment Network Stock Keeping Unit representing the product
asin	STRING	Amazon Standard Identification Number representing the product
product_name	STRING	Name of the product
product_group	STRING	Group to which the product belongs
brand	STRING	Brand of the product
fulfilled_by	STRING	Indicates whether the product is fulfilled by the seller or Amazon
your_price	STRING	Price set by the seller for the product
sales_price	STRING	Price at which the product is sold
… and 27 more columns

GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA (16 columns), FBA customer returns report Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
return_date	TIMESTAMP	The date and time when the return was initiated
order_id	STRING	The unique identifier of the order associated with the return
sku	STRING	Stock Keeping Unit of the product
asin	STRING	The Amazon Standard Identification Number of the product
fnsku	STRING	Fulfillment Network Stock Keeping Unit of the product
product_name	STRING	The name of the product returned by the customer
quantity	STRING	The quantity of the item returned
fulfillment_center_id	STRING	Identification of the fulfillment center where the return was processed
detailed_disposition	STRING	Detailed description of the disposition of the returned item
… and 6 more columns

GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA (12 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
shipment_date	TIMESTAMP	The date and time when the shipment was made.
currency	STRING	The currency used for the monetary values in the data.
item_promotion_discount	STRING	The discount amount applied to the item as part of the promotion.
item_promotion_id	STRING	The unique identifier for the item promotion.
description	STRING	A description of the promotion or shipment.
promotion_rule_value	STRING	The value associated with the promotion rule.
amazon_order_id	STRING	The unique identifier for the Amazon order associated with the shipment.
shipment_id	STRING	The unique identifier for the shipment.
shipment_item_id	STRING	The unique identifier for the item within the shipment.
… and 2 more columns

GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA (12 columns), FBA Fulfillment Customer Shipment Replacement Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
shipment_date	TIMESTAMP	Date and time of the free replacement shipment in DD-MON-YYYY format
sku	STRING	Unique identifier of the item used by the seller
asin	STRING	Amazon Standard Inventory Number
fulfillment_center_id	STRING	ID of the fulfillment center shipping this unit
original_fulfillment_center_id	STRING	ID of the original fulfillment center shipping the free replaced item
quantity	STRING	Number of units shipped in the replacement shipment
replacement_reason_code	STRING	Code indicating the reason for the replacement
replacement_customer_order_id	STRING	Order ID of the replacement order for the original item
original_amazon_order_id	STRING	Order ID of the original shipment for the replacement item
… and 2 more columns

GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA (18 columns), FBA Fulfillment Removal Order Detail Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
request_date	TIMESTAMP	The date and time the removal order was requested
order_id	STRING	The unique identifier for the order associated with the removal
order_type	STRING	The type of the removal order
order_status	STRING	The status of the removal order
last_updated_date	TIMESTAMP	The date and time when the data was last updated
sku	STRING	The Stock Keeping Unit for the item
fnsku	STRING	The Fulfillment Network Stock Keeping Unit for the item
disposition	STRING	The method used to dispose of the items
requested_quantity	STRING	The quantity of items requested for removal
… and 8 more columns

GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA (12 columns), FBA Fulfillment Removal Shipment Detail Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
removal_date	TIMESTAMP	The date and time when the removal of the product from fulfillment centers started.
order_id	STRING	The unique identification number for the order associated with the shipment.
shipment_date	TIMESTAMP	The date and time when the removal shipment was dispatched.
sku	STRING	Stock Keeping Unit (SKU) for the product being removed.
fnsku	STRING	The Fulfilled Network Stock Keeping Unit (FNSKU) associated with the product.
disposition	STRING	The status or action taken on the removal shipment.
quantity_shipped	STRING	The quantity of products shipped in the removal shipment.
carrier	STRING	The carrier responsible for shipping the removal shipment.
tracking_number	STRING	The unique tracking number assigned to the removal shipment.
… and 2 more columns

GET_FBA_INVENTORY_PLANNING_DATA (80 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
snapshot_date	TIMESTAMP	Date and time when the inventory snapshot was taken
sku	STRING	Stock Keeping Unit (SKU) for the product
fnsku	STRING	Fulfillment Network SKU for the product
asin	STRING	Unique identifier for the product in Amazon’s catalog
product_name	STRING	Name of the product
condition	STRING	Condition of the product (e.g., New, Used, Refurbished)
available	STRING	Quantity of the product currently available for sale
pending_removal_quantity	STRING	Quantity of the product pending removal from inventory
inv_age_0_to_90_days	STRING	Quantity of product inventory aged between 0 to 90 days
… and 70 more columns

GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku	STRING	Stock Keeping Unit, a unique identifier for the product
fnsku	STRING	Fulfillment Network SKU, a unique identifier for a product in Amazon’s fulfillment network
asin	STRING	Unique Amazon Standard Identification Number for the product
product_name	STRING	The name or title of the product
condition	STRING	The condition of the product (e.g., New, Used, Refurbished)
your_price	STRING	The price at which you are selling the product
mfn_listing_exists	STRING	Indicator if the Merchant Fulfilled Network listing exists
mfn_fulfillable_quantity	STRING	The quantity of Merchant Fulfilled Network inventory available for sale
afn_listing_exists	STRING	Indicator if the FBA listing exists on Amazon’s marketplace
… and 14 more columns

GET_FBA_REIMBURSEMENTS_DATA (21 columns), FBA Reimbursements Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
approval_date	TIMESTAMP	The date and time when the reimbursement was approved.
reimbursement_id	STRING	The unique identifier for the reimbursement record.
case_id	STRING	The case ID associated with the reimbursement.
amazon_order_id	STRING	The unique identifier for the Amazon order related to the reimbursement.
reason	STRING	The reason provided for the reimbursement.
sku	STRING	The Stock Keeping Unit (SKU) of the product.
fnsku	STRING	The Fulfillment Network SKU of the product.
asin	STRING	The Amazon Standard Identification Number (ASIN) of the product.
product_name	STRING	The name of the product for which the reimbursement was issued.
… and 11 more columns

GET_FBA_STORAGE_FEE_CHARGES_DATA (34 columns), FBA Storage Fees Report

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
asin	STRING	Unique identifier for the Amazon Standard Identification Number.
fnsku	STRING	Fulfillment Network Stock Keeping Unit for the item.
product_name	STRING	Name of the product or item.
fulfillment_center	STRING	Location identifier for the fulfillment center.
country_code	STRING	Country code where the data is applicable.
longest_side	STRING	Length of the longest side of the item.
median_side	STRING	Length of the median side of the item.
shortest_side	STRING	Length of the shortest side of the item.
measurement_units	STRING	Units used for measurements (e.g., inches, centimeters).
… and 24 more columns

GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING (28 columns), Flat File All Orders Data by Last Update Date General Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
order_id	STRING	The unique identifier of the order.
order_item_id	STRING	The unique identifier of the order item.
purchase_date	TIMESTAMP	The date and time of the purchase.
payments_date	TIMESTAMP	The date and time of the payment.
reporting_date	TIMESTAMP	The date and time when the data is reported.
promise_date	TIMESTAMP	The promised delivery date and time.
days_past_promise	STRING	Number of days past the promised delivery date.
buyer_email	STRING	The email address of the buyer.
buyer_phone_number	STRING	The phone number of the buyer.
… and 18 more columns

GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL (36 columns), Flat File All Orders Data by Last Update Date General Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amazon_order_id	STRING	The unique identifier for the Amazon order.
merchant_order_id	STRING	The unique identifier for the merchant’s order.
purchase_date	TIMESTAMP	The date and time of the order purchase.
last_updated_date	TIMESTAMP	The date and time of the last update to the order.
order_status	STRING	The status of the order.
fulfillment_channel	STRING	The channel through which the order was fulfilled.
sales_channel	STRING	The channel through which the sale was made.
order_channel	STRING	The channel through which the order was placed.
ship_service_level	STRING	The service level of the shipping method.
… and 26 more columns

GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL (36 columns), Flat File All Orders Data by Order Date General Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amazon_order_id	STRING	Unique identifier for the order on Amazon platform
merchant_order_id	STRING	Identifier for the order set by the merchant
purchase_date	TIMESTAMP	Timestamp of the order purchase date
last_updated_date	TIMESTAMP	Timestamp of the last update for the order
order_status	STRING	Status of the order (e.g., Pending, Shipped)
fulfillment_channel	STRING	Channel through which the order is fulfilled (e.g., FBA, Seller Fulfilled)
sales_channel	STRING	Channel through which the sale was made
order_channel	STRING	Channel through which the order was placed
ship_service_level	STRING	Service level of shipping (e.g., Standard, Expedited)
… and 26 more columns

GET_FLAT_FILE_ARCHIVED_ORDERS_DATA_BY_ORDER_DATE (34 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amazon_order_id	STRING	The unique identifier for the Amazon order
merchant_order_id	STRING	The merchant’s unique identifier for the order
purchase_date	TIMESTAMP	The date and time when the order was purchased
last_updated_date	TIMESTAMP	The date and time when the order was last updated
order_status	STRING	The status of the order
fulfillment_channel	STRING	The type of fulfillment channel
sales_channel	STRING	The sales channel where the order was made
order_channel	STRING	The channel through which the order was placed
url	STRING	The URL of the product
… and 24 more columns

GET_FLAT_FILE_OPEN_LISTINGS_DATA (26 columns), Flat File Open Listings Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku	STRING	Stock Keeping Unit code for the product
asin	STRING	Amazon Standard Identification Number for the product
price	STRING	Current price of the product
quantity	STRING	Available quantity of the product
business_price	STRING	The price set by the business for the listing
quantity_price_type	STRING	Type of pricing strategy used for quantity pricing
quantity_lower_bound_1	STRING	Minimum quantity threshold for pricing tier 1
quantity_price_1	STRING	Price for products in quantity tier 1
quantity_lower_bound_2	STRING	Minimum quantity threshold for pricing tier 2
… and 16 more columns

GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE (35 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
order_id	STRING	Unique identifier of the order.
order_date	TIMESTAMP	Date and time when the order was placed.
return_request_date	TIMESTAMP	Date and time when the return request was initiated.
return_request_status	STRING	Status of the return request.
amazon_rma_id	STRING	Amazon’s Return Merchandise Authorization ID.
merchant_rma_id	STRING	Merchant’s Return Merchandise Authorization ID.
label_type	STRING	Type of return shipping label.
label_cost	STRING	Cost associated with the return shipping label.
currency_code	STRING	The currency code used for monetary values.
… and 25 more columns

GET_LEDGER_DETAIL_VIEW_DATA (18 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the transaction
fnsku	STRING	Fulfillment Network Stock Keeping Unit
asin	STRING	Unique identifier for the Amazon Standard Identification Number
msku	STRING	Merchant Stock Keeping Unit
title	STRING	Title of the product
event_type	STRING	Type of event related to the transaction
reference_id	STRING	Unique identifier associated with the transaction
quantity	STRING	Amount of units involved in the transaction
fulfillment_center	STRING	Location where the product is fulfilled
… and 8 more columns

GET_LEDGER_SUMMARY_VIEW_DATA (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the event
fnsku	STRING	Fulfillment Network Stock Keeping Unit
asin	STRING	Amazon Standard Identification Number for the product
msku	STRING	Merchant Stock Keeping Unit
title	STRING	Title of the product
disposition	STRING	Action taken with the products
starting_warehouse_balance	STRING	The balance of products at the start of the period
in_transit_between_warehouses	STRING	Products moving between warehouses
receipts	STRING	Products received
… and 14 more columns

GET_MERCHANT_CANCELLED_LISTINGS_DATA (45 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
item_name	STRING	Name of the item
item_description	STRING	Description of the item
seller_sku	STRING	Seller Stock Keeping Unit
price	STRING	The price of the product
quantity	STRING	The quantity available for the listing
image_url	STRING	URL of the product image
item_is_marketplace	STRING	Indicates if the item is sold on the marketplace
product_id_type	STRING	Type of product identifier used
zshop_shipping_fee	STRING	Shipping fee set in the Zshop
… and 35 more columns

GET_MERCHANT_LISTINGS_ALL_DATA (32 columns), Get Merchant Listings All Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
item_name	STRING	Name of the item listed
item_description	STRING	Description of the item
listing_id	STRING	Unique ID for the listing
seller_sku	STRING	Seller-specific SKU for the item
price	STRING	Price of the item
quantity	STRING	Available quantity of the item
open_date	TIMESTAMP	Date and time when the listing was opened
image_url	STRING	URL for the item image
item_is_marketplace	STRING	Whether the item is a part of the marketplace
… and 22 more columns

GET_MERCHANT_LISTINGS_DATA (50 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
item_name	STRING	The name or title of the item
item_description	STRING	Description of the item
listing_id	STRING	Identifier for the listing
seller_sku	STRING	Seller-specific SKU (Stock Keeping Unit)
price	STRING	Price of the item
quantity	STRING	Available quantity of the item
open_date	TIMESTAMP	Date and time when the listing was opened
image_url	STRING	URL of the main image of the item
item_is_marketplace	STRING	Indicates if the item belongs to the marketplace
… and 40 more columns

GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT (49 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
item_name	STRING	The name of the item
item_description	STRING	Description of the item
listing_id	STRING	Unique identifier for the listing
seller_sku	STRING	Seller-specific SKU for the item
price	STRING	The price of the item
quantity	STRING	Available quantity of the item
open_date	TIMESTAMP	The date and time when the listing was opened
image_url	STRING	URL of the item’s image
item_is_marketplace	STRING	Indicates if the item is listed on the marketplace
… and 39 more columns

GET_MERCHANT_LISTINGS_INACTIVE_DATA (31 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
item_name	STRING	Name of the product item
item_description	STRING	Description of the product listing
listing_id	STRING	Unique identifier for the listing
seller_sku	STRING	Seller Stock Keeping Unit (SKU)
price	STRING	Price of the product listing
quantity	STRING	Available quantity of the product
open_date	TIMESTAMP	Date and time when the listing was opened
image_url	STRING	URL of the product image
item_is_marketplace	STRING	Flag indicating if the item is listed on the marketplace
… and 21 more columns

GET_MERCHANTS_LISTINGS_FYP_REPORT (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
status	STRING	Current status of the listing (Active, Inactive, Under Review, etc.)
reason	STRING	Reason for the listing status change or issue
sku	STRING	Stock Keeping Unit for the product
asin	STRING	Unique Amazon Standard Identification Number for the product
product_name	STRING	Name of the product listed
condition	STRING	Condition of the product (New, Used, Refurbished, etc.)
status_change_date	DATE	Date when the status of the listing was last changed
issue_description	STRING	Description of any issues with the product
data_end_time	DATE	End time of the report data
… and 1 more columns

GET_ORDER_REPORT_DATA_SHIPPING (34 columns), GET_ORDER_REPORT_DATA_SHIPPING

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amazon_order_id	STRING	Unique identifier for the Amazon order
amazon_session_id	STRING	Unique identifier for the Amazon session
order_date	DATE	Date when the order was placed
order_posted_date	DATE	Date when the order was posted
billing_data__buyer_email_address	STRING	Email address of the buyer
billing_data__buyer_name	STRING	Name of the buyer
billing_data__buyer_phone_number	STRING	Phone number of the buyer
fulfillment_data__fulfillment_method	STRING	Method used for order fulfillment
fulfillment_data__fulfillment_service_level	STRING	Service level for fulfillment
… and 24 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• GET_ORDER_REPORT_DATA_SHIPPING__item__item_price__component (3 columns)

GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT (33 columns), Restock Inventory Report

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
country	STRING	Country where the product is located
product_name	STRING	Name of the product
fnsku	STRING	Fulfillment Network Stock Keeping Unit
merchant_sku	STRING	Merchant’s Stock Keeping Unit
asin	STRING	Amazon Standard Identification Number of the product
condition	STRING	Condition of the product
supplier	STRING	Supplier of the product
supplier_part_nox	STRING	Supplier’s part number
currency_code	STRING	Currency code used for pricing
… and 23 more columns

GET_SALES_AND_TRAFFIC_REPORT (44 columns), Seller retail analytics reports - Sales and Traffic Business Report

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE
query_end_date	TIMESTAMP
marketplace_id	STRING
parent_asin	STRING
child_asin	STRING
sku	STRING
sales_by_asin__units_ordered	FLOAT64
sales_by_asin__units_ordered_b2_b	FLOAT64
sales_by_asin__ordered_product_sales__amount	FLOAT64
… and 34 more columns

GET_SALES_AND_TRAFFIC_REPORT_BY_DATE (54 columns), Seller retail analytics reports - Sales and Traffic Business Report aggregated by date

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
query_end_date	TIMESTAMP
date	DATE
sales_by_date__ordered_product_sales__amount	FLOAT64
sales_by_date__ordered_product_sales__currency_code	STRING
sales_by_date__ordered_product_sales_b2_b__amount	FLOAT64
sales_by_date__ordered_product_sales_b2_b__currency_code	STRING
sales_by_date__units_ordered	FLOAT64
sales_by_date__units_ordered_b2_b	FLOAT64
sales_by_date__total_order_items	FLOAT64
… and 44 more columns

GET_SALES_AND_TRAFFIC_REPORT_BY_MONTH (44 columns), Seller retail analytics reports - Sales and Traffic Business Report

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE
query_end_date	TIMESTAMP
marketplace_id	STRING
parent_asin	STRING
child_asin	STRING
sku	STRING
sales_by_asin__units_ordered	FLOAT64
sales_by_asin__units_ordered_b2_b	FLOAT64
sales_by_asin__ordered_product_sales__amount	FLOAT64
… and 34 more columns

GET_SELLER_FEEDBACK_DATA (9 columns), Seller Feedback Data Reports

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date when the feedback was received.
rating	INT64	Numeric rating provided by the buyer (e.g., 1 to 5 stars).
comments	STRING	Text comments provided by the buyer when leaving feedback.
response	STRING	Optional response from the seller to the buyer’s feedback.
order_id	STRING	Unique identifier for the order associated with the feedback.
rater_email	STRING	Email address of the buyer who provided the feedback.
data_end_time	DATE	End time of the data collection period.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

GET_STRANDED_INVENTORY_UI_DATA (21 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
primary_action	STRING	Primary action to be taken for the inventory
date_stranded	TIMESTAMP	Date when the inventory was stranded
date_to_take_auto_removal	TIMESTAMP	Date when the stranded inventory will be automatically removed
status_primary	STRING	Primary status of the inventory
status_secondary	STRING	Secondary status of the inventory
error_message	STRING	Any error message related to the inventory status
stranded_reason	STRING	Reason why the inventory is stranded
asin	STRING	Amazon Standard Identification Number (ASIN) of the product
sku	STRING	Stock Keeping Unit (SKU) of the product
… and 11 more columns

GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE (40 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
settlement_id	STRING	The unique identifier for a settlement.
settlement_start_date	TIMESTAMP	The start date of the settlement period.
settlement_end_date	TIMESTAMP	The end date of the settlement period.
deposit_date	TIMESTAMP	The date and time when the payment was deposited into the seller’s account.
total_amount	STRING	The total amount in the settlement.
currency	STRING	The currency in which the financial transactions are recorded.
transaction_type	STRING	The type of transaction (e.g., order, refund).
order_id	STRING	The unique identifier for an order.
merchant_order_id	STRING	The unique identifier for a merchant order.
… and 30 more columns

GET_VENDOR_FORECASTING_FRESH_REPORT (11 columns), A report with forward looking mean, P70, P80, and P90 weekly customer demand forecasts. Data is reported at the ASIN level for the most recent weekly forecast generation date.

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
forecast_generation_date	DATE
asin	STRING
start_date	DATE
end_date	DATE
mean_forecast_units	FLOAT64
p70_forecast_units	FLOAT64
p80_forecast_units	FLOAT64
p90_forecast_units	FLOAT64
data_end_time	DATE
… and 1 more columns

GET_VENDOR_FORECASTING_RETAIL_REPORT (11 columns), A report with forward looking mean, P70, P80, and P90 weekly customer demand forecasts. Data is reported at the ASIN level for the most recent weekly forecast generation date.

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
forecast_generation_date	DATE
asin	STRING
start_date	DATE
end_date	DATE
mean_forecast_units	FLOAT64
p70_forecast_units	FLOAT64
p80_forecast_units	FLOAT64
p90_forecast_units	FLOAT64
data_end_time	DATE
… and 1 more columns

GET_VENDOR_INVENTORY_REPORT (20 columns), Vendor retail analytics reports - Inventory Report

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
asin	STRING
vendor_confirmation_rate	FLOAT64
net_received_inventory_units	FLOAT64
net_received_inventory_cost__amount	FLOAT64
net_received_inventory_cost__currency_code	STRING
open_purchase_order_units	FLOAT64
average_vendor_lead_time_days	FLOAT64
sell_through_rate	FLOAT64
unfilled_customer_ordered_units	FLOAT64
… and 10 more columns

GET_VENDOR_SALES_REPORT (13 columns), Vendor retail analytics reports - Sales Report

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
start_date	DATE
end_date	DATE
asin	STRING
ordered_units	FLOAT64
ordered_revenue__amount	FLOAT64
ordered_revenue__currency_code	STRING
shipped_units	FLOAT64
shipped_revenue__amount	FLOAT64
shipped_revenue__currency_code	STRING
… and 3 more columns

GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
last_updated_date	TIMESTAMP	The date and time when the order was last updated.
sales_channel	STRING	The sales channel through which the order was made.
order_status	STRING	The status of the order.
amazon_order_id	STRING	The unique identifier for the order on Amazon.
purchase_date	TIMESTAMP	The date and time when the order was purchased.
fulfillment_data__address__state	STRING	The state for the order’s shipping address.
fulfillment_data__address__postal_code	STRING	The postal code for the order’s shipping address.
fulfillment_data__address__country	STRING	The country for the order’s shipping address.
fulfillment_data__address__city	STRING	The city for the order’s shipping address.
… and 6 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL__order_item (3 columns)

GET_XML_BROWSE_TREE_DATA (17 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
browse_node_id	STRING	The unique identifier of the browse node
browse_node_attributes__count	STRING	The count of attributes
browse_node_name	STRING	The name of the browse node
browse_node_store_context_name	STRING	The store context name of the browse node
browse_path_by_id	STRING	The path of the browse node by ID
browse_path_by_name	STRING	The path of the browse node by name
has_children	STRING	Flag indicating if the browse node has children
child_nodes__count	STRING	The count of child nodes
product_type_definitions	STRING	Definitions of product types associated with the browse node
… and 7 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• GET_XML_BROWSE_TREE_DATA__browse_node_attributes__attribute (3 columns)
• GET_XML_BROWSE_TREE_DATA__child_nodes__id (4 columns)

ListFinancialEventGroups (16 columns), List Financial Event Groups

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
financial_event_group_id	STRING	The unique identifier for the financial event group.
processing_status	STRING	The processing status of the financial event group.
fund_transfer_status	STRING	The status of the fund transfer.
original_total__currency_code	STRING	The currency code for the original total amount.
original_total__currency_amount	FLOAT64	The original total amount in the original currency.
converted_total__currency_code	STRING	The currency code for the converted total amount.
converted_total__currency_amount	FLOAT64	The total amount converted to a specific currency.
fund_transfer_date	TIMESTAMP	The date the fund transfer occurred.
trace_id	STRING	The unique identifier used for tracing the financial event group.
… and 6 more columns

ListFinancialEvents (3 columns), List of Financial Events

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
posted_before	TIMESTAMP	Date and time filter for events posted before a specific date
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• ListFinancialEvents__shipment_event_list (7 columns)
• ListFinancialEvents__shipment_event_list__order_charge_list (4 columns)
• ListFinancialEvents__shipment_event_list__order_charge_adjustment_list (4 columns)
• ListFinancialEvents__shipment_event_list__shipment_fee_list (4 columns)
• ListFinancialEvents__shipment_event_list__shipment_fee_adjustment_list (4 columns)
• ListFinancialEvents__shipment_event_list__order_fee_list (4 columns)
• ListFinancialEvents__shipment_event_list__order_fee_adjustment_list (4 columns)
• ListFinancialEvents__shipment_event_list__direct_payment_list (4 columns)
• ListFinancialEvents__shipment_event_list__shipment_item_list (4 columns)
• ListFinancialEvents__shipment_event_list__shipment_item_adjustment_list (4 columns)
• ListFinancialEvents__refund_event_list (7 columns)
• ListFinancialEvents__refund_event_list__order_charge_list (4 columns)
• ListFinancialEvents__refund_event_list__order_charge_adjustment_list (4 columns)
• ListFinancialEvents__refund_event_list__shipment_fee_list (4 columns)
• ListFinancialEvents__refund_event_list__shipment_fee_adjustment_list (4 columns)
• ListFinancialEvents__refund_event_list__order_fee_list (4 columns)
• ListFinancialEvents__refund_event_list__order_fee_adjustment_list (4 columns)
• ListFinancialEvents__refund_event_list__direct_payment_list (4 columns)
• ListFinancialEvents__refund_event_list__shipment_item_list (4 columns)
• ListFinancialEvents__refund_event_list__shipment_item_adjustment_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list (7 columns)
• ListFinancialEvents__guarantee_claim_event_list__order_charge_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__order_charge_adjustment_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__shipment_fee_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__shipment_fee_adjustment_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__order_fee_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__order_fee_adjustment_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__direct_payment_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__shipment_item_list (4 columns)
• ListFinancialEvents__guarantee_claim_event_list__shipment_item_adjustment_list (4 columns)
• ListFinancialEvents__chargeback_event_list (7 columns)
• ListFinancialEvents__chargeback_event_list__order_charge_list (4 columns)
• ListFinancialEvents__chargeback_event_list__order_charge_adjustment_list (4 columns)
• ListFinancialEvents__chargeback_event_list__shipment_fee_list (4 columns)
• ListFinancialEvents__chargeback_event_list__shipment_fee_adjustment_list (4 columns)
• ListFinancialEvents__chargeback_event_list__order_fee_list (4 columns)
• ListFinancialEvents__chargeback_event_list__order_fee_adjustment_list (4 columns)
• ListFinancialEvents__chargeback_event_list__direct_payment_list (4 columns)
• ListFinancialEvents__chargeback_event_list__shipment_item_list (4 columns)
• ListFinancialEvents__chargeback_event_list__shipment_item_adjustment_list (4 columns)
• ListFinancialEvents__pay_with_amazon_event_list (11 columns)
• ListFinancialEvents__pay_with_amazon_event_list__fee_list (4 columns)
• ListFinancialEvents__service_provider_credit_event_list (12 columns)
• ListFinancialEvents__retrocharge_event_list (7 columns)
• ListFinancialEvents__retrocharge_event_list__retrocharge_tax_withheld_list (4 columns)
• ListFinancialEvents__rental_transaction_event_list (8 columns)
• ListFinancialEvents__rental_transaction_event_list__rental_charge_list (4 columns)
• ListFinancialEvents__rental_transaction_event_list__rental_fee_list (4 columns)
• ListFinancialEvents__rental_transaction_event_list__rental_tax_withheld_list (4 columns)
• ListFinancialEvents__performance_bond_refund_event_list (4 columns)
• ListFinancialEvents__product_ads_payment_event_list (6 columns)
• ListFinancialEvents__service_fee_event_list (9 columns)
• ListFinancialEvents__service_fee_event_list__fee_list (4 columns)
• ListFinancialEvents__seller_deal_payment_event_list (8 columns)
• ListFinancialEvents__debt_recovery_event_list (4 columns)
• ListFinancialEvents__debt_recovery_event_list__debt_recovery_item_list (4 columns)
• ListFinancialEvents__debt_recovery_event_list__charge_instrument_list (4 columns)
• ListFinancialEvents__loan_servicing_event_list (4 columns)
• ListFinancialEvents__adjustment_event_list (5 columns)
• ListFinancialEvents__adjustment_event_list__adjustment_item_list (4 columns)
• ListFinancialEvents__safet_reimbursement_event_list (6 columns)
• ListFinancialEvents__safet_reimbursement_event_list__safet_reimbursement_item_list (4 columns)
• ListFinancialEvents__seller_review_enrollment_payment_event_list (6 columns)
• ListFinancialEvents__fba_liquidation_event_list (5 columns)
• ListFinancialEvents__coupon_payment_event_list (8 columns)
• ListFinancialEvents__imaging_services_fee_event_list (6 columns)
• ListFinancialEvents__imaging_services_fee_event_list__fee_list (4 columns)
• ListFinancialEvents__network_commingling_transaction_event_list (9 columns)
• ListFinancialEvents__affordability_expense_event_list (7 columns)
• ListFinancialEvents__affordability_expense_reversal_event_list (7 columns)
• ListFinancialEvents__trial_shipment_event_list (7 columns)
• ListFinancialEvents__trial_shipment_event_list__fee_list (4 columns)
• ListFinancialEvents__tds_reimbursement_event_list (7 columns)
• ListFinancialEvents__tds_reimbursement_event_list__fee_list (4 columns)
• ListFinancialEvents__adhoc_disbursement_event_list (5 columns)
• ListFinancialEvents__adhoc_disbursement_event_list__adjustment_item_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list (7 columns)
• ListFinancialEvents__shipment_settle_event_list__order_charge_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__order_charge_adjustment_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__shipment_fee_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__shipment_fee_adjustment_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__order_fee_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__order_fee_adjustment_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__direct_payment_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__shipment_item_list (4 columns)
• ListFinancialEvents__shipment_settle_event_list__shipment_item_adjustment_list (4 columns)
• ListFinancialEvents__charge_refund_event_list (4 columns)
• ListFinancialEvents__failed_adhoc_disbursement_event_list (9 columns)
• ListFinancialEvents__value_added_service_charge_event_list (6 columns)
• ListFinancialEvents__capacity_reservation_billing_event_list (4 columns)
• ListFinancialEvents__tax_withholding_event_list (4 columns)
• ListFinancialEvents__removal_shipment_event_list (7 columns)
• ListFinancialEvents__removal_shipment_event_list__removal_shipment_item_list (4 columns)
• ListFinancialEvents__removal_shipment_adjustment_event_list (8 columns)
• ListFinancialEvents__removal_shipment_adjustment_event_list__removal_shipment_item_adjustment_list (4 columns)

OrderItems (55 columns), All order items that were updated after a specified date

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amazon_order_id	STRING	ID of the Amazon order
asin	STRING	Amazon Standard Identification Number of the product
order_item_id	STRING	ID of the order item
seller_sku	STRING	SKU of the seller
title	STRING	Title of the product
quantity_ordered	INT64	Quantity of the item ordered
product_info__number_of_items	STRING	Number of items in the product
quantity_shipped	INT64	Quantity of the item shipped
points_granted__points_number	INT64	Number of points granted
… and 45 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• OrderItems__promotion_ids (4 columns)
• OrderItems__serial_numbers (4 columns)

Orders (48 columns), All orders that were updated after a specified date

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
seller_id	STRING	Identifier for the seller associated with the order
amazon_order_id	STRING	Unique identifier for the Amazon order
purchase_date	TIMESTAMP	Date and time when the order was purchased
last_update_date	TIMESTAMP	Date and time when the order was last updated
order_status	STRING	Status of the order
seller_order_id	STRING	Unique identifier given by the seller for the order
fulfillment_channel	STRING	Channel through which the order is fulfilled
sales_channel	STRING	Channel through which the order was sold
automated_shipping_settings__has_automated_shipping_settings	BOOL	Indicates if the order has automated shipping settings
… and 38 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• Orders__payment_method_details (4 columns)

VendorDirectFulfillmentShipping (29 columns), Vendor Direct Fulfillment Shipping

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
purchase_order_number	STRING	Unique identifier of the purchase order.
selling_party__party_id	STRING	Identifier of the selling party.
selling_party__address__name	STRING	Name of the selling party.
selling_party__address__address_line1	STRING	First line of the address.
selling_party__address__address_line2	STRING	Second line of the address.
selling_party__address__address_line3	STRING	Third line of the address.
selling_party__address__city	STRING	City of the address.
selling_party__address__county	STRING	County of the address.
selling_party__address__district	STRING	District of the address.
… and 19 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• VendorDirectFulfillmentShipping__selling_party__tax_registration_details (17 columns)
• VendorDirectFulfillmentShipping__ship_from_party__tax_registration_details (17 columns)
• VendorDirectFulfillmentShipping__label_data (8 columns)

VendorOrders (74 columns), All vendor purchase orders that were updated after a specified date

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
purchase_order_number	STRING	Purchase order number
purchase_order_state	STRING	State of the purchase order
order_details__purchase_order_date	TIMESTAMP	Purchase order creation date and time
order_details__purchase_order_changed_date	TIMESTAMP	Date and time when the purchase order was last changed
order_details__purchase_order_state_changed_date	TIMESTAMP	Date and time when the purchase order state changed
order_details__purchase_order_type	STRING	Type of purchase order
order_details__import_details__method_of_payment	STRING	Method of payment for import
order_details__import_details__international_commercial_terms	STRING	International commercial terms
order_details__import_details__port_of_delivery	STRING	Port of delivery
… and 64 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• VendorOrders__order_details__items (14 columns)

VendorOrdersStatus (44 columns), Status of vendor purchase orders

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
purchase_order_number	STRING	Purchase order number
status	STRING	Status of the purchase order
changed_before	TIMESTAMP	The timestamp indicating the maximum creation date of the status data to be fetched.
order_details__purchase_order_date	TIMESTAMP	Purchase order creation date and time
order_details__purchase_order_changed_date	TIMESTAMP	Date and time when the purchase order was last changed
order_details__purchase_order_state_changed_date	TIMESTAMP	Date and time when the purchase order state changed
order_details__purchase_order_type	STRING	Type of purchase order
order_details__import_details__method_of_payment	STRING	Method of payment for import
order_details__import_details__international_commercial_terms	STRING	International commercial terms
… and 34 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• VendorOrdersStatus__items (14 columns)

How the Amazon Selling Partner sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Amazon Selling Partner supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

Frequently asked questions

How long does the initial sync take for Amazon Selling Partner?

It depends on how much history is in your Amazon Selling Partner account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Can I sync only some tables or columns?

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Amazon Selling Partner’s schema changes?

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Amazon Selling Partner, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Amazon Selling Partner instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Amazon Selling Partner connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Amazon Selling Partner data

Order reporting

Use Orders and OrderItems to report units, revenue, and returns by marketplace and product.

Fees and settlements

Use ListFinancialEvents and the FBA fee reports to see what Amazon actually deducts per order.

Fulfilment and stock

Track shipments, removal orders, and open listings to keep an eye on FBA inventory.

Real margin

Combine order revenue with fees and ad spend to get margin per ASIN rather than gross sales.

Use Amazon Selling Partner data in your AI and BI tools

Once Amazon Selling Partner data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Amazon Selling Partner data.

Claude

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query’s BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Amazon Selling Partner connector pricing and plan details.

Related connectors

• Google Analytics: Sync Google Analytics to BigQuery.
• Recharge: Sync Recharge to BigQuery.
• Extensiv 3PL Warehouse Manager: Sync Extensiv 3PL Warehouse Manager to BigQuery.
• WooCommerce: Sync WooCommerce to BigQuery.
• Adobe Commerce: Sync Adobe Commerce to BigQuery.
• Akeneo: Sync Akeneo to BigQuery.