Sitelucent logo

Find out how to use the Product Management template

This template guides you through all possible values and column names you can enter and upload to our product management feature

In need of assistance? Read the Introduction to Product Management or send an email to support!

Mandatory fields – Column A – E

Field name Required? Definition Valid Values Example

GTIN

Code(s)

Required The GTIN code (i.e. EAN, UPC, ISBN, etc.), is a unique code assigned to a product to identify it.  GS1 standard.  8718696154014
Brand name Required The official brand name of the product. A valid brand name. Philips
MPN Code(s) Required The Manufacturer Product Number. Please note: An ASIN is NOT an MPN code. A valid manufacturer code. 915000131203
Other code(s) Desired An additional code. This can be a local code, or even a specific retailer code (like ASIN)  An additional code. 1710286PN
Product name Required The official name of the product. Use your companies standard language. An official product name. Nightingale wall lantern rust 2x35W 230V

Retailer assortments – Column F and further

You can see the retailer names for which you can define a Retailer Assortment, followed by a [number].

Do not make any adjustments to it!

Fill in a “Y”“X”, or “YES” in the columns to indicate whether a product is being sold at the retailer mentioned in that column.

Use “N”, “NO” or leave the cell empty/no value, to indicate that the product does not belong to the range of the retailer in question.

Blanks will be considered as a “NO“.

Product tags – No specific column order

Each tag shows up as a custom filter, such as Product Categories, Model Names, or Product Lifecycle Stages.

There is no specific column order for tags, although you can only place tags after the retailer assortments.

Field name EXAMPLE: Required? Definition EXAMPLE: Valid Values Example
Product Category Optional The main categories in which you organize your products.  max. 255 characters, spaces included* Outdoor Lighting
Subcategory Optional The subcategories in which you organize your products.  max. 255 characters, spaces included* Lanterns
Model Name Optional The model names your company uses for a range of products. max. 255 characters, spaces included* Wall lanterns
Product Life Cycle Stage Optional Is a product a new product introduction, an active product, or in the end-of-life product phase?  max. 255 characters, spaces included* Active

* In case you want to add multiple values in 1 cel, separate them with a pipe symbel “|” (no spaces). Points at the end of a value and Capitals are ignored. 

Product attributes – No specific column order

Attributes can be used in the DCC criteria to measure content completeness or correctness. For example, you can use the RSP to measure price deviations or include and measure if specific keywords are used in product descriptions.

There is no specific column order for Attributes, although you’re only allowed to place Attributes after the retailer assortments.

Field name EXAMPLE: Required? Definition EXAMPLE: Valid Values Example
RSP Optional The recommended selling price of the product max. 255 characters, spaces included* 39,99
Colour Name Optional The name of the color of the product. max. 255 characters, spaces included* Rust|black
Length (cm) Optional The length of the product in cm. max. 255 characters, spaces included* 18 cm|18 centimeter
Weight (grams) Optional The weight of the product in grams. max. 255 characters, spaces included* 100 g|100 gr|100 gram|100g|
Size Optional The size of the product. max. 255 characters, spaces included* Medium|M
USP / Keyword Optional A keyword or unique selling point should be mentioned in a product detail page’s product title or description. max. 255 characters, spaces included* Buitenverlichting|garden|tuin

* In case you want to add multiple values in 1 cel, separate them with a pipe symbel “|” (no spaces). Points at the end of a value and Capitals are ignored. 

sitelucent logo footer

Subscribe to our newsletter to stay in touch with our latest news

Sitelucent
Bogert 1
5612 LX Eindhoven
The Netherlands