I am looking to have a page on my website for people to get a quote for pamphlet/brochure distribution that may use multiple distribution vendors.
I would need the ability to upload spreadsheets related to different vendors for different areas , along with their costs.
When a customer came into the site , they can have the ability to choose or exclude a particular vendor , or ask for the best rate.
The customer would then choose the suburbs for distribution , the programme would then choose the vendor/price , taking into account preferences , or exclusions
A report would also need to be generated for a job showing distribution areas (suburbs chosen) , costs and the appropriate vendor for each area as well as the same information by vendor eg each vendor with a list of areas that they will be used for
The attached spraedsheet may help in seeing the basic concept