Show custom field in admin order screen

=OTS=G-Man

No avatar

2009-07-22 00:38

Hello, I am wondering how I would add something to the admin screen in the orders detail area

I have a custom field "sCatalogNum' that is our internal itemId for our items, I already have it stored in the DB files and can edit them from the products admin screen but i need to display after the itemID in the order detail, I tried just calling aData['sCatalogNum'] in the template but of course it did not work. I also tried adding it to the orders_products db in the addOrder($aForm) function but it just entered a blank.

So just to sum up, I need to display the sCatalogNum value of an item thats stored in the "en_products_ext.php" db on the order detail page in the admin section.

Thanks
Don

» Quick.Cart v3.x

Makaron

Avatar: Makaron

2009-07-22 11:15

When somebody make new order You have to add this value to database orders_products.php. Look at function addOrder() in core/orders.php.

beholder

Avatar: beholder

2009-07-22 13:05

if you really need help in this little thing and still don't know how, find my contact on this forum and send me ftp access to your site. I'll help you quickly, this should be very easy.

=OTS=G-Man

No avatar

2009-07-22 19:08

Thanks for the info. I tried adding it to the end of line 304 like this

>saveDB_ORDERS_PRODUCTS, Array( 'iElement' => $iElement++, 'iOrder' => $aForm['iOrder'], 'iProduct' => $aData['iProduct'], 'iQuantity' => $aData['iQuantity'], 'fPrice' => $aData['fPrice'], 'sName' => $aData['sName'], 'sCatalogNum' => $aData['sCatalogNum'] ) );



but in the DB it just inserts a blank, is there a different thing i need to get data from the ext table?

thanks again

=OTS=G-Man

No avatar

2009-07-22 19:09

ohh and forgot to mention, i did edit the order_product table and added the sCatalogNum to the arrays

beholder

Avatar: beholder

2009-07-22 23:42

I can't do it like this, over the forum. This thing is simple to do with sources, but to duplicate all your changes in my copy of QC would be a nuisance, all the while trying to show you how to do it via this interface.. impossible.

Back to top
about us | contact