The project is to output ERP data to an ExpressionEngine CMS MySQL website.
The objective is to create a form on the website front-end in which a user can select a product brand from a dropdown and search for the nearest stores stocking the specific product. See "stockist finder" on [url removed, login to view]
There is an existing map implementation using the Store Locator Plugin ([url removed, login to view]). Products exist as channel entries with product ids and associated data. Stores exist in a separate table with storeids and associated data.
A scheduled process should access an XML file through HTTP GET, update a database table with new storeid and productid from XML file and remove old. When a new storeid is added an email should be sent inviting the content manager to update coordinates for the new shop.
A front end form should be created in which product and id (from product channel) are selected from a dropdown, and location is typed, to produce results for shop stocking the product.