RE:

Imar Spaanjaars

Posted on 06/02/2014 03:52:59

Hi there,

At the web site level, I enabled the option "Include products inside sitemap.xml". However, I am not seeing any products in the site,map.xml file. Is there anything else I need to enable to make this work?

Imar

Replies

Nicolai Høeg Pedersen

Posted on 06/02/2014 10:36:01

Hi Imar

Check these things:

Ecommerce must be attached to a page in the navigation settings
Ecommerce settings on the website must be set (Language, currency etc.)
SEO or SEO Express must be installed.

Hope this helps - otherwise mail me a link and I will have a look.

BR Nicolai

Nicolai Høeg Pedersen

Posted on 06/02/2014 11:59:54

This post has been marked as an answer

Hi Imar

AND it requires that the primary group is set on a product. That should of course not be needed when you only have one group. I'll have someone look at that issue.

BR Nicolai

Votes for this answer: 1

Imar Spaanjaars

Posted on 06/02/2014 13:25:23

Hi Nicolai,

Thanks, it was the primary group that made the difference. Is there a way to batch upddate all products in a group or do I have to manually set the primary group for each product?

Imar

Nicolai Høeg Pedersen

Posted on 07/02/2014 11:16:26

This post has been marked as an answer

You can fire these SQLs in the management center 1 at the time:

alter table [EcomGroupProductRelation] add tempid int identity

update [EcomGroupProductRelation] set GroupProductRelationIsPrimary = 1

where tempid in(

SELECT distinct min(tempid) as id

FROM [ecommerceBikez].[dbo].[EcomGroupProductRelation]

group by GroupProductRelationProductID

)

alter table [EcomGroupProductRelation] DROP COLUMN tempid

Votes for this answer: 1

Imar Spaanjaars

Posted on 10/02/2014 12:41:27

Excellent. Where would I be without you.....

Imar

You must be logged in to post in the forum

Developer forum

RE:

Replies