Stock Upload (CSV)

We expect to receive stock updates periodically from the store's ERP system. The stock file sent from the stores has certain requirements, and they are listed in the following section.

Sending the stock file via SFTP

To submit a stock file, the following endpoint is used and the stock file needs to be sent periodically to this endpoint:

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

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

Testing the connection

Use the instructions that follow to transfer files from the command line using OpenSSH.

1. On Linux or macOS, open a command terminal.

2. At the prompt, enter the following command: stfp {Merchant ID}@sftp.michelberger.digital

3. (Optional) To view the user's home directory, enter the following command at the sftp prompt: pwd

4. To upload a file from your file system to the server, use the put command. For example, to upload hello.txt (assuming that file is in your current directory on your file system), run the following command at the sftp prompt: put hello.txt

   A message similar to the following appears, indicating that the file transfer is in progress, or complete: Uploading hello.txt to /my-bucket/home/sftp_user/hello.txt

   hello.txt 100% 127 0.1KB/s 00:00

Detailed instructions how to transfer files using different clients (e.g. WinSCP, Cyberduck or FileZilla) can be found here.

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 conventions:

  • Prefix FULL for daily full imports e.g. FULL_store1_2022-07-30T04:55:30.csv

  • Prefix DELTA for hourly delta imports e.g. DELTA_store1_2022-07-30T17:30:30.csv

Stock file columns

Column	Data Type	Full-Import	Delta-Import	Description	Example
store	Integer	Required	Required	Store identifier that represents a unique store in your source system.	501
ean	String	Required	Required	EAN of the article. Unique per store in the file, otherwise such articles are dropped and not handled.	0075678164125
quantity	Integer	Required	Required	Number of articles available at the store.	12
product_number	String	Required	Required	Unique product number that the client uses to identify a specific product.	88882572, 18751-060
price	Float	Required		Current selling price of an article, use dot . as a decimal separator, e.g: 10.54.	131.95
retail_price	Float	Required		Retail price of an article (RRP) is the original price of the article before applying any discount. Use dot . as a decimal separator, e.g: 10.54	329.95
brand	String	Required		Product brand	HUGO BOSS
product_group	String	Required		Product category	Jeans, T-Shirt
article_size	String	Required		Article size	S, 32
purchase_price	Float	Required		Purchase price	78.95
article_number	String	Recommended		Article number	18751
product_name	String			Product name, highly recommended field as this helps stores to identify the product.	Superstar Track Jacket, Converse Sneaker
article_color	String			Article color	White
article_color_number	Integer			Article color number	142
season	String			Article season, highly recommended field as this helps stores to control feed upload by season.	FS 2021
first_purchase_date	String			First purchase date, highly recommended field as this helps stores to control feed upload by first purchase date.	2022-07-01
store_article_location	String			The article location helps the store clerks to locate the article within the store.	3rd Floor, 201
picture	String			Default picture URL	https://api.fashioncloud.co/v2/products/media/images/60b4d44328ebf50011dd3246?token=0c6da146dd36758385a428fac6b6b0c8&px=200&minAcceptableSize=200
tag_1-n	String			Article tag, helps stores to control feed upload by tag value	Promotion, NO_DISCOUNT, SALE
gender	String			Gender	Allowed values: male, female and unisex
age_group	String			Age group	Allowed values: adults, teens, kids, babies, newborn or unknown
description	String			Product description	Denim Shorts in schöner Waschung. Elasthananteil für bequemen Sitz
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
product_group_number	Integer			Product group number	23124
erp_inventory_item_id	String			Internal ERP inventory item id	45213620895960
erp_variant_id	String			Internal ERP variant id	43118558642392
erp_product_id	String			Internal ERP product id	7765899346136
company_id	String			Company id (group of stores) item belongs to	m1

Sample stock file

Full-Import

store;ean;price;retail_price;quantity;product_number;product_name;article_number;article_color;article_size;store_article_location
100;5704498811166;99.95;99.95;10;"TOB21N00G";"Jeans Skinny Fit";"TOB21N00G-K11";"niceville mid";"24x30";"301"
101;4061749183108;169.95;199.95;2;"272762";"ZAIDA TURTLENECK - Strickpullover - nou...";"4060606039817";"Blue";"M";"1st floor"

Delta-Import

store;ean;quantity;product_number
100;5704498811166;10;"TOB21N00G"
101;4061749183108;2;"272762"