Catalog: New Brand Paid (No Existing Catalog)

  1. Create or edit BrandBrand > Company Directory. Search for brand. If not there “Create New Company”Make sure to add a color logo (for more things) and a b&w logo for brand page. Add as much info as possible. Make sure the color logo fits in the circle on this type of page. Put status as Live and/or on Billing Cycle and set date to Jan 1 2022 (until this is automated) If just created, once saved, re-find and set settings. Check Appear in Brand Health and appear in onboarding Status Panel. Products Appear in Search and SEO: Yes.
  2. Get catalog from brand. Check to make sure you have sufficient info (UPCs, MSRPs, etc)
  3. Make first column the UPC column. That column header needs to be “UPC”. It is ok if a brand is using EANs- on both the catalog end and retailer end our system will make 12 digits so they match. If a PL is used and a brand uses more than 12 digits, it’ll still match with our 12 digits from the right to left.
  4. Make second column the product name. The column header needs to be “Product Name”. The product name should be proper case. The excel formula is =proper(column/row) There may need to be some alterations to this field based on style number- see step 5. Do a search for any items labeled POP or Sample, etc and delete them – we only show items available to the public. Product Name should NOT have the brand name at the beginning. Product Name should have gender if applicable.
  5. Make the 3rd column style number. The column header needs to be “Style Number”. The brand hopefully has a column that says Style. Our system groups products by style number- for example if a group of UPCs has the same style they appear together (our system will force the Product Name to the first product name) and then the shopper can choose the variants within that like color and size. A good place to research is the brand site to see how they group and if the style number is visible (they need to pull that to match to the PL).The brand may have a column called SKU. In an ideal world, the sku is the style with a hypen with the variants. For example you might have 10134-S-001, 10134-M-001, 10134-L-001,10134-S-100, 10134-M-100, 10134-L-100. In this case, the style is 10134, the S,M,L are sizes and 001 is black and 100 is white. In excel, the way to separate if there are hyphens or a separator is Data > Text to Columns and choose the separator like hyphen. Make sure to make enough blank columns to take the data without overwriting any data. Note that sometimes the data put in the other columns is needed. Usually a brand provides a separate column with size or gender or color code but something the reference is only within the sku.There also might be a string of digits where the end digits are seemingly random and the first x number of digits emerges as the style. In excel you can pull the first x number of digits by using the formula =LEFT(C2,8) or (cell number, number of digits to extract)The least desirable is item numbers. There are few brands left that use item numbers. They don’t work well in our system, but it problematic along the way to make up a style. In this case, use the Product Name as the style number.
  6. With Product Name and Style side by side make sure to adjust Product Name if needed. For example, a brand may put the color and size in the title. If they are using proper styles, that data needs to NOT be in the Product Name. (You might use Data > Text to Columns if you need the data for an upcoming field). If the brand is using item numbers, there needs to be more info in the title since the variants won’t be on the product page. Remember that if proper styles are used our system forces the style to have the same name.This is a good time to do a find & replace in the Product Name Column if the brand uses anything internal abbrevs or strangeness. Common ones would be find and replacing Jkt to Jacket.
  7. Add Season Name. Generally a brand won’t have this. The header is “Season Name”. This is very strict it has to be Spring 20, Fall 20, Spring 21, Spring 22.
  8. Use the “Gender” column if needed. For Google Feeds all clothing items (things under category 1000). The variables are Womens, Mens, Kids, and Unisex (If a gender is not designated like for a beanie use unisex). Some shoe brands so not have a gender column, but instead name the shoe Running Shoe W or W Running Shoe- the W is for Women and the Men is implied (eye roll). There may be M and W in the sku but this usually doesn’t refer to Men and Women in shoe- this is usually width.If there is Gender, make sure the gender is in the title or add now. Note that many brands intermittently add gender so make sure if gender is added in bulk that there is not two genders in the title. Also when adding gender while in the gender color is should be Womens (without apostrophe) in the title add the apostrophe with find and replace so it read Women’s.
  9. If there are color variants, use “Color Code” and “Color Name”. These two columns are linked. If a brand provides a code for the color use that for the color code (this might come in very handy for image urls). If no code is provided, make the “Color Name” column and copy and paste into a new column as a duplicate and rename that one “Color Code”.
  10. Use “Size 1” and “Size 2” if needed. Use S for Small, M for Medium, L for Large, XL for X-Large, Reg for Regular, Long for Long, etc. Use “One Size”- one size or one size fits all, etc. Some brands put WS for Women’s Small- Size should only have size- make sure women’s is the gender and remove from this column.If a brand has two size columns, evaluate whether to make them one column or two. Note- if you are using 2 columns for size ALL items in a style will need to have 2 sizes. If you don't need, simply combine Size 1 and 2 into the same column as Size 1. Items that need two columns will have two choices for one Size 1- for example if a pant in size 32″ has a Short, Reg, and Long use two columns. If a shoe brand has makes each shoe a different style only use Size 1- for example if a shoe titled Hiking Boot A Wide Width and is the only variation in the style, don’t put Wide in style 2 – in this case wide is the only option and would only confuse shoppers- instead you may want to use 11W for size 11 wide. To combine to columns, use =G2&H2 or =G2&” “&H2 if you need a space.
  11. Make the price column header “Unit MSRP”. Make sure this is the MSRP and not cost as this price shows for all retailers. Some baby brands do MAP. Do a sort on MSRP. if anything is 0 or no price, delete it. Also, if the column is in $ format you must remove it to upload. Right click the column and change currency to none. Note: This is the first column to check immediately upon upload. Cross-reference that no prices were input as 0 or 1 – some formats make prices over 1,000 into 1.
  12. The file should now be ready for initial upload. Save as a copy- always save original brand copy for season in case there are problems.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.