Sitemap and category_pathway

  • Posts: 102
  • Thank you received: 3
10 years 3 months ago #200068

-- HikaShop version -- : 2.4.0

Hello everyone,

Maybe somebody knows how to make normal sitemap for hikashop? I can't to do that normally.

In sitemap i see product link like that:

http://tritatusha.ru/shop/product/2889-detskaya-zubnaya-shchetka-ot-6-12-let-zhestkaya-lion-kid-s-brush-for-6-12-years
But i closed this pages in robots.txt because need other pages to be indexed by Google and Yandex:
http://tritatusha.ru/shop/product/2889-detskaya-zubnaya-shchetka-ot-6-12-let-zhestkaya-lion-kid-s-brush-for-6-12-years/category_pathway-608

I need category pathway because if i don't show them, breadcrumbs will be formed wrong. I need to display category pathway in sitemap. Now i make this SQL query:
SELECT 
 `#__hikashop_product`.`product_name`, 
 `#__hikashop_product`.`product_id` AS `cid`, 
 `#__hikashop_product`.`product_alias` AS `name`
 FROM `#__hikashop_product`
 JOIN `#__hikashop_product_category` ON `#__hikashop_product`.`product_id` = `#__hikashop_product_category`.`product_id`
 WHERE 
 `#__hikashop_product`.`product_published` = '1'
 ORDER BY 
 `#__hikashop_product`.`product_name` ASC

May somebody help to mee? I do this in Jsitemap.
Thnx to all who will try to help me :side:

Last edit: 10 years 3 months ago by Rabbiteggs.

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13673
  • MODERATOR
10 years 3 months ago #200078

Hi,

Make sure that you have the correct URL in the "canonical URL" field of your product.
If that's the case, Jsitemap should normally use that URL over a dynamically generated URL and thus you would get the correct URL in the site map, like with the integration we did with Xmap/mapX.
If the canonical URL is correct in the product but that you don't get it in the site map, I would recommend that you contact Jsitemap support as it might be something they forgot to take into account in their integration with HikaShop.

Please Log in or Create an account to join the conversation.

  • Posts: 102
  • Thank you received: 3
10 years 3 months ago #200127

Hi Nicolas,

Thank you for quick reply. But what i can do if i disabled rel="canonical" because in Joomla it works terrible? It makes wrong canonical everywhere on all pages at the site. Maybe i can make some changes in sql query to join cathegory_pathway to url in sitemap? But i don't know what parameter is it and how it works in hika :dry:

Last edit: 10 years 3 months ago by Rabbiteggs.

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13673
  • MODERATOR
10 years 3 months ago #200144

Hi,

You can still disable rel="canonical" in Joomla and fill in the canonical URL of products.
First, it won't make wrong canonical URLs
Second, JSitemap should be able to use it.
And third, it's way either than customizing the code of JSitemap with complex queries to get the category_pathway, as it is not stored anywhere in the product but generated dynamically on the listings.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum