Businesses use the following standards to organize product data in databases and Excel files.
Bridge created these standards to help businesses more easily share data and reduce costs.
Businesses are encouraged to use Bridge Product Share standards to save time and money in sharing product data.
1.
Column
A*
B*
C
D*
E
F*
G*
H
I
J
K
L
M
N
O
P
Q
R*
S
T
U
V
W
X*
Y
Z
AA
BB
CC
Column Name
SKU
Brand
UPC
EAN
Collection_Group
Collection
Product_Name
US_Retail_Price
US_Sale_Price
US_Wholesale_Price
CAD_Retail_Price
CAD_Sale_Price
CAD_Wholesale_Price
Height
Length
Width
Diameter
Capacity
Weight
Department
Secondary_Department
Tertiary_Department
Description
Designer
New_Item
Keywords
Item_Can_Be_Monogrammed
Case_Pack
Retailer_Only
Required
Required
Required
Optional
Optional
Optional
Required
Required
Required
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Required
Optional
Optional
Optional
Optional
Optional
Required
Optional
Optional
Optional
Input Type
Text/numbers
Text/numbers
Numbers
Numbers
Text/numbers
Text/numbers
Text/numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Text/numbers
Text/numbers
Text/numbers
Text/numbers
Text/numbers
Text only
Text/numbers
Text only
Numbers
Text only
Notes
Sometimes called product code; this is not the UPC. All SKUs have to be unique. No duplicate SKUs.
12 digit number
11 digit number
We use the term 'pattern' and 'collection' interchangeably
U.S. pricing, E.g. 10 or 10.25, do not enter a "$" symbol
Do not enter a sale price that is the same as the retail price. Sale price should be lower than the retail price. U.S. pricing, E.g. 10 or 10.25, do not enter a "$" symbol
No "$" please, leaving blank will show keystone pricing
One of the keywords should be what the item is. e.g. "dinner plate", "saucer". Please separate keywords with commas.
"Yes" or leave blank for no
"Yes" or leave blank for no
Example
1234
Versace
823456781671
Butterflies
Dinner Plate
100
79
50
110
95
55
1.25
9
Dining and Entertaining
Dinnerware
Dinner Plates
Made by our artisans, this...
Dinner plate, butterfly, flower, gold, 24k
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
SKU (View SKU Directory)
UPC*
EAN*
Brand* (View Brand ID Directory)
Brand_ID* (View Brand ID Directory)
Collection_Group
Collection_Name*
Collection_ID*
Product_Name*
Department* (View Department Hierarchy)
Department_ID* (View Department Hierarchy)
Secondary_Department* (View Department Hierarchy)
Secondary_Department_ID* (View Department Hierarchy)
Thumb (image url)*
Medium (image url)*
Large (image url)*
Description*
Oven Safe*
Dishwasher Safe*
Microwave*
Freezer Safe*
Keywords*
Designer*
US_Retail_Price**
US_Sale_Price**
US_Wholesale_Price**
Stock**
Height**
Length**
Width**
Diameter**
Capacity**
Weight**
New_Item (1 = Yes, 0 = No)**
Item_Can_Be_Monogrammed**
Retailer_Only**
19.
We recommend that you update the Product_Edited_Date time stamp variable if any of the variables with a single asterisk (*) change. This alerts your data sharing partners that a recent change has been made and they will likely wish to refresh the specific data.
If any of the variables with a double asterisk (**) change, we recommend updating the time stamp SKU_Edited_Date. This alerts your data sharing partners that a recent change has been made and they likely wish to refresh this data.
Page tags: checklist for importing items to a website
