Add or Update Items

Objective:

  • Add new items.

  • Update existing items when item_external_id already exists.

  • Automatically create missing articles referenced by article_external_id.

  • Automatically update article sizes when item input introduces missing sizes.

Filename:

  • Pattern: AddItem_xxxxx

  • Example: AddItem_20240123-093412.csv

Columns:

Header

Alternative header

Requirement

Description

id

item_external_id

Mandatory

Unique item identifier

article_id

article_external_id

Mandatory

Associated article ID

article_name

article_name

Optional

Associated article name or description

size

size

Mandatory

Item size

alternate_item_id

alternate_item_external_id

Optional

Secondary item label or reference

destination_id

destination_external_id

Optional

Destination or location reference

user

user_external_id

Optional

User ID for a personal item

stock

item_pool_external_id

Optional

Generic stock or pool ID

customer

customer_external_id

Optional

Customer reference

Rules:

  • The file parser accepts either header name shown in the table.

  • Either user_external_id or item_pool_external_id must be set.

  • If user_external_id is set, the item is treated as personal.

  • If item_pool_external_id is set, the item is treated as generic.

  • Do not set both on the same row.

  • Use one stock or pool value per row.

  • customer_external_id is required in supplier mode.

Article behavior:

  • If an article_external_id does not exist yet, it is created automatically during item import.

  • Item size values are used to maintain article sizes.

  • New sizes are automatically added to the related article when they appear in item input.

  • Including article_name is recommended so newly created articles get a clear display name.

Examples:

As supplier:

item_external_id;article_external_id;article_name;size;item_pool_external_id;customer_external_id
040002FB5E0;12-3;T-Shirt Green;XL;1000;4312
040002EA6B4;12-3;T-Shirt Green;L;1000;4312

As customer:

item_external_id;article_external_id;article_name;size;user_external_id;alternate_item_external_id;destination_external_id
040002AC5E2;12-1;T-Shirt Red;XL;00045321;P-45321-A;SITE-01
040002AC5E3;12-1;T-Shirt Red;L;00045321;P-45321-B;SITE-01

Mixed import:

item_external_id;article_external_id;article_name;size;user_external_id;item_pool_external_id;customer_external_id;alternate_item_external_id;destination_external_id
040002AC5E2;12-1;T-Shirt Red;XL;00045321;;4312;P-45321-A;SITE-01
040002FB5E0;12-3;T-Shirt Green;XL;;1000;4312;G-1000-1;MAIN-STOCK