How to Import 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

Importing new products can be simplified with a spreadsheet. All you need is a CSV or Excel file with 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.

Update Existing Variants

This is helpful if you want to add variants to your existing Shopify products.

This spreadsheet would require at least two columns, making sure that a product-level identifier is in the first column and action items in the 2nd and 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. Click this related article to see more advanced spreadsheet detail.

✅ Tips and Troubleshooting

• Learn how to skip unchanged values and increase speed on uploads.
• Spreadsheet values are case-insensitive and leading/trailing spaces will be removed

(05.96)