UPC IMPORT FROM SPREADSHEET (PF7)

Import UPC Codes from a spreadsheet or txt file.

Menus > Inventory
Commands > UPC Import

This window shows the mapping for a 3 column spreadsheet:
Stock# – Size – UPC

The Stock number must be the full and exact stock number as shown in PERFECT FIT (ivnum)
The size is the same name shown on the top opf each size slot column.
UPC is the UPC number. Careful if this is opened in Excel, as Excel may convert the number to scientific notation. It must open in notepad to show as pure text.

Save the file as a TAB delimited txt file.

Click Import UPCs
Open the txt file.
It will check for valid stock numbers and sizes.

Click OK to save the data in PERFECT FIT.

Obsolete***
Left over from PF5

Make a single spreadsheet like this:

1 row per UPC

Columns as follows, with field names to import to:

1. Stock # exactly as shown in PERFECT FIT, IUPC_IVNUM
2. Size Slot Number (1-12), IUPC_SIZESLOT
3. UPC Number, IUPC_CODE
4. UPC ID Concatenation: IUPC_ID = IUPC_IVNUM & IUPC_SIZESLOT
5. Stock # exactly as shown in PERFECT FIT, IVNUM
(This column serves to “connect” the UPC number to the Stock #)

Import Main file: INVENT_UPC

See User Guide #16 for general import instructions.