Importing retailers flat files

Reference 

• Full file template: download file template / see in Google Drive
• Data flow: from ERP to LNB
• Data types: retailers, buyers
• File naming: see retailers in the flat files automation instructions

File requirements

If a row does not meet all these constrains, it will be ignored:

• country must be valid (ISO 2-letters) 
• price list must be valid
• sales admin email must be valid
• sales rep email must be valid
• if buyer email column is provided, a "retailer name + retailer country + buyer email" combination must be unique in the file, only the first row will be processed
• if buyer email column is not provided, a "retailer name + retailer country" combination must be unique in the file, only the first row will be processed

File processing rules

Retailers and buyers can be sent along within one CSV file. Each row of the file carries a combination of a retailer(identified by its reference) and a buyer (identified by its email).  A CSV file can therefore contains the same retailer on multiple rows with a distinct buyer on each row.

Retailers import via CSV files works in "create or update" mode:

• if the retailer reference is registered in your Le New Black data, it is updated. If not, it is created.
• if the buyer email is registered in your Le New Black data, it is updated. If not, it is created.

File schema / Main fields (see full schema in file template)