If you have a product using the "Variants having individual price/weight/stock/SKU" setting, especially if it has a LOT of possible combinations of options, you may find it easier to use a spreadsheet program such as Excel to help you populate values for your Variants configuration lines:
- Copy the generic format line from your Variants screen:
SKU,Price,Ounces,Stock,Option1Value,Option2Value,Option3Value
...OR for an existing product, copy its existing Variants configuration lines;
- Paste that into the first line of a new spreadsheet file;
- Add/edit the corresponding values in subsequent lines for every possible combination of option values (ideally with no quoted values, if possible);
- Save or Export that spreadsheet as a CSV (comma-separated values) file;
- Open that file in Notepad (Windows) or textEdit (Mac);
- Select All and Copy the text from there (delete or omit the generic first line);
- Paste from there into the appropriate box in our Variants screen;
- Click Next until you can Submit the new settings;
- If you edited the option values for an existing product, sure you recopy your new Add to Cart button code and repaste that into your page.
