New Page 1

Knowledge Base

Database Layout

Shelf Logic uses Access2000 for its database. It can also hook directly into an ODBC DSN bypassing the Access2000 database. We have an item maintenance window into which data can be added and we can import data from an Excel spreadsheet.

This is the layout of the Access database.

Column Name Letter	Required Entry	Max Characters	Required Format (Data Type)
A - UPC Code XE "UPC Code"	Required	(25)	Must be a unique number for each item.
B - Item No. XE "Item Code"		(25)	User defined, alphanumeric.
C - SKU Code XE "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
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 XE "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.

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 delete the data from row 2 on down. Then 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.