How to add a new product width multiple sizes via the import tool

Creating a new product with the import tool can be done in two ways.

If you just want to create a single product you can use the import mode insert/create new. Which creates new products where id does not exist, regardless of name, and never updates existing products.

  • Use the Insert/Create New import mode to create a single product.
  • This mode creates new products where the ID does not exist, regardless of the name, and does not update existing products.

Product with Multiple Sizes:

You can create a new product with multiple sizes using the Insert/Update import mode. This mode creates a product if no matching ID or Name exists, and updates an existing product if there is a match.

How It Works:

  1. The first row creates the product with its Name and assigns an ID.
  2. Subsequent rows match the Name from the first row to add additional product items (e.g., sizes).

Example:

The import file below creates a product named Black Shoe with an auto-generated ID and Article Number 40331.

  • Two sizes (S and M) are added, each with its own unique article number.

The product view in Merchant Center after the import: