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
- 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)