Stock Take By Csv File
You can use this Method when you want to stock opname with import csv file.
Step 1. Tab "Stock Take By CSV" on adjustment menu then Choose the outlet that the stock you want to update - download current inventory
Note : If you want to include the products without inventory (stock quantity at 0), you can click 'More Options' button, and choose Yes for 'Product Without Inventory'. Then click on the 'Download CSV' button on the upper right corner.
Step 2. Open up the downloaded CSV and fill Counted column Then save
|Name||Name of your product or variant.||String|
|Code||Code of your product or variant||String|
|Expected||Stock in DealPOS system.||Number|
|Counted||Counted Stock / Stock in Hand / Stock in your outlet||Number|
Step 4. Back to the Stock Take by CSV page, choose file for 'Counted Inventory' section. Then click 'Upload' button
Step 5. When the CSV file succcessfully uploaded, you will see the table of the data from CSV file you just uploaded. Then click on the 'Confirm Adjustment' button
The 'Differences' column is the quantity of the adjustment that we will create.The Qty is taken from the Differences colum from earlier. Note that the products with 0 difference (Expected = Counted) is excluded from the Adjustment Form.
Articles in this Section
- Inventory Adjustment
- Stock Take By Csv File
- Stock Take by Web Spreadsheet
- Inventory Adjustment with Replace Quantity