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:
Use the 'Product Suppliers' Import/Export tool.
Export the 'Product Suppliers' file.
Edit the 'supplier default price' values as needed.
Import the file to apply the changes.
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.