Product Data (CSV)

M-board provides a SFTP URL to import additional product master data from external systems (e.g. PIM). The product data file has certain requirements, and they are listed in the following section.

Sending the product data file via SFTP

To submit a product data file, the following endpoint is used and the product data file needs to be sent periodically (daily is recommended) to this endpoint:

stfp {Merchant ID}@sftp.m-board.io

The Merchant ID (Username) and API Key (Password) is required to communicate with the product data importer. These credentials can be obtained from [e-mail].

Format

Comma Separated Value (CSV)

• Must use semi-colons (;) as field separator

• Only allowed encodings are UTF-8 and UTF-16

• String-formatted fields should be enclosed by double quotes

• Filename and folder conventions:

  • The files need to be placed in the /product_data_import folder.

  • There's no explicit file naming convention e.g.product_master_data.csv

Product data file columns

Column	Data Type	Required	Description	Example
ean	String	Yes	EAN of the article.	0075678164125
brand	String		Product brand	HUGO BOSS
product_group	String		Product category	Jeans, T-Shirt
product_name	String		Product name, highly recommended field as this helps stores to identify the product.	Superstar Track Jacket, Converse Sneaker
description	String		Product description	Denim Shorts in schöner Waschung. Elasthananteil für bequemen Sitz
gender	String		Gender	Allowed values: male, female and unisex
age_group	String		Age group	Allowed values: adults, teens, kids, babies, newborn or unknown
picture_1-n	String		Additional picture URLs	https://api.fashioncloud.co/v2/products/media/images/60b4d44328ebf50011dd3246?token=0c6da146dd36758385a428fac6b6b0c8&px=200&minAcceptableSize=200
material	String		Product material composition	Obermaterial: 81% Baumwolle, 17% Polyester, 2% Elasthan
care_instructions	String		Product care instructions	Maschinenwäsche bei 30°C, Schonwaschgang, nicht Trockner geeignet
tag_1-n	String		Article tag, helps stores to control feed upload by tag value	Promotion, NO_DISCOUNT, SALE
search_color	String		Search color	Allowed values: black, white, brown, gray, green, pink, red, beige, blue, orange, multicolor, gold, silver, violet , yellow