Before creating sales or purchase transactions in DealPOS, you must input or create the product data into your DealPOS. To input the Product data, you can use manual input or bulk Input.
In the bulk input, you can upload product data using CSV (Excel) format. The CSV format is useful when you want to upload a large number of product data at once, typically more than 100-1000 products. This method helps save time when uploading products. To import the product data using CSV files, you can follow the steps below:
I. Import Product
Step 1. Go to Product then click Import
Step 2. Click on Download Template
Step 3. Open and Edit the downloaded File
Step 4. Upload the File
Once you are done ensure that you have already save the file. Click the browse files button, select and upload it.
Step 5. Next and Preview
Click the Next button
Please ensure there are no errors in the preview, then click the Next button
Note:
If the display of the CSV file format is messed up, you can fix the format by following the steps in this article: "How to Fix CSV Files Separating Into Columns".
Please ensure the total size of the file does not exceed 1 MB.
Step 6. Click Import to Proceed
Step 7. Upload Complete
II. Product Template
Step 1. Standard Template
Note:
If the product has no variants, you can leave blank the Variant column
Step 2. Product Template with Minimum Price
Description Table
Column | Description | Example |
Category* | Category of the product | Fashion |
Product* | Name of the product | Blue Jacket |
ProductCode | Product Code which is used to uniquely identify a Product | J001 |
Variant | Variants of the product | XL |
Code* | Code which is used to uniquely identify a variant. Also known as SKU/Barcode | J001XL |
UnitCost | Buying cost of the product | 50000 |
UnitPrice | Selling price of the product | 100000 |
Discount | Percentage discount of the product | 10 |
Inventory_Outlet1 | Inventory/stock of the product | 50 |
MinimumPrice | Product mininum price | 45000 |
Notes:
Required columns are marked with *
Click the following link Minimum Price to learn more details about minimum price
[Tutorial Video] Import Product By Bulk Using CSV File
Related Articles:
To learn more details about Product menu. Please refer to the article link below: Product Menu Introduction
To learn more about export products. Please refer to the article link below: Export Products with Different Details
To add new product data. Please refer to the article link below:
βAdd New Products
DealPOS is an online point-of-sale (POS) application specifically designed for retail businesses in categories like Fashion, Minimarkets, Electronics, Fresh Food, and Building Material Stores.
With DealPOS, you can manage both online and offline store inventory in real-time on a single platform. You can also sell through omnichannel (offline and online) as DealPOS integrates with marketplaces (Shopee, Tokopedia, TikTok Shop, Lazada) and instant web stores (Shopify and WooCommerce).