How would you go about making a restaurant database site?

efeezy

efeezy

New member
Oct 5, 2007
5,250
136
0
50
Looking for any suggestions for a good way to do this from anyone who may have done something similar. I want to create a site which has local restaurants for a particular area. I'm looking to display restaurants by food type category and have menus online, operation hours, food prices, etc. I'm guessing I'll probably have around 50 or so restaurants listed. Would it be best to just compile all of the information manually and create individual pages for each listing or would there be a quicker, more efficient way to go about putting all this information together for a site. If you have any thoughts I'd like to hear them. Thanks.
 


hire VA to surf Yelp & Yellowpages for your town and do it manually.

In each post have:

Pic of restaurant
Contact info, Store Hours, etc.
Copy and paste a (good) review from yelp,yellowpages,google places, etc.

BLAM! just Loop process until all of the restaurants are listed.


I did this (myself manually) for my own city I live in(300k population), I did this 7 months ago and I'm on the 1st page of G.

edit also dont forget to create a Twitter + Facebook fan page for your website as well! A good trick is to use TweetAdder and find your local News channels official twitter and go follow all their followers with your @CityNameRestaurant twitter ;)
 
this idea is actually what I got into the IM world with a few years back. I had a fully automated system that when you punched in a location, it would buy the domain, generate unique content (from well spun start content), launch the site.

and then for each cuisine type on the site (we did it so we would only list one restaurant per cuisine IE best burger joint, best pizza joint, etc), it would query the yelp api and pull in all the restaurant details for the top restaurants for that cuisine and import them into a custom CRM that would then generate a cold call list for sales people.

Then I got fucked by the guy I partnered with to do sales and marketing. But god damn that was a sexy system.
 
I've had decent luck scraping Google Squared for specific keyterms, and letting them do the hard work for you. Probably not the most efficient way if you are a coder, but its a good way to pull a decent sized dataset for most any "New York pizza restaurant" type of queries.
 
Oh now that I'm on the right track, let me ask this. Say I've scraped a list of the restaurants I want on my site, with all the info broken down like name, address, phone number, hours, payment methods, etc, and have them as a csv or mysql file. What would I need to do in order to create a page template and have all of the information for each of those restaurant listings imported into the areas where I need the data to show. I'm not sure if I've even explained this correctly. Hopefully someone will get what I'm trying to accomplish.
 
efeezy said:
Oh now that I'm on the right track, let me ask this. Say I've scraped a list of the restaurants I want on my site, with all the info broken down like name, address, phone number, hours, payment methods, etc, and have them as a csv or mysql file. What would I need to do in order to create a page template and have all of the information for each of those restaurant listings imported into the areas where I need the data to show. I'm not sure if I've even explained this correctly. Hopefully someone will get what I'm trying to accomplish.
Click to expand...


If you are using wordpress, check out Directorypress.com, they have a theme with a built-in CSV importer that might work out for you.
 
I was recently working on a project with similar mechanics. What worked for me was creating a simple static site generator using a few lines of Python and Jinja2 templates. I'd be happy to share some example code with you if you think it will help.
 
Can't you just use a YP scraper and wfreview? Not sure what your exact needs are...
 
You must log in or register to reply here.
Top Bottom