Plexis Point of Sale Inventory Importing FAQ

PLEXIS POINT OF SALE SOFTWARE

QUALITY POS SOFTWARE SINCE 1987
1-800-883-0814
Thousands & Thousands Sold

FAST FOOD - PIZZA - COFFEE SHOP - RESTAURANT

RETAIL - CONVENIENCE STORE - LIQUOR - DELIVERY

Discount Point of Sale Software for Do-It-Yourself Business Owners

IMPORTING INVENTORY FAQ

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.txt"

Output Example:
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

Excel File Sample

CSV Text File Sample

Plexis Software can assist you with your import needs.
If you require further assistance feel free to contact
us for a quote.