Discussions

Select Product by Year

I am looking for a simple way to select a part/product by the year in which it was manufactured, under a generation of products.

For instance, selecting a Schwinn bicycle model, manufactured between the years of 1971-1973. I have looked at Apache Solr and facets, but running a Solr instance looks to be a bit resource and database intensive.

I'd like to this with minimal code, if at all possible.

Thanks in advance for your answers, and for all the independent support and thought that has gone into this module.

P.S.

As an aside, if anyone needs to do bulk product editing, I suggest creating a view, and then turning off "Overlays" under the "Core Modules" section. It makes things far more responsive, and easy to organize.

commercebythegr...
Posted: Dec 14, 2011

Comments

rfay Randy Fay on December 14, 2011

I'd add a manufacture date datefield (using Date module) to the product. You could then use exposed filters on the date to provide blog-style listings (using arguments == contextual filters) in views. bicycles/manufacturedate/1994

commercebythegr... on December 15, 2011

Thanks for your response, rfay.

I'm thinking that would work for a single year, but not for a range of years. Unfortunately, some of my products have model ranges that span 12 years. Unless I am missing something, I would need a separate date field for each year to use the method suggested.

Is there a way to do a range of years, using a value such as 1953-1964...such that a product manufactured in 1967 would show up for that range?

commercebythegr... on December 15, 2011

Thanks.

If I get an answer over there, I'll make sure that I post the solution here, since this will rank first for any searches done for the subject.

commercebythegr... on December 15, 2011

rfay,

Having dug deeper into the Views module, I see what you did there :) Didn't get an answer yet on StackExchange.

It looks like it may be an issue of close, but not exact, in terms of results.

My current solution looks like a mixture of "Better Exposed Views" for the dropdown selection of years in question, + "Views" + the "Date" module. Now, all I have to do is solve the Token issue that is plaguing everyone.

I appreciate the pointer in the right direction, and your selection for "ranged" in Views was spot on.

Gracias.