Thanks jane! I am going to add that tomorrow afternoon.
This is somewhat related and since I'm not sure how to go about it, maybe someone has already combined new fields to auto-generate a global field.
More specifically, how do I combine several of my new product detail fields (along with the mfr ID field) so that [FONT="Courier New"]zen_products_description . products_name[/FONT] is created automatically? Essentially what is happening is that the products_name field is made up of several other fields. There is no need for it to be typed. IOW, the product name is controlled and consistent across the site.
Excusing the code, let's say the combined field protocol for products_name is:
[FONT="Courier New"]$manufacturers_id . ' » ' . $details_model_name . $details_style . ' » ' $details_size . $details_orientation . ' » ' . $details_color[/FONT]
For example, when displayed, the products names would look like:
- ACME » Medallion Trampoline » 18' round » blue and black
- SILLY » Trampoline » 9'x12'
- AVD » Slide » 12' high curlicue » clear painted aluminum
So, all the data is pulled from fields in the zen_products table (plus using the text conversion of manufacturer_id) based upon a conditional (the right angle brackets are only included if the following field contains something) and needs to be written into the products_name field in the zen_products_description table.
I've tried searching but my keywords are too general to get anywhere. Anybody have an idea of what PHP code is needed to do this?
Bookmarks