Upload Products

1- Creating content files

The first step is to create your own content for uploading. If possible, use data from a retailer.

At least two files have to be filled to successfully uploading.

It is possible to upload product data through different file formats:

• excel

• csv

You can see below two examples created in excel2007 format:

• • products-colour.xlsx: Every row or entity in this file defines the general information of a product that is shared between its different variations. 

  • skus-colour.xlsx: The rows or entities in this file define variations of a product.

In the picture above, there is only one product with productid 028EE1I008, but there are several skuids/codes associated with only one productid.

1.1 - Products-colour

The products-colour.xlsx file 

Must have the following columns:

• • itemtype: This is an internal attribute used by the system. It indicates to AdvanCloud if are uploading one single file (products-color) or if you are uploading two files (products-color + skus-color). 
    The possible values are:
    - sku: means you will upload a single Products file (products-color).
    - skucolor: means you will upload two separate Products file (products-color + skus-color)

  • productid: is the alphanumerical identifier that represents a family product. Typically, a set of products in different colors have the same productid.

  • skuid,code: It refers to the unique identifier for a combination of product+color+size. The barcode of the product is called code in AdvanCloud and it’s also used as the SKU identifier, skuid. Most of the times skuid and code use the barcode of the product as unique code, that’s why they are represented as a single column. You can separate them in two different columns if they have different values.

Can have the following columns:

• • colour.code: The code that represents the item color, for example, an HTML color code (e.g. #FF5733), or a color code defined by the retailer. If the code is HTML, interactive systems can identify it and display it in the template.

  • colour.name: The name of the colour on "colour.code" (e.g. Camel biege melange)

  • buyurl: URL where to buy the product.

  • currency: The currency associated with the price ($, €, ...)

  • price: The price of the product, cell format has to be text.

  • name: The name of the product.
    - If different translations for the text are needed, 
    - The attribute translation header will be defined as:
          The attribute followed by an underscore “_” followed by the two-letter language code from the ISO 639-1
    - E.g.:
        name_es (name in Spanish)
        name_fr (name in French)
        name_it (name in Italian)
    - Translation can be applied to any text.

  • description: The description of the product, in the default language.

  • material: The description of the product material, in the default language.

  • images[0]: The URL where the image is located (e.g. https://keonn.com/wp-content/uploads/2020/06/ADRD-70-M2.jpg) or the name of the image associated with the product (e.g. 093EO1D011_604.jpg) has to be uploaded previously to AdvanCloud through WebDav (guide here).
    - If you want to upload different images for the same product you have to add more columns with images[1], images[2], images[3], images[4],···, images[n].

  • videos[0]: The name of a video associated with the product (e.g. 093EO1D011_604.mp4).
    - If you want to upload different images for the same product you have to add more columns with videos[1], videos [2], videos [3], videos [4],···, videos [n].

  • recommended[0]: A product to be recommended. Fill this column with the skuid,code of the product you want to recommend. This is only available for interactive systems.
    - If you want to assign different recommendations you have to add more columns with recommended[1], recommended[2], recommended[3]

  • retailer: The name of the retailer.

  • reference:  This is a reserved field that appears in every inventory download, you can use it for getting extra information in your inventory export template. 

1.2 - SKUs-colour

The skus-colour.xlsx file:

Must have the following columns:

• • productid: An alphanumeric group of characters that identify a product (e.g. 118CC2I010)

  • skuid: Identifies the SKU (reference + color + size).

  • code: EAN13 Code associated with the product (e.g. 1118362408477). 

Can have the following columns:

• • colour.code/color.code: The code that represents the item colour, for example, a hexadecimal representation of a colour (e.g. #a38062) (HTML)

  • colour.name/color.name: The name of the colour on "colour.code" (e.g. Camel beige melange). This field has to be equal to one stated in the products-colour file.

  • size: The product size  (e.g. S, XS, M, ...)

3. Products file example