ACL product prices not working after import

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- Browser(s) name and version -- : All browsers

After importing products with a combination of multiple prices and different access levels; user group prices shown in the back end are not correctly reflected in the front end until I select and then unselect the product access level check box in the back end and resave. I have cleared the cache in Joomla to no avail. Could you please advise? Many thanks.

Hi,

This would indicate that what you have in your CSV is not correct.
Could you provide a small version of your CSV so that we could look at it ?

Hello
Thanks for looking into this.

I have attached the price import. It appears to be selecting the acl correctly when i check in the backend but the front end does not show the price to the group until I select it and unselect it.

Hi,

The value in "price_access" is indeed wrong. Instead of 15|15|15|16|16|16|17|17|17 it should be:
,15,|,15,|,15,|,16,|,16,|,16,|,17,|,17,|,17,

Trailing commas are necessary because of the way the MySQL queries are done on the frontend.
In the backend, it displays fine because the system is nice enough to try to understand it, but on the frontend, that's not possible due to the way the MySQL queries are optimized.
If you export a CSV of a product properly configured via the interface, you'll also see the commas for the price_access column.

Hello

Thank you very much for this.
This appears to have solved the problem for us.

Regards
Duncan