We need to modify and add often texts and links in concordance to our other websites.
It's too difficult with actual dynamic creation of CodeIgniter and Joomla.
An Email confirmation message of a demonstration spreadsheet trial is in attach.
Other spreadsheet calculation models are available.
Online multiplication is : (reference, description, size, price) by (empty cell for quantity insert by visitor) = total (+ total of totals on bottom of table), example : product cost = 10$ x 20 pieces = 200.
If this is too complicated, we may consider : ref, description, size + price (read-only for the visitor) and an empty cell where-in the visitor fill in the quantity he want.
He send it thus back without calculations. (multiplication version is more attractive but can follow later)
If possible a short space at the bottom, for little comment insertions from supplier and from customer.
This case (approx. 760 pixel x 60 pixel) is thus with free read, delete and write option,
Ref, description, sizes are databased.
Each pricelist offer of the day is stored in the database, without prices.
Supplier can use a previous list, add or delete products descriptions lines, enter prices and republish.
No application form for supplier, neither customer, but supplier has to fill his customers details with Email address in a separate table.
When the customer has fill and confirm his orderform, this order go to the supplier's ORDERSdatabase, + 1 or more copies per Email to the supplier, and 1 Email copy as a confirmation to the customer. On request the supplier admin can ask for : the orders per day, per name, per reference.
In case of regular use, the Emails of accepted customers are in the supplier's database.
A demonstration page is indispensable. It's a fixed demo sheet + space where-in the visitor add his unknow Email address(..es) for his trial copy. This need a little development in order to signalize the Email for trialsendings.
Maybe a separate database table for insert of DemoMailsTO: abc, ..xyz , .... aso ?
If it's too difficult, we add in the comments case at the bottom of the pricelist, the mention: ''send us a mail if you want become a full demonstration as a fictitius customer or supplier.
Table width = 760 pixel, maximum width for products descriptions.
Little space for supplier's logo + 3 lines text for co-ordinates of supplier and customer.
Also 1 line for the Welcome IP identification and the Datehour = together = 4 lines.
This heading space (approx. 1 inch high) is immediatly followed by the pricelist table.
(Spartan fashion and a minimum of blank space)
This programme is destinated as an independent folder, subdomain or website. The admin must be easy.
An automatic backup is to foreseen for daily, weekly or monthly security,
Other marketing developments are prepared.