Talk to me about anything. If you’d like to work with me, or
even if you just need a hug, I’ll get back to you shortly.

Please enter your name


Say something!

Type the characters you see in the picture below.

Captcha needed

+1  (818) 574-3596 
+44 (020) 8123-6463
+91 (0)   9864011106

osCommerceCoders.com

Affordable end to end oscommerce solutions with
Search Engine Optimization

Model Number field in oscommerce

Posted by admin On July - 31 - 2009

How to Change Product Model Length
The default 12 character limit for product model strings may be too short for certain needs, and can be easily increased with phpMyAdmin or directly with MySQL.

Two database tables need to be modified when changing the length of the product model
field: products, and orders_products.

Using phpMyAdmin

Select the products table on the left side of phpMyAdmin
Select the product_model check box
Click on the Change button
Set the new size value under the Length/Values field, and click on the Save button. The same steps need to be reproduced for the orders_products table.

Using MySQL
alter table products change products_model products_model varchar(255);
alter table orders_products change products_model products_model varchar(255);

Leave a Reply

Contact Us
Name*
Email*
Phone*
Services*
Message*
Security Code* 7ae1a
 
 

REACH US



You can email us at oscommercecoders@gmail.com


or Click here to contact us or call us at +1 - 818-574-3596

TAG CLOUD

Sponsors