Datapipe
Review your product catalog
Each product has a row with its name and SKU. Keep the current catalog in the worksheet you already use.
See your BigCommerce numbers in Looker Studio.
Current products alongside orders, line items, and refunds for your selected dates.
Looker StudioStart free Connect BigCommerce
Updated October 2026
Keep price beside inventory
See the current price and inventory level on the same product row. Prices remain in the store's own currency.
Refresh product worksheets
Send the product rows to your chosen destination. Scheduled refreshes replace the repeated work of exporting the current catalog.
Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
Metrics and dimensions
13 metrics and 8 ways to split them.
Browse the documented fields below. In the app, choose your project connection to load its field list. Availability depends on API permissions, report type, and compatible field combinations. Property-specific custom fields appear after connecting.
Send BigCommerce data anywhere
Google SheetsA sheet that refreshes every morning.Looker StudioCharts that read the same numbers.
BigQueryA warehouse table for the same columns.
Excel / CSVA Drive file you can open in Excel.
ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Better than exporting by hand
- You can keep a row per day instead of one lump sum.
- Products can be listed with the price and the status.
Start from a goal
Orders by creation date
Orders created during the selected UTC dates. Amounts remain in each order's currency and include unpaid or cancelled orders with their status.
Use thisOrder line items
One row per order product for orders created during the selected UTC dates. Line totals are separate from order totals; currency comes from the parent order.
Use thisRefunds by refund date
Refunds created during the selected UTC dates, including refunds for older orders. Currency is read from each parent order; these are recorded refunds, not a settlement report.
Use thisCurrent store products
Current product inventory, independent of the report date range.
Use thisHow it works
- Create a project and choose BigCommerce in Connections.
- Pick where it goes. This one sends the numbers to Looker Studio.
- Pick where it goes. Choose products, orders, line items, or refunds and a destination.
Sample report
Sample
| Product name | SKU | Price | Inventory | Order status | Currency | Quantity | Order total |
|---|---|---|---|---|---|---|---|
| Wool coat | COAT-01 | $80.00 | 24 | Paid | 1,240 | 1,240 | 860 |
| Canvas tote | TOTE-02 | $24.00 | 80 | Pending | 640 | 640 | 410 |
| Gift card | GIFT-03 | $50.00 | 0 | Refunded | 210 | 210 | 155 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Products show current inventory, independent of the selected report dates. Orders and line items use order creation dates in the selected UTC range. Refunds use refund creation dates, including refunds for older orders. Amounts retain the parent order's currency; unpaid and cancelled orders remain labeled by status. Product prices use the store's currency.
Questions
Free to start. Paid plans add more connections and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 connections.
No. Name a project, add a connection, then choose a report and destination.
Reporting reads product details. Optional product name or description updates require the workspace owner to enable the action and approve each change. These updates can change your live storefront. Price and inventory changes are not supported.
This page lists 13 metrics and 8 ways to split them. You pick the columns when you build the report.
Products show current inventory, independent of the selected report dates. Orders and line items use order creation dates in the selected UTC range. Refunds use refund creation dates, including refunds for older orders. Amounts retain the parent order's currency; unpaid and cancelled orders remain labeled by status. Product prices use the store's currency. Account permissions and the records available from the provider determine which rows can be read.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
ActiveCampaign
Airtable
Attriboo
beehiiv
Bing Webmaster