Importing products flat files

Reference 

• Full file template: download file template / see in Google Drive
• Data flow: from ERP to LNB
• Data types: collection, category, product, variant, SKU
• File naming: see products in the flat files automation instructions

File requirements

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

• All product variants must have the same sizing values
• EAN13 must be unique in the file, only the first row will be processed
• SKU must be unique in the file, only the first row will be processed
• a "model + variant + size" combination must be unique in the file, only the first row will be processed

File processing rules

Collections, categories, products, variants and SKUs can be sent along within one CSV file. Each row of the file carries a combination of a collection (identified by its name), a category (identified by its name), a product (identified by its model), a variant (identified by its fabric code) and an SKU (an EAN13 or SKU code).

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

• if the collection name is registered in your Le New Black data, it is updated. If not, it is created.
• if the category name is registered in your Le New Black data, it is updated. If not, it is created.
• if the product model 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)