If you only read one thing...

A Vendor SKU can only be used once in your catalog. If you try to add the same Vendor SKU again, it will move the item out of the original deal and into a new deal.


Planning Your Product Group


In Gateway, product groups are set at the point of upload through the Variation Grouping ID (Column K).


  • Consider which options should sell together on the same deal and decide what the VARIATION GROUPING ID should be for these items.

  • Make sure the VARIATION GROUPING ID is unique and less than 40 characters.  If it gets reused on a later upload, the uploaded product will be added as options on the existing group.

  • Ensure the Variation Grouping ID (Column K) is the same for all products you want to be grouped together on the same deal.

  • Some examples include: "89486 Egyptian Cotton Bath Towels", "GTS416-Graphic T-Shirt Collection", "Birthstone Necklaces-3125"  



Remember that Category ID, Product/Product Group Title, Description, Manufacturer, Brand and Bullet Points must be the same for all items grouped together on a deal.  The information must be relevant to ALL products in the group.


Choosing Category IDs & Attributes

  1. Reference the Category ID tab to find the category most applicable to your product. You can then copy and paste this category into column A (Category ID) on the Template tab.
  2. Filter by your Category on the Attributes Tab to review the attributes available for your category and determine which attributes are required versus optional.


***Check for your REQUIRED and DISTINGUISHING attributes BEFORE starting on the attribute section of the Template tab. ***


If you enter an attribute for one product, you must enter that attribute for all products in the group or else you will get the error of "All products selling together in a product group must have the same attributes.  Please apply missing {attribute name} and a corresponding attribute value to this product."

Distinguishing attributes create the deal drop downs. If there is more than one product in the group, at least one distinguishing attribute value must be unique to each product.


Any phrase related to "Alphanumeric… " should be NOT BE INCLUDED in the upload.  




The example highlighted in yellow above is incorrect because two products within the same product group contain the same exact combination of attribute values 



Custom Attributes


Custom attributes can be used by following the below guidelines.  These instructions were designed for the most frequently used Custom value: Color.



Images


Notice that on the first URL, the image is the only element on the page, while the second and third URLs include a Dropbox page.


Tips & Tricks


  • To keep a product from going live immediately after approvals, enter a quantity of 0. Please remember that you must add a value and cannot leave this field blank.

  • Do not change the column headers on the template tab. Also, you cannot add any extra columns.

  • If you are using a 13 digit UPC as a Product Identifier, choose EAN as the Product Identifier Type.

  • It is best practice to order items from lowest to highest price for each product on the same Product Group at upload.


IN CSVs, EXCEL AUTOMATICALLY FORMATS UPC in SCIENTIFIC NOTATION.  DO NOT SAVE FILE WITH UPC IN SCIENTIFIC NOTATION.  CONVERT TO A "NUMBER" or "TEXT" IF THERE ARE ANY LEADING ZEROS.  YOU WILL NEED TO RE-ADD ANY LEADING ZEROS.