Unknown column error

[robert329616]

Hello.

I am having an issue with alpha numeric item numbers on my site. I changed all the record sets to text instead of integer and went back into ecart to change the item number from number to text.

When I select an item (S10010E) and then try to checkout the confirm page is giving me the following error:

Unknown column 'S10010E' in 'field list'

I am not sure where to look to try and fix this. All the other items that start out with either 001 or 770, etc. work fine.

Thanks in advance for any help.

Regards,
Rob

[Ray Borduin]

You need to update the Store Cart Summary and Store Cart Details server behaviors on the confirm page. You need to go through each field type to text from number where applicable.

[robert329616]

Ray,

Thanks again, I thought by updating the ecart info from the checkout page would have taken care of it. Its good now.

Regards,
Robert