Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Retrieve Orders by Country / Province For Total - tax purpose


newnew

Recommended Posts

Hello,

 

I'm in Canada and need to calculate GST and PST for our online orders. For example in a year or 3-months, all orders shipped to Canada will show up so I'll have the total to calculate GST; And all orders shipped to Ontario showing up to calculate PST....

 

But I do not know SQL.... How can I retrieve orders by "country" and "province"??? Is there any ways to do this? Thank you for your help.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...