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:

Product Title Description Price
My Product A This is a description 9.99
My Product B This is a description 10.99

The columns themselves can be named whatever you want, and you can map them to the correct Shopify fields during the upload process.

Learn more about configuring the import.

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 in the first column and action items in the 2nd and subsequent columns, similar to:

Product Title Description Price Variant
My Product A This is a description 9.99 White
My Product B This is a description 10.99 Bronze

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. Click this related article to see more advanced spreadsheet detail.

✅ Tips and Troubleshooting

(05.96)

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

Still need help? Contact Us Contact Us