Shelf Logic Planogram Software

Planogram Power that's Easy to Use

Shelf Logic Database Layout

Shelf Logic uses Access2000 for its database. There's an item maintenance window into which data can be added and data can be imported from an Excel spreadsheet.

Master Edition Database Layout

Column Name Letter	Required Entry	Max Characters	Required Format (Data Type)
A - UPC Code	Required	(25)	Must be a unique number or alphanumeric for each product
B - Item No.		(25)	User defined, alphanumeric.
C - SKU Code		(25)	User defined, alphanumeric.
D - Vendor No.		(25)	User defined, alphanumeric.
E - Ven Name		(50)	User defined, alphanumeric.
F - Item Name		(50)	User defined, alphanumeric.
G - Item Type	Required	(1)	S=Shelf Item P=Peg Item I=Signage
H - Category		(50)	User defined, alphanumeric.
I - Desc		(50)	User defined, alphanumeric.
J - Width	Required	(8)	Inches in whole numbers or decimals.
K - Height	Required	(8)	Inches in whole numbers or decimals.
L - Depth	Required	(8)	Inches in whole numbers or decimals.
M - Weight		(8)	In ounces.
N - Ctn Pack		(8)	Whole number.
O - Peghole Left	Required for peg items	(8)	Inches in whole numbers or decimals.
P - Peghole Top	Required for peg items	(8)	Inches in whole numbers or decimals.
Q - Sugg Retail		(7)	In dollars.
R - Cost		(7)	In dollars.
S - Last Chg		(8)	Current date will automatically be inserted. No entry required.
T - Outline Color		(2)	Enter a number from color chart (1-16)
U - Fill Color		(2)	Enter a number from color chart (1-16)
V - Pattern		(2)	Enter a number from color chart (0-6)
W - Image "Bitmap" Name		(100)	Path and name of image file.
X – Transparent Color		(8)	Transparent background color or –1 if none.
Y – Nest Amount		(8)	Inches in whole numbers or decimals.
Z - User1		(50)	User defined, alphanumeric.
AA - User2		(50)	User defined, alphanumeric.
AB - User3		(50)	User defined, alphanumeric.
AC – Metric		(3)	Current unit of measure will automatically be inserted. No entry required.

Enterprise Edition Database Layout

Column Name Letter	Required Entry	Max Characters	Required Format (Data Type)
A - UPC Code	Required	(25)	Must be a unique number or alphanumeric for each product
B - Item No.		(25)	User defined, alphanumeric.
C - SKU Code		(25)	User defined, alphanumeric.
D - Vendor Code.		(25)	User defined, alphanumeric.
E - Ven Name		(50)	User defined, alphanumeric.
F - Item Name		(50)	User defined, alphanumeric.
G - Item Type	Required	(1)	S=Shelf Item P=Peg Item I=Signage
H - Category		(50)	User defined, alphanumeric.
I - Category		(50)	User defined, alphanumeric.
J - Category		(50)	User defined, alphanumeric.
K - Category Role		(25)	User defined, alphanumeric.
L - Strategic Role		(25)	User defined, alphanumeric.
M - Lifecycle Stage		(25)	User defined, alphanumeric.
N - Description		(50)	User defined, alphanumeric.
O - Unit Width	Required	(8)	Inches or cm in whole numbers or decimals.
P - Unit Height	Required	(8)	Inches or cm in whole numbers or decimals.
Q - Unit Depth	Required	(8)	Inches or cm in whole numbers or decimals.
R - Unit Units	Required	(6)	Always 1
S - Unit Cost		(8)	Currency
T - Unit Sell Price		(8)	Currency
U - Unit Retail Price		(8)	Currency
V - Tray Width		(8)	Inches or cm in whole numbers or decimals.
W - Tray Height		(8)	Inches or cm in whole numbers or decimals.
X - Tray Depth		(8)	Inches or cm in whole numbers or decimals.
Y - Tray Units		(6)	Whole Number
Z - Tray Cost		(8)	Currency
AA - Tray Sell Price		(8)	Currency
AB - Tray Retail Price		(8)	Currency
AC - Case Width		(8)	Inches or cm in whole numbers or decimals.
AD - Case Height		(8)	Inches or cm in whole numbers or decimals.
AE - Case Depth		(8)	Inches or cm in whole numbers or decimals.
AF - Case Units		(6)	Whole Number
AG - Case Cost		(8)	Currency
AH - Case Sell Price		(8)	Currency
AI - Case Retail Price		(8)	Currency
AJ - Display Width		(8)	Inches or cm in whole numbers or decimals.
AK - Display Height		(8)	Inches or cm in whole numbers or decimals.
AL - Display Depth		(8)	Inches or cm in whole numbers or decimals.
AM - Display Units		(6)	Whole Number
AN - Display Cost		(8)	Currency
AO - Display Sell Price		(8)	Currency
AP - Display Retail Price		(8)	Currency
AQ - Merch Style		(1)	Whole Number
AR - Brand		(50)	User defined, alphanumeric.
AS - Weight		(8)	Whole number or decimals
AT - Weight UM		(2)	User defined, alphanumeric.
AU - Peg Type		(2)	User defined, alphanumeric.
AV - Peghole1 Left	Required for peg items	(10)	Inches or cm in whole numbers or decimals.
AW - Peghole1 Top	Required for peg items	(10)	Inches or cm in whole numbers or decimals.
AX - Last Sales ID			Reserved
AY - Last Changed			Reserved
AZ - Outline Color		(6)	Windows Long Color
BA - Fill Color		(6)	Windows Long Color
BB - Pattern		(1)	Whole Number
BC - Image Name		(100)	Path and name of image file.
BD - Tray Image Name		(100)	Path and name of image file.
BE - Case Image Name		(100)	Path and name of image file.
BF - Display Image Name		(100)	Path and name of image file.
BG - Shape Number		(2)	Whole Number
BH - Shape Number		(100)	Path and name of shape file.
BI – Transparent Color		(8)	Transparent background color or –1 if none.
BJ – Nest Amount		(8)	Inches in whole numbers or decimals.
BK - User1		(50)	User defined, alphanumeric.
BL - User2		(50)	User defined, alphanumeric.
BM - User3		(50)	User defined, alphanumeric.
BN - User4		(50)	User defined, alphanumeric.
BO - User5		(50)	User defined, alphanumeric.
BP – Metric		(3)	"YES" if metric

Importing from Excel

Product information can be imported from an Excel spreadsheet or other comma delimited file. The spreadsheet must be in a specific format, with the correct name and number of columns. You can even maintain your database in Excel and then import it into the Shelf Logic database. Data is imported using the “Import” selection from the “File” menu. Spreadsheet Format The easiest way to get the proper format for importing data is to use the template included with the program. The first row has the field names to guide you. Just cut and paste your information column by column. The only information you really need is the UPC Code (or some other unique number), and the product’s height, width and depth. With this information, you can create planograms. One more important piece of information: Any UPC Codes with leading zeros must have an asterisk (*) in front of each one. This preserves the leading zeros.

Self Help
Support Options

1. FAQ - Check our Frequently Asked Questions area for help with your problem.

2. Knowledge Base - This has extensive information on several subjects.

3. Tips & Tricks - This area may answer your support question and has helpful information to make you more productive.

4. Forum - This has helpful information on using the software.

Contact Support

1. Phone Us at 1-845-796-4242 during our business hours: 9am to 4pm Eastern Standard Time, Monday through Friday.

2. Support Ticket - fill out a support ticket and we will respond to you within the next business day.