New / Custom Extra Product Fields

If the numinix mod was giving you problems, then I would have recommended contacting numinix, since they're the ones who best understand their modules.

I think csv is the last way I'd dare to do any SQL query preparation, but if it worked for you and you're confident you got all the values into the correct fields, then enjoy.

You could have also just put a new extra_datafiles file with a define for 'SHOW_PRODUCT_INFO_NOTES' to 1 if you don't expect you'll ever turn it off. There are many ways to set those switches. Using the database is only so that you can have an admin screen to change the value. But if it's never going to be changed, then the database is overkill.

I realize it may seem like you're 'out there on your own without support', but I thought you had ongoing dialog about it, so wasn't chiming in so as to not step on anyone else's toes. I can't answer everyone's questions immediately, and when a mod exists to do what's being suggested I find it's usually best to let the mod do its work instead of re-teaching the same thing again. And then there's the flip-side where what's being asked is very specialized and really needs someone to get their hands on the site to do what's needed, and that's a little beyond the scope of these forums, since it's usually better to pay someone with the knowledge to do it right then and there.
Anyway, glad you got it sorted out.

delia:

Hmm, the apsona shop manager is free and is a lot easier to use than the ezpopulate. Fields added to the product table automatically get included.
http://apsona.com/pages/ec/signup.html

Additionally, I wrote the extra product fields mod - it uses a different table because it had the possibility of adding many fields and I wanted to keep that info separated out of the products table.

I've thought about a new version since that one was actually written more to include a flash file on the product page and that's probably not happening anymore. At least I hope so.

So perhaps it would be best to rewrite the mod to include upload maybe 2 PDFs (the other reason for the mod) and several text fields. Connect them to the product table instead and that would have solved your problem, correct?

Hi Delia:

Please let me know when you re-write the the mod to include several text fields in the product table or better yet in a table that does not touch core files. The nature of our products require much additional information as well.

I have that done but was trying to incorporate searching that table and ran into problems. I will let you know when I have it ready.

delia:

I have that done but was trying to incorporate searching that table and ran into problems. I will let you know when I have it ready.

Great news. Thank you for the update.

I have installed ZC 1.5.3.
Installed EP 4.0
Added 13 custom product fields to the products table.They are all in TEXT format.
Installed TPP 1.10
I plan to install Image Handler 4.

I need TPP to be able to pull content / data from custom fields so that the custom data is displayed in tabs in the product information page of my store.

I read Crazy_Chris' post that was submitted in 2007 which seems to be the easiest to follow instructions so far. But. I am not sure if there have been changes in ZC since 2007, or if the TPP 1.10 Global Tabs instructions are sufficient to pull the data. Or do I need to make the changes that Crazy_Chris outlines and the TPP Global Instructions. I'm not a programmer; but, I am good at following instructions, provided they are clearly written.
I have looked at Numinix 3.0 but most of the custom field names are different than the ones I have created and it modifies ZC 1.5.3 core files.

AJ

That has nothing to do with this mod.

Oops. I'm sorry.

AJ

I thought that my custom fields were working perfectly, then I later noticed that any product that I updated through admin lost the values in the custom fields.

For example, one field that I have is products_width, and for product id X products_length has a value of 9.9. I click edit, preview, update (with or without changing ANY value, such as adjusting quantity) and ALL 7 of my extra fields lose the values that were in them (all values for the regular fields are fine).

I can upload them through Easy Populate to restore the values, but I really, really need to be able to do it through admin for all the tiny minor updates.

I looked at my collect_info.php, preview_info.php and update_product.php files and cannot see any problem...

CUT CUT STOP***

I found the problem within the update_product.php file. I had:
'products_length' => $products_length,

because I copied the format from:
'products_weight' => $products_weight,
'products_price' => $products_price,

and now changed it to:
'products_length' => zen_db_prepare_input($_POST['products_length']),

WHY WHEN I copy the line of code from weight, just like price, and modify it to my new field does it loses the value when I update through admin, but price does not?

?

Because there is extra coding in the file for the price field so it is very different.