CSV Export of all orders WITH Invoice number

  • Resolved esprit90

    (@esprit90)


    7 years, 2 months ago

    Dear Ewout,

    For accounts it is very useful to have a CSV output of the invoice information.
    Basically all they need is:
    <InvoiceNr><InvoiceDate><OrderNr><NetAmount><Tax><GrossAmount><NameAddrInfo><VATnumber>

    It would be great if an export like that would be added (with a date and/or InvoiceNr range).

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Ewout

    (@pomegranate)

    Hi! We currently do not have a built in export tool, but there are a number of dedicated exporter plugins available that support PDF Invoice numbers too (like Store Exporter Deluxe for WooCommerce by Visser Labs).
    Even if an exporter doesn’t explicitly support this plugin/invoice numbers, as long as it supports exporting order meta, you can use that too. The invoice number is stored in the meta field _wcpdf_invoice_number.

    Hope that helps!
    Ewout

    Hello,

    We are using the same pluging for our website in France and our accountant need to export the invoice each day with this information :

    Date / invoice n° / AMOUNT EXCUDING VAT / SHIPPING EXCUDING VAT / TOTAL VAT / TOTAL INCLUDING VAT

    How can we do this please ? We are completely lost !

    Thank you very much !

    Our accountant need to export it with a CSV file. Thank you in advance.

    Plugin Contributor Ewout

    (@pomegranate)

    @classequine, when you say “We are using the same pluging for our website in France”, are you referring to the Store Exporter plugin from my previous post? Please contact their support directly if you need help with this!

    If you don’t use that plugin, I’m sorry to let you know that the PDF invoice plugin does not have an exporter facility, so you will need a third party plugin for that.

    Ewout

    Hello,

    I am referring to WooCommerce PDF Invoices & Packing Slips.

    We don’t use currently another plugin. which plugin do you advise us to export invoices in CSV file please ?

    Thank you

    Plugin Contributor Ewout

    (@pomegranate)

    Any plugin that can export custom fields (most WooCommerce CSV exporters do) will do. The invoice number is stored in the field _wcpdf_invoice_number.

    Store Exporter Deluxe for WooCommerce (linked above) is one we recommend.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘CSV Export of all orders WITH Invoice number’ is closed to new replies.