CSV: Sizes and Colors for New Products

This article will explain how to create a feed file in order to add new products with variations (i.e., products that come in different colors or sizes). Once you create the file, you will upload it using the Add Products tool (Products > Add New Products > Products CSV File). *Click on any image below to make it larger. 

1) Parent Unique ID: this is used to group all variations (size/color) of one product into a single listing on Wish.

  • To add size/color variations to existing products, use the Unique ID/SKU of the existing product as the Parent Unique ID. See Accepted Colors Here
  • To add a new item with variations to Wish, you will create a feed with the first variation (row) as the "parent" variation. This first row will have the same Parent Unique ID and Unique ID. All additional rows for that product will have the same Parent Unique ID as the first row, but will have different Unique IDs.

2) Unique ID
: this represents a single item/variation (size and/or color) of your product. The Unique Id serves to identify the variations within one item listing (product).

3) Item
(also, Variation): this is one row in your feed. It represents a single variation of your product. This item shares the same Parent Unique ID as other size/color variations of the same product (see definition below) but has its own Unique ID. Here is one item:

4) Product: can be comprised of multiple items and, therefore, multiple rows. This is the set of all variations comprising one product listing. Each item/variation within a product listing has a different Unique ID but they all will share the same Parent Unique ID. Here is one product with several variations:


Creating the Feed
In order for the Merchant Dashboard to recognize rows as variations for a single product, each variation (row) must have the exact same Parent Unique ID as the other variations of that product. Remember, one item (the "parent" item, or, the first row when creating a new feed) will have the Parent Unique ID for its Unique ID as well. (See below in blue: The first item has TG-088 for both Parent Unique ID and Unique ID.) All the other items will need their own different Unique ID (See below in green).

Say we have a product named Sleeveless High and Low Chiffon Dress. It comes in two colors (Mint and Pink) and five sizes: XS, S, M, L, XL. Start by adding one item/row of the product. Here we have started with the XS Sleeveless High and Low Chiffon Dress in Mint. This item/variation will act as the "parent" variation, so this item's Unique ID is also the Parent Unique ID.

Notice that we have listed "Mint" under the Color attribute and "XS" under the size attribute. (If your product does not have different colors but does have different sizes, input the sizes in the Size column and leave the Color column blank. If the product does not have different sizes but does have different color variations, leave the Size column blank.) Now let's add our S and M sizes in Mint:

See the highlighted columns in blue? These are the columns that must be the same across all variations for the upload to create one product listing. The columns that are not highlighted in blue may have differences in them among the rows for the same product.

For each item, the Unique ID is different because the Unique ID responds to the item (with its color and size specification) rather than the overall product. And for this particular product, the quantities for each item differ (though it's possible you may have the same inventory for each variation of your product). In order for your product to upload correctly with its variations, you will need to make sure that the following attributes are the same for the product:

  • Parent Unique ID
  • Name
  • Tags
  • Product Description
  • Price
  • Shipping
  • Main Image URL 

Now that we've added the Sleeveless High and Low Chiffon Dress in Mint, we'll add the Pink variation of the dress, making sure to create rows for each size — just as we did for the Mint variation. And, just like the Mint variation, the Pink variation has the same Unique Id as the first product we added: TG-088.

Comparing the variations, you will see that the following attributes are all the same: Name, Tags, Product Description, Price, Shipping, and Image URLs. The other attributes—SKU, color, size, quantity—are different to correspond to the individual items for your product.

Sample Feed
You can view and download a sample feed with color and size variations here.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request


Powered by Zendesk