text field product option

[esferguson]

I've used osCommerce for years - this is my first ocMax installation.
I know many, many people have used the product attribute text option for personalization. What am I doing wrong?? I can't get the option information passed to the order from the shopping cart.

Any help is greatly appreciated!

[michael_s]

See this post:

http://oscdox.com/index.php?name=PNp...xt+input+field

[esferguson]

Thanks for the reply. I have already seen that post, and am using oscMax v1.7. The attributes make it into the basket fine - but they are not carried through to the order table.

I have it working on standard osCommerce with the contribution...

[bdneuman]

This is major - we're just getting our store opened up and realized the text fields are not being recorded. The post referenced does not address this issue. All text entered disappears from the cart during checkout and does not get passed to the database - what is going on?

[bdneuman]

Okay, here's the deal.

#1 There was a misspelling in my catalog/includes/configure.php. the line looked like this (at the bottom of the file in mine):

define('PPRODUCTS_OPTIONS_VALUE_TEXT_ID', 0); //Must match id for user defined "TEXT" value in db table TABLE_PRODUCTS_OPTIONS_VALUES

See the double P's in PPRODUCTS? Deleting the duplication allows the text value the customer entered to be passed to checkout/admin/email confirmation and so on. However, the text field definition is still omitted. For example, my form says "Enter custom size:". If they enter "8 inches", the checkout/email/admin order will show ":8 inches".

#2 I believe the problem lies with the attribute manager. In order for the check box to be available in attribute manager, I entered some default text when setting up attributes. So for "Enter custom size:", I entered "Custom Size" in the admin under Option Values - I believe this to be the wrong procedure. The note next to the line I fixed above says the OPTIONS_VALUES must match the id for user defined TEXT. When you enter a default value for each of these attributes like I did, they end up with different id's.

So, the fix is to reset all of my text fields to point to the same Option Value, "TEXT" which will all have the same id (in my case, 0). I think I'll do this via PHPadmin - but I've got a lot of products to change!

In the future, you cannot use the attribute manager to assign text fields to products - they have to be assigned from the bottom of the Product Attributes in admin - this is the old way, prior to attribute manager.

Does the guru agree with this?

[michael_s]

Not major. A glitch was introduced in one of the updates. The fix is attached here and is just a couple of lines of code.

The file checkout_process.php is the only one that needs to be modified. You can either overwrite your existing file or compare the attached file to your existing one and merge the changes manually. I recommend doing it manually, as there are several different versions floating around out there.

This has also been updated in the main osCMax 1.7 download as of this post.

[michael_s]

bdneuman,

It looks like you have a couple of things going on in addition to the bugfix I posted.

Before you change anything, incorporate the bugfix and see if that fixes your issue. It worked for my test store without changing anything else.

[bdneuman]

The zipfile is corrupt...

I'm just sitting here going through my attributes and products_options_values_to_products_options tables setting all my text fields option_values to "0". I'll hold up until I can check out your fix...be great if it works!

Thanks.

[michael_s]

The zip is not corrupt. I just downloaded it and opened it and it works fine.

[bdneuman]

I tried winzip and winrar and i keep getting this:

! Unexpected end of archive