Sales Import (CSV)

We provide a SFTP URL to import all sales notifications related to your multi-channel business. The sales file has certain requirements, and they are listed in the following section.

Sending the sales file via SFTP

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

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

The Merchant ID (Username) and API Key (Password) is required to communicate with the sales 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 /sales folder.

  • There's no explicit file naming convention e.g. sales_2022-07-30T04:55:30.csv or sales.csv

Sales file columns

Column	Data Type	Required	Ds
store_id	Integer	Yes	Store identifier	51
sale_id	String	Yes	Transaction Identifier	550e8400-e29b-41d4-a716-446655440000
ean	String	Yes	EAN of the article	4059701022541
source	String	Yes	Name of the source system. Description of source can be found in Source Description section	amazon retail webshop
type	String	Yes	Allowed values: sale, refund	sale
timestamp	String	Yes	ISO 8061 timestamp. Only date 2024-06-03 is also possible.	2024-06-03T12:34:56Z
seller_id	String	Yes	Seller's ID ("Verkäufernumer")	12
sale_number	String	No	Can be used to group multi-item sales	421
channel	String	No	Name of the channel. Description of channel can be found in Channel Description section	amazon_de store_108
quantity	Integer	No	Sold quantity of the article. (Default: 1)	2
price	Float	No	Price of the article	99.95
country	String	No	ISO 3166 country codes.	DE AT CH
city	String	No	City of the order's address	Munich
zip_code	String	No	Zip code of the order's address	80636

Sample sales file

File with all required and optional fields

store_id;sale_id;ean;source;type;timestamp;sale_number;channel;quantity;price
1;550e8400-e29b-41d4-a716-446655440000;4059701022541;retail;sale;2024-06-03T12:34:56Z;belege_123;store_108;1;99.95

File with only required fields

store_id;sale_id;ean;source;type;timestamp;price
1;550e8400-e29b-41d4-a716-446655440000;4059701022541;retail;sale;2024-06-03;99.95