A | B | C | D | |
---|---|---|---|---|
1 | Field | Format | Example | Description |
2 | Unique Merchant SKU | Alphanumeric | 12345 | SKU assigned to the item by the brand. |
3 | Product Name | String (90 character limit) | Acme Bird Seed | Name of the product associated with the SKU. |
4 | Product URL | String | Tracking URL that leads a customer directly to the product. | |
5 | Image URL | String | Direct URL to the image file associated with the product. | |
6 | Current Price | Integer (8,2) | 49.99 | Current price of the product. |
7 | Stock Availability | String | Y | Indicates availability of the product: "Y" (Yes), "N" (No), "Back-Order", "Pre-Order", "Limited Availability" |
8 | Condition | String | New | Condition of the product: "New", "Used", "Refurbished". |
9 | EAN | Integer | 012345678905 | International Article Number (or European Article Number) for the product—typically a 13 digit sequence on the bar code. |
10 | UPC | Integer | 12345678905 | Universal Product Code for the product—typically a 12 digit sequence on the bar code. |
11 | ISBN | Integer | 978-3-16-148410-0 | For written products, this is the International Standard Book Number. |
12 | MPN | Alphanumeric | HSC0424PP | Manufacturer Part Number for product set by the brand. |
13 | Shipping Rate | Integer | $4.99 | Shipping cost for this item; 0 denotes free shipping. |
14 | Original Price | Integer | 150 | The original price of the product. |
15 | Coupon Code | Alphanumeric | SAVE10 | Code that applies a discount or offer to the product. |
16 | Coupon Code Description | String (150 character limit) | 10% off + free shipping | Details about coupon/offer |
17 | Manufacturer | String | Acme Corporation | Manufacturer of the product. |
18 | Product Description | String (4000 character limit) | Acme's new bird seed formula is 100% guaranteed to attract Road Runners! | Provides all relevant product details |
19 | Product Type | String | bird,seed,birdseed | Ordered list describing the product (CSV) |
20 | Category | String | Bird Products > Bird Seed | The category field can be a breadcrumb or a custom value. |
21 | Category ID | Numeric | 96639 | Category ID value; specific to Shopping.com feed specs |
22 | Parent SKU | String | 323461A32 | If the product is a variant in a family of similar products,this SKU identifies the product family (e.g. shoes of different sizes/colors) |
23 | Parent Name | String | Acme Products | If the product is a variant in a family of similar products,this name identifies the product family. |
24 | Top Seller Rank | Integer | 1 | This is an advertiser's internal sales rank of the product. 1 is the best, meaning the product is the best-seller. |
25 | Estimated Ship Date | String | Allow 2-3 weeks for delivery. | Provides estimated time-frame for shipping. Most relevant when providing stock availability (e.g. back-order) |
26 | Gender | String | If the product is marketed at certain genders, these can be specified here. | |
27 | Color | String (CSV) | blue,white,red/black | Indicates the primary colors of the product. Multi-colored items are separated with a slash. |
28 | Material | String (CSV) | cotton,polyester | Indicates the material of the product. |
29 | Size | Integer | 28 | Indicates the size of the product. |
30 | Size Unit of Measure | String | Inches | Unit of measure used for sizing |
31 | Age Range | String | 3 - 6 years | Age range for whom the product is intended: # - # (years or months) |
32 | Cell Phone Plan Type | String | Prepaid | For cell phone plan products, indicate the type. |
33 | Cell Phone Service Provider | String | AT&T | For cell phone plan products, indicate the service provider. |
34 | Stock Description | String (100 character limit) | Free shipping on purchases of $100+ | Any special status about an item. |
35 | Product Launch Date | Integer | 20380119 | The date that the product was launched, in YYYYMMDD format. |
36 | Product Bullet Point 1 | String (100 character limit) | Acme Bird Seed is made with 100% organic ingredients. | First short descriptive statement about the product features. |
37 | Product Bullet Point 2 | String (100 character limit) | Specifically formulated for Road Runners. | Second short descriptive statement about the product features. |
38 | Product Bullet Point 3 | String (100 character limit) | Guaranteed to make a speeding Road Runner stop! | Third short descriptive statement about the product features. |
39 | Product Bullet Point 4 | String (100 character limit) | Great for using as a diversion when plotting against Road Runners. | Fourth short descriptive statement about the product features. |
40 | Product Bullet Point 5 | String (100 character limit) | Part of an excellent line of products from Acme Corporation. | Fifth short descriptive statement about the product features. |
41 | Alternative Image URL 1 | String | URL to an image with an alternative angle or view. | |
42 | Alternative Image URL 2 | String | URL to an image with an alternative angle or view. | |
43 | Alternative Image URL 3 | String | URL to an image with an alternative angle or view. | |
44 | Alternative Image URL 4 | String | URL to an image with an alternative angle or view. | |
45 | Alternative Image URL 5 | String | URL to an image with an alternative angle or view. | |
46 | Mobile URL | String | URL for the mobile site that provides product information. | |
47 | Related Products | String (CSV) | A123235,S2422541,G2365244 | Provide up to 3 merchant SKUs for complimentary or similar products. |
48 | Merchandising Type | String | "New" or "Clearance". | Identifies a product as New or Clearance. |
49 | Product Weight | Integer | 5 | Indicate the product's weight. |
50 | Zip Code | Integer | 93101 | If an advertiser has multiple shipping locations, this field identifies the shipping zip code. |
51 | Shipping Weight | Integer | 7.5 | Indicates shipping weight. |
52 | Weight Unit of Measure | String | Pounds | Unit of measure used for product weight. |
53 | Format | String | "Paperback" or "Vinyl" or "Digital". | Indicates the format of a media product—can be any custom format. |
54 | Unit Price | Strong | $2 / lb or $4 / oz | Price per unit by weight or volume |
55 | Bundle | Boolean | YES or NO | Indicates if the product is a bundle of several separate products. |
56 | Software Platform | String (CSV) | Indicates the platforms on which the software can run (CSV) | Mac,PC,Linux |
57 | Watch Display Type | String | "Analog" or "Digital" | For products that are a watch, indicate the display type. |
58 | Product Bid | Integer | 2 | Bid value of the product. |
59 | Text1 | String | First custom field for brands to pass any custom text values. | |
60 | Text2 | String | Second custom field for brands to pass any custom text values. | |
61 | Text2 | String | Third custom field for brands to pass any custom text values. | |
62 | Numeric1 | Integer | First custom field for brands to pass any custom numeric values. | |
63 | Numeric2 | Integer | Second custom field for brands to pass any custom numeric values. | |
64 | Numeric3 | Integer | Third custom field for brands to pass any custom numeric values. | |
65 | Money1 | Integer | First custom field for brands to pass any custom money values. | |
66 | Money2 | Integer | Second custom field for brands to pass any custom money values. | |
67 | Money3 | Integer | Third custom field for brands to pass any custom money values. |