More Products by this artist

Hi,

You need to publish your module in the option "Modules under the product page" in the config under the tab display and not as a normal joomla module. Is that the case ?

Could you give a link to your store so that we can have a look ?

Could you give an example of a page where it doesn't work like you want ?

I didn't change anything yet as I couldn't find anything wrong

Well, your product has two categories, so the module displays the products in the same categories. It's normal.

Now I understand that you would like to see only the products of the category from which the user is coming. In order to do that, you will have to edit the file components/com_hikashop/views/product/view.html.php and change the code:

$query = "SELECT category_id FROM ".hikashop::table('product_category').' WHERE product_id='.$product_id.' ORDER BY ordering';
$database->setQuery($query);
$pageInfo->filter->cid = $database->loadResultArray();


to the code:

$pathway = JRequest::getInt('category_pathway',0);
if(empty($pathway)){
//load products in the same categories
$query = "SELECT category_id FROM ".hikashop::table('product_category').' WHERE product_id='.$product_id.' ORDER BY ordering';
$database->setQuery($query);
$pageInfo->filter->cid = $database->loadResultArray();
}else{
$pageInfo->filter->cid = array($pathway);
}

In order to do that, you will have revert the previous change and edit the file components/com_hikashop/views/product/view.html.php and change the code:

$query = "SELECT category_id FROM ".hikashop::table('product_category').' WHERE product_id='.$product_id.' ORDER BY ordering';

//load products in the same first category
$query = "SELECT category_id FROM ".hikashop::table('product_category').' WHERE product_id='.$product_id.' ORDER BY product_category_id ASC LIMIT 1';

Could you paste the code around your modifications ?

Are you sure that you're using the code ORDER BY product_category_id ASC and not ORDER BY category_id ASC ?
Because product_category_id will order the categories with the first one being the first added in the categories of the product while category_id will order the categories with the first one being the first category created, which is what you're describing.