ACL product prices not working after import

  • Posts: 3
  • Thank you received: 0
8 years 11 months ago #221812

-- 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.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 11 months ago #221821

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 ?

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

  • Posts: 3
  • Thank you received: 0
8 years 11 months ago #221893

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.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 11 months ago #221917

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.

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

  • Posts: 3
  • Thank you received: 0
8 years 11 months ago #222429

Hello

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

Regards
Duncan

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

Time to create page: 0.060 seconds
Powered by Kunena Forum