Uploading Products

You must be one of your GoPlanogram site administrators to upload product data

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 support@goplanogram.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.

How to Create Your Products Spreadsheet

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.

Property Name Importance Notes
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.
HookID Optional A single character specifying the hook type.
  • J or blank indicates a J hook
  • S indicates a straight hook
  • L indicates a loop hook
Loop hooks and straight hooks will cause snapping to a position between 2 holes, J hooks will cause snapping to a position directly over a hole. Loop hooks will appear as an oval. Straight hooks and J hooks will appear as a circle
Hidden Optional 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.)
  • F or blank indicates the product is visible in the catalog
  • T indicates the product is not visible in the catalog
Color Optional

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: <categoryColor>;<subCategoryColor>;<subSubCategoryColor>

The values provided must be a valid CSS color, or a hexadecimal or RGB formatted color.

For example, specifying teal;red;#94C973 will color products of this Category teal, products of this SubCategory red, and products of this SubSubCategory spearmint green (the value of hex code #94C973), when the Category, SubCategory, or SubSubCategory view is turned on, respectively.

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.

Type Optional A single character specifying the item type.
  • S or blank indicates a standard product
  • BI indicates a background image. Background images can be dragged to a display as fixed size images that appear behind everything else, or, more commonly, are used as backgrounds for Racks.
  • Sign for any merchandising or sign.
  • HS for signs you want to snap onto the top of Racks. These signs can be included in donwloaded images.
  • CF indicates a custom fixture. Custom fixtures have a unique ProductID, a name (CatalogName), a picture (PictureFilename) , and Height and Width. Custom fixtures support smooth snapping (products dropped on custom fixtures stick to the fixture and can be smoothly moved to any position on the fixture)
  • FPL indicates this element is to be treated as a Floor Plan Label. These may be dragged from the catalog in Floorplan Mode. Providing Width and Height is supported for default dimensions of the label. Providing the Color field will make this Floor Plan Label default to that color.
  • P indicates a item that can contain other products, such as a panelboard backer or custom rack. “P” items will snap to legal peghole positions, but items placed on “P” items can be place anywhere on the “P” item
  • U indicates a product that can contain other products, where the contained products snap to legal peghole positions, such as a uni-rack backer
AcctID_XXX Pro Only

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

Custom Field Columns

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.