Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent Please Help. How Do You Change The Width Of The Model Section Inside Of The Order?


RC Heli Pilot

Recommended Posts

Hi.

I'm so sorry for having to ask this question but,...

 

I'm finally getting orders now. I was able to figure out how to change the width of the Model # while viewing the Product on the Website but,... When i view the orders that people have placed inside of the Admin I'm Only Seeing what I believe to be is 12 Characters of the Model # Instead of what I changed them to on the Website.

 

Please,... Could someone tell me how to change the Width of the Model # Section In The Order To View More of the Model # When a Order is Placed?

 

I Would Very Much Appreciate Your Help.

 

John.

Link to comment
Share on other sites

There are 2 places the products model gets put into. The products table and the orders_products table.

Using phpmyadmin you can change them each manualy or using the sql feature. If you want to do it that way then click on sql and copy and paste the below

 

alter table products change products_model products_model varchar(24);

alter table orders_products change products_model products_model varchar(24);

 

I set to 24 but you can set it to what you need.

Link to comment
Share on other sites

There are 2 places the products model gets put into. The products table and the orders_products table.

Using phpmyadmin you can change them each manualy or using the sql feature. If you want to do it that way then click on sql and copy and paste the below

 

alter table products change products_model products_model varchar(24);

alter table orders_products change products_model products_model varchar(24);

 

I set to 24 but you can set it to what you need.

 

Brian,... Man I Really Appreciate Your Help.

I'm going to go and check out phpmyadmin right now. I remember going in there to change the character width for the product, I think i did it manually, I think i'll try your Copy and Paste method and see what happens.

 

I'll be back and let you know what happens.

 

Thank You So Much My Friend.

John.

Link to comment
Share on other sites

Question,...

 

Do i need to be in each one, The Product and the Order_Products to type both or copy and paste 1 for each?

 

 

alter table products change products_model products_model varchar(24);

 

alter table orders_products change products_model products_model varchar(24);

 

John

Link to comment
Share on other sites

Question,...

 

Do i need to be in each one, The Product and the Order_Products to type both or copy and paste 1 for each?

 

 

alter table products change products_model products_model varchar(24);

 

alter table orders_products change products_model products_model varchar(24);

 

John

 

 

Brian,... NM I figured it out. I just used the

alter table products change products_model products_model varchar(24);

for the Product Models which i had already changed to 25 so i just kept it at 25 and then used the

alter table orders_products change products_model products_model varchar(24);

in the Order_Products Category and changed it to 25 and it worked like a Fracken Champ.

 

I also just descovered that it only chances it on future orders and not the orders that have already been placed which is cool. no biggie.

 

I really appreciate your help friend.

Best Wishes to you and yours.

RCHP.

Link to comment
Share on other sites

That was just a quick of doing both at once. All you have to do is log into phpmyadmin then click sql. In the box that appears paste the above code and click go.

 

If you already have done the products table then just click on the oreders_products table select products_model and change it that way.

Link to comment
Share on other sites

That was just a quick of doing both at once. All you have to do is log into phpmyadmin then click sql. In the box that appears paste the above code and click go.

 

If you already have done the products table then just click on the oreders_products table select products_model and change it that way.

 

Yep,.. Thank You so much.

I really appreciate your help.

 

Theres not many out there such as yourself that are willing to help me as you are.

 

RCHP

Link to comment
Share on other sites

Theres not many out there such as yourself that are willing to help me as you are.

Very very wrong. There a lot of people out here who give a ton of help. Most of whom know a whole hell of a lot more than me.

Link to comment
Share on other sites

Very very wrong. There a lot of people out here who give a ton of help. Most of whom know a whole hell of a lot more than me.

 

 

Very very wrong.

 

I agree,.. I mean what i was getting at was,... The people such as yourself that was willing to help me and answer the questions that i had.

 

My questions might seem tiny to the Big Helpers and i feel that some times those Big Helpers don't respond as much to the smaller tiny questions such as the ones i was asking. You simple just popped in to my thread and answered my question in just a sentence basicly and i sometimes feel that those Big helpers tend to over look the smaller questions and continue on. If that makes any sense,...

 

But yeah,.. There are some very smart people on here, Please don't get me wrong.

 

John

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...