Basic Product Excel Fields

The following figure is an example of the basic product Excel file contents.

Some of the basic product Excel fields are mandatory. In addition, we recommend that some of the optional fields should be always filled; the following example Excel file contains the minimum mandatory and recommended fields.

Example file:

SimpleStockProducts.xlsx

Mandatory and Recommended Fields

Field	Type	Mandatory/ Optional	Description
id	string	O	Product ID. If this field is left empty, the system will automatically generate a unique ID and create a new product. If you import same product twice with the id field empty, you will end up with duplicate products. Take extra care to avoid this, as mass deletion of products is not currently supported in Commerce Cloud. If a product corresponding to the ID already exists in the system, the product information will be modified according to the Excel file contents.
name	string	M	Name of the product. Minimum length 3 and maximum length 80 characters.
sku	string	O	GTIN/EAN code of the product. Note: If there is a need to follow up the amount of product in Stock, filling this field is mandatory.
taxpercent	decimal	M	Tax percentage of the product. Value must be between 0 and 100; typical values are 10, 14 or 25,5.
measurementunit	enum	M	Measurement unit of the product. The default value is pcs (pieces). Other most common valid values include: kg, g, l, cl.
standardprice	decimal	O	Sales price of the product, including taxes.
averageinpricetaxless	decimal	O	Average inprice of the product without taxes.
category:group	string	M	Identifier of the product’s category in the mandatory category type group. The identifier of the category type will be visible in the address field of the browser. In addition, the value of the field in Excel must be the value of the category’s ID field, and not the name of the category. In the example below: the heading of the field in Excel is category:group the value in the field is 1 (= Food category) Example with category type identifier and category ID

Additonal Optional fields

Field	Type	Description
category:{categoryType}	string - ID	Identifier of the product’s category in the category type. Note that the category type must have been created beforehand in the Back Office. When products are created with Excel import, the missing category selection will be created automatically in the system: If the product has a category type and the field contains a value: The category of the product is updated. If the category type is found for the product and the field is empty: category is removed from the product. If the category type is not found for the product and the field is not empty: new category is added to the product. If the category type is not found for the product and the field is empty: no change is made for the product.
description	string	Text description of the product. If the Excel does not contain this field, the existing description will not be modified. An existing description can be removed by leaving this field empty.
imageurl	string	Link to the product image.
sellingmultiplier	decimal	Selling multiplier; default value is 1.
barcode	string	Alternate barcode for the product.
openproduct	boolean	Defines whether the product is an open product. Default value is FALSE.
openinprice	boolean	Defines whether the product has an open inprice. Default value is FALSE.
trackserialnumber	boolean	Defines whether serial number tracking is applied to the product. Default value is FALSE.
sendtokitchen	enum	Defines the Send to kitchen setting for the product. Default value is never; other valid values are: always ifModified kitchenOrShelf
scale	enum	Defines whether the product is weighed in the store. Default value is none, and other possible values weight and piece, depending on the scale pricing method.
shortcode	number 4	Scale code consisting four digits. Only needed if the scale value is weight or piece.
additionalreceipttext	string	Additional text printed out in the receipt when the product is sold. Typical use is product warranty texts, for example.
pawnId	enum	The value of the deposit for the product. The system has the following values available as a default: P010, P015, P020 and P040 where the value of the deposit is in cents in the id.
attribute:{orderNumber}:id	string - category Type	Attribute. Will set a new attribute which belongs to a certain category type, according to the running number.
attribute:{orderNumber}:mandatory	boolean	Defines whether the attribute is mandatory.
Products utilizing GS1 synchronization need also the following values:
datasource	enum	Standard value gs1.
suppliergln	string	Supplier’s GLN code.