[Skip to main content](#vessel-content) # Product Variants - Access Level Issues ## - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 1 month ago [\#215060](#215060) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215060 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* was created by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 1 month ago [\#215077](#215077) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215077 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, That's a bug of the current release I think. We've added a patch since the release to fix that. Please download the install package of the current version via the menu My account>My subscriptions on our website and install it on your and that will add the patch to fix that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 1 month ago [\#215175](#215175) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215175 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Good to know that it might be a bug ![:)](/media/kunena/emoticons/8.png ":)") Unfortunately I get this error whenever I try to update: " Table 'fw.pftvd_falang_content' doesn't exist SQL=UPDATE pftvd_falang_content SET published=0 WHERE reference_field IN ('size','type','freshwatersaltwater','floatingsinking') AND reference_table='hikashop_product'" Any thoughts? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 1 month ago [\#215203](#215203) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215203 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, Please edit the file "administrator/components/com_hikashop/helpers/update.php" and replace Code: if(!empty($unpublish)){ foreach($unpublish as $k => $v){ $unpublish[$k] = $db->Quote($v); } $db->setQuery('UPDATE #__falang_content SET published=0 WHERE reference_field IN ('.implode(',',$unpublish).') AND reference_table='.$db->Quote('hikashop_'.$types[$file]['type'])); $db->query(); } if(!empty($publish)){ foreach($publish as $k => $v){ $publish[$k] = $db->Quote($v); } $db->setQuery('UPDATE #__falang_content SET published=1 WHERE reference_field IN ('.implode(',',$publish).') AND reference_table='.$db->Quote('hikashop_'.$types[$file]['type'])); $db->query(); } By Code: if(false) { if(!empty($unpublish)){ foreach($unpublish as $k => $v){ $unpublish[$k] = $db->Quote($v); } $db->setQuery('UPDATE #__falang_content SET published=0 WHERE reference_field IN ('.implode(',',$unpublish).') AND reference_table='.$db->Quote('hikashop_'.$types[$file]['type'])); $db->query(); } if(!empty($publish)){ foreach($publish as $k => $v){ $publish[$k] = $db->Quote($v); } $db->setQuery('UPDATE #__falang_content SET published=1 WHERE reference_field IN ('.implode(',',$publish).') AND reference_table='.$db->Quote('hikashop_'.$types[$file]['type'])); $db->query(); } } It will fix your issue. In the same time, we will create the appropriate patch and include it as an "hot fix" in HikaShop 2.6.0. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 1 month ago [\#215216](#215216) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215216 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hmm - it doesn't seem to be having any effect. Can I please confirm that the code (including surrounding code) will look like this? Code: } if($oneExtraField->field_type == 'wysiwyg') { $field = $xml->reference->table->addChild('field', $fieldTitle); $field->addAttribute('type', 'htmltext'); $field->addAttribute('name', $fieldName); $field->addAttribute('translate', '1'); } } if(false) { if(!empty($unpublish)){ foreach($unpublish as $k => $v){ $unpublish[$k] = $db->Quote($v); } $db->setQuery('UPDATE #__falang_content SET published=0 WHERE reference_field IN ('.implode(',',$unpublish).') AND reference_table='.$db->Quote('hikashop_'.$types[$file]['type'])); $db->query(); } if(!empty($publish)){ foreach($publish as $k => $v){ $publish[$k] = $db->Quote($v); } $db->setQuery('UPDATE #__falang_content SET published=1 WHERE reference_field IN ('.implode(',',$publish).') AND reference_table='.$db->Quote('hikashop_'.$types[$file]['type'])); $db->query(); } } $xml->asXML($destination); } function addUpdateSite(){ if(version_compare(JVERSION,'1.6.0','<')) return false; $config = hikashop_config(); $newconfig = new stdClass(); $newconfig->website = HIKASHOP_LIVE; $config->save($newconfig); $query="SELECT update_site_id FROM #__update_sites WHERE location LIKE '%hikashop%' AND type LIKE 'extension'"; $this->db->setQuery($query); $update_site_id = $this->db->loadResult(); $object = new stdClass(); $object->name='Hikashop'; $object->type='extension'; Thanks for all your help, by the way ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 1 month ago [\#215219](#215219) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215219 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, Please redownload HikaShop 2.6 it will be easier. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 1 month ago [\#215273](#215273) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215273 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Unfortunately I still get the error ( 1146 Table 'fw.pftvd_falang_content' doesn't exist SQL=UPDATE pftvd_falang_content SET published=0 WHERE reference_field IN ('size','type','freshwatersaltwater','floatingsinking') AND reference_table='hikashop_product') when installing it (regardless of whether I change the code - which seems to be overridden once I install it again, despite the error). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 1 month ago [\#215306](#215306) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215306 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, You don't need to change any code. The fix was added in the install package on our website. That's why you need to redownload it in order to get the patch in the back/helpers/update.php file of the package so that when you install the new version of the package, you don't get the error. If you still have it, there is a high chance that you're not using the new package we put on the website after you reported the issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 1 month ago [\#215310](#215310) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215310 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Can I please confirm whether you mean Hikashop Starter or Hikashop Business? I have downloaded the Hikashop business again however am still getting the error. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 1 month ago [\#215315](#215315) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215315 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, Do you have Joomfish or Falang installed in your website ? Or does one of these components has been installed before ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 1 month ago [\#215453](#215453) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215453 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi there - as far as I am aware, neither of those extensions have been installed on the website. Thanks ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 4 weeks ago [\#215456](#215456) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215456 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, If you have that error, it means that you have either the folder administrator/components/com_falang or administrator/components/com_joomfish on your website. So you probably had one of them installed before, one way or another. Rename the folder via FTP and try again and you shouldn't get the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 4 weeks ago [\#215500](#215500) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215500 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi there - thanks heaps ![:)](/media/kunena/emoticons/8.png ":)") That appears to have fixed it! It now shows two prices instead of one (so shows both the retail and wholesale price) - is it possible to get it to only show the wholesale price to a business user (even if the user is in multiple groups)? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 4 weeks ago [\#215501](#215501) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215501 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, The "retail price" is just an informative price and does not replace the product prices. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")** - [![Fishwise's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35566-fishwise "View Fishwise's Profile") Topic Author - [ Offline](/forum/user/35566-fishwise) Less More - Posts: 24 - Thank you received: 0 - - 11 years 3 weeks ago [\#215983](#215983) by [Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile") Replied by *[Fishwise](/forum/user/35566-fishwise "View Fishwise's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#215983 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Do you have any suggestions on how to make it appear less confusing? As for the wholesale user there is no indication as to what the two different prices mean. [ ![pricing.png](/forum/attachment/26799) ](/forum/attachment/26799 "pricing.png") - [ ![pricing.png](/forum/attachment/26799) ](/forum/attachment/26799 "pricing.png") [ ](/forum/attachment/26799?download=1 "pricing.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 3 weeks ago [\#216025](#216025) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Variants - Access Level Issues](/forum/26-product-category-display/879434-product-variants-access-level-issues#216025 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.4.36-0+deb7u1 -- Browser(s) name and version -- : Chrome Hopefully this is just me getting a bit confused and mixing things up! I have two sets of prices - wholesale prices, which I intend to assign to all "Business" users, and retail prices, for guests, registered users etc. These are the site's user groups: Public - Business - Guest - Manager - Registered - - Author - - - Editor - - - - Publisher - - Super Users Let's say the wholesale price is $15 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - Yes - Guest - No - Manager - No - Registered - No - - Author - No - - - Editor - No - - - - Publisher - No - - Super Users - No And the retail price may be $20 inc GST - the following I have checked for the variant's ACLs: Public - Yes - Business - No - Guest - Yes - Manager - Yes - Registered - Yes - - Author - Yes - - - Editor - Yes - - - - Publisher - Yes - - Super Users - Yes My test business account is part of the following user groups: Business and Registered However - when looking at the page - the Business account is still only seeing the $20 Retail price, and not the $15 Wholesale price. Is there any issue with my access level ordering, or is it perhaps an issue with the user having multiple access levels? Thanks heaps :)")* Hi, You can edit the file "listing_price" of the view "product" via the menu Display>Views in order to customize the price display the way you want and make it clearer for your need. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Nzk0MzQtcHJvZHVjdC12YXJpYW50cy1hY2Nlc3MtbGV2ZWwtaXNzdWVzP3RtcGw9bWFya2Rvd24=) 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.384 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)