Product Code Size

[Guest]

Is there anyway to increase the size of the Product code as my supplier has long product codes, and they are getting cut off, and I need to be able to see the exact product code that they purchased as there will be a lot of products on my website.

 

Thanks in advanced for you support :)

 

Cheers!

Tom

[jclngvl]

I had this exact issue and was looking for a solution TODAY. Product id defaults to 12 and I needed at 18.

 

In the most recent update of Easy Populate there's a warning if you try to upload product with more than 12 characters. This warning also indicates that you need to increase the "products_model" field of the "products" table in the OSCommerce Database and modify EasyPopulate.php.

 

1. Back up your database if you're concerned.

2. Using whatever admin tool your hosting service provides, you need to modify the attributes of the Products_model field in the Products table to the length that you need. I changed from 12 to 18.

3. Using your FTP client or using the OSC administrative control panel, change line 156 in the file admin/easypopulate.php. If your line 156 doesn't contain the following..... define ('EP_MODEL_NUMBER_SIZE', 112);.... then you need to download the most recent version of EP (at least 2.76, as updated on 13-Feb-2009.

 

This worked first time for me and has eliminated numerous "duplicate" products that had been truncated at 12 characters. Hope this helps. I don't know squat about OSC or EP, but have been spending the past 3 months helping a friend get a site up (3,000 products).

 

Good Luck

[Guest]

I had this exact issue and was looking for a solution TODAY. Product id defaults to 12 and I needed at 18.

 

In the most recent update of Easy Populate there's a warning if you try to upload product with more than 12 characters. This warning also indicates that you need to increase the "products_model" field of the "products" table in the OSCommerce Database and modify EasyPopulate.php.

 

1. Back up your database if you're concerned.

2. Using whatever admin tool your hosting service provides, you need to modify the attributes of the Products_model field in the Products table to the length that you need. I changed from 12 to 18.

3. Using your FTP client or using the OSC administrative control panel, change line 156 in the file admin/easypopulate.php. If your line 156 doesn't contain the following..... define ('EP_MODEL_NUMBER_SIZE', 112);.... then you need to download the most recent version of EP (at least 2.76, as updated on 13-Feb-2009.

 

This worked first time for me and has eliminated numerous "duplicate" products that had been truncated at 12 characters. Hope this helps. I don't know squat about OSC or EP, but have been spending the past 3 months helping a friend get a site up (3,000 products).

 

Good Luck

 

 

My webhost says to use phpmysql...i downloaded it and installed it. I searched google and I cannot figure out how to use this program to alter the table that I need to alter. I need to change it from 12 to 25.

 

Thanks for your help :)

 

Tom

[Guest]

Thank you for your help John :) I got it working :)

 

Cheers!

Tom