Skip to main content

Import Product By Bulk Using CSV File

Create or add new products data by Bulk method using CSV File import

Yansen Yulius avatar
Written by Yansen Yulius
Updated today

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

Import Product

Step 2. Click on Download Template

Download Template

Step 3. Open and Edit the downloaded File

Template CSV Product

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.

Browse file

Step 5. Next and Preview

Click the Next button

Click Next

Please ensure there are no errors in the preview, then click the Next button

Verify Error

Note:

  1. 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".

  2. Please ensure the total size of the file does not exceed 1 MB.

Step 6. Click Import to Proceed

Import to Proceed

Step 7. Upload Complete

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

MinimumPrice Template

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:


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).

dealpos-trial-indonesia
Did this answer your question?