Import Supplier Quantity Prices Field Definitions
FollowAdding new Supplier Quantity Prices
* denotes mandatory fields. Ensure that you enter the correct values in the template before importing into Unleashed.
This import must be used ONLY for existing suppliers of your products. You cannot create a new product, a new supplier or a product/supplier relationship using this import.
Field Name | Description |
---|---|
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 |
*Price/Discount |
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 occassions 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
Note: The first column "Guid" is a unique identifying value for a particular instance of a product's Supplier's minimum purchase quantity. The value must stay as is in order to update the correct price instance.
See below for an example Guid:
See below for an example Guid: