Error on last step of checkout with taxcloud

  • Posts: 176
  • Thank you received: 5
  • Hikashop Business
7 years 7 months ago #266893

We just enabled taxcloud and on the last step of checkout we are receiving the following error:

1054
Unknown column 'product_taxability_code' in 'field list' SQL=SELECT product_id, product_taxability_code FROM #__hikashop_product WHERE product_id IN (170424) AND product_access='all' AND product_published=1 AND product_type=‘main'

The orders are showing up in the backend, but the cart is not clearing and the order confirmation emails are not sending out.

Pls advise.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 7 months ago #266903

Hi,

You need to configure each of your products' taxability code in the backend. You won't get the error after that.

Please Log in or Create an account to join the conversation.

  • Posts: 176
  • Thank you received: 5
  • Hikashop Business
7 years 7 months ago #266945

I'll give that a try. Do I need to do this for each product individually? (There are about 400)

What is strange is on our staging server (we tested it there first) we did not have to do this step and it worked fine. The only taxability code we entered was in the plugin settings.

Please Log in or Create an account to join the conversation.

  • Posts: 176
  • Thank you received: 5
  • Hikashop Business
7 years 7 months ago #266955

I used a massaction to set the product taxability codes and it is working fine now. Thank you.

I do have a related question: If we use a massaction to update the payment status of orders from 'order received' to 'payment confirmed' will it capture the tax in taxcloud? I know that it does when you manually set it in the administrator, but I want to verify this works when done through a massaction as well.

Thank you,
Dustin

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 7 months ago #266961

Hi,

It depends. If you use the "change status" action, then the system will go through the standard triggers, and save the orders one by one so that the plugins can do their thing. If you use the "update the values" action, then the system will directly update the column data in the database, skipping all that.
The advantage of skipping the triggers and everything is that you can process a lot more orders in your mass action before you reach the limits of your php.ini

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum