- Posts: 102
- Thank you received: 3
Sitemap and category_pathway
- Rabbiteggs
-
Topic Author
- Offline
Less
More
11 years 5 months ago - 11 years 5 months ago #200068
by Rabbiteggs
Sitemap and category_pathway was created by Rabbiteggs
-- 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:
But i closed this pages in robots.txt because need other pages to be indexed by Google and Yandex:
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:
May somebody help to mee? I do this in Jsitemap.
Thnx to all who will try to help me :side:
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:
Code:
http://tritatusha.ru/shop/product/2889-detskaya-zubnaya-shchetka-ot-6-12-let-zhestkaya-lion-kid-s-brush-for-6-12-years
Code:
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:
Code:
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: 11 years 5 months ago by Rabbiteggs.
Please Log in or Create an account to join the conversation.
11 years 5 months ago #200078
by nicolas
Replied by nicolas on topic Sitemap and category_pathway
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.
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.
- Rabbiteggs
-
Topic Author
- Offline
Less
More
- Posts: 102
- Thank you received: 3
11 years 5 months ago - 11 years 5 months ago #200127
by Rabbiteggs
Replied by Rabbiteggs on topic Sitemap and category_pathway
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:
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: 11 years 5 months ago by Rabbiteggs.
Please Log in or Create an account to join the conversation.
11 years 5 months ago #200144
by nicolas
Replied by nicolas on topic Sitemap and category_pathway
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.
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.164 seconds