WordPress.org

Ready to get started?Download WordPress

Forums

WooCommerce - excelling eCommerce
[resolved] Tax status needs updating to work for each product (14 posts)

  1. talbot649
    Member
    Posted 1 year 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/

  2. talbot649
    Member
    Posted 1 year 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'...?

  3. mikejolley
    Member
    Plugin Author

    Posted 1 year 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.

  4. talbot649
    Member
    Posted 1 year 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...?

  5. talbot649
    Member
    Posted 1 year 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...

  6. mikejolley
    Member
    Plugin Author

    Posted 1 year 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.

  7. talbot649
    Member
    Posted 1 year 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?

  8. talbot649
    Member
    Posted 1 year 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 :)

  9. redrokit
    Member
    Posted 1 year 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?

  10. mireviewsite
    Member
    Posted 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' ?

  11. mireviewsite
    Member
    Posted 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 ?

  12. apcgallery
    Member
    Posted 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.

  13. mireviewsite
    Member
    Posted 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

  14. thomasjojo
    Member
    Posted 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?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.