[ Click here to download the Data Standard as an Excel spreadsheet ]
Version 2.0_6/2006 |
|||||
Field Name |
Length |
Format |
Required |
Field Explanation |
Example |
| Item_SKU | 40 |
Char |
Y |
Item or SKU# |
BB1234 |
| UPC | 14 |
N |
Y |
Includes check digit |
12345678901234 |
| Product_Name | 40 |
Char |
Y |
What is product called |
Full Moon Chandelier |
| Short_Description | 40 |
Char |
Y |
Use for invoices & ordering |
12 bulb bronze hall chandelier |
| Theme | 35 |
Char |
N |
Collection or Group Name |
Tiffany |
| Category | 35 |
Char |
N |
Type of item |
Chandelier |
| Unit_Increments | 4 |
4.0 |
Y |
Increments that the item must be purchased in |
6 |
| Order_Minimum | 3 |
3 |
Y |
How many must be purchased |
6 |
| Order_Unit_of_Measure | 3 |
Char |
Y |
Units item is sold in. EA=Each, IN=Inches, FT=Feet,
Set |
EA |
| Wholesale_Price | 9 |
7.2 |
N |
Wholesale unit price |
225.55 |
| Retail_Price | 9 |
7.2 |
N |
MSRP - Retail sales price |
325.00 |
| Sales_Price | 9 |
7.2 |
N |
Discounted price
/ sale/ discontinued |
150.00 |
| IMAP | 1 |
Char |
N |
Internet Minimum Advertised Price
in forced on this item |
Y |
| IMAP_Price | 9 |
7.2 |
N |
IMAP calculated price |
405.99 |
| UMAP | 1 |
Char |
N |
Universal Minimum Advertised Price
in forced on this item |
Y |
| UMAP_Price | 9 |
7.2 |
N |
UMAP calculated price |
405.99 |
| Height | 5 |
3.2 |
Y |
Expressed in inches |
15 |
| Length | 5 |
3.2 |
Y |
Expressed in inches |
12 |
| Width | 5 |
3.2 |
N |
Expressed in inches |
12 |
| Extends | 5 |
3.2 |
N |
Product extends from
the wall in inches |
Y |
| Weight | 7 |
5.2 |
Y |
Item in pounds |
2.60 |
| Cartons_per_Unit | 3 |
3 |
N |
Number of cartons |
2 |
| Carton_Height | 5 |
3.2 |
N |
Expressed in inches 1st carton |
18.00 |
| Carton_Length | 5 |
3.2 |
N |
Expressed in inches 1st carton |
15.00 |
| Carton_Width | 5 |
3.2 |
N |
Expressed in inches 1st carton |
15.00 |
| Carton_Cubic_Feet | 4 |
3.1 |
N |
Expressed in Cubic Feet 1st carton |
3.5 |
| Master_Pack_Barcode | 14 |
N |
N |
Barcode for master
pack |
12345678901234 |
| Packed_Weight | 7 |
5.2 |
N |
Complete item packed wght in LBS |
10.5 |
| Voltage | 4 |
N |
N |
Number of Volts |
120 |
| Number_of_bulbs | 3 |
3 |
N |
per unit |
12 |
| Type_of_bulbs | 20 |
Char |
N |
Type of bulb |
Flourescent |
| Max_Wattage | 5 |
5 |
N |
per unit |
180 |
| Number_of_bulbs2 | 3 |
3 |
N |
per unit |
2 |
| Type_of_bulbs2 | 20 |
Char |
N |
Type of bulb |
Flourescent |
| Max_Wattage2 | 5 |
5 |
N |
per unit |
180 |
| Bulb_Included | 1 |
Char |
N |
Bulbs Included (Y=Yes, N=No) |
Y |
| Number_of_arms | 2 |
2 |
N |
per unit |
4 |
| Safety_Rating | 15 |
Char |
N |
Safety
type list: UL, CSA, ETL, CUL (comma separated) |
UL,CUL |
| Shipped_Via | 6 |
Char |
N |
UPS, NonUPS, TRK=Truck Item, etc. |
UPS |
| Status | 1 |
Char |
N |
A=Active, N=New, C=Closeout, P=Planned termination, D=Delete, O=Obsolete/Discountinued |
A |
| Status_Date | 8 |
yyyymmdd |
N |
Item Status Effective date |
20060120 |
| Ranking | 10 |
Char |
N |
Internal rankings
of SKU's |
|
| Sales_Price_Info | 50 |
Char |
N |
Notes explaining promotion |
Speical |
| Designer | 35 |
Char |
N |
Artist |
Jane Doe |
| Energy_Star | 1 |
Char |
N |
Energy Star Compliant Y=Yes, N=No |
Y |
| Special_Features | 20 |
Char |
N |
Special
feature of the item (free form to your need) |
Duo
Mount |