Rank: Member
Joined: 2/25/2019(UTC)
Posts: 1
|
any guidance (required column labels, etc) for how to import sales tax table?
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
If you do an export you'll see the format (tab-delimited) and the columns. Of the columns you get in the export only Bvin, CountryBvin, and Rate are required; the rest are optional. If the Bvin field is blank the import will treat that as a new record; if there is a Bvin value it will do an update on that record. The current limitation of the sales tax import/export is is that it uses ID values for the RegionID and there is no list of these values except in the database (bvc_Region table). The RegionID corresponds to the ID value of a state, for example. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
An alternate to setting up a ton of tax rules is to use the integrated Avalara AvaTax service. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
|
|
Message was deleted by a Moderator. | Reason: Not specified
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.