Developing the Location Field in Products

This idea is above my pay grade.

Having said that ... it would be really awesome if someone developed the location field (as an add on module), so that it appeared below the Brands Box on the left column, and a shopper could then drill down to an array of products by location.

socal

Correct me if I'm wrong. A products has a Manufacturer. I have created a field in the manufacturer table called manufacturer_country where I'm adding the manufacturer's location. This field I can use it later for a product's location.

That might work.

I was seeing the location field in the product list. And Qhoria said it wasnt really utilized in the code.

I figured if you could have a drop down menu box on the left ... which was for location ... then
while in a category or at the front of the cart you could pick your category , etc, then select the location menu and drill down to only products located in that location.

I am using the manufacturer also, a little differently. But I hadn't tweaked the code at all.

This would in addition to the manufacturer module. so you could do both.

do you have a link I could check on your site I could check out.

socal2 wrote:That might work.

I was seeing the location field in the product list. And Qhoria said it wasnt really utilized in the code.

I figured if you could have a drop down menu box on the left ... which was for location ... then
while in a category or at the front of the cart you could pick your category , etc, then select the location menu and drill down to only products located in that location.

I am using the manufacturer also, a little differently. But I hadn't tweaked the code at all.

This would in addition to the manufacturer module. so you could do both.

do you have a link I could check on your site I could check out.

I'm adding the manufacturer's country from the admin panel (using the Country drop down list). I made a image file, but don't know how to share the pic in here. But my goal was print the Manufacturer's country in the Order Invoice letter, so that a customer can see which product is coming from which country. Here is a sample of my email output:

Products

Quantity [/b] Product Country Shop Price
1 T-shirt Australia DJ AU$9.50
1 I-Phone UK Tasco AU$499.00

I would think that the "Location" field has more to do with the physical location of the product. For example, I built a site for a business (Foamland -- built on OpenCart 0.7.9) that has two physical stores, one in Hobart and one in Launceston, but only one website. The products they sell could be located at either the Hobart store or the Launceston store.

Not all your customer(s) may wish to buy online, some may prefer to buy "over the counter". Having some idea of the "location" of the product, or your physical store (if you have one) could be handy.

Yes Fido, this is what I'm referring to.

Maybe a separate "location" table in the db. Then, when adding or editing a product, the location could then be selected from a drop-down list (same as manufacturer). A column module similar to the "Brands" could be created to handle the display of products by location.

That's do-able.

That's exactly what I had in mind.