Sync Amazon Seller data into Excel or BigQuery, then connect Power BI for reports. SyncRange keeps source data fresh so your dashboards stay accurate.
Connect, choose columns, schedule refreshes
Power BI reports read from connectors such as Microsoft Excel and BigQuery. SyncRange focuses on keeping Amazon Seller accurate inside those destinations. Think of us as the sync layer, not a charting substitute.
After data lands on a schedule, you build Power BI visuals and data models the same way you would for any other business data. Power BI stays fast because the heavy lifting happens in Excel or BigQuery.
Power BI connects natively to BigQuery and Microsoft Excel. SyncRange does not build visuals inside Power BI. We keep Amazon Seller synchronized into those destinations so your reports and data models stay fast and auditable.
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 Power BI.
Uses the selected date range.
| 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 |
| Buyer Email |
| Buyer Name |
| Ship City |
| Ship State |
| Ship Postal Code |
| Ship Country |
| 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.
| 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 |
Uses the selected date range. FBA-only; skipped if the seller is not authorized for FBA data.
| 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; skipped if the seller is not authorized for FBA data.
| 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 |
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 Power BI
