1.
We recommend that your database or Excel file have the column names listed below. To help get started,
download our sample Excel file here .
Choose how you primarily organize your products. Choices: a) Pattern (design motif) or b) Department (usage). We suggest that you organize your products to match your official website or catalog/price list.
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.
Remove columns not shown in the sample above.
3.
Please do not use hidden columns or rows.
4.
Please do not use Excel formulas to calculate any columns. For example, please remove formulas calculating retail pricing based off the wholesale price.
5.
One sheet per Excel file. Please no multiple tabs/sheets.
6.
One brand per Excel file. Please create multiple Excel files for each brand.
7.
One item per row. If you would like to import "multi-sku" products, please let us know and we'll provide directions for this.
8.
All SKUs must be unique. Please no duplicate SKUs.
9.
Use proper case for all names and descriptions. Please no: "dinner plate", Yes: "Dinner Plate".
10.
All items must have a collection/pattern assigned. Please place uncategorized items in the department "miscellaneous".
11.
Assign departments and secondary departments based on the current Bridge Department Hierarchy .
12.
Please make sure no items have a "0" retail price.
13.
For dimensions/capacity, please only input numbers for single item. Please add dimensions/capacity for multiple items in a SKU set to the description field.
14.
Please do not use fractions in dimension/capacity columns.
15.
Please do not enter ", lbs, oz, etc, in dimension/capacity columns; numbers only please.
16.
Please do not enter the brand name in the pattern name field, the word "collection" in the pattern name field, or the pattern name in the product name field.
17.
Please do not place quotes or words after products dimensions/descriptions (No: 24.5", Yes: 24.5; No: 15 oz., Yes: 15).
18.
Below are the suggested product attributes. These mirror the ones in the sample Excel sheet above.
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.
When sharing product data on an on-going basis, we recommend products contain these additional attributes:
Product_Added_Date
Product_Edited_Date*
SKU_Added_Date
SKU_Edited_Date**
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.