klopotnik Posted February 1, 2015 Share Posted February 1, 2015 Hi, i've read many of threads regarding this topic.. but no help.. therefore i'd like to start something i will create (with your help) and post as free module (if it will work) task: - have database of cars and their possible combination of wheels - have producsts with parameters - have filter, which will filter producs according this fittment combinations quite good example based on prestashop http://www.gand.nu/index.php?route=product/search&action=result&chassisID=15230&ktype=30390&size=18 advanced propertis: - many eshops selling wheels like to sell tyres as well, so we need to have similar database for more then one category (so there is need for fittment per category, e.g. wheels, tyres, other parts) - import car fittments - manage this in BO how to do that? i don't expect, that somebody will do it for me, or paste code doing that functionality, but I need some clues like: - downlaod this or this free module, edit it in this way - create new table in DB (best practice are..) - ... (this will be my first module, but I'd like to do it) anybody going to help? Link to comment Share on other sites More sharing options...
bellini13 Posted February 1, 2015 Share Posted February 1, 2015 There are many uses for a module like this, and a module currently exists that helps with the filtering aspect, and uses Prestashop Categories http://mypresta.eu/modules/front-office-features/step-by-step-categories.html some examples (and I am sure there are more) 1) printer ink 2) car and tires/wheels 3) guns and gun holsters Since the above are constantly changing as new products are released, creating a module that contains a database would be difficult to manage and constantly maintain. Some thoughts 1) Why not use the existing module, and then just manage your own database by creating a category structure for your products 2) If you do choose to create a new module, I would make it generic enough so that it would work for all of the above examples. Perhaps build it so that the merchant can install the module, and then they can import a data file based on what they need to filter. 3) If you are going to attempt to create a database, what are your thoughts for maintaining that data? How would merchants obtain updates to the data? Link to comment Share on other sites More sharing options...
klopotnik Posted February 1, 2015 Author Share Posted February 1, 2015 i know the module you mentioned, but it doesnt solve my problem,.. i cannot use categories, because if I add e.g. new car as a category, i have to assign all existing wheels/tyres to the category. and if I add new product, I have to assign it to all suitable car category my thoughts: - I use "features" and some kind of "search" within features.. - there would be new table (or more tables if needed) for cars.. every car has fittmentdata (e.g. for audi a4 where will be all possible combinations like "size 18 width 8 PDC 5x112") - when you enable search, it will provide subset of product matching all of these combinations - on the left side, there will be standard catalog filter, where you can filter it more (e.g. you will select color, specific size or specific width) - when new product is added, you just specify its parameters - when new car is added, you will specify all suitable combinations of parameters, which will be used within filter am I naive? Link to comment Share on other sites More sharing options...
bellini13 Posted February 2, 2015 Share Posted February 2, 2015 i cannot use categories, because if I add e.g. new car as a category, i have to assign all existing wheels/tyres to the category. and if I add new product, I have to assign it to all suitable car category I do not see the problem with that. You would have to create a module with the same associations anyway, and then maintain it going forward. Link to comment Share on other sites More sharing options...
klopotnik Posted February 2, 2015 Author Share Posted February 2, 2015 if car is category, there are two actions to be made 1) add new car (as category) and assign to all suitable wheels / tyres 2) add new product, fill features and assing it to all existing suitable cars in case the filter i'd like to have, it really simple (from the maintain point of view) - add new car with possibilities into some table - add new product with features,.. no more associations will be needed, because search/filter module would do it for me but maybe you're right, that overal it will take less time to maintain the categories as to provide such module Link to comment Share on other sites More sharing options...
eurooil Posted February 11, 2015 Share Posted February 11, 2015 I have almost the same problem, I'm working on an autoparts website. If I do it the way you tell (it's the way i'm trying to bye now) I'll have a problem in the future. By now I just want to sell oil, filters, and oil change kit so my categories are the Car Make, Series, Chassis, Engine, and then the consumer can filter the part type he want on the left side to choose what he want. (as you can see on my website: eurooil.ca) exemple: Category -BMW -X series -E83 X3 -E83 X3 3.0i Feature (part type) -Oil Filter -Engine Oil -Oil Change Kit With 3, 10, 15 kinds of part it work well but when my website will grow, I'll need to devide it by sections. Exemple: Feature (part type) -Engine: -Oil Filter -Air Filter -Engine Oil -Suspension: -Shocks -Springs -Anti-sway bar those features need to become categories, and prestashop don't let you navigate 2 categories from 2 different roots at the same time and it's almost impossible to create those subcategories for each make, model, year, etc, of car that exist. The only module I found to be the closest of what I need is Filter Product Pro from presteamshop but again, I'm not sure that it will be exactly the good thing. I want the consumer to be able to choose his car and then navigate the parts without having to enter his car make and model again and again. I want it to work the same way as this site do : ecstuning.com If you have a solution, a module or a way to do this please let me know! Link to comment Share on other sites More sharing options...
klopotnik Posted February 11, 2015 Author Share Posted February 11, 2015 eurooil, i was thinking the same way like you. tyres / wheels / car parts <---> car models between these angels of view, there need to be some fitting table i'm not sure that mentioned module will solve this problem if I just think of imports / editing / etc.. i don't know but if you try, let me know.. currently i had to change the focus to something else and wait for somebody more skilled that I am to help Link to comment Share on other sites More sharing options...
eurooil Posted February 11, 2015 Share Posted February 11, 2015 I found an other module from ukoo.fr called "gestion de compatibilites produits". Again, I'm not undred percent sure that it's the perfect one. Link to comment Share on other sites More sharing options...
eurooil Posted February 11, 2015 Share Posted February 11, 2015 The "filter product pro" is so close! But after some test, I see that it do not "remember" the car make/year/model when you choose a category so you choose the car and then you see 300 parts fitting this car but you can't go down by categories... Link to comment Share on other sites More sharing options...
Nielsds Posted August 2, 2015 Share Posted August 2, 2015 http://www.presteamshop.com/en/modules-prestashop/filter-products-pro.html Its states that it remembers the filter now.. so that would solve it ? Link to comment Share on other sites More sharing options...
francesco74 Posted August 3, 2015 Share Posted August 3, 2015 ciao ragazzi, avrei bisogno anche io di un modulo come state descrivendo. A che punto siete con la ricerca? come avete risolto Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now