Modifiers are configured with two worksheets in the spreadsheet - this is because they compose a 'parent and child' relationship -
the definitions for the actual modifiers, and then their permissible values.
For example, to create a modifier called "Size" with the options "Small, Medium, Large", you would add one line to
the "Modifiers" worksheet, and three to the "ModifierValues" worksheet.
Modifiers have an option named "HasStockImpact" - when this is enabled, the system will presume that stock is held against the
Product and Modifier combination (e.g. "T-Shirt, Large"). When it is disabled, the system will presume that stock is only held
against the product (e.g. A salad, which is available without the dressing).
A modifier may be repeated against a product, e.g. OPTION001,OPTION001 - which will then give the user the opportunity (or force the user - if the IsRequired flag is set) to
make two choices.
The Modifiers sheet contains the following columns:
- ModifierCode - Unique code identifying this modifier e.g. SIZE001
- Description - A description of this modifier, shown to the user e.g. Size, Colour, Dressing, Flavour
- IsRequired - Is the selection of this modifier compulsory when adding a connected product to the basket? E.g. y or n
- HasStockImpact - Does this modifier have an impact on stock-taking? E.g. y or n
- Enabled - Is this modifier enabled, and available for use? E.g. y or n
The ModifierValues sheet contains the following columns:
- ModifierValueCode - Unique code identifying this value e.g. SIZE001M, SIZE001L
- ModifierCode - The modifier to which this value applies e.g. SIZE001
- Description - The description of this modifier (shown to the customer) e.g. Small, Medium, Large
- PriceChange - The impact this value has on the price of the product in GBP, e.g. 0, 0.10, 1.00
- WeightChange - The impact this value has on the weight of the product in grams, e.g. 0, 10, 100
- Default - Is this value the standard choice for it's linked modifier? y or n
- Enabled - Is this value enabled and available for use? y or n
Previous topic:
Products
Next topic:
Hierarchy