Import Supplier Quantity Prices Field DefinitionsFollow
Adding new Supplier Quantity Prices
* denotes mandatory fields. Ensure that you enter the correct values in the template before importing into Unleashed.
|Guid||Only required when updating already existing Supplier Quantity Price (as per your exported CSV file). This column will not be present when you download a blank template as it will be created upon import by the system.
See 'Updating existing Supplier Quantity Prices' below for more information.
|*Product Code||The code of an existing product. Ensure that the product has been created in Unleashed before you import product pricing.|
|Product Description||Description of the Product.|
|*Supplier Code||The code of an existing Supplier for this product.|
|Supplier Name||The name of the Supplier of this product.|
|*Min. Quantity||Minimum quantity of the product to apply the specified price or discount. Numeric value to 4 decimal places|
Specify the value for the fixed price or discount %. Numeric value to 4 decimal places. If this is a discount, it cannot larger than 100.
|*Price Type||Values are Fixed price or Discount %.|
|Comments||Any additional notes related to the quantity pricing.|
Updating existing Supplier Quantity Prices
There may be occasions when your Suppliers issue revised pricing for products. If you prefer to bulk import the revised pricing, follow these steps:
From the Inventory | Products | View Products | Purchase | Quantity Prices tab:
- Click the "Export" button to download a CSV file of the quantity prices for a product
- Update the prices in the downloaded CSV file as required
- Save your changes and click the "Import" button on the Quantity Prices tab
A Guid is automatically created and assigned by the system when the template file is imported.
Do note that downloading a blank Supplier Quantity Prices template file will not have the 'Guid' column as this is not needed when creating a new Supplier Quantity Price.
See below for an example Guid: