I'm looking to add to a directory site (software powered by [login to view URL]) a list of all available stores selling the products related to my niche for the US and UK, should be organized by state and provinces/cities.
Finding and fetching the data for all the stores in the us and UK can be scraped from any of the yellow pages directory sites available online. I can also point you to one site that already complied such a list. You will need to collect all the basic info for each store/business as name address, tel, fax and website when available.
basically once once you have collected all the data, it should be easy to add to the mysql db with a sql command.
Check out the script at [login to view URL] there's a free download for a limited version, but that should give you a pretty good idea how the software works.
I will need you to help add the googlemap to each of the location as was done in the following example site (using the same software)[login to view URL]