Wrong Kelkoo feed file

Hello,

Just bought your amazing feedmanager and installed it.

Using Kelkoo-feed did unfortunately not work as expected. I got successfully generated this feed:

BUT on kelkoo website I only could choose between “Google (XML” and “ShoppingFeeder”. Both did not accepte/parse this generated feed. I generate a second “Google”-Feed named kelkoo in the feedmanager and this one could be parsed by Kelkoo ?

Why a special kellkoo-feed in Feedmanager ?

We added this template two years ago and we used this documentation
http://support.kelkoo.com/uk/pages.php?page=4447.

I see that this page doesn't work now.
Maybe Kelkoo changed its feed file.
It's not a problem.
We'll change it free but can you help us too?

I read this URL
https://www.kelkoogroup.com/kelkoo-developer-network/kelkoo-feeds/catalog-feed/

Can you ask Kelkoo support about the best type of feed file for them?
Send me documentation and I'll create new template.
It's not difficult because all settings are in external XML files.

Thank you for quick answer.

I have another problem, that at least occurred on the google feed (but I assume it is the same for all feeds)

I implemented some pictograms:


For this I used ProductPicture-table as well and just changed this method in Nop.Services.Media.PictureService like that:

    public virtual IList<Picture> GetPicturesByProductId(int productId, int recordsToReturn = 0)
        {
            if (productId == 0)
                return new List<Picture>();
            var query = from p in _pictureRepository.Table
                        join pp in _productPictureRepository.Table on p.Id equals pp.PictureId
                        orderby pp.DisplayOrder
                        where pp.ProductId == productId &&
                        (pp.IsPictogram == null || pp.IsPictogram == false) //new by Festemidler
                       select p;
            if (recordsToReturn > 0)
                query = query.Take(recordsToReturn);
            var pics = query.ToList();
            return pics;
        }

As you can see added I a bool to table telling if it’s an ordinary productPicture or a pictogram.

For some products in feed having pictograms, the pictogram-picture is taken instead of the picture having “pictogram==null or false”.

I run feed generation in debug mode and it seems you do not use that method. Do you have implemented own method to get productpictures ? What do you suggest I could do ? As you see, I did just change the query, not the method-call itself.

I shall contact Kelkoo according the feed spec.

Plugin has internal PictureService for creating pictures without watermark and in JPG format.
But if you need to use your own PictureService you can do it too.
Open plugin configure page and enable 'Use external picture service'.
Plugin will use your own PictureService.

I think it is that link you are looking for ?

https://www.kelkoogroup.com/kelkoo-customer-service/support-for-merchants/shopping-guides/product-data-feed/

I tested now with setting "use external picture service". It still does not jump into Nop.Services.Media.PictureService.GetPicturesByProductId(..)
Where does the feedManager gets the is the picture-object from database to generate picktureURL ?

>"use external picture service"

If you enable this parameter plugin will use internal NopCommerce PictureService using interface IPictureService.
but I think I showed you bad way.

Can you open the stored procedure
FNS_FeedManager_ProductLoadAll

and try to find this code

--Picture
  SELECT PM.ProductId,PM.DisplayOrder,P.Id,P.IsNew,P.MimeType,P.SeoFilename
  FROM Product_Picture_Mapping PM WITH (NOLOCK),Picture P WITH (NOLOCK)
  WHERE PM.PictureId=P.Id and PM.ProductId in (select ProductId from #ExportProducts)
  ORDER BY PM.ProductId,PM.DisplayOrder ASC
--end Picture

You can add new conditions and select only necessary pictures.

--Picture
  SELECT PM.ProductId,PM.DisplayOrder,P.Id,P.IsNew,P.MimeType,P.SeoFilename
  FROM Product_Picture_Mapping PM WITH (NOLOCK),Picture P WITH (NOLOCK)
  WHERE PM.PictureId=P.Id and PM.ProductId in (select ProductId from #ExportProducts)
and (pm.IsPictogram == null || pm.IsPictogram == false)

  ORDER BY PM.ProductId,PM.DisplayOrder ASC
--end Picture

https://www.kelkoogroup.com/kelkoo-customer-service/support-for-merchants/shopping-guides/product-data-feed/

Yes.
It's a good URL.
I'll check this template and answer you.

Hello again,

that worked fine ! Thanks for amazing and very quick support !
Looking forward to updated kelkoo-feed.

Download the new release from our site and try to create the feed file.

Read this documentation
https://www.kelkoogroup.com/kelkoo-customer-service/support-for-merchants/shopping-guides/feed-layout-fields-details/#toc1

This feed file has the MerchantID.  You must add it. MerchantID=offer-id
Don't forget about merchant-category

I added the main fields in this template.

Please try and write me about result.