CSV file
The table below presents the column names and their descriptions for products in a CSV file. When a column is required, all corresponding values must be provided in the rows of that column.
File description
Section titled “File description”| Header | Mandatory | Type | Description |
|---|---|---|---|
| product_id | YES | Text | This field identifies a product. |
| title | YES | Text | This field corresponds to the name of the product as it is displayed on the product detail page. |
| link | YES | Url | This field corresponds to the URL of the page of a given product. |
| image_link | YES | Url | This field contains the URL of the product image. |
| alternative_image_link | Optional | Url | This field specifies the URL of an alternative image of the product. |
| brand | YES | Text | This field indicates the brand name of the product. |
| category | YES | Text | This field indicates the identifier of the category of the product. Example: |
| taxonomy | Optional | Text | This field lists the complete categorization of the product. (code and label separated by ::) Each category level must be separated by the >> character. Example : |
| price | YES | Number | This field corresponds to the price of the product. The decimal separator must be a dot (.) with no thousands separator. Example : |
| sale_price | Optional | Number | This field corresponds to the price of the product when it is on sale. The decimal separator must be a dot (.) with no thousands separator. Example : |
| availability | YES | Text | This field indicates the availability of the product on the site. Example : |
| condition | Optional | Text | This field indicates the condition of the product. Example : |
| rating | Optional | Number | This field indicates the average rating of the product. The decimal separator must be a dot (.) Example : |
| reviews | Optional | Number | This field indicates the number of reviews on the product. |
| gtin | Optional | Text | This field indicates the international GTIN item code of the product. Depending on the type of product, these may be EAN, UPC or ISBN codes. |
| description | Optional | Text | This field corresponds to the product description. |
| attribute_[code] | Optional | Text | This field should be used to add specific attributes. Example: The column name may be "attribute_color" and the column value "blue". |
| offer_id | Optional | Text | This field corresponds to the unique identifier of the offer. This field is required for a MarketPlace |
| seller_id | Optional | Text | This field corresponds to the seller identifier of the offer. This field is required for a MarketPlace |
| seller_name | Optional | Text | This field corresponds to the name of the seller of the offer. This field is required for a MarketPlace. |
Example
Section titled “Example”CSV
product_id;title;link;image_link;alternative_image_link;brand;category;taxonomy;price;sale_price;availability;condition;rating;reviews;gtin;description;attribute_color"3761494";"Galaxy A22 - 5G - 128 Go - Blue";"https://";"https://";"https://";"SAMSUNG";"c87601";"c4001::Cell Phones>>c62901::Mobile phone>>c87601::Smartphone";"259.00";"229.00";"in_stock";"new";"4.5";"250";"8806092266223";"Smartphone 6,6 FHD+";"blue"