Searching by Zipcode

[jh79]

Hello, I want some help with a zencart site or mod where people can join and then you can search them by zipcode

something similiar to this
http://www.sittercity.com/

Is there anything out there like this??? I have searched and can't find anything!

Any help would be greatly appreciated! thanks in advance!!!

[jh79]

Ok looks like by the lack of replies Zencart can't do this. I'll check out some other engines...

[Ajeh]

Zen Cart is written in php so you can do anything you like ...

Are you trying to do this in the Catalog for Customers?

Or, are you trying to do this in the Admin as the store own to find Customers in various Zip Codes?

[IronTank]

*bump*

It's been a few weeks. Hi Ajeh. I'd like this same question answered. I've been asking in a few different threads.

I'd like to add a zipcode in a category/subcategory and have customers search and then display resulted category.

For example:

State > Area > Store Name > Menu of Store > products
State > Area > Store 2 > menu 2
State > Area > Store 3 > menu 3
State > Area 2 > store 1 > menu 1

If I added 33024 to "Store 2" and "Store 3"'s category

I'd like if a customer searched 33024 in the frontend, and have results display "Store 2" and "Store3" without directly going into the menu subcat allowing the customer to choose the store nearby that they might want to buy from.

Thanks, hope you reply soon!!

[Kim]

I've been asking in a few different threads.

Please do not continue posting the same question in multiple threads. It is considered spamming. Many of your duplicate posts have been deleted.

[IronTank]

Sorry, I didn't know that was spamming.

I also did not start those threads I posted in.

I just added my question started by others in hopes of getting it bumped and answered by different people which might lead to a faster solution.

I thought it would be spamming if I started threads and asked.

Anyway, *bump* I'd really like this answered.

Thanks,
ITF

[Ajeh]

You either need to decide if you want a search on the Categories Name or if you want a way to enter the Zip Codes on a Product that can be searched ...

While they could be added to:
Product Name
Product Description
Meta Tags

You really might be better off with some custom work does to add a new table of products_id and postal_code that can then be searched and locate the products ...

If you are not a coder, you may want to post in the Commercial Help Wanted as this is not a 30 second job ...

[IronTank]

Hi, Ajeh thanks for a quick reply.

I'd like to search zip code in a category, and have the category displayed. ZC currently supports search function for products.

Like this:

Florida > SteakHouse > Dinner > Roasted Ribs
Florida > SteakHouse > Lunch > BBQ Ribs

If I add 33024 to the products, BBQ Ribs, and search 33024, that product will display.
But, I'd like to add a zipcode to "SteakHouse" and if a visitor searches 33024 the category "SteakHouse" and other restaurants with same zip code will appear allowing a visitor to choose.

I was wondering if there's an addon that does a similar job or if an added query in the search file of ZC could do the job. I was looking at the XSell addon, would that achieve the goal?

If this really can't be done easily...
I'm not an expert programmer - I can't make advance scripts. But, I understand mysql queries and php functions and can definitely add/modify current code (which probably most won't recommend). If you don't mind explaining a bit more I might attempt to code it.
I'll post in the Commercial Help wanted after I've tried and become hopelessly lost.

[IronTank]

Okay, big apology. Maybe I'm over explaining a bit and asking the wrong questions. Basically I'd like to search categories and display them as results.

Would this require hard coding the ZC database or "easily" achieved?
Is there already an addon for this or one that's unofficially available?

[Ajeh]

How many Zip codes does a Product have, one or many?

Do you have a field for this? Or is this something that still needs to be added?

Pretend I know nothing about your site ...