• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

teesbeanies
#1 Posted : Monday, February 25, 2019 7:28:11 PM(UTC)
teesbeanies

Rank: Member

Joined: 2/25/2019(UTC)
Posts: 1

any guidance (required column labels, etc) for how to import sales tax table?
Aaron
#2 Posted : Tuesday, February 26, 2019 9:17:21 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,273
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 141 time(s) in 136 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
Aaron
#3 Posted : Tuesday, February 26, 2019 9:18:52 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,273
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 141 time(s) in 136 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
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.

©2019 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012