[Skip to main content](#vessel-content)

#   Sales tax for one state only

##

- **[mollyf](/forum/user/549-mollyf "View mollyf's Profile")**
- [![mollyf's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar549.jpg)](/forum/user/549-mollyf "View mollyf's Profile") Topic Author
- [ Offline](/forum/user/549-mollyf)

Less More

- Posts: 27
- Thank you received: 0
-
-

15 years 10 months ago [\#4206](#4206) by [mollyf](/forum/user/549-mollyf "View mollyf's Profile")  *[Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4206 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")* was created by *[mollyf](/forum/user/549-mollyf "View mollyf's Profile")*

Shipping is crazy complicated for my store ([ Miro Cellars](http://www.mirocellars.com/)) because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine directly to customers in very few states. Shipping rates are different for different sets of states.

When I originally set up HikaStore for our site, I tried to account for the different shipping rates. I have since abandoned that idea since it was so complicated and I could not get it to work. I decided to start by working with only a few states that share a rate instead.

However, now I can't get the sales tax working. I think I destroyed some settings when I was goofing around with shipping zones. I only need to charge tax for shipments within California.

Here are my settings:

**System-&gt;Taxes**
Tax Rules
Zone: CA; Rate: CA(9%); Customer type: blank (I set this to all customer types when I set it up); Published: check

**Manage tax categories**
Explorer shows
* Root
--Tax category
---California Tax Category

**Manage rates**
Tax namekey: CA; Rate: 9%

**Zones**
I have listed all the states to which we can ship wine (for now). The only one where the shipping address must pay sales tax is California.
Name in english: California; Name: California; Code 2 letters: CA; Code 3 letters: CA; Type: state; Published: check

**Configuration-&gt;Main**
Type of address used for tax: Shipping
Apply discounts: Before taxts
Default address type: All customer types
Main tax zone: 4511 California

**Display-&gt;Custom Fields**
Table: address; Column name: address_state; Label: State; Field type: Single Dropdown; Required: check; Order: 8; Front-end: check; Back-end Form: check; Back-end Listing: --; Published: check; Core: check; ID: 12

I will also provide a screen shot of the various settings for the state custom field.

Thanks in advance.

Molly  [ ![&#91;img](http://www.hikashop.com/media/kunena/attachments/legacy/images/field_address_state.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/field_address_state.png "&#91;img")

- [ ![field&#95;address&#95;state.png](/forum/attachment/278) ](/forum/attachment/278 "...ress&#95;state.png") [ ](/forum/attachment/278?download=1 "...ress&#95;state.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 10 months ago [\#4210](#4210) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4210 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

The problem is the custom field.
The default address state doesn't have the zone codes as value but the zone namekeys. That's why it doesn't work.

You should try to set the type of your custom field to "zone". If you want to remove states from it, you should just unpublish the zones via the menu System-&gt;Zones

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mollyf](/forum/user/549-mollyf "View mollyf's Profile")**
- [![mollyf's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar549.jpg)](/forum/user/549-mollyf "View mollyf's Profile") Topic Author
- [ Offline](/forum/user/549-mollyf)

Less More

- Posts: 27
- Thank you received: 0
-
-

15 years 10 months ago [\#4212](#4212) by [mollyf](/forum/user/549-mollyf "View mollyf's Profile")  Replied by *[mollyf](/forum/user/549-mollyf "View mollyf's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4212 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

Hm. So now the State field in the front end checkout disappears so the customer can't enter anything. How do I set the Zone information so that the choices appear here? (I deleted all of the bazillion states that came with the HikaShop plugin and added back only the few states to which I can ship. Sorry! I thought I was simplifying, not complicating.)  [ ![&#91;img](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2010_12_27_at_11.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2010_12_27_at_11.png "&#91;img")

- [ ![Screen&#95;shot&#95;2010&#95;12&#95;27&#95;at&#95;11.png](/forum/attachment/279) ](/forum/attachment/279 "...2&#95;27&#95;at&#95;11.png") [ ](/forum/attachment/279?download=1 "...2&#95;27&#95;at&#95;11.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 10 months ago [\#4214](#4214) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4214 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

Instead of deleting them, you should just have unpublished the ones you didn't need. It can be done with a few clicks.
Instead of trying to fix all that, you could just remove all your zones and reinstall hikashop. That will put back all the zones back.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mollyf](/forum/user/549-mollyf "View mollyf's Profile")**
- [![mollyf's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar549.jpg)](/forum/user/549-mollyf "View mollyf's Profile") Topic Author
- [ Offline](/forum/user/549-mollyf)

Less More

- Posts: 27
- Thank you received: 0
-
-

15 years 10 months ago [\#4215](#4215) by [mollyf](/forum/user/549-mollyf "View mollyf's Profile")  Replied by *[mollyf](/forum/user/549-mollyf "View mollyf's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4215 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

Okay, will do.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mollyf](/forum/user/549-mollyf "View mollyf's Profile")**
- [![mollyf's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar549.jpg)](/forum/user/549-mollyf "View mollyf's Profile") Topic Author
- [ Offline](/forum/user/549-mollyf)

Less More

- Posts: 27
- Thank you received: 0
-
-

15 years 10 months ago [\#4224](#4224) by [mollyf](/forum/user/549-mollyf "View mollyf's Profile")  Replied by *[mollyf](/forum/user/549-mollyf "View mollyf's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4224 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

Nope, still not getting tax for an address in California.

I didn't drop the HikaShop tables from the database in PHPMyAdmin, so the settings that are stored in the database are still there. Is there something else I can look at?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 10 months ago [\#4226](#4226) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4226 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

In System-&gt;Zones, do you have all the zones as default ?
Otherwise, delete all the zones there and reinstall. That should put back all of them.
Also, make sure that the state custom field has the default options (you can look at our demo website for the default options).

Also, did you apply the tax category "California Tax Category" to your products ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mollyf](/forum/user/549-mollyf "View mollyf's Profile")**
- [![mollyf's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar549.jpg)](/forum/user/549-mollyf "View mollyf's Profile") Topic Author
- [ Offline](/forum/user/549-mollyf)

Less More

- Posts: 27
- Thank you received: 0
-
-

15 years 10 months ago [\#4392](#4392) by [mollyf](/forum/user/549-mollyf "View mollyf's Profile")  Replied by *[mollyf](/forum/user/549-mollyf "View mollyf's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4392 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

Your quick response time is amazing. Thank you so much for providing the best support for any Joomla! component I've seen so far.

The Zone info for the few Zones I'm using did not change with the reinstall because I didn't delete them before. I will clear the entire list and install again.

Is there a quick way to delete all the zones in phpMyAdmin with a MySQL query? I set the Joomla control panel default to display 100 items per page, but it's still very clicky and tedious selecting and deleting (and unpublishing, for that matter, especially if I get to do this whole process again from a reinstall) the list of 4458 Zones.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 10 months ago [\#4393](#4393) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Sales tax for one state only](/forum/4-how-to/4206-sales-tax-for-one-state-only#4393 "Shipping is crazy complicated for my store () because I'm selling wine--an alcoholic beverage which is highly regulated in the US. Because of various prohibitions and licenses, we can only ship wine...")*

You can just delete the whole content of the tables hikashop_zone and hikashop_zone_link and then reinstall HikaShop. That will put back everything.
In order to empty a table, you can use such query for that:
TRUNCATE TABLE &#96;TABBLE_NAME&#96;
where TABBLE_NAME should be replaced by the name of your table.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDYtc2FsZXMtdGF4LWZvci1vbmUtc3RhdGUtb25seT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.061 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
