Add or Update Articles

Objective:

  • Add new articles.

  • Update existing articles when article_external_id already exists.

Filename:

  • Pattern: AddArticles_xxxxx

  • Example: AddArticles_20240123-093412.csv

Columns:

Header

Alternative header

Requirement

Description

id

article_external_id

Mandatory

Unique article identifier

name

name

Mandatory

Article name

sizes

sizes

Mandatory

List of available sizes, for example S;M;L;XL

customers

customer_external_id

Optional

Associated customer ID

Notes: * article_external_id is the stable identity of the article. * sizes can contain one or more sizes. * sizes must be quoted when using ; inside the value, for example "S;M;L;XL". * customer_external_id should be sent when available and is required for supplier imports.

Examples:

As supplier:

article_external_id;name;sizes;customer_external_id
12-3;T-Shirt Blue;"S;M;L;XL;2XL";1118-3
12-1;T-Shirt Black;"XS;S;M;L;XL";1118-3

Multiple customers in one file (one row per customer):

article_external_id;name;sizes;customer_external_id
12-3;T-Shirt Blue;"S;M;L;XL;2XL";1118-3
12-3;T-Shirt Blue;"S;M;L;XL;2XL";1118-4
12-1;T-Shirt Black;"XS;S;M;L;XL";1118-5

As customer:

article_external_id;name;sizes
12-3;T-Shirt Blue;"S;M;L;XL;2XL"
12-1;T-Shirt Black;"XS;S;M;L;XL"