Sometimes, we need to edit the data from existing products in order to maintain the business process such as changes in product names, changes in product descriptions, changes in prices, and so on. If you have a lot of products, it will take more time if you're trying to edit the products manually one by one.
In order to help you make editing product bulk faster, we provide options to edit product bulk data 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
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.
Step 3. Import CSV
Import the CSV file that you've updated to Products menu.
Choose File and click Upload.
Step 4. Recheck the Result on Product List
[Tutorial Video] How to Edit Product Bulk
You might like to read these related articles below :
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