Our Import Products Tool offers an efficient and user-friendly way to streamline the process of creating new or updating existing products in bulk to your BigCommerce store.
The Import Products Tool does not support updating variants. To update variants, use our Variant Updater tool.
Step 2: Launch Tool & Select File
To begin, launch the Import Product Tool from the tile on the Your Store Tools dashboard.
If your CSV file contains a SKU that does not exist in BigCommerce, you can opt to have a new item created automatically. If this option is toggled on, it is important to note that:
- Product Type will automatically be set to “physical”
- Weight will automatically be set to “0”
Step 3: Map Your Fields
Map the columns in your CSV file to the appropriate fields, then click Next.
Step 4: Select Your Notification Type and Submit
By default, Your Store Tools will provide a notification on the dashboard as well as a notification via email when the job is complete. If you choose not to receive a notification via email, you can turn this option off on this screen, or change the email address it will be sent to.
Once your selection is made, click Submit to finish.
How to Set an Image as the Thumbnail in Your CSV
If you are specifying image URLs in your CSV file, you can specify which one of those to use as the product’s thumbnail by entering the numeric value (1, 2, 3, 4, or 5) in a column you will map to the “What image should be used as the product thumbnail” field during the mapping process.
If you are creating a NEW item via a CSV upload, your CSV file should look like the example below, having columns for each of the images you are assigning to the item. In this case, three images are being as being assigned, with image_3 being marked to be used as the thumbnail.
If you are updating EXISTING items via a CSV, your CSV file should look like the example below and MUST include the BigCommerce image_id_X columns with the value. If these columns and values are not included when updating existing items, additional images will be added to the item as they are treated as new.
In this example, item 1234 is being updated to use image_2 as the thumbnail.
How to Delete Contents of Select Fields
If you want to delete the contents of specific fields, simply put the word “delete” in your CSV file as the value.
The delete function can be used on the following fields:
- Description
- Product Tax Code (Tax Provider Tax Code)
- Warranty
- Layout File (Template Layout File)
- UPC (Product UPC/EAN)
- Manufacturers Part Number (MPN)
- GTIN (Global Trade Identification Number)
- Search Keywords
- Availability Description (Availability Text)
- Meta Description
- Preorder Message
- Page Title
- Categories (numerical value for Category ID)
- Related Products (Show Related Products on Storefront)
- Meta Keywords
Additional Tool Features
By accessing the stacked menu in the upper right corner of the tool's tile from the dashboard, you can access the following:
- History - a list of the last 7 days of processing history for this tool.
- Help - a link to this support document.
If any errors were reported, from the stacked menu, you can retry to run the job or download the error file.
Additional Options for Premium Plan Subscribers
Scheduling a Tool to Run at a Later Day and Time
Premium subscribers have access to schedule tools to run in advance. This option will be displayed after you set your notification type.
By default, the scheduling option is set to No. If you do not want to schedule the tool, click Submit.
If you want to schedule the tool to run at a later time, click Yes.
From here you can select to schedule the tool to run at a specific date and time:
The scheduled start time is the time the tool will run, not complete.
Once you set the day and time for the tool to run, click Submit.
Scheduling a Tool to Run on a Recurring Schedule
Premium subscribers have access to schedule tools to run in advance. This option will be displayed after you set your notification type.
By default, the scheduling option is set to No. If you do not want to schedule the tool, click Submit.
If you want to schedule the tool to run at a later time, click Yes.
From here you can select to run the tool on a recurring basis:
Options for recurring jobs include:
- Schedule Start Date and Time: The day and time the first instance will run.
- Repeat: The recurring schedule for this tool, which can be:
- Daily
- Weekly
- Monthly
- Specify Hour: The hour of the day the tool will run.
- Times are based on the time zone set up in your Company Profile.
- Recurring runs can only be schedule at the top of the hour.
- Ends: When the recurring job should stop. Options include:
- Never
- After a set number of runs have completed
- On a specific date and time
The scheduled start time is the time the tool will run, not complete.
Once your recurring options are set, click Submit.
Scheduling the Update Guest Order Tool to Automatically Check Historical Orders
In addition to the regular scheduling option available on all tools with the premium plan, the Update Guest Order tool allows store owners an additional scheduling option for checking historical orders on a regular, recurring basis.
This additional schedule, allows you to do the following:
- Schedule a daily run to check and associate orders from the previous day.
- Schedule a weekly run to check and associate orders from the previous day, week, two weeks, or three weeks.
- Schedule a monthly run to check and associate orders from the previous day, week, two weeks, three weeks, month, two months, or three months.
In order to use this method for scheduling, you must set the schedule by going to the tool's tile in the Your Store Tools dashboard and select Create Schedule from the stacked menu:
From there you can schedule the tool to run on a daily, weekly, or monthly basis.
Did you find an error or need additional support? Contact us at support@yourstorewizards.com to let us know!