Product Upload Spreadsheet Columns

Menu Path
	AUTO MENU 11.3 Product Upload (from Excel) OP MENU 21.1.8 Product Update (from Tab-delimited Excel spreadsheet)

The following tables represent the spreadsheet columns you use when uploading product information. Although the information is presented here in multiple tables that is only for viewing convenience. In reality, the spreadsheet must contain all columns in order to be a valid spreadsheet. Not every column need have data. Many columns, as noted in the tables below, may contain only a Null.

Columns shaded in pale blue were added in release 8.6.2. Columns shaded in pale yellow were added in release 9.0.3 and 9.0.5.
The latest changes are in columns 60 through 82. Please see the pale blue and pale yellow shaded areas in Table 3 and Table 4 below.

To download a fresh, clean copy of a current Microsoft Excel spreadsheet file with appropriate column headings (and blank data), click here.

Table 1

Excel Column

Column Name

Vendor

Part Number

Desc

Cost

Sugg List

UPC

Prod Class

Prod Cat

Prod Type

PO UM

Carton Qty (UM Mult?)

Net Price (PO cost)

DS?

Whse

PL1

PLP1

PL2

PLP2

PL3

PLP3

PL4

PLP4

PL5

PLP5

PL6

Column Number

Comment

internal vendor only

required

Can enter multiple warehouses separated by a dash (-).
For example:
10-50-60

Table 2

Excel Column

Column Name

PLP6

PL7

PLP7

Eff Date

PO
(Carton) Wt

PO Hgt

PO Len

PO Wdt

Mfg Abbr

Mfg Pop

Core Price

Core Cost

Master Pack
(Ship Qty)

Ext Desc

Superseded

Interchangeable

Discontinued

Vendor Part

per car qty

pricing class

stocking ind

bin loc

Prohibit inv return

prohibit war return

prohibit core return

price hold bypass

Column Number

Comment

Valid Data

Table 3

Excel Column

Column Name

primary vendor flag

freeze date

abc code

taxable category

ROP

Line Point

Vendor MFG abbr

Warranty Eligible

My Code 1

My Code 2

My Code 3

My Code 4

My Code 5

My Code 6

My Code 7

My Code 8

My Code 9

My Code 10

My Code 11

My Code 12

My Code 13

My Code 14

My Code 15

My Code 16

My Code 17

My Code 18

Column Number

Comment

if 'Y' make this the primary vendor, everything else means 'N'

only load if not null

only load if not null, for new record only

only load if not null

only load if = "Y" or "N", for new record load Y if null

only load if not null

Table 4

Excel Column	CA	CB	CC	CD
Column Name	My Code 19	My Code 20	Product Manager	Dealer Part Number
Column Number	79	80	81	82
Comment	only load if not null	only load if not null	only load if not null	only load if not null

Columns shaded in pale blue were added in release 8.6.2. Columns shaded in pale yellow were added in release 9.0.3 and 9.0.5.
My Code. If you have been using a column labelled My Code, please note that it is no longer in column 60. It has been renamed to My Code 1 and moved over to allow for the Warranty Eligible column and to make it contiguous with the nine additional My Codes. If you leave My Code data in column 60 (that is, you use column definitions valid for a prior release), you may experience unpredictable results.