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.

Prerequisites

In order to follow along you should have:

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.

Next Steps

Now that you've performed a bulk edit there's several things you can try:


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.