Resolved Payment name

Hello,

The payment_name, I think I see the issue. If you export both payment_element and payment_name, you should get the name, is that the case?

Remains a mistery.

I made several tests:

In a simple export template:

1 country_name
2 shipment_name
3 order_number
4 first_name
5 last_name
6 order_item_name
7 product_quantity
8 payment_name

Payment name appears.
---------------------------------

In the following one payment name appears empty, there is no payment element field there:

1 created_on
2 full_name
3 order_number
4 invoice_number
5 order_shipment
6 order_payment
7 order_subtotal
8 order_item_name
9 product_quantity
10 custom
11 custom
12 custom
13 custom
14 custom
15 custom
16 order_tax
17 product_basePriceWithTax
18 order_discount
19 custom
20 coupon_discount
21 order_total
23 virtuemart_paymentmethod_id
24 product_price_total
25 discount_percentage
26 order_billDiscountAmount
27 order_billTaxAmount
28 order_tax
29 product_basePriceWithTax
30 product_discountedPriceWithoutTax
31 product_priceWithoutTax
32 product_subtotal_with_tax
33 product_tax
34 payment_name


Both are order export templates.

Checking log file:

LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`

Is normal that payment methods are searched in the language table? cause shipments dont.

Regards

Hello,

Is normal that payment methods are searched in the language table? cause shipments dont.

Yep, because the payment names are language dependent.

As for the payment name being empty, I believe it is fixed in today's release.

Thanks, just updated and tested but we still get empty results in payment_name exported column.

I have tried removing all fields and leaving like 3 and still fails. Also changing template settings but we can't get the payment_name to show.

Happens only with that field, the rest work fine.

Is really strange.

Regards

Hello,

The only reasons I can think of the payment_name to be empty is that the wrong language is set in the export template, so the payment name is being taken from the wrong language table. Other option could be that the payment ID set in the order no longer exists in the payment table.

Hi Roland

I'll leave this as an X-file cause is really strange.

Not a big issue anyway cause we use the payment_element and some replace rules to obtain the exact payment name as we want it.

The templates have the language correctly set and we have not deleted payment methods, one of this templates has the setting "current week" so is difficult that ID's had changed there.

Regards