Order Invoice - Product Description

[jdw1979]

If you want it as long as it is in the products table and don't care if when you delete the Product you cannot see the Product description and it just reading NOT FOUND vs Today's products_description then you can just use a quick look up ...

This one, totally.

We keep records of all orders in a separate inventory and accounting system (as only a small percentage of our orders come from our website). The thing that my coworkers are unhappy with is that our data feed (over which I have no control...damnit) has stupid, non-descript titles like "Cholestech Accessories" (this title is the same for at least 70 different products). I know, I know, it's clunky and awful. I would just fix the data feed myself, but it's too large to work with manually (60,000 products in our store). Sorry...that turned out to be more like whining than I intended. Thanks a lot for your response.

[Ajeh]

You still need to explain if you need the products_description to be available even if the Product is deleted later after the Orders have been processed etc. of if you just need the Products Description to always be on the Order for each Product ...

If you need it always with the Order, then it will need to be saved in the orders_products table and some numerous code changes are needed ...

If you need it for a short period of time, such as when the Product might be deleted and it is no longer available, you can just use a function to pull the information for display and if the Product is not found then display:
Description Not Found

Which way do you really need this to work?

[jdw1979]

If you need it for a short period of time, such as when the Product might be deleted and it is no longer available, you can just use a function to pull the information for display and if the Product is not found then display:
Description Not Found

That one.

We enter these orders into a completely different accounting and inventory system as we receive them. So, we only need the online record to exist for a short while.

[Ajeh]

You could use the:
function zen_get_products_description($product_id, $language_id)

from the general.php and pass it the current values for $product_id and $language_id from where you are in the code for the file where you want to see this ...

If you need to clean up the products_description because of html code that might be in it, you might look how the Product Listing does it ...

[jdw1979]

You could use the:
function zen_get_products_description($product_id, $language_id)

from the general.php and pass it the current values for $product_id and $language_id from where you are in the code for the file where you want to see this ...

Okay...I kinda get it.

So, I would want to put the first part of this code (the function) into /admin/includes/orders.php (not the admin/includes/classes/order.php), , as that is the file actually outputting the data into the browser, correct?

The second part is where I get confused; "general.php" is where the function is created? So I don't have to do anything there, right? That's just where all of the functions are defined...I'm guessing.

So...in orders.php, I'd find the table where the order data is actually being output, simply insert another row in that table, and insert the "zen_get_products_description" function there...I'm hoping...

[Ajeh]

The function itself is in the file:
/admin/includes/functions/genera.php

you do not need to touch this, just use the function from it:
zen_get_products_description($product_id, $language_id)

On the file where you want to output the data, you would then find how to address the products_id and languages_id to pass to this function ...

Most likely:
$order->products[$i]['id']
$_SESSION['languages_id']