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
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
Column Name
SKU
Brand
Brand_ID
UPC
EAN
Collection_Group
Collection_Group_ID
Collection_Name
Collection_ID
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
Department_ID
Secondary_Department
Secondary_Department_ID
Tertiary_Department
Tertiary_Department_ID
Description
Designer
New_Item
Keywords
Item_Can_Be_Monogrammed
Monogram_Character_Count
Case_Pack
Retailer_Only
Stock
Thumb (image url)
Medium (image url)
Large (image url)
Required
Required
Required
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Required
Required
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Required
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Required
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Optional
Input Type
Text/numbers
Text/numbers
Numbers
Numbers
Numbers
Text/numbers
Numbers
Text/Numbers
Numbers
Text/numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Text/numbers
Numbers
Text/numbers
Numbers
Text/numbers
Numbers
Text/numbers
Text/numbers
Text only
Text/numbers
Text or number
Numbers
Numbers
Text or number
Numbers
Text only
Text only
Text only
Notes
Sometimes called product code; this is not the UPC. All SKUs have to be unique. No duplicate SKUs.
12 digit number
13 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 "1", or "No" or "0"
Maximum number of characters or 0 if unlimited
"Yes" or "1", or "No" or "0"
Example
1234
Versace
823456781671
Butterflies
Dinner Plate
100
79
50
110
95
55
1.25
10
Dining and Entertaining
Dinnerware
Dinner Plates
Made by our artisans, this...
Dinner plate, butterfly, flower, gold, 24k
1
8
4
0
32
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_Group_ID
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
