Load Amazon Seller data into BigQuery for scalable SQL reporting and historical analysis. SyncRange maps export tabs into stable tables and refreshes them on your schedule.
Connect, choose columns, schedule refreshes
When spreadsheets are not enough, SyncRange loads Amazon Seller into Google BigQuery. Tables inherit the column layout from your export tabs, so SQL models and dbt projects can depend on predictable names.
BigQuery becomes the place to join marketing, ecommerce, and finance sources, run large historical queries, and power BI tools that expect a warehouse instead of a sheet.
Send your Amazon Seller data directly to Google BigQuery for enterprise-grade data warehousing. Build a central analytics repository, run SQL across massive datasets, and power large-scale reporting without managing pipelines or writing ETL code.
What we can export, and how it lands
Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination (worksheets in Google Sheets or Excel, or BigQuery columns) when you choose BigQuery.
Order-level detail for the selected date range. Large presets may take extended time due to Amazon rate limits. Buyer and shipping address fields are coming soon.
| Columns |
|---|
| Amazon Order ID |
| Purchase Date |
| Last Updated Date |
| Order Status |
| Fulfillment Channel |
| Sales Channel |
| Ship Service Level |
| Currency |
| Order Total |
| Items Shipped |
| Items Unshipped |
| Payment Method |
| Marketplace ID |
| Is Premium Order |
| Is Business Order |
| Is Prime |
| Order Type |
| Earliest Ship Date |
| Latest Ship Date |
| Earliest Delivery Date |
| Latest Delivery Date |
| Date Exported |
Uses the selected date range.
| Columns |
|---|
| Amazon Order ID |
| Order Item ID |
| ASIN |
| Seller SKU |
| Title |
| Quantity Ordered |
| Currency |
| Item Price |
| Item Tax |
| Shipping Price |
| Shipping Tax |
| Shipping Discount |
| Promotion Discount |
| Promotion ID |
| Condition |
| Date Exported |
Current FBA inventory snapshot. The selected date range does not apply.
| Columns |
|---|
| Seller SKU |
| FNSKU |
| ASIN |
| Product Name |
| Condition |
| Fulfillable Quantity |
| Inbound Working |
| Inbound Shipped |
| Inbound Receiving |
| Reserved Quantity |
| Total Quantity |
| Unsellable Quantity |
| Per Unit Volume |
| Researching Quantity |
| Date Exported |
Current listings snapshot. The selected date range does not apply.
| Columns |
|---|
| Seller SKU |
| ASIN |
| Item Name |
| Item Description |
| Listing ID |
| Price |
| Currency |
| Quantity |
| Open Date |
| Product ID Type |
| Item Condition |
| Status |
| Fulfillment Channel |
| Business Price |
| Date Exported |
Uses Amazon-generated settlement reports only. Older history is limited by Amazon report retention (~90 days).
| Columns |
|---|
| Settlement ID |
| Settlement Start Date |
| Settlement End Date |
| Deposit Date |
| Total Amount |
| Currency |
| Transaction Type |
| Order ID |
| Merchant Order ID |
| SKU |
| Quantity Purchased |
| Marketplace |
| Amount Type |
| Amount Description |
| Amount |
| Fulfillment ID |
| Posted Date |
| Date Exported |
Finances event lines (charges, fees, refunds, adjustments) filtered by posted date. Separate from Settlement Reports. How far back Amazon returns data varies; use append mode on scheduled exports to build history in your destination.
| Columns |
|---|
| Event Type |
| Financial Event Group ID |
| Settlement ID |
| Settlement Start Date |
| Settlement End Date |
| Deposit Date |
| Total Amount |
| Currency |
| Transaction Type |
| Order ID |
| Merchant Order ID |
| SKU |
| Quantity Purchased |
| Marketplace |
| Amount Type |
| Amount Description |
| Amount |
| Fulfillment ID |
| Posted Date |
| Date Exported |
Uses the selected date range. FBA-only.
| Columns |
|---|
| Return Date |
| Order ID |
| Seller SKU |
| ASIN |
| FNSKU |
| Product Name |
| Quantity |
| Fulfillment Center ID |
| Detailed Disposition |
| Return Reason |
| Status |
| License Plate Number |
| Customer Comments |
| Date Exported |
Monthly/current FBA storage fee report. The selected date range does not backfill full history.
| Columns |
|---|
| ASIN |
| FNSKU |
| Product Name |
| Fulfillment Center |
| Country Code |
| Longest Side |
| Median Side |
| Shortest Side |
| Measurement Units |
| Weight |
| Weight Units |
| Item Volume |
| Volume Units |
| Product Size Tier |
| Average Quantity On Hand |
| Average Quantity Pending Removal |
| Estimated Total Item Volume |
| Month Of Charge |
| Storage Rate |
| Currency |
| Estimated Monthly Storage Fee |
| Dangerous Goods Storage Type |
| Eligible For Inventory Discount |
| Qualifies For Inventory Discount |
| Total Incentive Fee Amount |
| Breakdown Incentive Fee Amount |
| Average Quantity Customer Orders |
| Date Exported |
Uses the selected date range.
| Columns |
|---|
| Snapshot Date |
| SKU |
| FNSKU |
| ASIN |
| Product Name |
| Condition |
| Per Unit Volume |
| Currency |
| Volume Unit |
| Country |
| Quantity Charged |
| Amount Charged |
| Surcharge Age Tier |
| Rate Surcharge |
| Date Exported |
Current estimated fees for active FBA offers. Not historical; Amazon limits this report to about once per day.
| Columns |
|---|
| SKU |
| FNSKU |
| ASIN |
| Product Name |
| Product Group |
| Brand |
| Fulfilled By |
| Has Local Inventory |
| Your Price |
| Sales Price |
| Longest Side |
| Median Side |
| Shortest Side |
| Length And Girth |
| Unit Of Dimension |
| Item Package Weight |
| Unit Of Weight |
| Product Size Weight Band |
| Currency |
| Estimated Fee Total |
| Estimated Referral Fee Per Unit |
| Estimated Variable Closing Fee |
| Expected Domestic Fulfilment Fee Per Unit |
| Expected EFN Fulfilment Fee Per Unit UK |
| Expected EFN Fulfilment Fee Per Unit DE |
| Expected EFN Fulfilment Fee Per Unit FR |
| Expected EFN Fulfilment Fee Per Unit IT |
| Expected EFN Fulfilment Fee Per Unit ES |
| Expected EFN Fulfilment Fee Per Unit SE |
| Date Exported |
Uses the selected date range. FBA-only.
| Columns |
|---|
| Approval Date |
| Reimbursement ID |
| Case ID |
| Amazon Order ID |
| Reason |
| SKU |
| FNSKU |
| ASIN |
| Product Name |
| Condition |
| Currency |
| Amount Per Unit |
| Amount Total |
| Quantity Reimbursed Cash |
| Quantity Reimbursed Inventory |
| Quantity Reimbursed Total |
| Original Reimbursement ID |
| Original Reimbursement Type |
| Date Exported |
Lightning Deal and Best Deal performance for promotions that start in the selected date range.
| Columns |
|---|
| Promotion ID |
| Promotion Name |
| Marketplace ID |
| Merchant ID |
| Promotion Type |
| Status |
| Creation Channel |
| Glance Views |
| Units Sold |
| Revenue |
| Revenue Currency |
| Amount Spent |
| Amount Spent Currency |
| Start Date |
| End Date |
| Created Date |
| Last Updated Date |
| Funding Agreement ID |
| Vendor Code |
| ASIN |
| Product Name |
| Product Glance Views |
| Product Units Sold |
| Product Revenue |
| Product Revenue Currency |
| Product Amount Spent |
| Product Amount Spent Currency |
| Date Exported |
Coupon campaign stats for campaigns whose start date falls in the selected range (Brand Analytics role; may be empty if ineligible).
| Columns |
|---|
| Coupon ID |
| Merchant ID |
| Marketplace ID |
| Currency |
| Coupon Name |
| Website Message |
| Start Date |
| End Date |
| Customer Segment |
| Discount Type |
| Discount Amount |
| Clips |
| Redemptions |
| Budget |
| Total Discount |
| Budget Spent |
| Budget Remaining |
| Budget Percentage Used |
| Sales |
| ASINs |
| Date Exported |
Social proof
See how teams export clean ecommerce and marketing data to Google Sheets, Microsoft Excel, or BigQuery without manual work.
Shopify Store and Food delivery
Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.
Multi-brand Shopify Plus Operator
We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.
Shopify Store Founder
We were manually updating Google Sheets every morning with Shopify and ad data. It was slow and error-prone. Now everything updates automatically, and our daily profitability tracker is always accurate.
Large Shopify Store
SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.
Connect your account, then follow the configuration guide for your first export.
Other data sources you can sync to BigQuery
