Programmatically get the product name from $order I need to get the product name using the $order variable in Ubercart. How can I achieve?
In ubercart uc_products table stores the product details. You can get product id from the $orders array and can fetch the required product data from
uc_products table.

$query = "SELECT * FROM uc_products WHERE nid = ". $pid;


Refer the links for more details
https://www.drupal.org/node/1940926