Product (P)

A Product represents one thing being sold. Many times refered as an SKU, i.e. Stock Keeping Unit - an item which you can take from stock and sell.

Fields

sku – (unique key) Unique ID of the product.

label – Description of the product.

image – (Boolean) If we have an image for this product. See how to add an image to a product.

attribute1..30 – Custom attributes for storing properties of the product (e.g. size, weight, color, product group, hierarchy levels,…​). Ideally, values of these attributes should not change in time because there is no value history kept. For keeping attribute values, which depend on time, it is better to use a Product Extension table.

currency – Symbol of the default currency in which you calculate the price of this product. This value is automatically copied to PLI or PGI when a price list is calculated.

unitOfMeasure – Symbol of the default unit in which you measure and sell the product – e.g. PCS, KG, T, M, KM, etc. It is likely that you will calculate the price in this unit. This value is automatically copied to PLI or PGI when a price list is calculated.

formulaName – (do not set this unless you are really sure) Name of the logic which should be used in the price list or quote line item for calculation of the line item. This logic will override whatever logic is set somewhere else in the price list or quote, so use it only in very special cases.