VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: EvanGR on December 06, 2018, 15:04:06 PM

Title: Product multiple custom fields (best practices)
Post by: EvanGR on December 06, 2018, 15:04:06 PM
Hello,

We are preparing an overhaul of our products catalog, and I want your suggestion for our product's custom fields.

We run a car accessories shop, and we want to designate the compatible car manufacturers for each of our products.


A good way to achieve this would be to have a preset list of car manufacturers, and then for each product, select one or more of the manufacturers which are compatible. (like you would add tags from a list)

It is preferred to not have to type the manufacturers again for every product (to avoid misspellings).

We also want to be able to use a 3rd party Filtering solution (e.g. Custom Filters Pro), to filter products suitable per car manufacturer.

Important note: the example given here is NOT about the manufacturer of the product (of which there is one), but for the car manufacturers the product is compatible with (of which there can be many)

Any suggestion on a good way to implement this, is very welcome!

Thanks

EDIT#1:
Another possible way to do this, would be to use product Categories instead of custom fields. So we can create a Category for every car manufacturer, and even add nested sub-categories for specific car models.
Not sure of the drawbacks of this method though...

Title: Re: Product multiple custom fields (best practices)
Post by: GJC Web Design on December 06, 2018, 15:40:29 PM
we do it like this

https://www.4wdpartshop.com.au

Title: Re: Product multiple custom fields (best practices)
Post by: Studio 42 on December 07, 2018, 02:57:38 AM
You can set a list of values for customfields using the As Adminlist option.
You can see then a list in product edit customfield
Title: Re: Product multiple custom fields (best practices)
Post by: diri on December 07, 2018, 05:52:29 AM
Working with manufacturers and categories is fine as long as manufacturer offers products for one category only.

In case a manufacturer offers products in multiple product categories (i.e. cars and fan clothing) you are in trouble doing it this way.

Title: Re: Product multiple custom fields (best practices)
Post by: EvanGR on December 07, 2018, 10:11:21 AM
Thank you all...

@GJC
This was one of the ideas we had. Place Car Manufacturers in categories, with models being in sub-categories.
The products belong to a different main (canonical) categories, based on their type and use. But since a product can be assigned to secondary categories, this should work.

Questions on this approach...

1) Are there any pre-made/available lists on Car Manufacturers and their models we can use and import? So that we don't have to waste the time to do the same work again ourselves.

2) If we do the work and create the car manufacturers/car models categories ourselves, could we later export this data in some other form to be able to use it elsewhere?

Also, if we use a product AJAX Filtering module, we would want to be able to filter all products by Car Manufacturer. Not sure if this would be an option, if we implemented it via Categories (as opposed to custom fields).

Title: Re: Product multiple custom fields (best practices)
Post by: balai on December 07, 2018, 11:00:52 AM
Since you intent to use Custom Filters and i suppose that you also want dependencies and pre-created values, have you see that?
https://breakdesigns.net/extensions/joomla/dependent-custom-fields-for-all
Title: Re: Product multiple custom fields (best practices)
Post by: EvanGR on December 07, 2018, 12:06:45 PM
Quote from: balai on December 07, 2018, 11:00:52 AM
Since you intent to use Custom Filters and i suppose that you also want dependencies and pre-created values, have you see that?
https://breakdesigns.net/extensions/joomla/dependent-custom-fields-for-all

Yes, we have already purchased a subscription.

We wanted to look for a native Virtuemart solution first. To avoid locking ourselves too deep into custom 3rd party extensions (this specific task may require a lot of time investment if we decide to include Car models data, so we need to think it through very well).

Title: Re: Product multiple custom fields (best practices)
Post by: GJC Web Design on December 07, 2018, 12:51:29 PM
Quote1) Are there any pre-made/available lists on Car Manufacturers and their models we can use and import? So that we don't have to waste the time to do the same work again ourselves.
sorry -- don't know

QuoteIf we do the work and create the car manufacturers/car models categories ourselves, could we later export this data in some other form to be able to use it elsewhere?
simple enough either by DB directly, a small query script, Studio 42's admin comp or other solutions

QuoteAlso, if we use a product AJAX Filtering module, we would want to be able to filter all products by Car Manufacturer. Not sure if this would be an option, if we implemented it via Categories (as opposed to custom fields).

don't know the module -- have u looked at the filtering and search capabilities of the site I mentioned
these  (my modules) are also used on other sites like https://www.quality-tuning.eu/gb/
Title: Re: Product multiple custom fields (best practices)
Post by: christopherr on March 14, 2019, 21:46:55 PM
Quote from: GJC Web Design on December 06, 2018, 15:40:29 PM
we do it like this

https://www.4wdpartshop.com.au

Hi GJC Web Design, is that site built with Joomla and VirtueMart? I am looking into using Joomla but a major requirement is to be able to do a search the same way you have "Select Your Vehicle" where you select from multiple drop downs and then search.

Thank you.