|IMPORTING YOUR INVENTORY ITEMS INTO PLEXIS POS|
Inventory transfers using ASCII CSV Text Files:
There are six choices available in Plexis POS that allows for the importing of
your existing inventory. The easiest method is to have your inventory in an Excel
spreadsheet prior to sending the information to the Plexis POS inventory database.
All fields must be properly formatted in Excel as Generic Text.
Data Field Names and Types for Excel. (example using Plexis POS Import Type 5):
FIELD NAME and TYPE
Item Number: 1-20 Characters cell formatted as Generic Text
Description: 1-40 Characters cell formatted as Generic Text
Cost:Currency, 2 Decimals cell formatted as Generic Text
List:Currency, 2 Decimals cell formatted as Generic Text
Quantity: 4 Decimals cell formatted as Generic Text
* Do NOT use Numeric Formatting in Excel, it will truncate
or remove leading and trailing zeros
No other fields or cells must be present. Remove all extranious cells.
The Excel file must now be saved as MS-DOS CSV. Example: "Items.csv"
01234567890,WINDOW ARCHED LG,22.00,32.00,2.0000
If you have special characters such as commas within descriptions then enclose them in quotes.
01234567890,"WINDOW, ARCHED, LG",22.00,32.00,2.0000
C-Store Import Sample
Liquor Store Import Sample