How To Add New Product Fields?

[webego]

Sorry I have not been back to post for a while (super busy) and thanks for all the comments. I hope some of the older replies have been resolved, if not let me know and I will see what I can do.

With regard to deleting records in the TABLE_PRODUCTS_EXTRA_STUFF table, I can't believe I forgot to include this functionality in the first place.

I have not tested the following code so if someone cares to try this out and let me know if it works that would be great.

1. Open admin/includes/functions/general.php and search for 'function zen_remove_product' (line 1203 for me)
   
   
2. At the end of that function and just after the following code:
   
   $db->Execute("delete from " .
   TABLE_PRODUCTS_DISCOUNT_QUANTITY . "
   where products_id = '" . (int)$product_id . "'");
   
   (line 1276 for me)
   
   Add the following on a new line:
   
   $db->Execute("delete from " .
   TABLE_PRODUCTS_EXTRA_STUFF . "
   where products_id = '" . (int)$product_id . "'");
   
   Make sure you add this before the closing '}' of the function (line 1279 for me before the edit).

I hope this also helps you out.

[maeve100]

Hi there -

Has anyone come across this issue - or know what page I should look into for problems? The product display pages work fine, and I can manually enter values in the products_color database - but after these changes my "Update Products" from the Zen cart Admin is totally broke. I can enter in data for new and exsisting products - but when I hit update it goes to a blank screen with the Zen cart nav bars up top. I am thinking its the update_products.php file - but I have reverted it, copied over the snippet and it still doesn't work. Any ideas on what to look for?

Liz

[ruthnis]

Hi

The issue is not with the code that appears in this thread because it is working.

I assume that the problem is with the SQL script that updates the database.

The fact that you are getting a blank page is because there is an error.

You can configure php.ini differently so that you see the errors.

I would suggest that you check your definitions in admin/includes/modules/update_product.php
(article 6 in the explanation of the procedure).

Good Luck,
Ruth

[maeve100]

I am not sure what was causing this at all - but I tried copying over the code once more and it worked. There must have been a return, or an extra space somewhere in what I was doing. I am very glad to have these instructions though - thank you!

[webego]

Has anybody tried out my delete code above?

[dansicle]

Not yet, but I intend to very soon.

[JE2009]

well, I don't know what's happening with our zen leaders so I've uploaded my mod to my website so that everyone can grab it now. Please, if anyone runs into problems, let me know!

The first extra field is now a textarea that can be used for embedding a YouTube video by the way.

Grab the zip file here

Enjoy!

Delia,

the link is broken, wanted to download your mod.

thanks,

JE

[autoace]

I am looking to add additional product data fields as well but also have Easy Populate CSV installed as well. Will this additional code process break Easy Populate CSV?

Thank you.

[webego]

Sorry autoace, I don't use easypopulate so can't comment. If you do try the mods out though, please report back on your success or failure for the benefit of others using easypopulate.

Thanks

G

[ALiepinieks]

it won't break it, it simply ignores any fields that are not defined in the easypopulate.php file located under admin/includes.
to define these additional/custom fields, you could simply do a search for a similar type field in the aforementioned file, and then add the extra code (where relevant) after you've added your database fields of course. you need to ue a bit of common sense, but it worked for me making all the changes required (to easypopulate) in under 10min.

andrejs