Adding UT, CO and WI to Smith_Tax Table

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Item

Qty

Total

{{cartItem.ProductName}}
SKU: {{cartItem.ProductSku}}

{{cartItem.Quantity | number : 2}} x {{cartItem.UnitCost | currency : '$' : 2}}

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your shopping cart.

Subtotal

{{minicart.cartTotals.SubTotal | currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Image

Item

Qty

Total

{{cartItem.ProductName}}
SKU: {{cartItem.ProductSku}}

{{cartItem.Quantity | number : 2}} x {{cartItem.UnitCost | currency : '$' : 2}}

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your shopping cart.

SKU

Product Name

Unit Cost

Qty

Line Total

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your saved shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

Status

Order No.

Order Date

Ship To

Order Total

Pay Total

Balance

Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}

{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}

Home

Product Discus...

SmithCart

Adding UT, CO and WI to Smith_Tax Table

7/5/2011 11:09 AM

aaron case

Joined: 5/6/2011

Posts: 8

Adding UT, CO and WI to Smith_Tax Table

Hello,

When I look at Smith_Tax table, it shows only CA. How do I add flat state taxes for:

UT at 6.05%

WI at 5.5%

CO at 4.5%

7/5/2011 2:41 PM

Mike Damico

Joined: 12/30/2010

Posts: 190

Re: Adding UT, CO and WI to Smith_Tax Table

Before the Zip2Tax integration ($275 a year for 1000 lookups for all 50 states and works with SmithCart, I had it customized) I had to edit the stored procedure in SQL. Look for either (I'm not sure anymore) Smith_GetTaxRate OR Smith_GetTaxState and add your states there.

Hope that helps,

-Mike

7/5/2011 10:04 PM

Joined: 1/1/0001

Posts: 0

Re: Adding UT, CO and WI to Smith_Tax Table Modified By on 7/5/2011 10:12:46 PM

Hi Aaron,

Which version of the Cart are you running?

In Cart v.4.36 we released the following tax enhancements thanks to Mike:

Added a new button on the Store Admin menu titled "Manage Tax Tables" with the following
Add, update and delete tax table records
Import data from CSV file to tax tables.

The following is the CSV import format:

City
County
State
Zip
TaxRate

You can now import data from Zip2Tax.com with real time tax calculation integration.

In the BuyNow module settings tax section added a new radio button option titled “Zip2Tax Real Time Integration”. When selected, the Cart will do a real time lookup to the Zip2Tax service and display the appropriate tax to the user in the cart checkout.

Also, see the following post for the CSV Tax Import Sec Example for v.4.35+.
http://www.smith-consulting.com/Forum...

Thanks

7/6/2011 6:48 AM

aaron case

Joined: 5/6/2011

Posts: 8

Re: Adding UT, CO and WI to Smith_Tax Table

I am running version: 4.28

7/6/2011 10:59 PM

Joined: 1/1/0001

Posts: 0

Re: Adding UT, CO and WI to Smith_Tax Table Modified By on 7/6/2011 11:00:17 PM

Hi Aaron,

Please see the following forum post for directions on populating the tax table:
http://www.smith-consulting.com/Forum...

Thanks, Kevin

7/14/2011 8:12 AM

aaron case

Joined: 5/6/2011

Posts: 8

Re: Adding UT, CO and WI to Smith_Tax Table

I upgraded to the latest SmithCart and I tried to upload a CSV containing the UT and WI information, but I get this error: A critical error has occurred.
Could not load file or assembly 'FileHelpers, Version=2.0.0.0 ... or one of its dependencies. The system cannot find the file specified.

7/14/2011 1:18 PM

Joined: 1/1/0001

Posts: 0

Re: Adding UT, CO and WI to Smith_Tax Table

Hi Aaron,

Copy filehelpers.dll from the install zip to your \bin folder and it should work but the file helpers dll requires full trust. The reason its not copied during the install is because it requires full trust.

Thanks