How to Create New Products and Add Variants with a Spreadsheet

You can use Ablestar Bulk Product Editor to create new products or modify existing product data using a spreadsheet. This can be helpful to create brand new products from scratch, or adding variants to already existing products.

Create New Products

To create or import new products using a spreadsheet, click the 'Create products' option from the navigation menu.

Your CSV or Excel file should have at least 2 columns specified, making sure that a product-level identifier is in the first column and action items in the 2nd and subsequent columns, similar to this layout:

The columns themselves can be named whatever you want, and you can map them to the correct Shopify fields during the upload process. From this view, you can also adjusted the 'Advanced settings' for the first-column identifier:

Learn more about creating new products..

Update Existing Variants

If you want to add variants to your existing Shopify products, click the 'Spreadsheet edit' option from the navigation menu.

Your CSV or Excel file should have at least 2 columns specified, making sure that a product-level identifier is specified and action items are present in subsequent columns, similar to:

Only new or modified data that is found on the spreadsheet will be processed and added to your store.

The values are case-insensitive and leading/trailing spaces will be removed.

✅ Tips and Troubleshooting

• Learn how to skip unchanged values and increase speed on uploads
• Learn the subtle difference between product-level and variant-level identifier fields
• Create or import new products

(05.96)