Käynnissä

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

Background

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

Robot

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.

Implementation

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:

humashahid80

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

1500 $ USD 20 päivässä
(55 arvostelua)
6.9

24 freelancers are bidding on average $1228 for this job

sanjay2004

Can be done as desired. View PM for details

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

please consider our offer.

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

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)
7.9
CrossBiz

Please view PMB

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

Hi Please check [url removed, login to view]

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

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)
6.9
websoftech

plz check PMB

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

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)
6.7
naveedurrehman

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)
6.0
ManiksSoftware

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)
5.9
ventom

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)
5.7
acer2004

please, see pm , thanks

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

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

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

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

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

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

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

Hi Please see PM. Thanks

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

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)
3.9
Hounddog

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)
3.4
hayiyi

Kindly check my account detail.

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

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)
0.0