POS Software for Restaurant, Retail, Pizza, Liquor Store, Grocery and Delivery Plexis Point of Sale Software
Free to try for 30 days
Buy Plexis POS Today
Only $349.95

IMPORTING OR UPDATING YOUR INVENTORY ITEMS


Inventory Transfers using a PDT Device

The built in Import Routines allows for Adding, Updating, Deleting and Compare functionality. Plexis POS provides reports that will show you the Old Qty, New Qty, Deviation and upload status.

Typically low cost devices transmit two fields, ITEM NUMBER (UPC) and QUANTITY. If other fields such as Selling Price, Cost Price, Description and Department are needed then you will need to get a programmable PDT and its programming software to accomplish this.

Plexis POS will accept any properly formatted data sent to the Windows Keyboard Wedge from the device and transfer that information directly into the Plexis POS databases.
Inventory Control with a Portable Data Terminal (PDT / PDA) Plexis POS PDT Import Screeen
Portable Data Terminal PDT Inventory Update with Plexis POS

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

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

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

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"




Convenience Store CSV TEXT Import Sample

Liquor Store CSV TEXT Import Sample



Demo Download

Downloads and Updates

Price List

Features

Screen Samples

Restaurant POS Software | Pizza POS Software | Coffee Shop POS Software
Grocery Store POS Software | Convenience Store POS Software
Retail POS Software | Liquor Store POS Software
Cafe and Deli POS Software | EBT / WIC / Snap and Food Stamp POS Software




Phone: 1-302-727-0333
Frequently Asked Questions

Help Center

Our 30 Day Refund Policy

About us

Contact us