How To Add New Product Fields?

[Kevin205]

When I update the field colour in admin, it does not update the zen_products_extra_stuff table.


I have used the following SQL to math records.

INSERT products_extra_stuff (products_id, products_colour) SELECT products_id, 'your default value here' FROM products

[Kevin205]

Bump...

Does anyone why the field will not get updated in the SQL table?

[vacuumwarlock]

What I am wondering due to the fact I don't know php or Zen Cart that well, YET, but in the examples everywhere no one ever says exactly where the sort for "colour" is even coming from. I can't just make something up if it isn't an attribute or something. So my question, is do these extra fields draw from something that was created in the products such as attributes?

[Pompidompie]

This is the answer to my question. I would like to add, deliverytime, shippingcosts and used material to de details. So therefor i want to try whats written in this thread. However, i bumped into a problem right away
I don't have much experience and being Dutch I sometime do not understand the words.
So my problem is this:


Create a new table to hold your additional fields and give it a name i.e. products_extra_stuff and add the products_id field (so we can relate our new table to the existing products table) and whatever fields you wish to add i.e. products_colour

Do I have to go to the database and then add something? I can see what, but i don't see where. Can someone please help me with this?

[dharrison]

Create a new table to hold your additional fields and give it a name i.e. products_extra_stuff and add the products_id field (so we can relate our new table to the existing products table) and whatever fields you wish to add i.e. products_colour

Ok. I have a newbie question: How can I add the products_id field to her new table?

I win newbie prize award

[dharrison]

Hi

I have just new product fields to my test template and it looks ok. Using http://sitstandforbusiness.com/paral...ent-p-113.html as an example.

I have an issue with the product fields. For example, I can add the following to technical info



But when I save the changes and go back in I get



And this happens everytime I edit the product. It makes a mess.

I set up the product fields as text. I really can't think of what else I can do?

Please help.

[davewest]

I set up the product fields as text. I really can't think of what else I can do?

Please help.

Don't you just love HTML editors...

Click the source button and the HTML tags well hide.. In What-You-See-Is-What-You-Get mode the tags are not displayed, however they are created. In source mode you see all the HTML tags.

[davewest]

I'm slow on editing...
Info: to remove the editor only for this field, change the class from editorHook to noEditor.. This well make the field text only and no HTML editor well be used.

[dharrison]

Hi David

The tag rendering exists on both text and visual editor.

If you look at the link I sent you can see what it looks like

[davewest]

Hi David

The tag rendering exists on both text and visual editor.

If you look at the link I sent you can see what it looks like

Yes, HTML editors add tags so you get what you see... The link shows the added tags in product description, then sanitized it on all other tabs. Could be an issues with the template display or how the text fields was saved.. If the new text fields are saving the same as the description field in update_product.php then it may be how the template is reading it into the tabs...

To give me a better idea, can you post just the input lines for the text field and the DB line for the save..
like.. collect_info.php

 <?php echo zen_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '100%', '30', htmlspecialchars((isset($products_description[$languages[$i]['id']])) ? stripslashes($products_description[$languages[$i]['id']]) : zen_get_products_description($pInfo->products_id, $languages[$i]['id']), ENT_COMPAT, CHARSET, TRUE), 'class="editorHook form-control"'); ?>

and update_product.php

'products_description' => zen_db_prepare_input($_POST['products_description'][$language_id]),

I've not read the entire post, but use many added product fields..