Product Variants - Access Level Issues

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

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?

Hmm - it doesn't seem to be having any effect. Can I please confirm that the code (including surrounding code) will look like this?

}
			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';

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

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.

Hi there - as far as I am aware, neither of those extensions have been installed on the website.

Thanks

Hi there - thanks heaps 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)?

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.