Change VAT Rate in existing invoicies (Database)

  • Resolved agrofluid

    (@agrofluid)


    2 years, 4 months ago

    Due to a wrong entry in our tax settings all invoices issued to Austrian customers show 23% VAT instead of 20%. We have fixed the issue and all new orders show the correct VAT.
    But what to do with the already printed invoices showing the wrong VAT.
    How can we change the Tax Rate for those invoices and then print them again.
    Perhaps a SQL Query on the database might solve the problem? Which tables in the DB have to be considered? Any suggestions are very much appreciated.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Darren Peyou

    (@dpeyou)

    Hey @agrofluid,

    Do you have a ton of orders to modify? Your question regarding the database tables would be to WooCommerce, since you are talking about the WooCommerce orders here.

    This code snippet would allow you to modify orders of any status, this allowing you to click the ‘Recalculate’ button which would recalculate taxes:

    add_filter( 'wc_order_is_editable', '__return_true' );

    Thread Starter agrofluid

    (@agrofluid)

    Dear Darren

    Many Thanks. Works fine.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Change VAT Rate in existing invoicies (Database)’ is closed to new replies.