Categories
View Replies (13)

Resolved Order (Advanced) not exporting custom shopper field

  1. roderic
    roderic
  2. RO CSVI
  3. Saturday, 08 June 2024
  4.  Subscribe via email
Unfortunately I only discovered today, because I customer told me, that a custom shopper field, aufstragsnummer, is not exporting anything, even though there are values in the database. If I run the same query as in the logfile, I get the value that is stored in the DB, it's just not in the exported XML file.



SELECT `auftragsnummer`,`phone_2`,`phone_1`,`company`,`address_1`,`address_2`,`zip`,`city`,`virtuemart_country_id`,`managersqlid`,`first_name`,`last_name`,`middle_name`,`title`,`fax` FROM `nawssrt4_virtuemart_order_userinfos` WHERE `virtuemart_order_id` = 661 AND `address_type` = 'BT';


Result:
auftragsnummer-query.png

But as I said, nothing in the exported XML file.

As a test, I filled in this value in the column customer_note and added that in the export layout. This time the value is there. However, this is a textarea, so I'd like to use the auftragsnummer field, which is a text field.

Cheers!
Attachments (1)
auftragsnummer-query.png auftragsnummer-query.png
0
Responses (13)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Roderic,

The missing value is not something I can reproduce. In both the regular and the advanced order export I get the value as stored in the database. Did you add the field to the XML layout in the template?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
roderic
roderic
Accepted Answer Pending Moderation
Yes, I added the value, I also added a default value, to see if it would export something then, and it did, but just the default value and not the actual value in the database. So, there is no typo or something in that order.

I just tried exporting another field, managersqlid, to see if it is just that column. But same story.

It just doesn't make any sense :D

Logfile attached
Attachments (1)
com_csvi.log.82832.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
We have tested this issue in two different machines and not able to reproduce the issue of missing value. I can also see the value in export file. Can we have the site login details to check? You can post it in Site details tab under your reply. We can check what is going wrong in your export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
I just noticed from debug log that you are using override for export. Please check export without override file. See if that works. There could be possibility that override file has outdated code and is causing the issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
roderic
roderic
Accepted Answer Pending Moderation
Good morning,

I have already tested exporting without override, this did not change anything. I then tried creating a new Order template (non-advanced), here the value was there in the export. I then created a new Advanced order template with the same layout, the value is there now as well. I'm currently comparing the 2 templates. I'll keep you posted, but I'm thinking, it is just a bug that came into the original template and I've been copying that same template for several other templates.

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 5
roderic
roderic
Accepted Answer Pending Moderation
Ok, I have found the problem. If you set Order address type to any option instead of Do not use, you need to add shipping_xx and billing_xx fields as well.
In the layout it will then look like:



<customer_note>[auftragsnummer][billing_auftragsnummer][shipping_auftragsnummer]</customer_note>


Not sure if that was intended that way?
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If you set Order address type to any option instead of Do not use, you need to add shipping_xx and billing_xx fields as well.

You need to add the field for which the order address type is set. If you have set address type as billing address then use billing_xx field else if address type is set to shipping address then use shipping_xx field. You don't need to use all the fields. You have address type set to Billing address so do you have auftragsnummer value saved for this billing address?

Not sure if that was intended that way?

That is not the intended way. You only need one field based on order address type.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
roderic
roderic
Accepted Answer Pending Moderation
Hello,

It is actually set to Billing or Shipping address. So it will load the Shipping address if one is given, else, it will default back to the billing adress. That all works fine. I do however not understand why this influences a field like auftragsnummer which is not a shipping nor billing field. Just like customer_note isn't. Therefor having customer_note as a field is sufficient (no customer_note_billing / customer_note_shipping), I would think, this would be the same for a custom field like auftragsnummer, as it is not linked to shipping/billing. So I would say, there is some inconsistency there.

Cheers!
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
why this influences a field like auftragsnummer which is not a shipping nor billing field.

Not sure if you noticed, in VirtueMart when you add a shopper field you have an option of setting to show the field in shipping form. If set to Yes we can add individual values for shopper fields for billing and shipping address. See attached screenshot. To differentiate these values we have billing_auftragsnummer and shipping_auftragsnummer.
Attachments (1)
Screenshot 2024-06-11 at 12.26.21 PM.png Screenshot 2024-06-11 at 12.26.21 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
roderic
roderic
Accepted Answer Pending Moderation
Hi Tharuna,

Yes I have noticed, however, this is not a billing/shipping field, but a cart field. Like customer_note. And for customer_note I also do not have select shipping_customer_note or billing_customer_note. So going by that logic, it should also work with auftragsnummer without shipping_ / billing_
Or am I overseeing something?

auftragsnummer-field.png
Attachments (1)
auftragsnummer-field.png auftragsnummer-field.png
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
We treat all user added shopper fields same way and so you see billing_ and shipping_ for all user added fields. May I ask why not use billing_ auftragsnummer in template since your address type is set to Billing? Does that not work for you?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
roderic
roderic
Accepted Answer Pending Moderation
Hi Tharuna,

Sorry for late reply.

The address type is set to Billing or shipping. It will use Billing except when a customer has set an alternative shipping address, then it will use Shipping. Because of that, I will have to make use of both billing_ and shipping_

So to be clear, it works. However, it works different from customer_note and I do not see why. Since it's not specifically documented, It took me several hours to figure out. So, either more consistency or some documentation around this "issue" would be helpful.

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
We will look into this and see if we can improve the documentation on using these fields.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!