To add product data we provide options by importing the product with the .CSV file. This allows you to quickly add items without having to manually add them individually. Follow these steps for adding products using the .CSV file
Step 1. Select Import button on Product Menu
Step 2. Download Sample then Choose file, upload the file after you input on .CSV file
1. Open the sample file that has been downloaded and change according to the product you want to put into the DealPOS system then Save. If the display of the CSV file format is messy you can fix it by following the steps in this article : " Why my file csv has display bad format "
2. Click Choose File to upload the CSV file that was created previously. To display additional setup options you can click more options. When it's finished you can press the upload button to save your product into the DealPOS application.
3. Make sure you also set the Inventory Options - Update to "Yes", if you are also importing Initial / Opening Inventory for your outlet.
Standard Column Sample
More Column Detail
Category of the product
The name of the product
Code which is used to uniquely identify a Product
Available variants for the product
Code which is used to uniquely identify a variant
Supplier Name when you Buy Product
Price when you purchase to supplier
The price you want to sell to your customer
Discount of the product
Set weight product
Units of measurement from your product
Standard / Non-inventory / Complementary / Serialized / Composite
Alert users when inventory belowt the ReorderPoint
Give your sales commission for selling products
To make notes for your product
To explain notes your product
"This product contain glass"
Tag for your product
Expiration point in day
Expiration Point in month
Each variant contains some units of goods
If you want payment type that can be made
If you want to insert the product image
Dynamic column name
The inventory count of the particular product in a certain outlet
Lower limit of inventory stock.
Upper limit of inventory stock
extra cost is an additional fee charged to the outlet, such as shipping costs
If you have two or more prices in your outlet for two or more outlets
If you have two or more discount in your outlet for two or more outlets
If You have pricebook for your products
If you want composite two or more product.
Note : You can input opening inventory at the time of adding product Using Spreadsheet and fill in “Inventory_(Name of Outlet)” field.