You have no items in your shopping cart.

Friday, October 4, 2024 12:15:35 PM

Wrong Kelkoo feed file

Posted: 7 years ago

#6586 Quote

info@skrujernet.no

Posted: 7 years ago

#6586 Quote
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 ?

Posted: 7 years ago

#6587 Quote

Support

Posted: 7 years ago

#6587 Quote
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.



Posted: 7 years ago

#6590 Quote

info@skrujernet.no

Posted: 7 years ago

#6590 Quote
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.

Posted: 7 years ago

#6591 Quote

Support

Posted: 7 years ago

#6591 Quote
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.

Posted: 7 years ago

#6592 Quote

info@skrujernet.no

Posted: 7 years ago

#6592 Quote
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/

Posted: 7 years ago

#6594 Quote

info@skrujernet.no

Posted: 7 years ago

#6594 Quote
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 ?

Posted: 7 years ago

#6596 Quote

Support

Posted: 7 years ago

#6596 Quote
>"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




Posted: 7 years ago

#6597 Quote

Support

Posted: 7 years ago

#6597 Quote
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.

Posted: 7 years ago

#6607 Quote

info@skrujernet.no

Posted: 7 years ago

#6607 Quote
Hello again,

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

Posted: 7 years ago

#6608 Quote

Support

Posted: 7 years ago

#6608 Quote
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.

Powered by nopCommerce

Copyright © 2023 FoxNetSoft. All rights reserved