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:
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 | Optional | Optional | Required | Optional | Required | Required | Optional | Optional | Optional | 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 | 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 | 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 or number | Text | Numbers |
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 | 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 | 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 "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 |
Page tags: product updates, updating products, image management, file sharing, supply chain management, datafeed, headless commerce, product syncing standards, how to share products, best practices, optimizing product content, product information management, PIM