Collecting Requests
Prices
Contacts
Prices
Terms of Cooperation
Contacts
Main
News
System description
Collecting Requests
For partners
Prices
Download
FAQ
Contacts
Salesman on Google Play

How to set an item individual price for a specific customer?

General Questions
How can I buy PalmOrder:Pre-Selling?
How many licenses do we need to buy?
How much does implementation cost?
How much does support cost?
What if I don't have a static IP-address?
PalmOrder for Android
How to install the license?
xml2eldb errors, reasons and correction
What is the time format?
How to change the administrator password?
How to select Holo Light or Holo Dark theme?
How to highlight a reference element with some other color?
How to show an item image in Details?
How to deny Request creation for customer that has overdue debt
How to prevent an unauthorized access to your server by resigned
How to set an item individual price for a specific customer?
How to take a photo and send it to server?
How to set up GPS-tracking?
How to change preferences remotely?
How to create a route?
How to set an obligatory photograph?
How can I know the GPS-coordinates of a created document?
How to print documents?
How can I use Dropbox service for data exchange
How to create and download a custom table

You can set an item individual price for a specific customer (customers). To do this, you need to create the file customer_product_data.xml with the fields customer_code, product_code, price. Here is the example of the file customer_product_data.xml for a customer with code 4 and an item with code 12:

<?xml version="1.0" encoding="windows-1251"?>
<table name="customer_product_data">
  <schema>
    <field name="customer_code" type="TEXT KEY" />
    <field name="product_code" type="TEXT KEY" />
    <field name="price" type="REAL" />
  </schema>
  <data>
    <record>
      <f>4</f>
      <f>12</f>
      <f>17.50</f>
    </record>
  </data>
</table>

The table for selecting items in the «Request» document will look like this:

The individual price now has the highest priority over any other category of prices established for this customer. You can change it by selecting another category of prices in a document «Details», or manually tapping «Price» in the Quantity dialog box. To return an individual price, you can either delete the record from a document, or set its quantity as 0, and then enter a desired quantity again.

The same way you can add any field containing any item individual parameter for any customer. For example, if you want the information on the quantity of goods from a customer's previous «Request», your file customer_product_data.xml should look like this:

<?xml version="1.0" encoding="windows-1251"?>
<table name="customer_product_data">
<schema>
	<field name="customer_code" type="TEXT KEY" />
	<field name="product_code" type="TEXT KEY" />
	<field name="price" type="REAL" />
	<field name="preorder_count" type="REAL" />
</schema>
<data>
<record>
	<f>4</f>
	<f>12</f>
	<f>17.50</f>
	<f>6</f>
</record>
</data>
</table>

This is the result on your screen.

office@palmorder.com
palmorder2
sites creation and promotion
sites creation
promotion
© 2017 PalmOrder