How do I add text to the product name if out of stock when ordered?

[Lanbo]

Hello. Been trying to figure this one out on my own for a little bit but I'm having trouble. If someone can point me to the location of the SQL queries that create the order, I should be able to get it done.

Basically, I want to add an asterisk (*) to the front of the `products_name` in the `zen_orders_products` table for any products that are not in stock at the time of that order. Basically, if the quantity ordered is more than the quantity in stock, I want the `products_name` to have the asterisk at the front.

The below paragraph is completely irrelevant to the problem so no need to read it unless you want to know why I want this function.

When ordered inventory comes in, we don't put it away since most of it is going right back out. This way my guys will know it was a special ordered item and they can look in the boxes that just came in for those items. I use the "low stock" function to have the cart send me emails when an item drops below zero so that I know to order it in and that works great, but if I can flag these items on the actual packing slip it will greatly speed up the order filling process. It will also help if a customer contacts us and wonders where his order is or why it hasn't shipped. We can take one look and see that an item was special ordered. As we all know, customers don't always read the giant red letter warnings that tell them important information. All our items that are not in stock are flagged as ***SPECIAL ORDER*** in the cart but people still order and then email the next day wondering why their order hasn't shipped. Makes me laugh, but it's also frustrating.

THANKS IN ADVANCE!!!

[Lanbo]

So I seem to answer my own questions after I post them. Oh well, at least I remember to share with others this way.

I was able to get exactly what I wanted by adding this to the end of the "for loop" inside the "function create_add_products".

// Flag special order items with *
if ( $stock_left <= STOCK_REORDER_LEVEL )
     {
     $db->Execute("update " . TABLE_ORDERS_PRODUCTS . " set products_name = concat('*',products_name) where products_id = '" . zen_get_prid($this->products[$i]['id']) . "' AND orders_id = '" . $zf_insert_id . "'");
     }