Creating Products with the Bulk Editor
In this article we'll take you through the steps of using a spreadsheet to import products with the Bulk Editor. We'll cover:
- Formatting your spreadsheet
- Mapping the product fields to Shopify fields
- Finding and editing your newly created products
In our example we're going to import one product with three variants.
In order to follow along you should have:
- The Bulk Product Editor app installed
Formatting your spreadsheet
You can download a sample CSV template to see an example of the format required to import products using the Bulk Editor app.
In this sample file, there is one product with three variants. The label for the variants options are stored in the 'Option Name' fields, and the values for those variants are stored in the 'Option Value' fields. All variants of the same product share a 'Handle'. This is the field that groups them together in one product. You can find a complete list of the field descriptions here.
Once you have your spreadsheet ready, you can upload it into the Bulk Editor by clicking 'Spreadsheets' on the left, 'Import Products', and then 'Click to Upload Spreadsheet'.
Mapping the product fields
If the field names in your spreadsheet match the field names in Shopify, you can click 'Auto-Detect' and map the fields automatically. If the names do not match, you may have to manually map them by clicking the dropdown beside the field.
When you are ready, click 'Import Products' at the bottom of the screen to complete the import.
Finding your newly created products
After the products have been imported, you can easily find them by clicking 'History' on the left, 'Imported Products', then clicking the import on the list.
Editing your newly created products.
You can also edit them by clicking 'Edit Products' on the history page for the imported products. You can read more about in-app edits here.
Now that you've performed a bulk edit there's several things you can try:
Don't have the app yet? Get it here