multiple pulldown label names in editor?
By (Deleted User) - September 21, 2012
The trouble occurs when there is a family of products for example called redbear. there may be a redbear bed, redbear chair etc. Currently when populating the products table they have to add a product name(redbear) and choose a category (bed)
Using a pulldown list (multi) The related products currently show just the Product Name.
Is it possible to have more than one value for the label?.
Option Label : Product Name - Product Category
Option Value : Product Name
so the client would see on the dropdown box - redbear - bed
Hope someone can help
Re: [greg] multiple pulldown label names in editor?
By (Deleted User) - September 24, 2012
Both product name and category shows in drop down.
Is there away to change the value from num to product name? I am trying to make SEO URL friendly titles.
I did try changing to SELECT product_name?
Re: [g_williams] multiple pulldown label names in editor?
I've done a quick test and you should be able to use the following to make the stored value the product_name:
SELECT product_name, CONCAT(product_category, " - ", product_name)
FROM `<?php echo $TABLE_PREFIX ?>product_table`
Let me know if this doesn't work for you.
PHP Programmer - interactivetools.com