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:

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:

  1. Select Create Products
  2. Select Click to Upload Spreadsheet

Step 2: Mapping the product fields 

  1. 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. 
  2. 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: 

  1. Select History > Import History
  2. Select the Import Name from the list.

Step 4: Editing your newly created products.

  1. 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

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.