Advanced Search

I did this and no issues are there



OK Table "hikashop_address" checked

OK Table "hikashop_badge" checked

OK Table "hikashop_banner" checked

OK Table "hikashop_cart" checked

OK Table "hikashop_cart_product" checked

OK Table "hikashop_category" checked

OK Table "hikashop_characteristic" checked

OK Table "hikashop_click" checked

OK Table "hikashop_config" checked

OK Table "hikashop_currency" checked

OK Table "hikashop_discount" checked

OK Table "hikashop_download" checked

OK Table "hikashop_entry" checked

OK Table "hikashop_field" checked

OK Table "hikashop_file" checked

OK Table "hikashop_filter" checked

OK Table "hikashop_geolocation" checked

OK Table "hikashop_history" checked

OK Table "hikashop_limit" checked

OK Table "hikashop_massaction" checked

OK Table "hikashop_order" checked

OK Table "hikashop_orderstatus" checked

OK Table "hikashop_order_product" checked

OK Table "hikashop_payment" checked

OK Table "hikashop_price" checked

OK Table "hikashop_product" checked

OK Table "hikashop_product_category" checked

OK Table "hikashop_product_related" checked

OK Table "hikashop_plugin" checked

OK Table "hikashop_shipping" checked

OK Table "hikashop_shipping_price" checked

OK Table "hikashop_tax" checked

OK Table "hikashop_taxation" checked

OK Table "hikashop_user" checked

OK Table "hikashop_variant" checked

OK Table "hikashop_vote" checked

OK Table "hikashop_vote_user" checked

OK Table "hikashop_waitlist" checked

OK Table "hikashop_widget" checked

OK Table "hikashop_zone" checked

OK Table "hikashop_zone_link" checked

OK Table "hikashop_warehouse" checked

OK Table "hikashop_email_log" checked

OK Product categories checked

OK Variants orphan links cleaned

OK Joomla users synchronized

OK User email addresses synchronized

As pay does give some service outside the plugin, they say the error is that there are too many requests towards the iDeal server. also asking if i can give them any more logs, can i offer them anything hikashop logs?
I checked the payment log file which has mostly ip's with "no zone found for the coutry code ..."
And purchases show like this:
<pre>BluePsyduck\Ga4MeasurementProtocol\Request\Payload Object
(
[clientId] => 80993421.1729508772
[userId] =>
[timestampMicros] =>
[userProperties] => Array
(
)

[nonPersonalizedAds] =>
[events] => Array
(
[0] => BluePsyduck\Ga4MeasurementProtocol\Request\Event\PurchaseEvent Object
(
[currency] => EUR
[transactionId] => E2Z6Y43
[value] => 40.46
[affiliation] =>
[coupon] => GLOW
[shipping] => 0
[tax] => 6.86
[items] => Array
(
[0] => BluePsyduck\Ga4MeasurementProtocol\Request\Event\Item Object
(
[itemId] => 8720892420725_wit
[itemName] => Night Glow Rood Licht Nachtlampje : Wit
[affiliation] =>
[coupon] =>
[currency] => EUR
[creativeName] =>
[creativeSlot] =>
[discount] =>
[index] => 0
[itemBrand] =>
[itemCategory] => "Accesoires"
[itemCategory2] => "Tafel modellen"
[itemCategory3] => "Alles"
[itemCategory4] =>
[itemCategory5] =>
[itemListId] =>
[itemListName] =>
[itemVariant] =>
[locationId] =>
[price] => 44.95
[promotionId] =>
[promotionName] =>
[quantity] => 1
)

)

[session_id] => 1729508771
[engagement_time_msec] => 1
)

)

)
</pre>

Nothing else pops out that might show an error or delay

Hi,

If you want the tax to apply to everyone, then you should remove the zone restriction in your tax rule.
It should then work automatically without doing anything else, based on what I see on your screenshots with what you already have configured. Just make sure that the tax category of the products match with the tax category of the tax rule like it is already the case with the "GST" tax category on your screenshots.

Hi,

There are two ways to go about it:

1. If you add these products as "bundled products" in another product, then you need to provide a price in that other product. And the tax will be calculated based on the tax category of this product and its price.
So, you could create a special tax rate with a special tax category and a special tax rule to link them together so that the tax amount would be 87.35 - 84.95.

2. Another option would be to add these products as "options" of another product. Then, you could do a view override of product / option in the menu Display>Views and change the line:
if($selectionMethod != 'check')
to:
if(false)
This way, on the product page, you would have 5 options, one per option product, with only one preselected choice for each option.
The total price would be calculated automatically from the price of each option product, and same for the taxes.
So that seems ideal for what you want to do.

-- url of the page with the problem -- : bookshop.school2u.my/booklist?limitstart...&filter_SetType_12=+
-- HikaShop version -- : 4.5.1
-- HikaMarket version -- : 4.1.0
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.4
-- Error-message(debug-mod must be tuned on) -- : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published =' at line 1

When login certain vendor account

visiting product list page as per mentioned

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published =' at line 1

will hit above error?

any clue which source code to check or optmized for this issue?

only happen on certain vendor account, suspect naming or setting of vendor causing this

Hi,

To me, this looks like you didn't configure a tax rule for your Default tax category in the System>Taxes menu.
Could you check there what you have ?
If you have a tax rule there, could you provide a screenshot of its settings ?
Also, could you provide a screenshot of the settings under the Taxes section of the HikaShop configuration page ? These can also influence which tax rule will be enforced.

-- HikaShop version -- : 5.1.0 [2406261918]
-- Joomla version -- : 4.4.6
-- PHP version -- : 8.1.29

Have a bundled product that consists of products with and without tax.

Have calculated the tax free and tax included value.

So the Price and the Price with tax are different

If I choose Tax category as Default or None it matters not as the number entered in either price box gets put into the other box.

Hi,

Thanks for the details.
You don't need two tax rates. You can just have the 10% tax rate.
For products you don't want to be taxed, you can just set their "product tax category" to "none".
For the other products you want to be taxed, make sure the "default tax category" is selected in that "product tax category" setting.
Then, in System>Taxes, you must have one tax rule for that 10% tax rate with the "default tax category" selected in the "tax category" setting. That way, the tax will only apply to the products linked to the default tax category.
You actually could configure a 0% tax rate with another tax category and another tax rule to link them together so that the products exempt would have the 0% tax rat applied to them instead of no tax. But I don't think this is needed.

That way, when you configure HikaShop to display the prices with taxes, you'll see that the products without a tax category won't have anything changed, but the others will have the 10% rate applied to their price.

Sure - for example here: