More Products by this artist

Hi Nicholas,

I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown.

Am I doing something wrong or is this a bug.

Please see the definition attached.

Gert.

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 ?

Yes I did that.

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

Sorry, was in Birma for a couple of days without any internet access. I PM you the login details.

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

Did you change anything? The page that always showed wrong is now ok!?

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

Hmm,

Then it probably has something to do with the fact that I installed the latest version last Thursday. Didn't check it after that any more.

Anyway, will let you know if I find the problem somewhere else.

Thanks.

Nicolas,

The problem is still there. Look at this page:

www.thaihandmadecraft.com/cms/index.php?...y_pathway=29&lang=en

You will see that there are products shown from other artists.

Gert.

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

Thanks so much Nicholas,

Working fine now!

Gert.

Hi Nicholas,

Unfortunately it's still not what I need. Now if I first go to the category artists and then select a product it goes well. But if I start from the category product categories it shows products from the product category, not from the artist.

What I need is that whereever I come from, if I display a product page, on that page I only want to see products that were made by the same artist as the product I am showing.

Any idea how I can achieve that?

Gert.

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

to the code:

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

And, for all your products, the first category you add to it should be the artist category. If it's always the last, then, you should replace ASC by DESC.

Hi Nicolas,

Followed your recommendations but still the same problem.

Changed your code to DESC because the artist is the second category. But it doesn't change anything.

Gert.

Could you paste the code around your modifications ?

Hi Nicolas,

Not sure what you mean. What would you like to see? By the way, you can still login to the site if it helps.

Gert.

Nicolas,

Solved the issue already. It was a problem in the database, not in the code.

Gert.

Nicholas,

After working almost 6 months with the system I still have a problem with the above.

The problem is that if an artist has a lower id than the product category it always comes in the first place, even if i add it after the product category.

The ASC, DESC part is therefor not working.

Any other way this can be solved?

Gert.

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.