Zones and blank fields

  • Posts: 234
  • Thank you received: 4
5 years 2 months ago #303150

-- url of the page with the problem -- : draganfly.co.uk
-- HikaShop version -- : 4.0.2
-- Joomla version -- : 3.9.0
-- Browser(s) name and version -- : Chrome

Hello,

I have lots of customers where the county/state has been removed from the country. The county/state still is in hika shop however isn't associated to the country. There is also an issue which I have no idea if it is related where the country has lots of blank sub-zones (see screenshot).

I found out that the sub-zones were missing because lots of my customers started not being charged vat, the country they were listed was to be charged vat but if their address contained a sub-zone that was no longer in their country it wouldn't charge them.

I hope this makes sense.

Attachments:
Last edit: 5 years 2 months ago by mad-q.

Please Log in or Create an account to join the conversation.

  • Posts: 81513
  • Thank you received: 13068
  • MODERATOR
5 years 2 months ago #303170

Hi,

To handle the zones in HikaShop, there are two tables in the database:
- hikashop_zone which stores the information of each zone
- hikashop_zone_link which stores the links between the parent zones and the subzones.
If you have blank lines, it means that there is an entry in hikashop_zone_link pointing to a zone that has been deleted in hikashop_zone.
I would recommend to delete these two tables, install again the install package of HikaShop 4.0.2 and that will put back all the zones as they were by default. Then, add the zones that you need (if any), relink the zones in the "zone" setting of your tax rules, payment methods, shipping methods, discounts, coupons if you set any and you should be good to go again.

Please Log in or Create an account to join the conversation.

  • Posts: 234
  • Thank you received: 4
5 years 2 months ago #303220

Hello Nicolas

Thanks for this however I don't have any tables containing the word zone.

ra2bt_hikashop_address
ra2bt_hikashop_badge
ra2bt_hikashop_banner
ra2bt_hikashop_cart
ra2bt_hikashop_cart_product
ra2bt_hikashop_category
ra2bt_hikashop_characteristic
ra2bt_hikashop_click
ra2bt_hikashop_config
ra2bt_hikashop_currency
ra2bt_hikashop_discount
ra2bt_hikashop_download
ra2bt_hikashop_email_log
ra2bt_hikashop_entry
ra2bt_hikashop_field
ra2bt_hikashop_file
ra2bt_hikashop_filter
ra2bt_hikashop_geolocation
ra2bt_hikashop_history
ra2bt_hikashop_limit
ra2bt_hikashop_massaction
ra2bt_hikashop_order
ra2bt_hikashop_orderstatus
ra2bt_hikashop_order_product
ra2bt_hikashop_payment
ra2bt_hikashop_plugin
ra2bt_hikashop_price
ra2bt_hikashop_product
ra2bt_hikashop_product_category
ra2bt_hikashop_product_related
ra2bt_hikashop_shipping
ra2bt_hikashop_shipping_price
ra2bt_hikashop_tax
ra2bt_hikashop_taxation
ra2bt_hikashop_user

Cheers
Iain

Please Log in or Create an account to join the conversation.

  • Posts: 81513
  • Thank you received: 13068
  • MODERATOR
5 years 2 months ago #303226

Hi,

Then please click on the "check database" button of the Hikashop configuration page. It will check that all the tables of HikaShop are there.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum