How to update stock prices for existing stock items in bulk using a CSV file
From the navigation bar, expand the Stock heading and open the Stock Maintenance page:
Select the Supplier that requires the price update. Now click the More menu and select Update Cost from CSV file by Supplier's Code:
To download the template file click Download CSV Template:
The template will have two columns, Supplier's Code and New Cost. Simply copy and paste the information from your Supplier's price list into the respective fields.
Save the template and return to CTB to upload the file:
After uploading the template file, you will see a message summarising which stock items were successfully updated and which were not found. If the Supplier's Code does not exist in Stock Maintenance then it will not be found. Click Download Status Report to find out exactly which Supplier's Codes could not be found.
Want to find out more? Should you require further assistance, please Contact Us or start a live chat today!