I would like to gather some information from multiple pages on a website.
1. I will have a list of PRODUCT_ID in a MYSQL table on my site. The tool will go to [login to view URL] (102444 as an example for PRODUCT_ID)
2. Enter Zip Code provided as a parameter
3. Extract each Store Name (Gamestop 1234), Address, New Stock, Pre-Owned Stock (X = out of stock, checkmark = in stock), New Price, Pre-owned Price. Input results into ZIP_SKUS & INVENTORY tables (on my site).
4. If no results, return No Results to ZIP_SKUS table (on my site) for that PRODUCT_ID
5. Continue with next PRODUCT_ID until all PRODUCT_ID are complete.
The tool must take less than 5 seconds per PRODUCT_ID and will potentially go through 100's of PRODUCT_ID's. The tool will need to be able scheduled via a cron job to run as needed and will reside on my HostGator shared server.
To show that you read through to the end of the requirements, please include the phrase "I am ready for the challenge." in your proposal or it will be rejected. Thank you.