No Monthly Renewal Fees
Keep Your Credit Card Company
Keep your info Private
IMPORTING OR UPDATING YOUR INVENTORY ITEMS
Inventory Transfers using a PDT Device
|Inventory Transfers using 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.
FIELD NAMES and TYPES
Item Number: 1-20 Characters cell formatted as Generic Text
Description: 1-40 Characters cell formatted as Generic Text
List: Currency, 2 Decimals cell formatted as Generic Text
Cost: Currency, 2 Decimals cell formatted as Generic Text
Quantity: Up to 4 Decimals cell formatted as Generic Text
Dept: 1-4 Characters cell formatted as Generic Text
Taxable: 4 Characters, True or False
Arrange your Excel or Text file cells to match the order and position of the following import specification:
Item Number, Description, List Price, Cost Price, Quantity, Department
The Excel file must now be saved as MS-DOS CSV. Example: "Items.csv"
* Do NOT use Numeric Formatting in Excel, it will truncate
and remove leading and trailing zeros.
Import text Examples:
01234567890,WINDOW ARCHED LG,32.00,18.00,2.00,D21,True
If you have special characters such as commas within descriptions then enclose them in quotes.
01234567890,"WINDOW, ARCHED, LG",32.00,18.00,2.00,D21,True
As a general rule and to make importing seamless surround all field data with Double Quotes.
"01234567890","WINDOW, ARCHED, LG","32.00","18.00","2.00","D21","True "
Downloads and Updates
Restaurant POS Software | Pizza POS Software | Coffee Shop POS Software
Plexis Point of Sale Software
12:00 Noon to 8:00pm Weekdays Eastern Time
Our 30 Day Refund Policy
A Delaware, USA Company