Upload Fixed Prices

Fixed Prices Overview

Customers Fixed Price Items locks in any special price you have negotiated with your customer. When you select the tick box in the fix price column for an item, the current sell price for the Price List they have been assigned (e.g. price List 1), will appear. 

You can now edit this price and lock it in by clicking on the SAVE button at the bottom of the list. Once you save the edited price it will not be affected by any price changes you make to the customers assigned price list.

OPTION: You can also apply the fixed price to the customers’ current order, by selecting the tick box at the bottom of the A-Z product list.
Click the save button.

NOTE: If you have fixed prices for an item that you have on special the customer will be charged the specials price if the value is less than the fixed price.

click image to enlarge

OPTION: You can also apply the fixed price to the customers’ current order, by selecting the tick box at the bottom of the A-Z product list.
Click the save button.

NOTE: If you have fixed prices for an item that you have on special the customer will be charged the specials price if the value is less than the fixed price.

Import/Export Fixed Prices

If the majority of your customers have fixed pricing then manually entering these fixed prices can be a time consuming task. Uploading fixed prices using a cvs fiel can be very useful and time saving.

To Import
Navigate to Customer/ Upload Fixed Prices
Click on Download Sample
The file contains field names CustomerName, ItemName & FixedPrice.
Enter the values required & save the file to your computer.

NOTE: The customer name and the item name must be identical to the data in the system. Any differences will cause the upload to fail

click image to enlarge

To import click on the Choose File button next to Import Fixed Price List

Navigate to the the saved file

Click on the Upload button

Your fixed prices will upload in a batch

To Export

You may want to edit a customers fixed prices or apply a one particular customers prices to another.

Search by Customer Name and select the customer you require.
Click on Export
Navigate to folder where the file was downloaded to.
Edit the file and import it again,as per instructions above

NOTE: If your sales reps are resposible for their customers fixed prices you can search by Rep Name. This will give you a file with all the customers that Rep has been assigned to. This is particularly helpful as it allows you to edit more than one customer at a time. 


Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.