Unleashed provides robust tools for performing bulk updates to various pricing fields, including customer pricing, product costs, sell price tiers, and purchase prices.
Important:
Do not delete any columns or headers in any import template files, as this can result in data loss.
Always save a backup copy of the original file before making changes.
Sale prices
Customer Pricing
To update customer pricing in bulk:
Go to Customers > Import/Export.
Export the 'Customer Pricing' CSV file.
Open the file and make the necessary pricing changes.
Import the updated CSV back into Unleashed.
For detailed field definitions, refer to the customer pricing field definitions.
Sell Price Tiers
To bulk update sell price tiers for products:
Go to Inventory > Products > Import/Export.
Export the Products CSV file.
Modify only the sell price tier columns in the file.
Save the file and import it back into Unleashed.
Product costs
Average Landed Costs
To update Average Landed Costs for multiple SKUs:
Use the Import Stock Revaluation to export the current product cost data.
Update the cost fields in the exported CSV file.
Import the updated file back into Unleashed to apply the changes.
Last and Nominal Costs
To bulk update last costs and nominal costs for products:
Go to Inventory > Products > Import/Export.
Export the Products CSV file.
Modify only the 'Last cost' or 'Nominal cost' columns in the file.
Save the file and import it back into Unleashed.
Purchase Price
Default purchase price
To bulk update purchase prices:
Go to Inventory > Products > Import/Export.
Export the 'Products' CSV file.
Update the 'purchase price' fields in the file.
Import the updated file back into Unleashed.
Default supplier price
To bulk update supplier-specific purchase prices:
Go to Import/Export > Product Suppliers.
Download the Product Supplier import template.
Update the Supplier Default Price column with the new prices.
Import the updated file back into Unleashed.
đ Note: The Default Purchase Price is a product-level setting updated via the general Products import, while the Supplier Purchase Price is specific to a supplier and updated using the Product Suppliers import template. Always use the correct template to ensure accurate updates.
Troubleshooting pricing import issues
If a pricing import fails:
Ensure the file does not contain currency symbols (e.g., ÂŁ, $, âŹ) or other non-numeric characters in numeric fields.
Remove all non-numeric characters and re-upload the file.
Best practices for bulk updates
Modify only the fields you intend to update.
Validate the data before importing to ensure accuracy.
Use the correct import template (Products or Product Suppliers) depending on whether you are updating product-level or supplier-specific prices.