Product Share

Product Share

Open Source Product Sharing Standards

Home How Smart Products FAQ Software
Departments Brands SKUs Products Images Files


Products

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
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 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 Required Optional Optional Numbers Numbers Numbers Required Numbers Numbers Retailer_Only
Input Type Text/numbers Text/numbers Numbers Numbers Text/numbers Text/numbers Text/numbers Required 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 Canadian pricing Canadian pricing Canadian pricing Inches only Inches only Inches only (we use this column to store diameter) Ounces Ounces Bridge Department Hierarchy Bridge Department Hierarchy Bridge Department Hierarchy e.g. "Jonathan Ive" "Yes" or leave blank for no 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*
Keywords*
Designer*
US_Retail_Price**
US_Sale_Price**
US_Wholesale_Price**
Stock**
Height**
Length**
Width**
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 specif 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