Catalogue discounts and margins for individual product prices (level 3) – EQ

The Individual Prices button is the 3rd level of discount overrides. It overrides the discount and margin that is set against a whole catalogue AND any discount/margin that is set at level 2. This 3rd level allows you to specify a discount, a margin, specific cost price or specific sell price against individual prices. For an overview of discount and margin levels (including how the hierarchy works) refer to this article.

This article covers:

Prerequisite to enable own prices

How to set a specific cost and sell prices on products

How to set a discount and margin on products

Export to Excel

Import from Excel

Prerequisite to enable own prices

For these prices to work you need to go to System Config > Quotations & Pricing > Pricing and tick the box Enable own prices.

You also need to make sure that the catalogue for the product you are altering is set to Supplier Margin in the Priced column of the supplier screen otherwise your individual price will be ignored. See this article on Supplier List.

Discount hierarchy - If you use the customer supplier price option from the customer screen, that overrides this screen of individual product prices. The customer supplier discount will take precedent.

The remaining figures in this screen remain at 0. This means there is no data to over-ride your main settings, it does not mean the prices will be 0.

How to set a specific cost and sell prices on products

Open the Supplier List screen (top toolbar):
Select a supplier and click on the Catalogues button:
Select the catalogue of the product(s) you want to work with and click the Individual Product Prices button:
Locate your product by scrolling, or use the Find box at the top left:
Type your selling price in the Selling Price column and type your cost price in the Cost Price column:

Once you have entered a price, the row will change to pale yellow.
Rows that are white do not have any price override (will be priced with the catalogue price and levels 1 and 2).
Rows that are red are prices that are delivered by Direct Pricing (currently only suppliers IDS and PWS)

Repeat step 5 for as many different products are you need to price. If you are working on many products you may find it easier to export the list to Excel to work on more quickly.
Click Update to save all the prices.

Check your pricing is correct by viewing pricing information in the catalogues screen. You will see [ Individual Prices ] next to cost and selling prices to confirm the prices entered here are successful.

How to set a discount and margin on products

Open the Supplier List screen (top toolbar):
Select a supplier and click on the Catalogues button:
Select the catalogue of the product(s) you want to work with and click the Individual Product Prices button:
Locate your product by scrolling, or use the Find box at the top left:
Type your discount in the Selling Discount % column and type your margin in the Selling Margin % column:

Once you have entered a price, the row will change to pale yellow.
Rows that are white do not have any price override (will be priced with the catalogue price and levels 1 and 2).
Rows that are red are prices that are delivered by Direct Pricing (currently only suppliers IDS and PWS)

Repeat step 5 for as many different products are you need to price. If you are working on many products you may find it easier to export the list to Excel to work on more quickly.
Click Update to save all the prices.

Export to Excel

You can export the whole catalogue to an Excel spreadsheet and maintain the prices outside of EQ. This can be quicker when you want to change lots of prices because you can use an Excel formula.

Click Export to Excel and pick a location to save the spreadsheet and type a name so you can identify it.

Do not change the structure of the spreadsheet, the columns must remain in the same order with the same headings. If you use a formula you need ensure you paste the values in before importing the spreadsheet back into EQ.

When you have made changes, save the spreadsheet and close it. Ensure it is still saved in the Microsoft Excel 5.0 format so that it can be imported back in to EQ.

Import from Excel

There are 2 formats of spreadsheet that EQ can read and import:

Standard Format

Use this format when you have made amendments to the spreadsheet that was exported from this screen in EQ and you have not made any structural changes to the spreadsheet. This is perfect for importing back simple price changes.

Ensure your spreadsheet is saved and closed before you continue. Keep the spreadsheet in the Excel 5.0/95 format.

Within the Individual Prices screen click Import from Excel:
Select Standard EQ Format.
Locate your file and click Import.
Wait while the system reads the spreadsheet, which can take many minutes if it is a large catalogue.

Once imported the prices screen will show all lines with imported prices in pale yellow. Click Update to save and close.

Other Formats

Use this format to bring in a spreadsheet which may have come from another source. E.g. your supplier has sent a price list and you would like these prices to replace the prices in EQ. In this instance EQ will need to be configured so that it knows what is in each spreadsheet column and it will match up product codes from your spreadsheet into EQ.

Note: Before you begin, re-save your spreadsheet into the Microsoft Excel 5.0/95 format. This ensures that no extra formatting will cause problems.

Ensure your spreadsheet is saved and closed before you continue.

Within the Individual Prices screen click Import from Excel:
Select Other Formats
Click the ... button and browse to your spreadsheet and click OK
For each field listed on the screen use the Linked To column and select which column contains this data in your spreadsheet.

E.g. Field 1 = column A, Field 2 = column B etc.
You may not have all the fields in your spreadsheet, they can be left empty.
Once matched click the arrows (at the bottom right) to step through each of the fields and you will see your spreadsheet data appear in the correct fields. The arrows work through your spreadsheet row by row.
When you have verified the fields are correct you can click Preview to see the whole sheet, and then Import on the preview window.