Find items not taxed

Store Builder Questions
1

any way to find items that have no taxes applied ?

2

probably the only way is to export product code and taxes then filter in a spreadsheet

John

3

This is a nuisance.

4

select all products, edit>bulk edit…taxes



John

5

with 45k products, this doesnt work…



direct db solution:



[color=#990099]SELECT[/color][color=#444444][font=Verdana,] [/font][/color][color=fuchsia][font=Verdana,]*[/font][/color][color=#444444][font=Verdana,] [/font][/color]

[color=#990099][font=Verdana,]FROM[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#008000][font=Verdana,]cscart_products[/font][/color][color=#444444][font=Verdana,] [/font][/color]

[color=#990099][font=Verdana,]WHERE[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=#008000][font=Verdana,]tax_ids[/font][/color][color=#444444][font=Verdana,] [/font][/color][color=fuchsia]=[/color][color=#444444][font=Verdana,] [/font][/color][color=#008000][font=Verdana,]''[/font][/color]

[color=#008000][font=Verdana,]finds them… so gather tax_ids from what you need… in my case 16,17,18[/font][/color]



then… update cscart_products set tax_ids='16,17,18' where tax_ids=''