Required and optional attributes for the new product CSV upload experience

As part of our new product CSV upload experience, we have compiled a list of all required and optional product attributes for product CSVs with descriptions and examples. Please be aware that several product attributes have been renamed, which will be indicated below.

Required Attributes:

It is necessary to include certain product attributes in your CSV file when uploading products via CSV. Please see below for a table of required attributes depending on your desired action: 

See below for a description of these required attributes:

Parent SKU 

Type: String

When defining a variation of a product, we must know which product to attach the variation to. 'Parent SKU' is the 'SKU' of the product you wish to attach this variant to. The 'Parent SKU' must already exist on Wish or be included elsewhere in your upload. 

Examples:

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

SKU 

Type: String 

Provide the unique SKU number you use internally to identify this item. Please keep this SKU number for any SKU number updates to this item in future feeds. Wish.com's system uses this SKU number to identify, track, update, and report on this item.

Examples:

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

Name

Type: String 

Use the following template to build your product names: Main brand + Sub-brand, family or product name + Up to 3 key attributes + Generic product type. Names must be clear and concise and should also be descriptive of the product being sold. This template will help 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!!!

Description 

Type: String 

A detailed description of your product. Limit of 4,000 characters, and only the first 250 characters are displayed on the initial search page. Do not include any HTML code, details about store policies, other store-specific language or multiple lines. 'New line' characters (such as 'enter' or 'return') will cause problems with your file. Information about size, fit, and measurements is helpful for apparel items.

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>.

Main Image (previously Main Image URL) 

Type: URL 

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 100 x 100 pixels in size. Do not include any "image not found" images. We do not accept image URLs that begin with https://. Please see this article if you need help finding and copying an image URL.

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3
• 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

Currency Code (previously Local Currency Code)

Type: String

Your local currency code, the currency used for all of your products. This must match your localized currency.

Examples:

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

Price

Type: Price

The local currency price of your product. The customer will pay this amount for the product after the prices have been converted to your currency. The local currency price is based on the local currency code that can be found under Currency Settings or via API GET /api/v3/merchant/currency_settings.

Examples:

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

Default Shipping Price (previously Shipping)

Type: Object

The default shipping price of your product. This will automatically apply as the shipping price for any new or unset countries in this warehouse.

Examples:

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

Inventory (previously Quantity)

Type: Integer 

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

Examples:

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

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

Optional Attributes:

See below for a list and description of optional attributes when uploading products via CSV.

Extra Images (previously Extra Image(s))

Type: String

List of URLs of images of the product, separated by '|'. 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 will be 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 will be done. Provide REMOVE_ALL to unset all existing extra images. Images can be in JPEG, PNG or GIF format. Images should be at least 100 x 100 pixels in size. 

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3 | https://www.yourwebsite.com/images/dress.jpg
• 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 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, PNG or GIF format. Do not include company logos or names or promotional or other identifying text. Images should be at least 100 x 100 pixels in size. 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
• 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

Clean Image 

Type: String

URL of the clean image of your product. Must 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. Learn more.

Examples:

• Acceptable: http://www.yourwebsite.com/images/7324204/3
• 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

Video URL

Type: String

URL of the demo video that was uploaded for this product. Learn more.

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

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

GTIN (previously UPC)

Type: String

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

Examples:

• Acceptable: 716393133224
• Unacceptable: asdf884445ds

Reference Price (previously MSRP)

Type: String

Listings include a field for a comparison or reference price. Merchants are not required to provide a value for Reference Price. If merchants choose to provide a value for Reference Price, each Reference Price must comply with the Product Reference Price Policy. To learn more, click here.

Examples:

• Acceptable: 716393133224
• Unacceptable: asdf884445ds

Color

Type: String

The color of the product, especially as it pertains to apparel or jewelry. Each color variation must be its own row in the feed, have its own unique SKU, and its own inventory level. If you would like to have it show two colors (eg 'black and red'), simply separate the colors by "&" (eg "black & red"). Please note that showing two colors here should not to be confused with products having two different colored variations. The name of the color must be in the list of currently accepted colors.

Examples:

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

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 currently accepted sizes.

Examples:

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

Tags

Type: String

Non-hierarchical keyword or term assigned to each product in your feed. This kind of metadata helps describe an item and allows it to be categorized and found again by browsing or searching on Wish.com. 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 our users will 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

Enabled

Type: String

Enable this SKU on Wish. Users will be able to view and purchase the product.

 

Examples:

• Acceptable: 1
• Unacceptable: True
• Unacceptable: Enable

Disabled

Type: String

Disable this SKU on Wish. Users will not be able to view or purchase the product.

Examples:

• Acceptable: 1
• Unacceptable: True
• Unacceptable: Disable

Unit

Type: String

The unit of measurement for the total content of a product. This will be used to display the price per unit of a product (per the below formula), and is the unit of measurement that will be 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 mililiters

For more information on unit price and setting unit price product attributes, please see this guide.

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

Reference value

Type: Number <float>

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 mililiters:

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

For more information on unit price and setting unit price product attributes, please see this guide.

Examples:

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

Quantity value

Type: Number <float>

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, you will need to 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

For more information on unit price and setting unit price product attributes, please see this guide.

Examples:

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

Height (previously Package Height)

Type: Decimal

The height of your product that will be packaged to ship to the customer (Units in cm).

Examples:

• Acceptable: 13.40

Width (previously Package Width)

Type: Decimal

The width of your product that will be packaged to ship to the customer (Units in cm).

Examples:

• Acceptable: 13.40

Length (previously Package Length)

Type: Decimal

The length of your product that will be packaged to ship to the customer (Units in cm).

Examples:

• Acceptable: 10

Weight (previously Package Weight) 

Type: Decimal

The weight of your product that will be packaged to ship to the customer. (Units in g).

Examples:

• Acceptable: 151.5
• Acceptable: 10

Pieces Included

Type: Integer

The amount of pieces that are associated with this item.

Examples:

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

Contains Liquid

Type: Boolean

Whether the product contains liquid.

Examples:

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

Contains Metal

Type: Boolean

Whether the product contains metal.

Examples:

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

Contains Powder

Type: Boolean

Whether the product contains powder.

Examples:

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

Contains Battery

Type: Boolean

Whether the product contains a battery/batteries.

Examples:

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

Country of Origin

Type: String

Country where the product is manufactured. Country code should follow ISO 3166 Alpha-2 code.

Examples:

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

Declared Name

Type: String

Declared name for logistics.

Examples:

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

Customs HS Code

Type: String

Harmonization System Code used for customs declaration.

Examples:

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

Customs Declared Value

Type: String

The price (in USD) of your product that will be declared to the customs.

Examples:

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

Max Quantity

Type: String

The maximum quantity of products per order. This lets users 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

US TTD

Type: Integer

The specified time-to-door for the given country or region. Time-to-door 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 'disabled'. To update TDD for a different country/region use their 2 letter country code instead of US.

Examples:

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

US

Type: Price

The localized country shipping price for customers that purchase in the United States. To update the localized shipping price for a different country use their 2 letter country code instead of US.

Examples:

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

US_HI

Type: Price

The regional shipping price for customers that purchase in Hawaii, United States. You can specify "disabled" or "enabled" to determine whether users 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 defined here instead of US_HI.

Examples:

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