One Product One Line (options in cells)
In this price list format, the product including its options is on one line. It is in this format that the plugin exports products with options:
In this example, we have 5 products with SKUs in column 1 and the "Color" option in column 6. Product prices and quantities are in columns 3 and 4, and option values prices and quantities are in separate columns 5 and 7.
Option values are separated by semicolons. The same symbol separates prices and quantities in columns 5 and 7.
For option values, prices, and quantities, the separator has to be the same.
The following characters can be used as a separator:
; | : /
If a different separator is used in the price list, then it can be added to the module code in the admin/model/catalog/suppler.php file. In two places, after the lines: $ss = '/';
uncomment /* */ the code and replace the "comma" character with another one.
Supplier's form settings
Columns 5 and 7 (see the image above) cannot be used for product price and quantity, because their content is not a number. At the same time, the "Product price" and "Product quantity" are required in the supplier form.
Fortunately, there are such columns in this price list - these are columns 3 and 4:
The result of such a setting, using the example first product will be:
- product price: 9
- option values and prices: big +0, middle +1, small +2
- product quantity: 10+12+14 = 36
If these columns (3 and 4) are missing, you have to enter arbitrary numbers in the supplier form, set the quantity by default, and use the "Set price by minimum option" button for the price:
The result of such a setting, using the example first product will be:
- product price: 9
- option values and prices: big +0, middle +1, small +2
- product quantity: 10+12+14 = 36
The product quantity was set to 9 by default, because if the quantity is 0 the product price is not updated. Then the plugin recalculates the correct product quantity as the sum of the options quantities.
Products in rows 2 and 3 will only be added or updated if there is a price for the item in the price list since option prices are in addition to that price.
Options tab settings:
"General buttons" settings:
