Product share seal

Product Share

Open Source Product Syncing Standards

Home How Product Syncing FAQ Departments
Brands SKUs Products Images Files Software & Help


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 AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR
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 Size_Unit_of_Measure Capacity_Unit_of_Measure Weight_Unit_of_Measure 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 Image_URL Material Country_of_Origin Warranty
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 Optional Optional Optional Optional Optional Optional
Input Type Text/number Text/number Number Number Number Text/number Number Text/Number Number Text/number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Text/number Number Text/number Number Text/number Number Text/number Text/number Text only Text/number Text or number Number Number Text or number Number Text only Text or number Text Number
Tips Sometimes called product code; this is not the UPC. All SKUs have to be unique. No duplicate SKUs. View brand ID directory 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 price of $0.		 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.

If you're a retailer, we recommend leaving this blank		 Canadian pricing Canadian pricing Canadian pricing Inches only Inches only Inches only Inches only Ounces Pounds Bridge Department Hierarchy Bridge Department Hierarchy Bridge Department Hierarchy Bridge Department Hierarchy Bridge Department Hierarchy "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. Leave blank for no Maximum number of characters or 0 if unlimited "Yes" or "1", or "No" or "0".

This is for items designated for retailers' stores. e.g a display case.
Example 1234 Juliska 123456789112 123456789013 Butterflies Dinner Plate 100 79 50 110 95 55 1.25 10 10 10 .75 Dining and Entertaining Dinnerware Dinner Plates Made by our artisans, this... Jonathan Ive Yes Dinner plate, butterfly, flower, gold, 24k Yes 8 4 No 32 Porcelain Portugal
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)
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**
Size_Unit_of_Measure*
Capacity_Unit_of_Measure*
Weight_Unit_of_Measure*
New_Item (1 = Yes, 0 = No)**
Item_Can_Be_Monogrammed**
Material
Country_of_Origin
Warranty
Retailer_Only**

These fields are for wholesalers (brands, etc.):
Wholesale Notes*
Next Available Date*
* = Product level data
** = SKU level data

Please see #19 below for more information about handling product level and SKU level data.

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