Tax status needs updating to work for each product

  • Resolved talbot649

    (@talbot649)


    11 years ago

    Hi there,

    I’ve got a major problem with my woocommerce shop. I’ve uploaded around 14,000 products successfully and I’m ready to launch.

    The problem I have is that the tax (UK VAT) is not adding at the checkout for the products, just for the shipping. If I go into the admin for the product and look in the Product Data (General tab) the Tax Status is set as ‘Taxable’ and the ‘Tax Class’ is set as ‘Standard’, however it won’t register on the front end.

    If I click the drop down list for ‘Tax Class’ and reselect ‘Standard’ then update the post it works fine at the front end, but I can’t go through and do this for 14,000 products!

    Is there an update I can apply to the database itself to bulk update all these products?

    Your help would be greatly appreciated.

    http://wordpress.org/extend/plugins/woocommerce/

Viewing 13 replies - 1 through 13 (of 13 total)
  • Thread Starter talbot649

    (@talbot649)

    11 years ago

    Please could someone help with this?

    I’m not a complete novice but by no means advanced. I was thinking there could be a SQL query to run on the database to update all tax entries, either to another class that I could set as 20% VAT or switch it to ‘zero’ then back to ‘standard’…?

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    11 years ago

    How did you import these products? Tax Class should be ” for standard (blank). Check your data in the database to see how its actually formatted, or whats missing.

    You can use a CSV import extension to ‘merge’ correct values should you need a faster way to bulk edit.

    Thread Starter talbot649

    (@talbot649)

    11 years ago

    Thanks for coming back to me.

    I used the CSV Import plugin (http://wordpress.org/extend/plugins/woocommerce-csvimport/) to get the data into the site in the first place.

    A snapshot of two lines of the database table -postmeta is:

    meta_id ↓ = post_id ↓ = meta_key ↓ = meta_value ↓ =
    3771 769 _tax_status taxable
    3772 769 _tax_class standard-rate

    I was wondering if I could run a query on this table to change the -tax-class and then change it back – see if that solves the problem…?

    Thread Starter talbot649

    (@talbot649)

    11 years ago

    Hopefully someone familiar with SQL queries could suggest something simple to find all ‘standard-rate’ in the table and replace with something else?

    Really desperate to solve this…

    Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    11 years ago

    Does that importer provide a merge? My paid one does…

    Otherwise some SQL could do it. Do it via PHPMYAdmin

    update wp_postmeta set meta_value = ” WHERE meta_value = ‘standard-rate’ AND meta_key = ‘_tax_status’

    Tweak the table name and back up first.

    Thread Starter talbot649

    (@talbot649)

    11 years ago

    Thank you for your help.

    So with this code:

    update wp_postmeta set meta_value = ” WHERE meta_value = ‘standard-rate’ AND meta_key = ‘_tax_status’

    It would replace ‘standard-rate’ with an empty value? And should I then run another to change it back, or will an empty value count as the standard tax rate?

    Thread Starter talbot649

    (@talbot649)

    11 years ago

    Yes that fixed it – thank you!

    I updated the meta_key from ‘_tax_status’ to ‘_tax_class’ but that’s a minor detail.

    14,000 products now working 🙂

    redrokit

    (@redrokit)

    11 years ago

    I’ve got three sites using the woocommerce plugin and that tax doesn’t show on any of them. Tried the demo on Woocommerce theme site for their shopping cart and didn’t see tax on checkout either. Read the documentation a million times and can’t get it to work on any of the sites. Any one have any insight on why tax doesn’t show up on checkout?

    mireviewsite

    (@mireviewsite)

    10 years, 8 months ago

    talbot649: Where did you find the update wp_postmeta set meta_value = ” WHERE meta_value = ‘standard-rate’ AND meta_key = ‘_tax_status’ ?

    mireviewsite

    (@mireviewsite)

    10 years, 8 months ago

    I have same problem with you. I was already added the tax rate on standard but unfortunately they cannot show up in the checkout page ? Is there anything I can fix the issue ?

    apcgallery

    (@apcgallery)

    10 years, 8 months ago

    mireviewsite: It is SQL code inputted through PHPMYAdmin. If you have access to PHPMYAdmin, you should be able to find it in your hosting site’s diashboard.

    mireviewsite

    (@mireviewsite)

    10 years, 8 months ago

    What possible problem why the tax rates doesn’t show up in woo commerce checkout page ?Do I need to update there in PHPMYAdmin ? DO you know how to fix this ? Thanks

    thomasjojo

    (@thomasjojo)

    10 years, 7 months ago

    talbot64..

    I need you to tell me what did you do exacley in your DB to show the products WITH tax, mine is showing all products without tax. my taxrate is 1,25 and settings should add that to the price?

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Tax status needs updating to work for each product’ is closed to new replies.