5.2 Tools


5.2.2 Export  <<  5.2.3  >>  5.3 Settings 

5.2.3 Contract Pricing

Contract pricing expands the Workspace product pricing model and makes it possible to eg. set different product prices for each customer. You can create pricing contracts that override the default product pricing. A single pricing contract has an itemcode, a pricerule and possibly a customer number, contract pricing group or customer group name (For customer group based pricing you should primarily use the pricegroups in products instead of contract pricing because pricegroups are more efficient). To enable contract pricing you upload your pricing contracts to Workspace and then activate contract pricing from Product's general settings. To ennable the use of contract pricing groups you have to add an question "Contract pricing group" to Customer questions.The pricing contract group is not the price group.



Contract Pricing
Picture 5.22 : Contract Pricing




Contract pricing is used by uploading and downloading pricing contracts to and from Workspace. Choose "Download all pricing contracts' to get yourself an empty Contract Pricing file. The file is in CSV-format. The first line is the header line which shows the used columns. You can modify a CSV file with a spreadsheet program or a text editor. After you have created your pricing contracts to the file, you upload it to Workspace by using the file upload on the "Contract Pricing"-tab. You can remove all pricing contracts from Workspace by using the "Remove all contracts"-button. The CSV-format used in contract pricing is defined with these rules: column separator character is a comma (,), records are separated by a new line character (\n, \r\n, or \r). If some column's value contains commas, multiple lines or quote characters ("), then the column's value should be surrounded with quotes. If a column's value contains quote characters, they are doubled.

Columns in the contract pricing file are (in order): ITEMCODE,CUSTOMERGROUPID,PRICERULEGROUP,CUSTOMERID,PRICERULE

One pricing contract needs to have at least:


  • ITEMCODE = Product's itemcode which this contract involves.

  • PRICERULE = New price for the product. eg. percentual change to the original price ( -15%) or a new fixed price ( 24 ) or a fixed change to the original price ( -10 ).

Also the pricing contract may have a restriction marking this contract to be used only for a customer group, contract pricing group or a single customer. A contract can contain one of them.


  • CUSTOMERGROUPID = Customer group name, if you want to enable this contract just for customer's who's primary customer group is this group.

  • PRICERULEGROUP = Contract pricing group id if you want to connect customers with certain contract pricing group.

  • CUSTOMERID = Customer number, if you want to enable this contract just for this customer.



Example
ITEMCODE,CUSTOMERGROUPID,PRICERULEGROUP,CUSTOMERID,PRICERULE
3000070621,,,,234
5850391363,,,,+14
3503913632,,,,+20%
2352555552,resellers,,,-10%
2352555552,,15,,-15%
2352555552,,,234,-15%
Using pricing contracts


  • If you want to override the product price for all customers, add only the itemcode and the pricing rule. (see example rows 2-4)

  • If you want to change product's price for a single customer group, add the itemcode,customer group's name and the pricing rule. (see example row 5)

  • If you want to change product's price for contract pricing group, add the itemcode, price rule group's name and the pricing rule. (see example row 6) Then you can connect the pricingrule group with customer via customer question.

  • If you want to change product's price for a single customer. add the itemcode,customer number and the pricing rule. (see example row 7)

If you are using pricing contracts, remember to activate Contract pricing from general product settings.