The Excelify app makes migrating Products from BigCommerce to Shopify a bit easier.
This import will convert your BigCommerce Products into Shopify Products, create Redirects from old BigCommerce URL to Shopify URL and create simple Custom Collections that your products are in.
Any custom fields in the BigCommerce export file or fields that are not used in the Shopify, will be created as Metafields in Shopify.
Let’s dig into the process of how to migrate the BigCommerce Products into Shopify.
Quick summary to migrate your Products
- Export your Products from BigCommerce to CSV file using advanced Product export in BigCommerce.
- Rename the exported file so it contains the words “BigCommerce” and “Products“, e.g. “BigCommerce_products-2020-08-06.csv”.
- Upload your file to the Excelify app.
- Under Options, choose “Dry Run” – to not import just yet.
- Download generated Import Results file and check that Products are as you need them, make corrections if needed.
- Import that tidy Excel file.
- Enjoy your BigCommerce Products in Shopify.
1. Export your Products from BigCommerce
To migrate data as fully as possible, we will need to create advanced Product export in BigCommerce by creating new export template.
1.1. Create a new Export Template in BigCommerce
In your BigCommerce admin, go into Advanced Settings -> Export Templates under “Bulk Edit” template open the Action dropdown menu and select “Create a Copy”
Next, you can edit the new template.
Set a new name for the template, for example, “Export for Excelify“.
The only other option you need to change is to enable exporting product image links.
Open the “Products” tab in this new template.
Scroll down to “Product Images” and select “Product Image URL”
Leave all other checkboxes and settings for the template as they are by default.
Once all that is edited, press the “Save & Exit” button at the bottom.
1.2. Export products with the new Export Template
Now we do have a template that we need to export to.
Head back to Products -> Export on your BigCommerce Admin. On this page select your newly created template.
The format should be “
Then follow the instruction on the screen to export products and download the exported file.
2. Rename the exported file
For the app to correctly detect what and from where you are importing, you need to give the file the correct name.
When you download your exported CSV file from BigCommerce, it will be called something like this:
For Excelify to know that this is a BigCommerce file, you need to change that file name so that it contains words “bigcommerce” and “products”. For example:
3. Upload the file to Excelify
Now you can head into your Shopify store and open Excelify app.
In the app Home page, you can see the Import section, click on it to select the file from your computer or drag and drop it in the import area from your folder.
You should see that the app detects the format as “Format: BigCommerce”
Right away, after Excelify analyzed the file, you will see how many “Products” are found in the file.
This is product count not including their variants.
You can also see that the app will create a Redirect for each product. So that once you switch your store domain to Shopify, then customers that are visiting product URLs with the old BigCommerce paths are redirected to the correct product in Shopify.
Press the “Import” to start the dry-run import job.
Good to know:
- If you see that Format is recognized as “Excelify” or any other format then do not continue the import and make sure that filename is set correctly to include words “bigcommerce” and “products”.
- If you are receiving an error “BigCommerce Products: Required columns not found in your file” then you have either exported to default BigCommerce export template or have not correctly selected to include image URL column as per step #1.
4. Select the “Dry Run” option to generate Excel file
Once you have confirmed that details about the job look correct, you can scroll down to the “Options” section of the import job.
In the Options, you would need to select “” option.
Leave all other options as they are by default.
With Dry Run, the app will process the BigCommerce CSV file and generate an Excelify template Excel file.
Excel files are a lot simpler to work on and a lot more stable than CSV files so if you need to adjust, fix, or clean-up any data before import, do that in the “Dry Run” generated Excelify Excel file, and not in the exported BigCommerce CSV file.
5. Download generated Import Results file and check data
Once the dry-run has completed, which should be relatively quick, you can press on the “Download Import Results file” button to download the generated file.
Now you can check the file to see if the data matches your needs. Do your data cleanup, adjust any data that you need to be different, and basically – tidy it up.
Each column from our Products template is explained in the Products template documentation page.
Good to know:
- Shopify has a limitation of 100 Variants per product. Becouse of this, if the product has more than 100 Variants, then Excelify splits that product into several products by 100 Variants each. For example, if you have 243 variants, then Excleify will create 3 Products in the file, two with 100 Variants and one with 43. All the Basic Columns and images for those products will stay the same, except for the “Handle” which will have “-1”, “-2”, etc. added to the end of it. In this way you can then glue them together on your storefront.
- Shopify allows a maximum of 3 Options per Product. If your Product has more than 3 options, then Excelify will join the 3rd and any more options into one 3rd option.
6. Import that tidy Excel file
Once you have checked that all data matches your needs you can finally import the file.
Head back to the Excelify app and on the Home page, Import section upload your corrected Excel file.
Now you should see that format is “Excelify”.
Make sure that product counts are correct and that there are no unexpected warnings showing.
This time, you do not need to select or change any options.
If it all looks correct, then press the “Import” button to start actually importing data into Shopify.
If you see any Failed items, then after the import has finished, you can again download the Import Results file and look into the “Import Comment” column. It will tell why the particular product failed. Then you can fix that issue and re-import just those failed and fixed rows again.
Once the import is started, you can follow its progress in the app.
You can close the app while the job is running as everything is happening in our servers.
By default, Shopify store owner email will receive a notification email when manual import job finishes.
You can, at any time, open the Excelify, and on the Home page see the last 5 jobs including any running jobs. Click on the job to open it and see its details and progress.
If you change your mind about something, you can press the “Cancel” button to cancel the import job, and start over. Thus far imported Products will still be on your Shopify store. Also, when canceling the import job, Excelify will still generate the Import Results file for you for the items as far they are imported.
7. Enjoy your BigCommerce Products in Shopify
After finishing the import can go into your Shopify store and enjoy your migrated Products.