Global change for taxable items?

You can use the built in import/export function: https://docs.woocommerce.com/document/product-csv-importer-exporter/

Export the products – you just need the SKU, Tax Status and Tax Class columns.

Edit in Excel to set the Tax Staus and Tax Class columns.

I would set a few manually to the correct tax settings first so you can see exactly what needs to be edited.

Re-import making sure the select the ‘Update existing porducts’ checkbox

You have set up the Tax Classes etc in the WooCommerce settings? https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/

Thanks for the reply, seank123.

My client is only collecting taxes from within New York State (where he is located), so I set up the Standard rate for NYS tax rates.

I attempted exporting products, but Excel seems to be having problems with the file. I think the sheer size of even just products (103MB) is giving Excel a problem.

Thanks for getting back @dwny.

Since you’re dealing with a large number of products, you could do the exports/imports in smaller bits like certain categories instead of all at once.

Just to add, another approach would be to use plugins that can make bulk updates to your products directly on your site.

You could check out our Bulk Edit Products, Prices, and Attributes extension and try using it to make the modifications. If you have any questions or require support with the extension, please create a ticket with us – https://woocommerce.com/my-account/create-a-ticket/?form=ticket.

Thanks.

You could also do it directly in the database with PHPMyadmin in Cpanel: https://betterstudio.com/blog/search-and-replace-phpmyadmin/

So

update wp_postmeta set _tax_status =
replace(post_content,'','taxable');

Should change them all to Taxable. Then:

update wp_postmeta set _tax_class =
replace(post_content,'','class-name');

To change to your Tax Class – in my case it’s either ‘standard’ or ‘zero-rated’

I haven’t tried this though so BACKUP EVERYTHING FIRST!!!!!!

• This reply was modified 3 years, 2 months ago by seank123.
• This reply was modified 3 years, 2 months ago by seank123.

Hi,
We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above options were helpful and you were able to proceed as advised.

If you have further questions, please feel free to open a new topic.

Thanks.