Product (P)

A Product represents a single item offered for sale. It is often referred to as a stock-keeping unit (SKU)—a distinct item that can be taken from inventory and sold.

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.

createdDate – The date and time when the product was added to the table. Hidden by default.

createdBy – The user who added the product to the table. Hidden by default.

lastUpdateDate – The date and time when the product was updated for the last time.

lastUpdateBy – The user who updated the product for the last time. Hidden by default.