Query MySQL database to scan for changes & keep online inventory updated

Avg Bid (USD)
Project Budget (USD)
$750 - $1500

Project Description:
We need to develop a way to use PHP to query a MySQL database to populate data on a Wordpress website.
For example, we have a vehicle with a stock number of 3A6691. We want to query the MySQL database to find the parts available for that stock number.

Currently, we have a database with thousands of truck parts and no way to query this database to transpose it on our webpage. We are looking for a solution to scan the inventory and look for changes on a daily basis to keep an up-to-date online inventory. We would like this data to be indexed by search engines to generate traffic to our site.

Also, our inventory software uses 3 letter prefixes for the part names (for example, TCS stands for Transfer Case) We need a way to replace these prefixes with a customer friendly version that makes sense.

Skills required:
MySQL, PHP, Software Architecture
Additional Files: excel.PNG query.PNG
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 1500
in 20 days
$ 800
in 5 days
Hire rajeshsonisl
$ 1500
in 7 days
Hire ithinksolutions
$ 1200
in 30 days
$ 1777
in 15 days
$ 750
in 30 days
$ 750
in 10 days
$ 777
in 33 days
Hire garygoog
$ 1500
in 60 days
$ 750
in 3 days