I seem to be having issues with importing the boundary file for the state of Washington. The boundary file (http://streamlinedsalestax.org/ratesandboundry/Boundary/WAB012011NOV29.zip) is 519M and when I run the Django management command sst_import_boundry it will run for hours and the amount of ram the python process uses will gradually grow to where it takes over 3GB of ram before I finally kill the import. I know it's importing the records because when I go and look at the boundaries in the admin site it shows a total of 400K+ records.
I would like to know A.) If the amount of records I'm seeing sounds like a correct amount for Washington and B.) If the importer isn't "broke" is there a way to speed up the importer so that it takes less time and uses less ram in the process. If the amount of records for the boundaries is 400K+ then it should be noted documentation that it will take forever and consume a lot of ram in the process.
I'm using Satchmo version 0.9.2 (2114) that is installed using pip (-e hg+http://bitbucket.org/chris1610/satchmo#egg=Satchmo). It should also be noted that I'm experiencing issue <<issue 1155>>.
Also, if someone has a better way of going about charging city and county sales tax for the State of Washington then I'm all ears.
The following steps are the steps I took in order to try and use the US_SST module. It might be a good idea to add these steps to the documentation because it might save someone else the time I used trying to figure it out.
Add the us_sst module (tax.modules.us_sst) to your INSTALLED_APPS in your Django settings file.
Run Django syncdb management command.
Update your Satchmo settings so Satchmo uses the new module.
- Go to the /settings/ url in your browser.
- Under the Tax Settings, change the active tax module to "USA: Streamlined Sales Tax."
Download the CSV files from http://streamlinedsalestax.org/ratesandboundry/
Import the boundary and rates CSV files
$ django-admin.py sst_import_rate /path/to/state-rate-file.csv
$ django-admin.py sst_import_boundry /path/to/state-boundry-file.csv