Required and Optional Attributes for Adding Products

We have compiled a list of all product attributes for adding/editing products via CSV and API (excluding category-specific attributes, which can be found in Products > Categories and Attributes) and included a table to reference for required attributes (based on desired CSV action). Please be aware that several product attributes have been renamed, which are indicated in the list below.

Required Attributes

Click on the "Attribute" to be taken to a description and acceptable examples.

*Note: For all Edit CSV actions, fields that are marked “Optional” can be removed from downloaded CSV templates if you do not want to edit these attributes. If these fields are not removed, they are considered “Required” and must be filled for all rows/listings in the file. For example, if using the Edit Price/Inventory CSV template, the Inventory field can be removed and the CSV file can be submitted successfully. If the Inventory field is not removed, it must be filled for all listings in the file to submit the CSV file successfully.

Attribute List

Brand ID

Type: String

Provide the product brand ID of the product being sold.

The product must be authentic and directly manufactured by the brand owner. For example, Apple is the brand of iPhone or iPad but Apple is not the brand of an iPhone case not manufactured by Apple.

Visit Brand Directory to view a list of brands to select from or request a new brand to be added.

Examples:

• Acceptable: 545d5e6a6fa88c38cdfe0735

California Proposition 65 Chemical Names

Type: String

Provide the specific chemical name(s) applicable to your product, if any, for compliance with California's Proposition 65. If you selected the Food, Furniture, or Chemical warning type (see previous attribute), you must provide at least one specific chemical name. 

When using CSV, provide a list of chemical names, separated by a vertical "|" bar. You can provide up to a maximum of five chemical names. Learn more about Proposition 65 warning notices.

Examples:

• Acceptable: Benzyl Chloride
• Acceptable: Lead
• Acceptable: Nalidixic Acid
• Unacceptable: Chemical 

California Proposition 65 Warning Type

Type: String

Provide the warning type applicable to your product, if any, for compliance with California's Proposition 65. You can choose “Chemical,” “Food,” “Furniture,” “On_Product_Cancer,” “On_Product_Combined_Cancer_Reproductive,” “On_Product_Reproductive,” “Raw_Wood,” or “Diesel_Engines.” Learn more about Proposition 65 compliance.

Examples:

• Acceptable: Chemical
• Acceptable: Food
• Acceptable: On_Product_Cancer
• Unacceptable: Other

Clean Image 

Type: String

URL of the clean image of your product. Must be the same Wish URL as the main image URL or one of the existing extra image URLs or the URL of a new added image. Products with a Clean Image selected may receive increased impressions and sales. Read how to select a clean image, including image guidelines. 

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3.png
• Acceptable: http://www.yourwebsite.com/images/dress.jpg
• Unacceptable: https://www.your website.com/images/7324204/3
• Unacceptable: http://www.yourwebsite.com/images/dresses.html

Color

Note: If your product falls under the categories of Apparel Accessories, Cellphones & Telecommunications, Computer & Office, Consumer Electronics, Entertainment, Home & Garden, Home Improvement, Jewelry & Accessories, Luggage & Bags, Men's Clothing, Shoes, Sports, or Toys & Hobbies, we recommend that you use “Primary color” to enter the color of your product. For other categories, use this field.

Type: String

The color of the product. If you would like to have it show two colors, simply separate the colors by an ampersand "&" (e.g., black & red). Please note that showing two colors here should not be confused with products having two different colored variations. Each color variation must be its own row in the CSV file, have its own unique SKU, and its own inventory level. The name of the color must be in the list of acceptable colors.

Examples:

• Acceptable: red
• Acceptable: black & blue
• Unacceptable: red, blue
• Unacceptable: black & blue & green

Condition

Note: If your product falls under the categories of Cellphones & Telecommunications, Computer & Office, Consumer Electronics, or Electronic Components & Supplies, we recommend that you use the “Item condition” field to enter the condition of the product. For other categories, use this field.

Type: String

Provide the condition of the product. You can input “New," “Used," or “Refurbished." Make sure to provide this information so that the product’s European Union-bound orders may smoothly pass through customs.

Examples:

• Acceptable: New
• Acceptable: Used
• Acceptable: Refurbished
• Unacceptable: Old

Contains Battery

Type: Boolean

Products that already contain batteries or the batteries may be built into the product which may not be removed and may be rechargeable.

Examples:

• Acceptable: Yes
• Acceptable: No
• Unacceptable: 0

Contains Liquid

Type: Boolean

Products that consist of a substance that flows freely but is of constant volume, having a consistency like that of water or oil and including semi-liquids such as creams, gels, lubes, etc.

Examples:

• Acceptable: Yes
• Acceptable: No
• Unacceptable: 0

Contains Metal

Type: Boolean

Products that are made of or contain metal as a material component. Metal is a solid material that is typically hard, shiny, malleable, fusible, and ductile, with electrical and thermal conductivity.

Examples:

• Acceptable: Yes
• Acceptable: No
• Unacceptable: 0

Contains Powder

Type: Boolean

Any product that is totally composed of fine, dry particles.

Examples:

• Acceptable: Yes
• Acceptable: No

Unacceptable: 0

Country of Origin

Type: String

Country where the product is manufactured, produced, or grown. Country code should follow ISO 3166 Alpha-2 code.

Examples:

• Acceptable: CN
• Acceptable: US
• Unacceptable: China

Currency Code
Type: String

Currency code of the currency used for all of your products. This must match your localized currency. 

Examples:

• Acceptable: USD
• Acceptable: CNY
• Unacceptable: Chinese

Customs Declared Name

Type: String

Declared name of the product used for customs clearance. This is often displayed on the product packaging.

Examples:

• Acceptable: Repair Tools Kit Set
• Acceptable: Rings
• Unacceptable: !Rings
• Unacceptable: T
• Unacceptable: Good 衬衫
• Unacceptable: Name that is longer than 200 characters

Customs Declared Value

Type: Number (Decimal)

The price (in USD) of your product declared to customs. This is often displayed on the product packaging.

Examples:

• Acceptable: $100.99
• Acceptable: 10.99
• Unacceptable: $49.99 + S/H

Customs Harmonization System (HS) Code

Type: String

HS Code classification used for customs declaration. This is often displayed on the product packaging.

Examples:

• Acceptable: 33021010.00
• Acceptable: 6403.20
• Unacceptable: 2
• Unacceptable: a

Default Shipping Price
Type: Number (Decimal)

The default shipping price of your product. This automatically applies as the shipping price for any countries that you don’t set the shipping price.

Examples:

• Acceptable: 100.99
• Acceptable: 10.99
• Unacceptable: 49.99 + S/H

Description 

Type: String 

A detailed description of your product. Limit of 4,000 characters. Do not include any HTML code, details about store policies, or other store-specific language. 

Examples:

• Acceptable: This dress shirt is 100% cotton and fits true to size.
• Unacceptable: This <b>dress shirt</b> is 100% cotton and <i>fits true to size</i>.

Enabled

Type: String

Enable this SKU on Wish by entering Yes. Customers are able to view and purchase enabled products. Disable this SKU by entering No.

Examples:

• Acceptable: Yes, No
• Unacceptable: True
• Unacceptable: Enable

Extra Images 

Type: String

List of URLs of images of the product, separated by a vertical “|” bar. Link directly to the image, not the page where it is located. Same rules apply as the main image URL attribute. The order of the URLs is the order of the images displayed on the product page. To update existing images or add new images, you need to provide all extra image URLs, including the ones that remain the same. If none of the extra image URLs are provided, no update occurs. Images can be in JPEG, PNG or GIF format. Images should be at least 500 x 500 pixels. 

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3 | https://www.yourwebsite.com/images/dress.jpg
• Acceptable: http://www.yourwebsite.com/images/dress.jpg
• Unacceptable: http://www.yourwebsite.com/images/dresses.html

GTIN 

Type: String

Should be 12 to 14 digits GTIN (UPC, EAN, ISBN) that contains no letters or other characters. This number is barcode symbology used for tracking trade items in stores and scanning them at the point of sale.

Examples:

• Acceptable: 716393133224
• Unacceptable: asdf884445ds

Inventory 

Type: Integer 

Amount of a SKU that is in stock. Please use inventory buffering for Wish specified inventory. Maximum 500,000. Larger inventories are automatically lowered.

Examples:

• Acceptable: 1200
• Acceptable: 0
• Acceptable: 4
• Unacceptable: In stock
• Unacceptable: Out of Stock

Main Image 

Type: String 

URL of a photo of your product. Link directly to the image, not the page where it is located. We accept JPEG or GIF format. Do not include company logos or names or promotional or other identifying text. Images should be at least 500 x 500 pixels. Do not include any "image not found" images. 

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3.png
• Acceptable: http://www.yourwebsite.com/images/dress.jpg
• Unacceptable: http://www.yourwebsite.com/images/dresses.html

Max Quantity

Type: Integer

The maximum quantity of products per order. This lets customers break down large orders for easy management and tracking. This should only be used in rare cases.

Examples:

• Acceptable: 100
• Acceptable: 10
• Acceptable: 1
• Unacceptable: 0

Name

Type: String 

Use the following template to build your product names: Main brand + sub-brand, family or product name + up to three key attributes + generic product type. Names must be clear and concise and should also be descriptive of the product being sold. This template helps customers identify your product.

Examples:

• Acceptable: Nikon D5100 DSLR Camera (Body Only) USA MODEL
• Acceptable: Sony VAIO 15" Laptop
• Unacceptable: Best Price!!! ***CHEAP*** Baby Stroller!!!

Package Height

Type: Number (Decimal)

The height of the package in which your product ships to the customer (units in cm).

Examples:

• Acceptable: 13.40

Package Width

Type: Number (Decimal)

The width of the package in which your product ships to the customer (units in cm).

Examples:

• Acceptable: 13.40

Package Length

Type: Number (Decimal)

The length of the package in which your product ships to the customer (units in cm).

Examples:

• Acceptable: 10

Package Weight

Type: Number (Decimal)

The weight of the package in which your product ships to the customer (Units in grams). This is a required field for listings created by merchants in China.

Examples:

• Acceptable: 151.5
• Acceptable: 10

Parent SKU 

Type: String

Parent SKU is the unique identifier of a product. When using CSV to edit or add new listings, you must provide the Parent SKU. 

Examples:

• Acceptable: HSC0424PP
• Acceptable: 112123343455432
• Unacceptable: 2
• Unacceptable: a

Pieces Included

Type: Integer

The amount of pieces that are associated with the item.

Examples:

• Acceptable: 2
• Acceptable: 1
• Unacceptable: -1

Price

Type: Number (Decimal)

The price of your product in the currency as indicated by the ‘Currency Code’. It can also be found under Currency Settings or via API GET /api/v3/merchant/currency_settings. The customer pays this amount for the product after the prices have been converted to your currency. 

Examples:

• Acceptable: 100.99
• Acceptable: 10.99
• Unacceptable: 49.99 + S/H

Quantity Value

Type: Number (Decimal)

The total quantity of the product variant (in the given unit) that is used to calculate the price per unit of a product, using the below formula. Note that if a product has multiple product variants, then you must set quantity values for each product variant.

(Price * Reference Value) / Quantity Value = Unit Price (displayed per Reference Value in given Unit)

As an example, you are listing a 200mL bottle of perfume for $33.12 and would like to display the price per 100mL:

• Measured Type = Volume metric
• Unit = mL
• Quantity value = 200  
• Reference value = 100
• Unit Price = ($33.12 * 100) / 200 = $16.56 per 100mL

Learn how to set unit price and unit price product attributes.

Examples:

• Acceptable: 1
• Acceptable: 15
• Unacceptable: ABCXYZ

Reference Price
Type: Number (Decimal)

Listings include a field for a comparison or reference price. If merchants choose to provide a value for Reference Price, each Reference Price must comply with the Product Reference Price Policy. 

Examples:

• Acceptable: 716393133224
• Unacceptable: asdf884445ds

Reference Value

Type: Number (Decimal)

The reference value (in the given unit) that is used to calculate the price per unit of a product and to illustrate the unit count for the consumer to see, using the below formula.

(Price * Reference Value) / Quantity Value = Unit Price (displayed per Reference Value in given Unit)

As an example, you are listing a 200 milliliter bottle of perfume for $33.12 and would like to display the price per 100 milliliter:

• Measured Type = Volume metric
• Unit = milliliter
• Quantity value = 200  
• Reference value = 100
• Unit Price = ($33.12 * 100) / 200 = $16.56 per 100 milliliter

Learn how to set unit price product attributes.

Examples:

• Acceptable: 100
• Acceptable: 38
• Unacceptable: ABCXYZ

Shipping Price US (previously US)

NOTE: To update the localized shipping price for a different country, use their two-letter country code from the list of shipping countries/regions instead of "US."

Type: Number (Decimal)

The localized country shipping price for customers that purchase in the United States. 

Examples:

• Acceptable: 1.99
• Unacceptable: 1.99+
• Acceptable: disabled
• Acceptable: enabled

Shipping Price US_HI 

Type: Number (Decimal)

The regional shipping price for customers that purchase in Hawaii, United States. You can specify "disabled" or "enabled" to determine whether customers in this region can buy the product. You can also specify "use country shipping price" to unset the regional shipping. To update the shipping price for a different region use their country code + '_' + region code instead of US_HI.

Examples:

• Acceptable: 1.99
• Acceptable: disabled
• Acceptable: enabled
• Acceptable: use country shipping price
• Unacceptable: 1.99+

Size

Type: String

The size of the product, especially as it pertains to apparel, footwear, or jewelry. Each size variation must be its own row in the feed, have its own unique SKU, and its own inventory level. It must be either a number or in the list of acceptable product sizes.

Examples:

• Acceptable: S
• Acceptable: XXL
• Acceptable: 6
• Acceptable: 6.5
• Unacceptable: small
• Unacceptable: S, M

SKU 

Type: String 

SKU is used to identify unique variants of a product (Parent SKU). Each Parent SKU can have multiple unique SKUs. Any additions or edits to variations of a product require you to provide this SKU. 

Examples:

• Acceptable: HSC0424PP
• Acceptable: 112123343455432
• Unacceptable: 2
• Unacceptable: a

Tags

Type: String

Non-hierarchical keyword or term assigned to each product in your feed. This helps describe an item and allows it to be categorized and found again by browsing or searching on Wish. Tags should be comma separated, but do NOT use commas in individual tags. The more tags you add, and the more accurate your tags, the better the chances for customers to find your products. There is a maximum of 10 tags allowed per product. If you add more than 10, we ignore the extra tags.

Examples:

• Acceptable: Shirt, Men's Fashion, Navy, Blue, Casual, Apparel
• Acceptable: Women's Fashion, Jewelry & Watches
• Acceptable: Men's Fashion, Suits, Mafia, Silk Tie, Ties
• Unacceptable: Clearance Items
• Unacceptable: Cheap Cheap Cheap
• Unacceptable (Too many tags): Fashion, Suits, Ties, Silk Ties, Men's Suits, Italian Made Suits, Italian, Men's Fashion, Hand Crafted, Silk, High Quality

US TTD (Time-to-Door)

Note: To update the TTD for a different country, use their two-letter country code from the list of shipping countries/regions instead of "US."

Type: String

The specified time-to-door for the given country or region. TTD is measured as the time from when the order was placed to when the order was confirmed delivered. If the delivery for this country is disabled, this column must also be set to “unset”. 

Examples:

• Acceptable: 4
• Unacceptable: one
• Unacceptable (over 15 days): 20
• Unacceptable (non-positive): -2
• Unacceptable (non-integer): 20.5

Unit

Type: String

The unit of measurement for the total content of a product. This is used to display the price per unit of a product (per the below formula), and is the unit of measurement used for both the Reference Value and Quantity Value attributes. 

(Price * Reference Value) / Quantity Value = Unit Price (displayed per Reference Value in given Unit)

As an example, you are listing a 200 milliliter bottle of perfume for $33.12 and would like to display the price per 100 milliliters:

• Measured Type = Volume metric 
• Unit = milliliter
• Quantity value = 200  
• Reference value = 100
• Unit Price = ($33.12 * 100) / 200 = $16.56 per 100 milliliters

Learn how to set unit price for products.

Examples:

• Weight: ounce, pound, gram, milligram, kilogram
• Volume US imperial: fluid_ounce, pint, quart, gallon
• Volume metric: milliliter, centiliter, liter, cubicmeter
• Length: inch, foot, yard, centimeter, meter
• Area: square_foot, square_meter
• Per unit: count, load, wash, roll, pod

Variation Image 

Type: String

Note: Only required if variations exist. Each variation must have an image (this does not need to be a unique image).

URL of a photo of your product. Link directly to the image, not the page where it is located. We accept JPEG, PNG or GIF format. Do not include company logos or names or promotional or other identifying text. Images should be at least 500 x 500 pixels. Do not include any "image not found" images. We do not accept image URLs that begin with https://.

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3.png
• Acceptable: http://www.yourwebsite.com/images/dress.jpg
• Acceptable: REMOVE_ALL
• Unacceptable: https://www.your website.com/images/7324204/3
• Unacceptable: http://www.yourwebsite.com/images/dresses.html

Variation Option

Type: String

This field is used to define the parameters for the creation of variations. You can create your variations with traditional Color and Size fields or use category-specific attributes. Include the name of the desired attributes under the Variation Option column (separate by a comma if there are multiple) for the relevant product row and ensure that each variation SKU has unique values defined for that field(s). 

To find the category-specific attributes that can be used to create variations, navigate to the Categories and Attributes page, select your desired category, and click “View Attributes." The “Enabled for Variations” column indicates whether an attribute can be used as a variation option or not. 

Examples:

• Acceptable: Creating variations using category-specific attributes as parameters. See the table below demonstrating adding variations of Men’s Belts:

Parent SKU	SKU	Variation Option	Material	Alpha Size
1234abcd	5678efgh	Material, Alpha Size	Denim	M
1234abcd	8765hgfe	Material, Alpha Size	Leather	S
1234abcd	1122aabb	Material, Alpha Size	Leather	M

• Acceptable: Creating variations using traditional parameters (use when a parameter is missing from the category-specific attributes or that specific attribute cannot be used as a parameter). See the table below demonstrating variations of Primer (Makeup > Face > Primer) using traditional color and size attributes since category-specific attributes are unavailable for this category. Here “Size” is used to represent finish and “Color” is used to represent color:

Parent SKU	SKU	Variation Option	Size	Color
1234abcd	5678efgh	Size, Color	Glow	Light
1234abcd	8765hgfe	Size, Color	Matte	Medium
1234abcd	1122aabb	Size, Color	Semi-Matte	Deep

Video URL

Type: String

URL of the demo video that was uploaded for this product; see how to upload product videos.

Examples:

• Acceptable: http://www.yourwebsite.com/videos/demo.mp4
• Unacceptable: https://www.youtube.com/watch?v=123465789
• Unacceptable: http://www.yourwebsite.com/video/dresses.html

Warehouse 

Type: String

Provide the unique warehouse name you use internally to identify a warehouse. Shipping price, and inventory are applied to the specified warehouse only. If you do not define one, they are applied to the default warehouse attached to your account.

Examples:

• Acceptable: US_94132
• Acceptable: SZ_CN
• Unacceptable: 2
• Unacceptable: a