Model number in admin

[zefeena]

Hi,

 

this is something I've been trying to do for 10 years!  i'm sure I've probably asked before, but to date I still haven't figured out whats wrong.

 

I added a bit of code someone wrote so it gave a column in admin showing the quantity:

 

 

essentially the important bit was

 

add in admin/categories.php:

 

<td class=''dataTableContent'' align=''centre''><?php echo $products[products_quantity'];?></td>

 

it worked brilliant,

 

so I repeated the set of code and changed the [products_quantity] bit to [products_model].

 

But it never worked.  The column header showed up, but no data.  I checked my database it seems its definitely called 'model' .

 

It would be brilliant to get this working as my 'model' is also my location so I would be able to see where something is without having to click on it, which when  you are stock checking a few thousand items is very laborious!

 

Any help would be appreciated.

 

thank you  Kellie

 

 

 

[ecommunlimited]

@@zefeena You stated for 10 years you've been trying so I am only assuming you have an older system.  The below should work. One is an add on the other 2 are forum links. I hope they help, take care.

 

http://addons.oscommerce.com/info/6359

http://www.oscommerce.com/forums/topic/273275-show-product-name-and-product-model/

http://www.oscommerce.com/forums/topic/107262-add-model-to-admin-product-listing/

 

Bill

[Dan Cole]

@@zefeena  Kelly you probably just need to add the products_model field to your sql query.

 

Dan

[♥Tsimi]

As Dan said there are 2 queries around line 937-939. Just add p.products_model to the second query.

[zefeena]

As Dan said there are 2 queries around line 937-939. Just add p.products_model to the second query.

 

That worked!  so easy when you know how!

 

I do have a current up to date site, but over the years everytime I have updated or started afresh i've wanted this to happen, had a go and failed.  So success at last!  thank you so much.