Use the Import Supplier Quantity Prices templates to add new or edit existing supplier-specific, purchasing Quantity Prices for products in bulk.
📌 Note: The Import Supplier Quantity Prices template cannot be used to remove existing product supplier Quantity Pricing in a product's record. Go to the product's Purchase > Quantity Prices tab and use the bin icon to delete it.
Blank Import Supplier Quantity Prices template field definitions
If you're creating new quantity prices for product suppliers, the blank template downloaded from the Supplier Quantity Prices tab, the columns available in the template are explained in the table below.
Import Supplier Quantity Prices template field* denotes mandatory fields | Description |
*Product Code | The unique Product Code for the product. |
Product Description | The description of the product. |
*Supplier Code | The product supplier's unique Supplier Code. The Supplier must already be saved in the product's Purchase > Suppliers tab. |
Supplier Name | The product supplier's unique Supplier Name. |
Unit of Measure | The supplier's default purchasing Unit of Measure, as saved in the product's Purchase > Suppliers tab. |
*Min. Quantity | The minimum quantity required for the supplier's price/discount to apply per Purchase Order. Numeric value up to 4 decimal places. |
*Price/Discount | The value to be applied as either a fixed price or discount when the minimum quantity is purchased from the Supplier. If using Price Type: Discount %, only enter a numerical value between 1 and 100. |
*Price Type | Enter either
|
Comments | Enter additional notes related to the product supplier's Quantity Prices. |
Pre-populated Supplier Quantity Prices template field definitions
To update a product supplier's quantity prices, you can export a pre-populated Supplier Quantity Prices template, but it will include additional fields that will need to be retained when importing.
Export Supplier Quantity Prices template field* denotes mandatory fields | Description |
Guid | The unique code generated by Unleashed for the product's specified Supplier Quantity Price. |
*Product Code | The unique Product Code for the product. |
Product Description | The description of the product. |
Default Purchase Price | The product's Default Purchase Price, populated in the product's Purchase tab. |
*Supplier Code | The product Supplier's unique Supplier Code. NOTE: The Supplier must already be saved in the product's Purchase Suppliers tab. |
Supplier Name | The product Supplier's unique Supplier Name. |
Supplier Default Price | The Supplier's Default Purchase Price for the product, populated from the product's Purchase, Suppliers tab. |
Unit of Measure | The supplier's default purchasing Unit of Measure, as saved in the product's Purchase Suppliers tab. |
*Min. Quantity | The minimum quantity required for the supplier's price/discount to apply per Purchase Order. Numeric value up to 4 decimal places. |
*Price/Discount | The value to be applied as either a fixed price or discount when the minimum quantity is purchased from the Supplier. If using Price Type: Discount %, only enter a numerical value between 1 and 100. |
*Price Type | Enter either
|
Discounted Purchase Price | The product supplier's Quantity Price after the Fixed Price or Discount % has been applied. |
Comments | Enter additional notes related to the product supplier's Quantity Prices. |