Hi Team
We have integrated our Jiwa to Prestashop for online store activity. Prestashop has the capability to group products such that;
ACME White Porcelain Plate 22cm and ACME White Porcelain Plate 14cm can be grouped when shopping so that you have ACME Porcelain Plate with two options for 22cm and 14cm - even though the product ref for these two products will be different. We have been messing around with using three fields, namely BRAND, RANGE and a Custom Text field for grouping - but we think we really need a Parent/Grouping fields to bring together ranges.
Our dream is a lookup, that incorporates ID, BRAND, RANGE and CustomText where we can add this lookup to products with a dropdown in the form of pipe delimited BRAND | RANGE | CUSTOMTEXT, but that sets the group id on the product.
This will enable JIWA users, to create product groups and assign them to products. The ID linkage means string changes in CustomText, Brand or Range will not impact on the grouping. BRAND and RANGE are already lookups in our Jiwa - so these could be Lookups inside our new grouping Lookup.
Are you able to assist in regards to (a) is this possible, or (b) have you encountered this notion before and is there a better/another way?
Thanks in anticipation!