any way to find items that have no taxes applied ?
probably the only way is to export product code and taxes then filter in a spreadsheet
John
This is a nuisance.
select all products, edit>bulk edit…taxes
John
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=''