How to make the PayPal to view "Item Name", but not "Order ID"???

[pandorra]

here is the code from PayPal extra Info...

"item_name" => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER').": ". $db->f("order_id"),

what must be written here to show not the Order ID, but the Name of Product...

Thanks in advance...

[guimplenchik]

I did in this way. Back up first!!
after lines:

<?php
$db1 = new ps_DB();
$q = "SELECT country_2_code FROM #__vm_country WHERE country_3_code='".$user->country."' ORDER BY country_2_code ASC";
$db1->query($q);

add the following:

$dbcart = new ps_DB;
$z = "SELECT order_item_name FROM `#__vm_order_item`
                WHERE order_item_id='".$db->f("order_id")."'";

      $dbcart->query($z);

and instead of:


"item_name" => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER').": ". $db->f("order_id"),

add this:

"item_name" => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER').": ". $db->f("order_id"). " - ". $dbcart->f("order_item_name"),

or u can change the red one to ". $dbcart->f("order_item_sku"), if u want to display SKU

Hope this will help

[pandorra]

This new code doesn't work...

[evilryu530]

yes it does, do it right and u will have no problem pandorra. i just did it and it worked fine.

[pjpendleton]

I assume the comma changes to a period after:
"item_name" => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER').": ". $db->f("order_id"),
?

[pjpendleton]

OK... I've tried this and cannot get it to work.

Notice the image below after the fix -




[attachment cleanup by admin]

[pravin_bluebird]

hey but what if there are more products in cart?.....

[kontrolfreek]

your screwed with more then one part, that is my issue, there has got to be a way to do this so it list out all the products you bought in the paypal form, surely