marvso Posted February 5, 2014 Share Posted February 5, 2014 I am not having success setting up Sales Tax setting for Washington State in US. I set up a tax rule that should add 7.8% to the product (but not shipping). It doesn't add anything to customers purchasing in Washington. Any ideas? Thanks. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 5, 2014 Share Posted February 5, 2014 Let's review: in admin, go to Taxes. The Tax Classes tab has as Current Tax Classes: Standard Tax, Reduced Tax, and Tax Exempt (predefined when installing CubeCart). The Tax Details tab has as Current Tax Details: VAT, and perhaps you added another Tax Detail named GST (General Sales Taxes), and it's enabled. The Tax Rules tab has a set of three Rules for VAT, and perhaps you have added some more. For example: Tax Class: Standard Tax Tax Detail: GST Country: United States (from a drop-down selector) State: Washington (from a drop-down selector) Tax rate: 7.8 (do not enter anything but numbers and decimal point) Apply to: Green Check - Goods Status: Enabled Go to Products and bring a product up for editing, Pricing tab. Tax Class: Standard Tax Tax Included: Red Cross. Go to Store Settings, General tab. Add sales tax to qualifying customers: Yes Tax Customer by: Delivery Address The customer you are testing with is not a member of a Customer Group with tax benefits? The customer you are testing with has a delivery address in Washington? The customer you are testing with is logged in and has chosen the Washington address as the order's delivery address? (We can explore a non-logged in customer later.) Quote Link to comment Share on other sites More sharing options...
marvso Posted February 5, 2014 Author Share Posted February 5, 2014 That worked! Thanks so very much One other question. Is there a way to globally change all products to collect sales tax? Or do I need to manually go in and change each product? Thanks again. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 5, 2014 Share Posted February 5, 2014 There is no feature/function in CC5 to do this in a controlled manner. CC5 does have a place where you can enter an arbitrary SQL statement, but there is no ability to verify a return status. If you have access to your database directly, such as using a utility like phpMyAdmin (a tool typically included in your hosting account control panel), you can browse the CC_inventory table and quickly manually change the tax_type column to 1 for each record. If phpMyAdmin is a no-go for you, let us know if you want to try the CubeCart Database Maintenance SQL Command window. Quote Link to comment Share on other sites More sharing options...
marvso Posted February 5, 2014 Author Share Posted February 5, 2014 I do have phpMyAdmin. I can't seem to locate cc_inventory table however. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 5, 2014 Share Posted February 5, 2014 Sorry, I abbreviate CubeCart as cc. The tables may have a prefix assigned by you when you installed it. Then after the prefix, CubeCart_inventory. Quote Link to comment Share on other sites More sharing options...
marvso Posted February 6, 2014 Author Share Posted February 6, 2014 Got it figured out. Thanks so much for all your help :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.