How to get the model/part # not to truncate?

[ActiveTuning]

My part numbers are too long so they are truncating on the invoice. I know there is a simple fix, but how can I do this?

[charles]

My part numbers are too long so they are truncating on the invoice.  I know there is a simple fix, but how can I do this?

<{POST_SNAPBACK}>

 

In MYSQL table 'products', field 'products_model' change # of characters in column 'type'

 

if you use easypopulate, you need to change it in easypopulate.php also, look for 'products_model'.

 

Good luck, charles

[ActiveTuning]

In MYSQL table 'products', field 'products_model'  change # of characters in column 'type'

 

if you use easypopulate, you need to change it in easypopulate.php also, look for 'products_model'.

 

Good luck, charles

<{POST_SNAPBACK}>

 

 

Thanks for the reply. The characters fit, but just to test I upped it to 25. No go. For example, on the invoice, what is supposed to be:

 

NI-AL-02KYBRSHX

 

Comes up as this on the invoice:

 

NI-AL-02KYBR

 

Seems like maybe something in the script is truncating it? Any thoughts?

[charles]

Thanks for the reply.  The characters fit, but just to test I upped it to 25.  No go.  For example, on the invoice, what is supposed to be:

 

NI-AL-02KYBRSHX

 

Comes up as this on the invoice:

 

NI-AL-02KYBR

 

Seems like maybe something in the script is truncating it?  Any thoughts?

<{POST_SNAPBACK}>

 

Hmmm... 12 is the default. It worked for me when I set it to 130 because I used the Model number to store the botanical names of herbal products, but I never printed an invoice, settling on a different method instead. You only say that the Model number is truncated on the invoice. If it is complete in catalog then it is probably a box size issue in the Admin funtion that produces the invoice? Of this I know nothing. Anyone else have any ideas?

 

I hope I was of some help.

 

Good luck, charles

[ActiveTuning]

Hmmm... 12 is the default. It worked for me when I set it to 130 because I used the Model number to store the botanical names of herbal products, but I never printed an invoice, settling on a different  method instead.  You only say that the Model number is truncated on the invoice.  If it is complete in catalog then it is probably a box size issue in the Admin funtion that produces the invoice? Of this I know nothing.  Anyone else have any ideas?

 

I hope I was of some help.

 

Good luck, charles

<{POST_SNAPBACK}>

 

 

I assume the same thing...anybody know for sure?

[ActiveTuning]

I assume the same thing...anybody know for sure?

<{POST_SNAPBACK}>

 

Anybody?

[Guest]

Let start from the top:

 

1. Use phpMyAdmin to edit products_model field of the products table:

ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( XX ) DEFAULT NULL

 

2. Use phpMyAdmin to edit products_model field of the orders_products table:

ALTER TABLE `orders_products` CHANGE `products_model` `products_model` VARCHAR( XX ) DEFAULT NULL

 

Notes:

- Replace XX with your desired length. (defaults = 12)

- Step 1 allows you to change the products_model length shown throughout your store.

- Step 2 allows you to change the products_model length shown in Admin >> Order

- To achieve Step 2 you must complete Step 1 first.

- The above modifications will work for every future orders.

- To change products_model of the orders made in the past, you'll have to use phpMyAdmin or find someone to write a custom script to excute after completing Step 2.

[ActiveTuning]

Let start from the top:

 

1. Use phpMyAdmin to edit products_model field of the products table:

ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( XX ) DEFAULT NULL

 

2. Use phpMyAdmin to edit products_model field of the orders_products table:

ALTER TABLE `orders_products` CHANGE `products_model` `products_model` VARCHAR( XX ) DEFAULT NULL

 

Notes:

- Replace XX with your desired length.  (defaults = 12)

- Step 1 allows you to change the products_model length shown throughout your store.

- Step 2 allows you to change the products_model length shown in Admin >> Order

- To achieve Step 2 you must complete Step 1 first.

- The above modifications will work for every future orders.

- To change products_model of the orders made in the past, you'll have to use phpMyAdmin or find someone to write a custom script to excute after completing Step 2.

<{POST_SNAPBACK}>

 

PERFECT, thanks so much Alpha Ray, that was the exact sort of answer I was looking for. It was step 2 that I was missing lol!

 

Thanks again for the tremendous help, and the great post :D

[Guest]

PERFECT, thanks so much Alpha Ray, that was the exact sort of answer I was looking for.  It was step 2 that I was missing lol!

 

Thanks again for the tremendous help, and the great post :D

<{POST_SNAPBACK}>

Anytime David! :thumbsup: I happened to come accross this a couple of weeks earlier.

[Guest]

Alpha Ray.

Spot on.

Great.

Cheers.

Keep smiling and thanks.

Colin

Scotland

[bibleman]

Let start from the top:

 

1. Use phpMyAdmin to edit products_model field of the products table:

ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( XX ) DEFAULT NULL

 

2. Use phpMyAdmin to edit products_model field of the orders_products table:

ALTER TABLE `orders_products` CHANGE `products_model` `products_model` VARCHAR( XX ) DEFAULT NULL

 

Notes:

- Replace XX with your desired length.  (defaults = 12)

- Step 1 allows you to change the products_model length shown throughout your store.

- Step 2 allows you to change the products_model length shown in Admin >> Order

- To achieve Step 2 you must complete Step 1 first.

- The above modifications will work for every future orders.

- To change products_model of the orders made in the past, you'll have to use phpMyAdmin or find someone to write a custom script to excute after completing Step 2.

<{POST_SNAPBACK}>

 

 

THANKS ALPHA RAY,

 

I searched this site for about an hour before I found your simple easy to understand response.

 

Everyone was saying do it in PHPmyadmin.... but I always thought I was to do the products model in the products table ONLY.

 

STEP 2 cleared it up!

 

Thanks a bunch.