{"id":13818,"date":"2019-08-16T14:30:43","date_gmt":"2019-08-16T21:30:43","guid":{"rendered":"https:\/\/www.crystalcommerce.com\/blog\/?p=13818"},"modified":"2019-08-16T14:30:45","modified_gmt":"2019-08-16T21:30:45","slug":"support-question-of-the-week-setting-multiple-products-as-tax-exempt","status":"publish","type":"post","link":"https:\/\/www.crystalcommerce.com\/blog\/2019\/08\/16\/support-question-of-the-week-setting-multiple-products-as-tax-exempt\/","title":{"rendered":"Support Question of the Week: Setting Multiple Products as “Tax Exempt”"},"content":{"rendered":"\n

Question: I need to set all products in a category as “Tax Exempt”. Is there a way to mass edit them instead of individually editing each product and tagging tax exempt?<\/p>\n\n\n\n

Answer: Yes! If you used the mass create tool, you can upload a csv that will toggle tax exempt on for all products on the spreadsheet. On your inventory page, select the categories you want to make tax exempt, and export to csv.
Once it completes, open the file in excel, and delete all of the columns except for Product Name and Category.
Then, add a third column named Tax Exempt. In all of the rows underneath that column, enter the word Yes.
When you upload that via mass create, it will toggle tax exempt on for all of those products.<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

Question: I need to set all products in a category as “Tax Exempt”. Is there a way to mass edit them instead of individually editing each product and tagging tax exempt? Answer: Yes! If you used the mass create tool, you can upload a csv that will toggle tax exempt on for all products on …<\/p>\n

Support Question of the Week: Setting Multiple Products as “Tax Exempt”<\/span> Read More »<\/a><\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[29,50],"tags":[93,45,47,48,49,51,100],"class_list":["post-13818","post","type-post","status-publish","format-standard","hentry","category-onboarding","category-support","tag-admin","tag-csv","tag-inventory","tag-mass-create","tag-onboarding","tag-support","tag-tax-exempt"],"crystal_rest_feed":{"author":"paulmartin","id":13818,"featured_image":{"original":null,"medium":null,"large":null,"thumb":null},"title":"Support Question of the Week: Setting Multiple Products as “Tax Exempt”","link":"https:\/\/www.crystalcommerce.com\/blog\/2019\/08\/16\/support-question-of-the-week-setting-multiple-products-as-tax-exempt\/","date":"2019-08-16T14:30:43","content":"\nQuestion: I need to set all products in a category as “Tax Exempt”. Is there a way to mass edit them instead of individually editing each product and tagging tax exempt?\n\n\n\nAnswer: Yes! If you used the mass create tool, you can upload a csv that will toggle tax exempt on for all products on the spreadsheet. On your inventory page, select the categories you want to make tax exempt, and export to csv.Once it completes, open the file in excel, and delete all of the columns except for Product Name and Category.Then, add a third column named Tax Exempt. In all of the rows underneath that column, enter the word Yes.When you upload that via mass create, it will toggle tax exempt on for all of those products.\n\n\n\n\n","excerpt":"Question: I need to set all products in a category as “Tax Exempt”. Is there a way to mass edit them instead of individually editing each product and tagging tax exempt? Answer: Yes! If you used the mass create tool, you can upload a csv that will toggle tax exempt on for all products on …\n Support Question of the Week: Setting Multiple Products as “Tax Exempt” Read More »\n","categories":[{"name":"Onboarding","slug":"onboarding"},{"name":"Support","slug":"support"}],"comments":0},"_links":{"self":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/posts\/13818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/comments?post=13818"}],"version-history":[{"count":0,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/posts\/13818\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/media?parent=13818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/categories?post=13818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/tags?post=13818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}