Product Share

Open Source Product Sharing Standards


Formatting Product Files

Businesses use the following checklist to organize, format, and share Excel product files.

Bridge created this checklist to help businesses more easily share files and reduce costs.

Excel checklist:

  1. Confirm that your products follow the Product Share product guidelines shown here.
  2. Ensure that your Excel file has the column names listed below. To help get started with a new file, download our sample Excel file here.
    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 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 Canadian pricing Canadian pricing Canadian pricing Inches only Inches only Inches only Inches only 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
  3. Remove columns not shown in the sample above.
  4. Please do not use hidden columns or rows.
  5. Please do not use Excel formulas to calculate any columns. For example, please remove formulas calculating retail pricing based off the wholesale price.
  6. One sheet per Excel file. Please no multiple tabs/sheets.
  7. One brand per Excel file. Please create multiple Excel files for each brand.
  8. One item per row. If you would like to import "multi-sku" products, that would use a different process than the one shown here.

Page tags: product updates, updating products, image management, file sharing, supply chain management, datafeed, headless commerce, product sharing standards, how to share products, best practices, optimizing product content, product information management, PIM