Create or update product items in batch
The product list contains individual product items where you can add sizes and manage stock. Each product always has at least one row—either a single row for items without sizes (like a water bottle or book) or multiple rows for products with sizes (S, M, L, etc.).
You can add or edit items directly in the product view. Or for batch updates, you can use the import tool. Learn more about general product import here: Import products
Key Columns for Importing/Updating Product Items:
- Id, Name, Size (required for adding/updating items)
- Additional columns: Stock, Oversellable, StaticStock, Shelf, SizeExternalId, SizeArticleNumber, ItemWeight.
ItemHeight, ItemLength, and ItemWidth can be saved per item and are accessible via our APIs, but not through the Merchant Center interface.
Creating new or updating existing products
When creating new products, if no value is entered in the Size colum, an item with the size "one size" will be automatically added. For existing products with specified sizes, ensure the size column is filled when updating fields like stock, shelf, or article number.
The system matches the value in the Size colum exactly by text. For example, if the existing size is called "one size" and you enter "One size" (with a captial O) the system will create a new row, so double-check spelling to avoid duplicates.
For a full list of product import columns: Product import template
For more information regarding product stock: Product stock options