My issue is pretty simple. In Canada we collect 3 taxes (PST, GST, HST) depending what province you live in. I know how to add this to OC to collect the tax from the customer. My issue is I need an easy way to show me the amounts collected for each tax (PST, GST, HST) every month. Otherwise it will take hours to calculate this manually.
Do you think I could get this information with a SQL query? I've searched the extensions for weeks and don't find anything that will handle this! How do you guys figure out every month how much tax you've collected when you have multiple tax types?
RE: http://docs.opencart.com/display/opencart/Tax+report
So nobody has a solution for getting totals for multiple taxes with the built-in Tax Porting page? Even after searching these forums and Google I can find no solution to this. Surprising as many countries countries multiple taxes. I've searched but does anyone know of an extension where they can export this data to excel to calculate manually? Someone out there must have faced this problem.
So nobody has a solution for getting totals for multiple taxes with the built-in Tax Porting page? Even after searching these forums and Google I can find no solution to this. Surprising as many countries countries multiple taxes. I've searched but does anyone know of an extension where they can export this data to excel to calculate manually? Someone out there must have faced this problem.
You could do this with an SQL query, based on the title of the tax. All of the line items for an order are recorded into the "order_total" table, and include the title of each tax. (The "code" is also recorded, but this is "tax" for every tax line item, so it's not helpful for separating them.) You'd have to understand MySQL to create the appropriate query, but it would be something like this:
You'd then have to LEFT JOIN that with the "order" table so you could pull appropriate dates. I'd imagine that there is a reporting extension available in the extension store, if you take a look there, although I don't know of any that specifically do this.
Code: Select all
SELECT SUM(value) AS total FROM order_total WHERE title = 'VAT (17.5%)';
Thanks John, at least I know it's possible. I am mystified as to why there seems to be no extension that does this, but moreso that OC doesn't do this with its own built in tax report page. If anyone has a solution or workaround for their own multi-tax situation, please chime in.
Who is online
Users browsing this forum: No registered users and 154 guests