osCommerce Community Support Forums: mbuswell - Viewing Profile

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.

surfalot, on Aug 4 2009, 12:51 PM, said:

Good point. I am looking at it. I am always worried I will mess something up.

I know I am not the first to ask, and I know that it isn't yet available, however it would be great if SPECIALS could be included in EasyPopulate

Failing that or additionally, the ability to export the product_id from the database would be handy. Understanding that model could still be easy populates primary key, however if product_id was exportable then it would be easier for people to do manual sql updates into other tables not supported by Easy Populate like SPECIALS.

thanks