Inventory - Bulk update Sales tax code field
Sales tax code for Products & Services SKUs "Item Name"
When you export the list of items from Products & Services you get a CSV with the fields:
ItemCode ItemName SalesUnitPrice SalesAccount SalesTaxRate InventoryAssetAccount CostOfGoodsSoldAccount
However, there is no field for "Sales tax code" which is used when you're leveraging AutoTax lookup integration with Avalara. Therefore, as we're converting to using AutoTax, we have ~700 SKUs here that we have to manually update ONE BY ONE!!!!
This is insane. Why is this field not able to be edited in bulk like every other field?
Paul Campbell
shared this idea
Hi team, we've released a change to the CSV import for inventory. You'll now find you can bulk update the Avalara sales tax code by importing this with the CSV file. You can find information on preparing data in your import file on Xero Central 😁 Thanks for sharing your idea with us, here!
-
Donielle Van Gieson
commented
Being able to import the Fully Taxable vs Non Taxable sales tax code for every product. Currently the sales tax coding for sales, auto lookup or location based is able to be imported but the option to import if the item is even taxable is the one field that can't be imported into.