Product Attributes
These attributes appear on the Product Related Sheets.
IsSKU
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
If there is a demand for the product, you must enter a 1 in the IsSKU column, otherwise the application will not treat it as a product.
IsUnion
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
In the InUnion column we identify the product groups that are created by taking the union of two or more other products or product groups.
IsIntersection
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
In the IsIntersection column we identify the product groups that are created by taking the intersection of two or more other product groups.
SubProduct
- Sheets on which it appears
- Possible inputs
An existing product or product group
- How it affects the model
In the SubProduct column can be used to specify element of a product group.
UOM
- Sheets on which it appears
- Possible inputs
String
- How it affects the model
In the UOM column you can specify the unit with which a product is measured. The default/base UOM is used in all sheets that do not contain a UOM column.
UOM Equivalent
- Sheets on which it appears
- Possible inputs
Any number greater than 0
- How it affects the model
In the UOM Equivalent column, you can specify how many base units will fit into the new unit.
If the base unit is kg.
Product
UOM
UOM Equivalent
Product 1
tons
1000
If the base unit is tons.
Product
UOM
UOM Equivalent
Product 1
kg
0.001