[Skip to main content](#vessel-content) # ACL product prices not working after import ## - **[duncanj](/forum/user/39499-duncanj "View duncanj's Profile")** - [![duncanj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39499-duncanj "View duncanj's Profile") Topic Author - [ Offline](/forum/user/39499-duncanj) Less More - Posts: 3 - Thank you received: 0 - - 10 years 11 months ago [\#221812](#221812) by [duncanj](/forum/user/39499-duncanj "View duncanj's Profile") *[ACL product prices not working after import](/forum/37-import-export-csv-xls/880667-acl-product-prices-not-working-after-import#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.")* was created by *[duncanj](/forum/user/39499-duncanj "View duncanj's Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2NjctYWNsLXByb2R1Y3QtcHJpY2VzLW5vdC13b3JraW5nLWFmdGVyLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14267 - - 10 years 11 months ago [\#221821](#221821) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[ACL product prices not working after import](/forum/37-import-export-csv-xls/880667-acl-product-prices-not-working-after-import#221821 "-- 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 ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2NjctYWNsLXByb2R1Y3QtcHJpY2VzLW5vdC13b3JraW5nLWFmdGVyLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[duncanj](/forum/user/39499-duncanj "View duncanj's Profile")** - [![duncanj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39499-duncanj "View duncanj's Profile") Topic Author - [ Offline](/forum/user/39499-duncanj) Less More - Posts: 3 - Thank you received: 0 - - 10 years 11 months ago [\#221893](#221893) by [duncanj](/forum/user/39499-duncanj "View duncanj's Profile") Replied by *[duncanj](/forum/user/39499-duncanj "View duncanj's Profile")* on topic *[ACL product prices not working after import](/forum/37-import-export-csv-xls/880667-acl-product-prices-not-working-after-import#221893 "-- 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.")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2NjctYWNsLXByb2R1Y3QtcHJpY2VzLW5vdC13b3JraW5nLWFmdGVyLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14267 - - 10 years 11 months ago [\#221917](#221917) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[ACL product prices not working after import](/forum/37-import-export-csv-xls/880667-acl-product-prices-not-working-after-import#221917 "-- 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, 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2NjctYWNsLXByb2R1Y3QtcHJpY2VzLW5vdC13b3JraW5nLWFmdGVyLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[duncanj](/forum/user/39499-duncanj "View duncanj's Profile")** - [![duncanj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39499-duncanj "View duncanj's Profile") Topic Author - [ Offline](/forum/user/39499-duncanj) Less More - Posts: 3 - Thank you received: 0 - - 10 years 10 months ago [\#222429](#222429) by [duncanj](/forum/user/39499-duncanj "View duncanj's Profile") Replied by *[duncanj](/forum/user/39499-duncanj "View duncanj's Profile")* on topic *[ACL product prices not working after import](/forum/37-import-export-csv-xls/880667-acl-product-prices-not-working-after-import#222429 "-- 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.")* Hello Thank you very much for this. This appears to have solved the problem for us. Regards Duncan Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA2NjctYWNsLXByb2R1Y3QtcHJpY2VzLW5vdC13b3JraW5nLWFmdGVyLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.171 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)