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 app. 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
Step 1: 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 are three products, and the first product ( example-t-shirt) has three variants. All variants of the same product share the same 'Handle'. This is the field that groups them in one product. The option labels are stored in the 'Option Name' fields (like 'Size' or 'Color), and the data for those options are stored in the 'Option Value' fields (like 'Small', or 'Red').
You can find a complete list of the field descriptions here.
To upload your spreadsheet into the Bulk Editor app:
- Select Create Products
- Select Click to Upload Spreadsheet
Step 2: Mapping the product fields
- If the field names in your spreadsheet match the field names in Shopify, you can choose Autodetect 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, select Import Products to complete the import.
Step 3: Finding your newly created products
To find the products after they have been imported:
- Select History > Import History
- Select the Import Name from the list.
Step 4: 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.
Don't have the app yet? Get it here