CREATE INTERACTIVE PRICE LIST WEBSITE
A supplier's dedicate website who send his pricelist on Internet
BUYER'S side - with password, clic for actualisation
consult his pricelist with his company heading +(automatic copy in client's income OFFERS folder):
write or add his orders online, see the calculations, add eventually comments and send back his filled order lines with his heading, per Email (+copy in client's income ORDERS folder)
We encourage each client to register also his orders on his own computer..
The pricelist disappear if there is a new offer online. A new pricelist become then visible and the buyer can renew his orders. The tempo of pricelist pushing can be monthly, weekly, daily or immediate (minutes), (Fresh good need mostly a daily offer)
Supplier's side (+ password)
He prepare a global pricelist with several price quotation levels as for example : *1,05 -*1,10 –*1,15 and so more (maximum 10 levels) -
He put each client in a price level field with as result: each client see his particular price quotation,
He write his pricelist with products description and sizes (selected at multichoice prefilled products listing and prefilled sizes listing). He include the marginal prices and obtain all salesprices per pricelevel calculation.
He dress the table for each combination of price level column and the thereby affected clients.
Only the rows with prices are published.
Every pricelist is copied in his SENDOFFER folder
All Email orders forms are also keeping in his CLIENTSORDERS folder,
All folders are backup stored in monthly or weekly archives.
Used software is : MySQL, PhP, html, OOo Calc
The IP address and datetime are always visible on all in and out messages,
A model of spreedsheet is in attach and visible on
trialswebsite dot com/pricelisting/[url removed, login to view]
- - - - - - - - - - -
Other development can be add later on. We think on a daily balance between marginal prices and sales prices.. Include of offered quantities with deduction of sales so that an offer disappear.
Calculation of monthly bonus for salesman (or woman)
Please offer separate moreprice for each addition,
on this moment we want the cheapest way in order to do the first trials.
Maybe other proposition?, new developments ?