Your site's product catalog is generated based on a data in spreadsheet you upload, in either XLSX (recommended) or CSV format. The data must be in a particular format.
This file is always the "truth" of your products database. Uploading another spreadsheet replaces previous upload data.
To add a product, simply add a row, save the spreadsheet, and upload it. To delete a product, remove the row, save the spreadsheet, and upload it.
Our server saves old copies of product catalogs. If your organization loses their data file, contact email@example.com and we can help recover it.
To upload your spreadsheet go to Admin -> Upload Products. If you are already in the admin panel, click Products on the left side panel.
From here, click Choose Files, select your spreadsheet, then click the Upload Products button. Wait until a success message appears before leaving this window.
The format of your spreadsheet must match GoPlanogram's expectations. The simplest approach is to download our sample spreadsheet XLSX file, which will contain all pre-supported data in the column headers, then populate it with your own data.
A screenshot of our Sample Spreadsheet
Column header names must be spelled and cased exactly as they are in the sample spreadsheet. The columns may be placed in any order, except for ProductID, which should be the first column.
Your spreadsheet must contain all Required columns, and can contain as many of the optional columns you want. We have flagged some properties as Recommended, for best results.
For properties pertaining to dimensions or measurements, all entries must be in either inches or centimeters, depending if your site is in US Customary mode or Metric mode. One spreadsheet may not contain measurements in both inches and centimeters.
|ProductID||Required||A unique identifier for this entry. Maximum of 50 characters. No two products can have the same ProductID.|
|CatalogName||Required||The name of the item as it will appear in the catalog. Maximum of 150 characters.|
|Height||Required||A decimal number specifying product height in inches or centimeters.|
|Width||Required||A decimal number specifying product width in inches or centimeters.|
|Depth||Recommended||A decimal number specifying product depth in inches or centimeters.|
|CatalogCategory||Recommended||The major category this item belongs to. Maximum of 150 characters.|
|CatalogSubCategory||Optional||The category below CatalogCategory this item belongs to. Requires the CatalogCategory column not be blank. Maximum of 150 characters.|
|CatalogSubsubcategory||Optional||The category below CatalogSubCategory this item belongs to. Requires the CatalogSubCategory column not be blank. Maximum of 150 characters.|
|PictureFilename||Recommended||A text field specifying the name of the image file to use for this item. Maximum of 150 characters. These filenames must not contain semi-colons (;).|
|ShortDescription||Optional||An additional text field you may use for product details or whatever else you want. Maximum of 150 characters.|
|UPC||Optional||A text field specifying the Universal Product Code. Maximum of 50 characters.|
|Price||Optional||A decimal number specifying item price.|
|Cost||Optional||A decimal number specifying item cost.|
|BestSelling||Optional||A decimal number specifying how rapidly a product sells, or really any sales data you wish. See also heatmaps and catalog color chips.|
|PegholeDown||Optional||A decimal number specifying the distance of item's peghole from the top of the product, in inches or centimeters. Defaults to 0.5" if blank.|
|PegholeRight||Optional||A decimal number specifying the distance of item's peghole from the left of the product, in inches or centimeters. Defaults to center if blank.|
|Peghole2Down||Optional||A decimal number specifying the distance of item's second peghole from the top of the product, in inches or centimeters. Defaults to 0.5" if blank.|
|Peghole2Right||Optional||A decimal number specifying the distance of item's second peghole from the left of the product, in inches or centimeters. Defaults to center if blank.|
A single character specifying the hook type.
A single character specifying if the product is hidden from users (but still "in" the catalog, so planograms
previously saved with this product will not be altered.)
If provided, this will be used as the color(s) for elements of this Category, SubCategory and SubSubCategory when the appropriate View Option is active.
To specify category colors, this value must be a semi-colon separated string. The format is:
The values provided must be a valid CSS color, or a hexadecimal or RGB formatted color.
For example, specifying
You do not have to specify all three colors. Specifying none, one, or two is also allowed -- the unspecified colors will be auto-generated, either based on a random color if no Category color is provided, or on the provided Category, if one is provided.
A single character specifying the item type.
An alternate product identifier used by a particular account or channel. Maximum of 50 characters.
You may distribute your products via multiple distributors or “accounts” which may handle a subset of your products and have their own product numbers for your products. For example, a column header labeled AcctID_HomeDepot would allow you to specify a set of product numbers used by the account “HomeDepot”. Leaving this entry blank would indicate that the “HomeDepot” account did not handle a particular product
Other columns where the column header is prefixed with a "#" are treated as Custom Fields.
For example, if you wanted to add Brand as a field associated with each product, you would put #Brand as a column header. The sample spreadsheet has an example of a Custom Field.
By default, you may have up to 15 custom fields. If you need more, please contact support.
Lite accounts are limited to 10 custom fields.
Custom fields, along with all the other pre-supported data properties listed on this page, can be used in many, many types of site customizations.