Build a Courier Quote Analysis and Pricing Tool

We’re an established UK courier company looking for an experienced developer to build a quotation analysis and pricing tool within our existing website admin.

We subcontract deliveries through a Transport Exchange platform, where suppliers submit quotations for our advertised jobs. We want to analyse these quotations, establish reliable subcontractor costs and use the results to prepare customer and internal price lists.

What we need

- Data extraction: Write and supply your own reusable script to extract our quotation history through our authorised Transport Exchange account. It must support selected date ranges, capture all available bids, avoid duplicates and resume interrupted runs.

- Web database: Store the extracted data in a searchable database on our server, with clear screens for reviewing jobs, quotations, exclusions and calculation results.

- Cleaning and analysis: Apply our documented filtering and calculation rules. Keep ordinary mainland road journeys separate from specialist services, out-of-hours work and crossing routes.

- User approval and pricing: Allow us to review and approve the cleaned data, then enter a percentage markup to generate selling prices.

- Two editable price lists: Populate a Customer Price List and an Internal Price List. Both must be editable in the browser, with saved versions and protection against accidentally overwriting manual changes.

- PDF downloads: Let us convert either saved price list to PDF and download it to our PC.

Technical requirements

The tool must run on our dedicated Linux server and integrate with our existing custom PHP admin, using its authenticated login. Extraction and other tasks must continue safely in the background without disrupting the live website.

This is a web database application, not an Excel-based solution. We require complete source code, testing, documentation and a practical handover.

Project specification

A detailed developer brief is attached and sets out the implementation stages, calculation rules, price-list layouts and acceptance checks. Please review it before providing your final quotation.

Our existing price lists and confidential prices will not be supplied. The brief describes the required layouts, and development demonstrations should use blank or fictional values.

Please include in your proposal

- Relevant experience with data extraction, PHP admin integration, database applications and editable PDF outputs.

- Your proposed approach to extracting the Transport Exchange data, including any access requirements or limitations.

- Your estimated development time and fixed price, with a breakdown by stage.

- Any third-party charges, ongoing costs, assumptions or exclusions.

- Your testing, handover and post-launch support arrangements.

We would like a video discussion before work begins. Please explain your approach and identify anything that needs resolving before you can commit to a fixed price.

The advertised budget is a placeholder. We welcome realistic quotations for the complete scope.

Thank you.