Sometimes, we need to edit the data from existing products in order to maintain the business process such as changes in product names, product descriptions, prices, and so on. If you have a lot of products, it will take long time if you're trying to edit the products manually one by one.
In order to help you edit the products data faster, we provide options to edit product by bulk method by using import and export product's data with the CSV file type. This option will help you to edit Multiple Products Data faster than manually editing them one by one. You can try to follow the steps below to edit the product with export and import CSV file.
Step 1. Export Products Data
Go to product, click on Export Button, then open the CSV file.
Step 2. Edit Products from CSV File
You can edit anything in the CSV file such as Name, Code, UnitCost, UnitPrice, etc. except for ID & ProductID Column.
For example, we're going to change this value (Product, Code, UnitCost, and UnitPrice) :
Into this:
And then you can save the CSV file.
Note:
If you want to leave the release date blank, fill it with the format 01/01/0001.
Step 3. Import the product CSV
Import the CSV file that you've updated to Products menu.
Click Browse File and click Next.
After we click "Next," a preview of the product will appear, showing which products we have edited. If everything looks good, we can click "Next" to finish.
Upload Complete
Step 4. Recheck the Result on Product List
Before:
After:
[Tutorial Video] Edit Product Bulk Using CSV Files
Related Articles
If you want to edit product bulk by web UI, you can go to DealPOS Tools App and use the Product editor spreadsheet. To use the product editor spreadsheet you can follow this article : Edit Existing Product via Spreadsheet
if you want to differentiate selling prices and extra costs of products in each outlet, you can see this article : How to set Different Selling Prices and Extra Cost of Products on Each Outlet
In order to remove a product/products which have a transaction, you can only remove the product by making it a discontinued product. To set discontinue on a product/products you can see the article : Discontinue Product or Variant
To make a report from your products data, you can try to export the products data according to your needs. You can see the article on what kind of export data products you can get from DealPOS here : Export Data Product
