How to change product attribute for order placed?

I have customers that order the wrong size of clothing on my store. In the 1.2x version, I used phpMyAdmin and changed the attribute using easy, simple text.

(zen_orders_products_attributes => went blobby on version 1.3x and above)

Now that these are stored in blobs, what can I possibly do? I searched the forums, but did not see this anywhere. Thanks for any help you can give.

Binary - do not edit (3 B)
shows above the field in phpMyAdmin and has a file upload control next to it. Weird.

I'll paypal someone $15 if you can answer this for me by Monday- I'd hate to delay this guy's order any more, but I need to be able to send the correct size to the warehouse. Thanks!

Has anyone ever found a fix? Are order product attributes impossible to change? Please advise.

Just signed up for a monthly donation to zen-cart from my little martial arts supply store. Please advise on the previous question (and/or the motion on the previous question).

If I am understanding you correctly, all you are missing is have on the Option Name for Size is to add 1 more Option Value:

What Size do you Wear? (or Pick one or Select from below)
Sort Order 0
Default YES
Display Only YES

What this does is force the customer to make a "proper" choice and not an "accidental" choice ... :smile:

Sorry this got past us ... when you have a post and no response for more than 24 hours ... add on to your post incase someone doesn't have the enough information or perhaps someone who can help hasn't been around ...

Hi Ajeh,

Thanks for the response. I have customers that sometimes choose the wrong size, or we need to change the size due to availability in our warehouse. Is there a way to change a size once an order is placed? We used to use phpMyAdmin to edit the product attribute in the database, but now I see it is a blob field. Any advice?

thanks,

Jim

Backup your database ...

You can try using TEXT vs BLOB and see how that works with your site ...

Could you explain that a little more for the MySql challenged among us:unsure:

Yes- How can I change database structure so easily? I won't lose any existing information? Zen cart will just store the incoming order data - even though it is no longer a blob?

Thanks!

Jim

If you backup your database ...

Go to phpMyAdmin ...

Look at the structure of the orders_products_attributes table ...

Edit the field products_options_values and change from BLOB to TEXT ...

NOTE: I have not tested this 100% but at the moment I am not seeing any reason that this would not work for you so that you have a large field capable of holding anything that the products_options_values could hold before but this lets you view it in phpMyAdmin ...

I have to chew on this a bit and consider if there is any reason why this couldn't be changed this way ...

NOTE: you may wish to use a test site and test database and make the change on there and then conduct a lot of tests and examin your old data and see if you see anything obvious that might be moofed up ... :eek:

But, like I say, I don't think this will be an issue ... but again I have not tested it 100% ...

what was the reasoning for changing it in the first place from text to blob? Just curious, trying to learn.

It was way too small original because of all that field has to manage ... varchar(64)

So some "bright elf" got the idea that making it a BLOB was ideal so that "anything and everything" we may want to do with that field not and in the future would work and not have to be changed again and again ... :rolleyes:

Unfortunately ... I didn't think about the fact you guys might want to browse the raw database and look at the raw data via phpMyAdmin ... :cry:

Gonna have to rethink the BLOBs ... I should of know after watching the movie ... you don't want to go there ... :eek:

Thanks for the explanation......also i'm now gonna have nightmares like I did when I was 5 (when the BLOB was colorized) Thanks

See? and you wonder why I work late at night ... I saw the black and white then colorized the same night ... :shocking:

:shocking: shivers, turns on all of the lights and locks the doors

You've scared my monkey, but answered my question. Thanks!

Ajeh:

If you backup your database ...

Go to phpMyAdmin ...

Look at the structure of the orders_products_attributes table ...

Edit the field products_options_values and change from BLOB to TEXT ...

NOTE: I have not tested this 100% but at the moment I am not seeing any reason that this would not work for you so that you have a large field capable of holding anything that the products_options_values could hold before but this lets you view it in phpMyAdmin ...

I have to chew on this a bit and consider if there is any reason why this couldn't be changed this way ...

NOTE: you may wish to use a test site and test database and make the change on there and then conduct a lot of tests and examin your old data and see if you see anything obvious that might be moofed up ... :eek:

But, like I say, I don't think this will be an issue ... but again I have not tested it 100% ...

A Question for Linda or Anyone "-)

I've been testing this -- changed it to text, edited, then changed it back. No problems that I've been able to ferret out.

Any reason not to do this? I could leave it as text always, but because they can upload files (with potentially longer names) and leave longer comments in a text box (no one has as yet) thought maybe better to put it back the way it was?

Basically I'm confused and just need a quick way to fix an order -- don't want to install Edit Orders or Super Orders until such a time as the functions I need are available. I'm comfortable using phpMyAdmin to mess things up. hehe.

Thanks for your input!

Becky

I change it to text in phpMyAdmin, and it worked fine.

I have not broken it yet ... but I have more testing for this for future releases to do ... :smile: