Categories
View Replies (9)

Resolved Virtuemart Order Export - All products in one order

  1. roderic
    roderic
  2. RO CSVI
  3. Monday, 17 January 2022
  4.  Subscribe via email
Hello once more,

I made an export and all seemed to work as expected. Then today there was an order with 2 items and then I saw it made 2 separate orders in the XML file. I then looked at Advanced Order Export as I saw this exports the Order Items in one order. However this advanced order template is missing quite a lot of fields. Most important: product_gtin.

Is there a way to get GTIN/EAN in the Advanced Order Export?
Or is there a way to get all the Order Items in one Order with the normal Order Export? So basically, have the same XML layout options in the normal Order export as Advanced?

Cheers!
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
I have added support for product table fields to VirtueMart Order Advanced export with attached patch file. Please load the attached patch file, reset tasks and update available fields and then add products table fields to export. Let me know on how it goes.
Attachments (1)
patch_vm_2022_01_25.zip
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. # Permalink
Responses (9)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
Yes we do not support product details in Order advanced export yet. Will add support in order advanced export and send you a patch file.
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. # 1
roderic
roderic
Accepted Answer Pending Moderation
Hello Tharuna,

I have tried the described procedure 4 times, 3 times on the live site and once on the test site and I cannot add additional fields from the Products Table.


Roderic
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
Did you reset tasks and also updated available 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. # 3
roderic
roderic
Accepted Answer Pending Moderation
Hello,

Did you reset tasks and also updated available fields?


Yes, that's what I meant with "the described procedure".
So, what I did is:

1. Load the patch
2. Reset the tasks
3. Update available fields

Result: As far as I can see, no difference. You can check the test site yourself.

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
I am not sure what went wrong with your patch install. I installed the same patch again, reset tasks and updated available fields. Now the product fields show up for order advanced export template. Please check the test site.
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. # 5
roderic
roderic
Accepted Answer Pending Moderation
Hello Roderic,
I am not sure what went wrong with your patch install. I installed the same patch again, reset tasks and updated available fields. Now the product fields show up for order advanced export template. Please check the test site.


I am not sure as well, I did the exact same procedure once more on the livesite and now I was able to select product_gtin... Weird. Very weird.

Anyway, it works now, thanks! :D

To make it complete, I also need:



<InvoiceTitle>[billing_title]</InvoiceTitle>

	<InvoiceFirstName>[billing_first_name]</InvoiceFirstName>

	<InvoiceMiddleName>[billing_middle_name]</InvoiceMiddleName>

	<InvoiceLastName>[billing_last_name]</InvoiceLastName>

	<InvoiceEmailAddress>[billing_email]</InvoiceEmailAddress>

	<InvoicePhone>[billing_phone_1]</InvoicePhone>

	<InvoicePhoneMobile>[billing_phone_2]</InvoicePhoneMobile>

	<InvoiceAddress>[billing_address_1]</InvoiceAddress>

	<InvoiceZipcode>[billing_zip]</InvoiceZipcode>

	<InvoiceCity>[billing_city]</InvoiceCity>

	<InvoiceCountry>[billing_country_name]</InvoiceCountry>

	<InvoiceCountryCode>[billing_country_3_code]</InvoiceCountryCode>

	<InvoiceCompanyName>[billing_company]</InvoiceCompanyName>


These fields work in the normal Order export but not in the Advanced. Could you also add that?

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
Thank you for confirming patch is working. Here is another patch file which includes the billing fields you asked for. Load the patch file, update available fields, run the export and let me know on how it goes.
Attachments (1)
patch_vm_2022_02_02.zip
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 Tharuna,

Seems to work well, thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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