Extending Product_Code Past 32 Characters

General General Questions
1

I have some rather long product code names. So in the past I had extended the length allowed by doing:

[quote]You'll need to change this in your database, use PhpMyAdmin if you can. The field you need to change is 'product_code', there are three tables you need to edit:


  1. Table 'order_details'
  2. Table 'products'
  3. Table 'product_options_inventory'



    The dafault value is VarChar 32, change the 32 to what ever you need.[/quote]



    Well I have done that but it still seems to be limiting me to 32 characters when naming products. Did something change in 4.3.1 that I need to adjust to make this work past 32 characters?
2

Hello,



Please, make a backup of your database at first. Then create .sql file with this content and restore it:



[color=#990099][font=Verdana,]ALTER[/font][/color][font=“Verdana, Segoe UI, Arial, Tahoma”][color=“#235a81”][color=#235A81][font=Verdana,] [/font][/color][/color][/font][color=#990099][font=Verdana,]TABLE[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#008000][font=Verdana,]cscart_products[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#990099][font=Verdana,]CHANGE[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#008000][font=Verdana,]product_code[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#008000][font=Verdana,]product_code[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#FF9900][font=Verdana,]VARCHAR[/font][/color][color=fuchsia][font=Verdana,]([/font][/color][color=#444444][font=Verdana,] [/font][/color][color=teal][font=Verdana,]255[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=fuchsia][font=Verdana,])[/font][/color][color=fuchsia][font=Verdana,];

[color=#990099]ALTER[/color] [color=#990099]TABLE[/color][color=#444444] [/color][color=#008000]cscart_product_options_inventory[/color][color=#444444] [/color][color=#990099]CHANGE[/color][color=#444444] [/color][color=#008000]product_code[/color][color=#444444] [/color][color=#008000]product_code[/color][color=#444444] [/color][color=#FF9900]VARCHAR[/color]([color=#444444] [/color][color=teal]255[/color][color=#444444] [/color]);[/font][/color]



You will change product_code lenght to 255 symbols in this case.



Thank you.