How to Export CSV Data from BigCommerce and Import It into clariBI

BigCommerce is a robust e-commerce platform with built-in CSV export capabilities across orders, products, and customers. Importing this data into clariBI enables AI-driven analysis of your store performance.

What You Can Export from BigCommerce

• Order records with line items, totals, taxes, and shipping details
• Product catalog with variants, pricing, inventory, and categories
• Customer records with contact information and order history
• Store analytics and traffic reports
• Coupon and discount usage data
• Shipping and tax configuration data
• Brand and category performance data
• Abandoned cart data

Export CSV Data from BigCommerce

Method 1: Export Orders

1. Log in to your BigCommerce admin panel
2. Navigate to Orders in the left sidebar, then click Export Orders to open the dedicated export page
3. Select the export template or choose Default for all standard fields
4. Use the filter options to narrow by date range, order status, or payment method
5. Choose CSV as the file format
6. Click Export and download the file when it is ready

Tip: For large exports (1,000+ orders), select the Server Storage option instead of a direct download. BigCommerce will save the file on the server for you to retrieve, which is more reliable for large datasets.

Method 2: Export Products

1. Go to Products in the left sidebar
2. Apply filters by category, brand, availability, or inventory status if needed
3. Click the Export button at the top of the product list
4. Select the fields you want included in the export
5. Choose CSV as the format
6. Click Export and download the file

Method 3: Export Customers

1. Navigate to Customers in the left sidebar
2. Click the Export button at the top of the customer list
3. Select the customer fields to include (name, email, phone, address, group, date created, etc.)
4. Choose CSV as the format
5. Click Export and download the file

Method 4: Export Analytics Data

1. Go to Analytics in the left sidebar
2. Select a report such as Overview, Real Time, Merchandising, or Marketing
3. Set the date range using the date picker
4. Click the Export or Download button on the report page
5. The report data will download as a CSV file

Tips for Clean Exports

• Use the date range filters before exporting orders to keep files focused and manageable
• Export products with inventory data included to perform stock-level analysis in clariBI
• BigCommerce export templates let you save custom field selections for repeated exports

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "BigCommerce - Orders March 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What is my average order value by customer group?"
- "Which product categories have the highest conversion rates?"
- "Show me a revenue comparison between this month and last month."

clariBI's AI will automatically analyze your data and suggest relevant insights.