Build Power BI reports from BigCommerce data by syncing orders, catalog, and customers into Excel or BigQuery first. SyncRange handles refreshes so reports stay up to date without repeated BigCommerce CSV exports.
Free plan · No credit card · From $19/mo
Connect, choose data, open the report
Power BI reports read from connectors such as Microsoft Excel and BigQuery. SyncRange focuses on keeping BigCommerce 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 BigCommerce 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.
Store orders from the BigCommerce Orders API (v2)
| Columns |
|---|
| Order ID |
| Customer ID |
| Date Created |
| Date Modified |
| Date Shipped |
| Status ID |
| Status |
| Custom Status |
| Subtotal Ex Tax |
| Subtotal Inc Tax |
| Subtotal Tax |
| Base Shipping Cost |
| Shipping Cost Ex Tax |
| Shipping Cost Inc Tax |
| Shipping Cost Tax |
| Base Handling Cost |
| Handling Cost Ex Tax |
| Handling Cost Inc Tax |
| Handling Cost Tax |
| Base Wrapping Cost |
| Wrapping Cost Ex Tax |
| Wrapping Cost Inc Tax |
| Wrapping Cost Tax |
| Total Ex Tax |
| Total Inc Tax |
| Total Tax |
| Items Total |
| Items Shipped |
| Payment Method |
| Payment Provider ID |
| Payment Status |
| Refunded Amount |
| Order Is Digital |
| Store Credit Amount |
| Gift Certificate Amount |
| IP Address |
| GeoIP Country |
| GeoIP Country ISO2 |
| Currency ID |
| Currency Code |
| Currency Exchange Rate |
| Default Currency ID |
| Default Currency Code |
| Store Default Currency Code |
| Store Default Exchange Rate |
| Staff Notes |
| Customer Message |
| Discount Amount |
| Coupon Discount |
| Shipping Address Count |
| Is Deleted |
| eBay Order ID |
| Cart ID |
| Channel ID |
| External Source |
| External ID |
| External Merchant ID |
| Tax Provider ID |
| Customer Locale |
| Order Source |
| Consignments |
| Coupons |
| Products Resource URI |
| Shipping Addresses Resource URI |
| Billing Address First Name |
| Billing Address Last Name |
| Billing Address Company |
| Billing Address Street 1 |
| Billing Address Street 2 |
| Billing Address City |
| Billing Address State |
| Billing Address Zip |
| Billing Address Country |
| Billing Address Country Iso2 |
| Billing Address Phone |
| Billing Address Email |
| Billing Address Form Fields |
| Date Exported |
Line items for orders in the selected date range (v2 order products)
| Columns |
|---|
| Order ID |
| Line Item ID |
| Product ID |
| Variant ID |
| Order Address ID |
| Name |
| Customer Name |
| Merchant Name |
| SKU |
| UPC |
| Type |
| Base Price |
| Price Ex Tax |
| Price Inc Tax |
| Price Tax |
| Base Total |
| Total Ex Tax |
| Total Inc Tax |
| Total Tax |
| Weight |
| Width |
| Height |
| Depth |
| Quantity |
| Base Cost Price |
| Cost Price Inc Tax |
| Cost Price Ex Tax |
| Cost Price Tax |
| Is Refunded |
| Quantity Refunded |
| Refund Amount |
| Return ID |
| Wrapping ID |
| Wrapping Name |
| Base Wrapping Cost |
| Wrapping Cost Ex Tax |
| Wrapping Cost Inc Tax |
| Wrapping Cost Tax |
| Wrapping Message |
| Quantity Shipped |
| Event Name |
| Event Date |
| Fixed Shipping Cost |
| eBay Item ID |
| eBay Transaction ID |
| Option Set ID |
| Parent Order Product ID |
| Is Bundled Product |
| Bin Picking Number |
| External ID |
| Fulfillment Source |
| Brand |
| Applied Discounts |
| Product Options |
| Configurable Fields |
| Gift Certificate ID |
| Order Date Created |
| Date Exported |
Customer records from the BigCommerce Customers API (v3)
| Columns |
|---|
| Customer ID |
| Company |
| Customer Group ID |
| First Name |
| Last Name |
| Notes |
| Phone |
| Registration IP Address |
| Tax Exempt Category |
| Date Created |
| Date Modified |
| Accepts Review/Abandoned Cart Emails |
| Origin Channel ID |
| Channel IDs |
| Store Credit Amounts |
| Authentication |
| Addresses |
| Attributes |
| Form Fields |
| Date Exported |
Catalog products from the BigCommerce Catalog API (v3)
| Columns |
|---|
| Product ID |
| Name |
| Type |
| SKU |
| Description |
| Weight |
| Width |
| Depth |
| Height |
| Price |
| Cost Price |
| Retail Price |
| Sale Price |
| MAP Price |
| Tax Class ID |
| Product Tax Code |
| Calculated Price |
| Brand ID |
| Option Set ID |
| Option Set Display |
| Inventory Level |
| Inventory Warning Level |
| Inventory Tracking |
| Reviews Rating Sum |
| Reviews Count |
| Total Sold |
| Fixed Cost Shipping Price |
| Is Free Shipping |
| Is Visible |
| Is Featured |
| Warranty |
| Bin Picking Number |
| Layout File |
| UPC |
| MPN |
| GTIN |
| Search Keywords |
| Availability |
| Availability Description |
| Sort Order |
| Condition |
| Is Condition Shown |
| Order Quantity Minimum |
| Order Quantity Maximum |
| Page Title |
| Meta Keywords |
| Meta Description |
| Date Created |
| Date Modified |
| View Count |
| Preorder Release Date |
| Preorder Message |
| Is Preorder Only |
| Is Price Hidden |
| Price Hidden Label |
| Base Variant ID |
| Categories |
| Related Products |
| Custom URL |
| Variants |
| Images |
| Custom Fields |
| Bulk Pricing Rules |
| Date Exported |
Catalog categories from the BigCommerce Catalog API (v3)
| Columns |
|---|
| Category ID |
| Parent ID |
| Name |
| Description |
| Sort Order |
| Page Title |
| Meta Keywords |
| Meta Description |
| Layout File |
| Image URL |
| Is Visible |
| Search Keywords |
| Default Product Sort |
| Custom URL |
| Date Exported |
Catalog brands from the BigCommerce Catalog API (v3)
| Columns |
|---|
| Brand ID |
| Name |
| Page Title |
| Meta Keywords |
| Meta Description |
| Search Keywords |
| Image URL |
| Custom URL |
| Date Exported |
Marketing coupons from the BigCommerce Coupons API (v2)
| Columns |
|---|
| Coupon ID |
| Name |
| Type |
| Amount |
| Min Purchase |
| Expires |
| Enabled |
| Code |
| Applies To |
| Number Of Uses |
| Max Uses |
| Max Uses Per Customer |
| Restricted To |
| Shipping Methods |
| Date Created |
| Date Exported |
Shipping addresses for orders in the selected date range (v2)
| Columns |
|---|
| Order ID |
| Shipping Address ID |
| Items Total |
| Items Shipped |
| Shipping Method |
| Base Cost |
| Cost Ex Tax |
| Cost Inc Tax |
| Cost Tax |
| Base Handling Cost |
| Handling Cost Ex Tax |
| Handling Cost Inc Tax |
| Handling Cost Tax |
| Shipping Zone ID |
| Shipping Zone Name |
| Cost Tax Class ID |
| Handling Cost Tax Class ID |
| Shipping Quotes |
| First Name |
| Last Name |
| Company |
| Street 1 |
| Street 2 |
| City |
| State |
| Zip |
| Country |
| Country Iso2 |
| Phone |
| Form Fields |
| Order Date Created |
| Date Exported |
Shipments and tracking for orders in the selected date range (v2)
| Columns |
|---|
| Order ID |
| Shipment ID |
| Customer ID |
| Order Address ID |
| Date Created |
| Tracking Number |
| Merchant Shipping Cost |
| Shipping Method |
| Shipping Provider |
| Shipping Provider Display Name |
| Tracking Carrier |
| Tracking Link |
| Generated Tracking Link |
| Comments |
| Items |
| Order Date Created |
| Date Exported |
| Shipping Address First Name |
| Billing Address First Name |
| Shipping Address Last Name |
| Billing Address Last Name |
| Shipping Address Company |
| Billing Address Company |
| Shipping Address Street 1 |
| Billing Address Street 1 |
| Shipping Address Street 2 |
| Billing Address Street 2 |
| Shipping Address City |
| Billing Address City |
| Shipping Address State |
| Billing Address State |
| Shipping Address Zip |
| Billing Address Zip |
| Shipping Address Country |
| Billing Address Country |
| Shipping Address Country Iso2 |
| Billing Address Country Iso2 |
| Shipping Address Phone |
| Billing Address Phone |
| Shipping Address Email |
| Billing Address Email |
| Shipping Address Form Fields |
| Billing Address Form Fields |
Payment transactions and refunds for orders in the selected date range (v3)
| Columns |
|---|
| Order ID |
| Transaction ID |
| Event |
| Method |
| Amount |
| Currency |
| Gateway |
| Gateway Transaction ID |
| Date Created |
| Test |
| Status |
| Fraud Review |
| Reference Transaction ID |
| Payment Method ID |
| AVS Result |
| CVV Result |
| Credit Card |
| Gift Certificate |
| Store Credit |
| Custom |
| Payment Instrument Token |
| Offline |
| Order Date Created |
| Date Exported |
Catalog product variants from the BigCommerce Catalog API (v3)
| Columns |
|---|
| Variant ID |
| Product ID |
| SKU |
| SKU ID |
| Price |
| Calculated Price |
| Sale Price |
| Retail Price |
| MAP Price |
| Cost Price |
| Weight |
| Width |
| Height |
| Depth |
| Is Free Shipping |
| Fixed Cost Shipping Price |
| Calculated Weight |
| Purchasing Disabled |
| Purchasing Disabled Message |
| Image URL |
| UPC |
| MPN |
| GTIN |
| Inventory Level |
| Inventory Warning Level |
| Bin Picking Number |
| Option Values |
| Date Exported |
Gift certificates from the BigCommerce Marketing API (v2)
| Columns |
|---|
| Gift Certificate ID |
| Customer ID |
| Order ID |
| Code |
| To Name |
| To Email |
| From Name |
| From Email |
| Amount |
| Balance |
| Status |
| Currency Code |
| Purchase Date |
| Expiry Date |
| Template |
| Message |
| Date Exported |
Inventory locations from the BigCommerce Inventory API (v3)
| Columns |
|---|
| Location ID |
| Code |
| Label |
| Description |
| Type ID |
| Enabled |
| Managed By External Source |
| Time Zone |
| Address |
| Storefront Visibility |
| Special Hours |
| Operating Hours |
| Date Exported |
Per-location inventory levels from the BigCommerce Inventory API (v3)
| Columns |
|---|
| Product ID |
| Variant ID |
| SKU |
| Location ID |
| Location Code |
| Available To Sell |
| Total Inventory On Hand |
| Warning Level |
| Safety Stock |
| Is In Stock |
| Date Exported |
Sales channels from the BigCommerce Channels API (v3)
| Columns |
|---|
| Channel ID |
| Name |
| Platform |
| Type |
| Date Created |
| Date Modified |
| External ID |
| Icon URL |
| Is Listable From UI |
| Is Visible |
| Status |
| Date Exported |
Product-to-channel assignments for multi-storefront catalogs (v3)
| Columns |
|---|
| Product ID |
| Channel ID |
| Date Exported |
See how teams export clean ecommerce and marketing data to BigQuery, Google Sheets, or Excel 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.
Large marketplace
We struggled to find a Shopify extraction tool that went beyond basic product, order, and customer data until we found SyncRange. It effortlessly pulls everything we require, including metaobjects and custom fields. SyncRange's hands-on guidance has given us complete confidence.
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
Install on Shopify