MySQL, PHP & Screen Scrape Script

There are 6 parts to this project:

I have a requirement to develop an admin application (PHP) and to access and enter data into Pre Porduction MySQL database that drives product prices on our website.

A robot to query prices on competitor websites and populate results in the Pre Prod MySQL database - Any Language that works is fine

Buinsess logic and formula transferred from excel spreadsheet to Pre Prod MySQL database

Publish utility that transfers all data from Pre Prod to live database

Test Scripts to ensure all data is good and web output is correct

Migration (If necessary) and implementation


Currently our website is in draft but we wish to go live in the next 2 weeks. We currently use an excel spreadsheet to enter all of our product information, including sales prices, competitor prices etc. There is then some simple formula that calculates the price of our products. We currently save the spreadsheet as CSV and use an upload utility to populate all of our online products.

Business Logic transfer and Admin Application

We have multiple staff constantly updating data in the spreadsheet as sales prices, costs etc change on a daily basis. Currently the spreadsheet performs all the logic which we then upload onto the website daily to display all of our prices and product information. We want all the staff to access a database directly via the new application in order to enter data into the database. Some staff need to access the selling price fields (which drive our prices) and we also need to be able to make small changes to the logic using the admin application.

Multiple levels of security is required, some staff just need access to the sales price field, some to change the logic/formula and the sales price and an admin user who can change everything and also still upload CSV file to overwrite the entire database if necessary.

All the business logic and formula currently done by the spreadsheet needs to be performed directly by the database so all this needs to be developed in MySQL.

Finally we require a utility that will publish all the relevant data to the live website database


We currently manually check approx 8 competitor sites for their prices which we enter into our pricing spreadsheet. These numbers are also used in the formula that drive our online prices. We need a robot to automatically query the websites and populate the Pre Prod database with the results.

Test Scripts & Backup

We need to have confidence that the prices shown on our website following all the changes above are always correct . We need some simple error checking scripts/routines that constantly run and alert if anything doesn’t look right! We will need the supplier (you) to figure out the necessary logic and write and implement script. We also require a simple script that we can run or schedule daily to back up the entire database (live and pre prod) and a mechanism to restore if we need to.


We currently host the site on a hosting package from a large ISP. If because of this new functionality we need to move the site to a dedicated server or a new platform, the migration of current website and implementation of new functionality is part of the requirement for this project.

Taidot: C-ohjelmointi, Java, Perl, PHP, Python

Näytä lisää: perl screen scraping mysql, screen scraping script, write scripts online, write and publish online, who is develop php, web develop php, staff requirement, spreadsheet to web application, small business server online, security logic, run php file online, product supplier database, product pricing spreadsheet, php save as, php online platform, php developed by, parts database access, online selling websites, online robot, online file server for small business, online excel works, mysql database application, mysql data access, good security websites, fine products

Tietoa työnantajasta:
( 2 arvostelua ) Leek, United Kingdom

Projektin tunnus: #448989

Myönnetty käyttäjälle:


Hi, Please have a look on the PMB for more detial.

$1500 USD 20 päivässä
(55 Arvostelua)

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Can be done as desired. View PM for details

$1500 USD 30 päivässä
(420 arvostelua)

please consider our offer.

$1500 USD 0 päivässä
(76 arvostelua)

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have experti Lisää

$1400 USD 12 päivässä
(212 arvostelua)

Please view PMB

$1250 USD 20 päivässä
(60 arvostelua)

Hi Please check [login to view URL]

$1500 USD 30 päivässä
(38 arvostelua)

Hello Charlie, this kind of proect are my speciality, please check PMB for details of my bid. Thanks. Leo.-

$750 USD 7 päivässä
(105 arvostelua)

plz check PMB

$1200 USD 30 päivässä
(9 arvostelua)

Dear Customer! We are specializing in e-commerce web site development and have great experience in shopping cart integration. We have worked with many shopping carts using OS Commerce, CRE Loaded, Drupal, Zen Cart, V Lisää

$1500 USD 21 päivässä
(52 arvostelua)

Dear Buyer, I have gone through the details and I am absolutely clear with them. Please check pm for more info. Waiting for your kind response. Many thanks, Naveed

$750 USD 7 päivässä
(55 arvostelua)

We possess extensive experience of developing numerous high-end websites and are highly organized and adept at meeting tight deadlines that are so common in this industry. Please see PMB for more details. Please tak Lisää

$1260 USD 20 päivässä
(6 arvostelua)

Hello the project you need can be done fast and professionally. Please check PMB for more details.

$1200 USD 30 päivässä
(30 arvostelua)

please, see pm , thanks

$750 USD 13 päivässä
(62 arvostelua)

Please check PM, I am here in the usa and have quite a bit of experience.

$1500 USD 14 päivässä
(8 arvostelua)

I would like to have additional details on this project before committing. Thanks. Please see PMB

$1500 USD 30 päivässä
(12 arvostelua)

Hi Charlie, please read the document I have attached to PMB, Hoppy

$1500 USD 30 päivässä
(1 arvostelu)

Hi Please see PM. Thanks

$1500 USD 31 päivässä
(2 arvostelua)

Hi my name is Eric Gibson. I am a programmer and system administrator with over 10 years of experience. I'm a native English speaker, and have extensive experience in the skills necessary to complete your project. I ca Lisää

$750 USD 14 päivässä
(7 arvostelua)

Hi, i have worked on something similar in the past to upload "bulk" data into the database with verification and backup process. Please Refer to PM for further information.

$1000 USD 20 päivässä
(1 arvostelu)

Kindly check my account detail.

$800 USD 20 päivässä
(0 arvostelua)

Dear Sir or Madam, I understand what you need. Please read PM for my proposal. Best regards, Krum Cheshmedjiev

$1400 USD 25 päivässä
(0 arvostelua)