Categories
View Replies (4)

Resolved Export Virtuemart invoice date

  1. p.barg
    p.barg
  2. RO CSVI
  3. Wednesday, 22 January 2020
  4.  Subscribe via email
Hello,

I would like to export Virtuemart orders. Most of it works fine, but I need the delivery date (or invoice date). If I select the field delivery_date the output is the string "same as invoice date" and not a date. A field invoice_date is obviously not available for export. I tried to use modified_by as a workaround, but that only works for orders where the status isn't changed later to e.g. refunded.
Any ideas how the invoice date could be exported?

Kind regards,

Petra
0
Responses (4)
p.barg
p.barg
Accepted Answer Pending Moderation
Hi Tharuna,

thank you for answer - I'll take a look at that. Sounds promising :D

Kind regards,

Petra
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Petra,
You're right, the invoice date in not part of the order (and hence probably nothing that can be exported...), but it appears on the invoice. Therefore I thought, that there might be some way/workaround to get that date into the export data.

It is not possible to export invoice date with order. VirtueMart has entries of each invoice generated in #__virtuemart_invoices table with virtuemart_order_id entry. You can use RO CSVI Advanced custom table export and join #__virtuemart_orders and #__virtuemart_invoice table to export created_on (that is invoice date) field with other needed fields.

Am I correct that if I export the field "modified_on" that this is the date the order was last modified? This corresponds to the invoice date in most cases, but unfortunately not in all cases...

Yes modified_on is the date when the order has been last modified.
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. # 2
p.barg
p.barg
Accepted Answer Pending Moderation
Hi Roland,

thanks for your answer. Yes, I know that the delivery date results from Virtuemart (never actually understood how to change things there, e.g. to get a real date printed on the invoice).
You're right, the invoice date in not part of the order (and hence probably nothing that can be exported...), but it appears on the invoice. Therefore I thought, that there might be some way/workaround to get that date into the export data.
Am I correct that if I export the field "modified_on" that this is the date the order was last modified? This corresponds to the invoice date in most cases, but unfortunately not in all cases...

Kind regards,

Petra
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Petra,

That the delivery_date outputs the text Same as invoice date is because that is how VirtueMart stores it. The delivery date field is actually a text field and not a date field.

Where do you see the invoice date in VirtueMart when you edit an order? I don't see this in my setup.
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. # 4
  • Page :
  • 1


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