Share on
× Get iREAP POS PRO Voucher
Published 25 July 2016

How To Import / Upload Master Data Product/ Item / Article and Price From CSV or Excel file via Web Admin iREAP POS Pro

Mobile Cashier Android Support Multiple Store iREAP POS Pro

If your store has quite a lot of product data, it will be very time consuming to input your item data one by one through the IREAP POS Pro application, or via the Web Admin.

IREAP POS Pro provides facilities so that you can prepare your product / item master using a CSV file or Excel, then after all the data is ready you can use the import / upload data function for new goods / products via the web admin to add or change the master of goods at once (For example a change in selling price).

Download CSV File Template iREAP POS Download Excel File Template iREAP POS

The Upload process will see ITEMCODE, if ITEMCODE already exists it will be considered UPDATE, so when you update price/promo price, etc and when you re-upload so the PRICE will be updated. If during the upload process, the ITEMCODE has never existed, it will be considered a new item.

If using a CSV file, a maximum of 5000 product/row data can be uploaded at once, and for using an Excel file, a maximum of 1000 product/row data can be uploaded at once. If you have more products than the maximum limit, please split them into batches of 5000 rows (for CSV) or 1000 rows (for Excel).

New version of CSV file use the first row as the column header, the text for the column header must be exactly as shown below (no space between column):

Category, ItemCode, Description, UnitOfMeasure, NormalPrice, PromoPrice, WholesalePrice, WholesalePromoPrice, Cost, Tax, NonStock, Unsellable, Note

For non-stock products or those that do not have stock, you can still add the cost price through the product master data, regardless of whether you use the moving average method.

Here are the steps for importing / uploading products on iREAP POS Pro

iREAP POS : iREAP stand for Integrated Retail Application, is an application designed and developed to help you managed and run store operation, consists of Point of Sale / Cashier system and inventory control system.

contact whatsapp