productpage is showing 0 as price, not price & tax

-- HikaShop version -- : latest
-- Joomla version -- : latest
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : no message

Hi after our update to the latest hikashop we noticed that all our prices at the productpage are €0,0. We always showed the price with product on our productpages. So we did some tests and this is what we know now:

1. When you look at the productlist the real prices are showing. ( this is productprice including tax)
2. The prices on the productpages are all €0,0
3. The price restrictions or ACL's are all klicked on. So everybody should be able to see the prices. (but its not)
4. Just to make sure we also onclicked all prices and tried to see what happend. Nothing happend all prices stay €0,0
5. When we fill in a retailprice this will show up at the productpage. This retailprice wich shows the description: normal price. and the price with tax with the description: our price.

So somehow we think the price with tax is not showing on the productpage even when it should. All our prices are filled in at the price including tax box. The retailprice boxes we never used so they are all at 0,0 and we can not go into 3000 productpages and put a new price into the retailbox.

So please do you guys have any idea why the price including tax is not showing and how we can change this?

Here the website we are talking about:

and attacht a screenshot of our settings in productpage backend and of our global settings

Hi,

Well now we found the reason for this 0,0 price. We still need an solution. First of all the variants are needed as we adapt them regular with more or less. In the old versions this was never a problem and it was never a different price. Now we do an update and out of the blue we need to adapt all our (3000) products? That sounds crazy. We can not go into each product and fill in the correct price or delete the variant. Thats a week of work.. minimal.

We dont understand why you guys would make an update like that! Again we simply wanna show the price including tax that we had in our webshop before the update. Is there any way to make this happen? Maybe some change in code?

Hi,

we have over 2000 products with mutiple variants. Think of shoes, and other clothes. We didnt do anything else then press update. We dont wanna delete these variants we simple want the prices how we had it first. Are you saying that with this query you delete the variants, or are you saying that with this query you can simply make every variant get the price that is showing at the product with tax?

also about the configuration of the variants. We never had this option in hikashop so we never did change or do anything to that. Again we update and out of nothing we get a tab called variants with prices 0 and a productpage without the correct price.

ok thank you for the clear explenation. Hereby the screenshots you asked for.

when i click on the pencil before a variant i get a popup screen and then an error.

Hi,

if we delete very price for every variant then the product price with tax will show up. So thanks for that.

This means we have to do a Mysquel query. The last time i did that is years ago so hopefully you can guide me a little here. I will writhe down what steps i think i have to take. Hopefully you can tell me if its correct.

1. I make a backup of the website.
2. i go to phpmyadmin
3. i press SQL. Wich will bring me to a screen that says: start SQL query/queries on server "localhost":
4. i put these exact words into the box:

DELETE from #__hikashop_price where price_value=0

5. i press start.
6. that should be all?

ok we did it an all prices are oke again. thanks as always for the help.

Hi,

So we had to change al our prices back as it made our sales go down badly. So we did do a massaction and lowerd all prices.

We first tried it with one product. Product price got lowered perfectly and also on the productpage the price was fine. Then we did it for al products and bam on the productpages al prices where back to 0.

So we did the query again. But this time the query told us there were 0 changes made. So no cganges and all prices back to 0 on the productpage. For now we put the backup back but we need to lower al prices. Any idea why it makes the prices go to 0 when we do all of them and not when we do 1?

Hi Jerome,

We use joomla 3.4.8. Hikashop 2.6.0
The massaction is shown in attacht screenshot of the settings:

Hi,

Please update to version 2.6.1, we done some fixes on the mass actions.
I just tried your configuration on my local and it is working correctly.

What can be tried it to reduce the quantity of products handled via the limitation fields.