product_model length too short

[ivan8r]

I'm using Easy Populate to upload a database. I'm getting an error which says:

 

16SKIPDOCTORMD-PRO... ERROR! - Too many characters in the model number.

12 is the maximum on a standard OSC install.

Your maximum product_model length is set to 15

You can either shorten your model numbers or increase the size of the field in the database.

 

I've gone into the MySQL database into the products table, and changed the products_model length to 50. I'm still getting the error.

 

Did I change the wrong table field? Anybody know the correct field?

[ivan8r]

I managed to figure it out... Not only do you have to change the database, but there is a variable you have to change within Easy Populate itself. Seems to work fine now!

[Authority Electronics]

where do you edit the model number setting in the database?

[mbuswell]

Just as a reference if anyone happens to be looking for information on changing the size of the products model number.

You change it in the DB in two places

1) products table

2) orders_products table

 

If you only change it in the products table you will see that on the packing slip and invoice the model number is still the default 12 characters. this is because the model number for these pages is coming from the order information not the products table information.

 

simple use SQL to increase the orders_products.model_number field size. This will now have effect for all new orders, old orders will still have the max 12 digit model numbers.

 

cheers.