|5.2.2 Export << 5.2.3 >> 5.3 Settings|
5.2.3 Contract PricingContract 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.
|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 ).
- 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
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
- 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)