Product Extra Fields for text, pdfs and flash

[MikeyG]

jill8026

your sites seem to achieve what I am after. would you care to share or point me in the right direction. Very much appreciate the help.

Thank you

[delia]

Thanks for this mod. I just installed it and it seems to be working.

Does the Extra Text Field have to be a large text box? I actually need to enter a 2nd Model Number (Part Number). So just need a short text input box. Is this possible?

Also, would there be a way to link to YouTube videos instead of uploading flash? I know I can cut and paste the embed code, but I would rather have it entered as a field.

You can use that extra text field anyway you want. It still will just list the info on the product page.

I created that field for youtube videos initially. Cut and paste the code into there. But then there is only one field for that kind of use in the mod. The request that lead me to doing this mod was more about attaching pdfs and embedding flash that anything so I only put in one extra generic field. I will add more in the next version - whenever that should be.

[delia]

I wish to use the extra text field for suggested age for my product....Childrens products - eg age 3.

How do I get the advance search to pick up this field and allow a search by age similar to the search by price?

You would have to alter the search function - /includes/modules/pages/advanced_search_result/ header_php.php and then add code for the age searching. Not a small thing.

There are some instructions in this thread: http://www.zen-cart.com/forum/showthread.php?t=131143

[MikeyG]

delia,

thank you for the heads up. Not really a php programmer so it is going to keep me busy for a while. ;-)

[eVelt]

I found some issue and i have a temporary workaround
ZC 1.3.9h

If you link a product to a different category and you decide to delete it form being linked you will not be able to edit the product anymore in the master category.

you will see it in the admin, but when you click to edit the product, no information will be viable.

in the error you will get something like this

[07-Jul-2011 09:50:04] PHP Warning: reset() expects parameter 1 to be array, null given in /home/xxxx/public_html/admin/includes/classes/object_info.php on line 29

[07-Jul-2011 09:50:04] PHP Warning: Variable passed to each() is not an array or object in /home/xxxx/public_html/admin/includes/classes/object_info.php on line 30


because the admin/includes/module/delete_product_confirm.php will delete the information from both the MASTER and the LINK thus breaking the array.


WORKAROUND #1: Do not override the
admin/includes/module/delete_product_confirm.php
nothing bad can happen, only the additional fields will stay in the DB

BTW: it is good practices not to delete any products. disable them or move them when they are no more needed, saving you the product ID

WORKAROUND #2 NOT RECOMMENDED for people like you..., remove the product from being linked via phpMYadmin

find the product to category table and delete the record of the link

[delia]

eek, no one has reported that before. Has anyone else run into this? That sounds more like a bug introduced from something else and not this mod but it's possible it's my bug.

[labcomputer]

Hi Della,
After installing this patch I am getting the following SQL error when I try to import into DB:

An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

Your help is appreciated

[delia]

Did you use sql patch facility or the easy populate import? I've never seen that message about the easy populate maintainer so you may have some mods installed (not the normal easy populate mod) that are creating the problem.

[labcomputer]

Actually easypopulate works fine before instaslling product extrafield

[delia]

Sorry, I thought you meant the mod didn't work.

Easy populate can't import or export these extra fields so if you trying to do that you are out of luck. Easy populate only works on the default database tables. Any changes will stop easy populate from working.