POS SOFTWARE SINCE 1987
PLEXIS POINT OF SALE SOFTWARE Thousands & Thousands Sold Free to Try for 90 Days |
FAST FOOD - PIZZA - COFFEE SHOP - RESTAURANT |
| ||||||||||||||||||||||||||||||||
| Do-It-Yourself Windows Touch Screen POS Software | ||||||||||||||||||||||||||||||||
| 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. |