CSV Files to BigCommerce Migration

Step-by-Step Guide to Importing CSV Files into BigCommerce

Step 1. Add Your Data Sources and Connect BigCommerce

Collect the files containing the products, customers, orders, and other supported data you want to transfer. Keep each data type in a separate file where possible. For exports divided into several parts, include all the files needed for the migration.

Open the LitExtension app and click New Migration. Under Source Cart Type, choose Files (CSV, Excel, Google Sheets), then add your data through the available input methods:

• File Upload: Select files from your computer or drag them into the upload area. LitExtension accepts CSV, TSV, XLSX, and XLSM files, with a limit of 50 MB per file and up to 50 files.
• Google Sheets: Set the spreadsheet’s sharing permission to Anyone with the link can view. Open the relevant tab and copy its URL. Add each tab separately, as one link reads only one tab.
• Link: Paste a public link to a CSV or Excel file stored in Dropbox, Google Drive, or OneDrive. Use a link to an individual file that can be opened without signing in.

You can combine these methods within the same migration.

Check the file names, row counts, and detected Data Type in the source list. Update the data type if it does not match the file’s contents. When a product or customer appears in more than one file, the record in the higher-listed file takes priority, so arrange overlapping files accordingly.

Check that your image URLs are publicly accessible. Fill in the optional Old Store URL to resolve relative image paths, such as /images/product.jpg, or when needed for supported redirect options.

Choose BigCommerce as the Target Cart Type and enter the connection details requested for your store. Follow the displayed instructions to complete the connection. Before importing, back up your existing BigCommerce data and pause automated emails or workflows that the imported records could trigger. Continue to Prepare Data once the connection is ready.

Step 2. Match Your Fields, Validate the Data, and Choose Migration Options

Open Field Mapping and review how each source column connects to a destination field in BigCommerce. LitExtension pre-fills mappings for recognized file formats. Compare the record previews with your source data and correct any mismatched fields.

Set the Product Identifier to the column that groups each product with its variant and image rows. Review the mapped names, SKUs, prices, stock quantities, image references, and fields linking related records.

Choose an available ID, email, or phone column for the Customer Identifier. Remove the selection from fields you want to exclude. Additional columns can be retained as custom fields where the migration supports them.

If your files use unfamiliar column names, try AI Mapping Suggestions and review the suggested matches.

Select Next: Data Check to save your mappings and check the complete dataset. This stage validates the data without importing records into BigCommerce.

Use the results to identify which records can proceed and which need attention:

• Ready: Records that can be imported, including those carrying warnings.
• Errors: Issues that stop the affected records from being imported.
• Warnings: Issues to review even though the records remain eligible for import.
• Skipped / Duplicates: Records left out because of errors or duplication.

Set the error-handling policy to either skip invalid records and continue or block the affected data type until the errors are corrected.

Download the Results File to locate the affected rows and review their status information. Correct the source values, replace the uploaded file, and click Check Again.

For a file supplied through a shared link, refresh the source with Refresh link or add the link again before rechecking. Linked files are downloaded when added, so editing the original file does not automatically update the migration’s copy.

Repeat Data Check after any change to your files, Google Sheets, or field mappings. The migration cannot start until the check reflects the latest data and settings.

Proceed to Configuration and select the supported data types you want to import into BigCommerce. Reviews are not currently supported through Files Migration.

Review the additional options offered for your migration and enable those you need. Check Order Status Mapping where available, confirm the selected data and settings, and continue to the free demo.

Step 3. Test the Import and Complete Your BigCommerce Migration

Launch Free Demo Migration to import a small sample into BigCommerce. Leave the source files and Google Sheets unchanged while the demo is running.

After the demo finishes, click View to open the imported records in your BigCommerce admin. Compare the sample with your source files, including:

• Products: Product names, SKUs, prices, variants, images, and inventory quantities.
• Customers: Email addresses and address information.
• Orders: Statuses, amounts, and links to the corresponding customers and products.

Check the outcome of any additional options you enabled. For example, if you selected redirects, visit sample old URLs and confirm that they open the intended BigCommerce pages.

Resolve discrepancies by updating the source data or correcting Field Mapping. Run Check Again, then use Demo Again to verify the revised results before proceeding.

When the demo meets your requirements, select Next: Confirm Orders, check the migration price, and complete payment. Start Full Migration to transfer all selected records eligible after Data Check. Changes to the source data or mappings require another check before payment.

Follow the transfer in My Migrations. You can close your browser and return later to view its progress. Maintain the required BigCommerce access and keep image links available until the transfer finishes. LitExtension will email you when the migration is complete.

Compare the imported record counts with the eligible Data Check totals for your selected data types. Review representative products, customers, orders, and other migrated records to confirm their values, images, and relationships. Finish by testing the relevant customer journeys in your BigCommerce store.