You have no items in your shopping cart.

Wednesday, February 26, 2020 8:20:01 PM

Using Google Feed Not Generating

Avatar

Posted: 4 years ago

#1715 Quote

pankildesai1988

Posted: 4 years ago

#1715 Quote
I have setup the google Feed on the NOP 3.7 and set the Debugging and getting below error.

2016.02.04 06:41:51:6600*******
ExportProducts. Exported 0 products
2016.02.04 06:42:31:3813*******
FeedsController. CategoryFilterList. feedId=1, categoryId=0
2016.02.04 06:42:31:3933*******
FeedsController. ProductFilterList. feedId=1, categoryId=0
2016.02.04 06:51:03:7286*******
FeedsController. CategoryFilterList. feedId=1, categoryId=232
2016.02.04 06:51:35:2934*******
FeedManagerService. GetAllProducts. feedRecId=1, pageIndex=0, pageSize=1000
               Product. start.
               Product. end.
               FeedProductDefault. start.
               FeedProductDefault. end.
               Read SEO Slug. start.
-----------------> Error An item with the same key has already been added.
products.Count=0, productSlugs.Count=0, categoriesName.Count=0, manufacturersName.Count=0, pictures.Count=0, feedProductDefaults.Count=0
Avatar

Posted: 4 years ago

#1716 Quote

Support

Posted: 4 years ago

#1716 Quote
Version 1.37 - February 05, 2015

- fixed bug (product has several active SLUGs). Original NopCommerce store doesn't allow it.

Upgrade plugin. Replace all files into plugin folder and restart your site.
Avatar

Posted: 4 years ago

#1721 Quote

pankildesai1988

Posted: 4 years ago

#1721 Quote
Hello Support,

I am Getting the Same kind of Error Log by Updating the Plugin with Newer Version.
2016.02.09 09:15:22:8401*******
ExportProducts. Exported 0 products
2016.02.09 09:15:33:5287*******
FeedManagerService. GetAllProducts. feedRecId=1, pageIndex=0, pageSize=1000
               Product. start.
               Product. end.
               FeedProductDefault. start.
               FeedProductDefault. end.
               Read SEO Slug. start.
-----------------> Error An item with the same key has already been added.
products.Count=0, productSlugs.Count=0, categoriesName.Count=0, manufacturersName.Count=0, pictures.Count=0, feedProductDefaults.Count=0

duration=00:00:00.6740386

2016.02.09 09:15:33:5287*******
Avatar

Posted: 4 years ago

#1722 Quote

Support

Posted: 4 years ago

#1722 Quote
1. Check plugin version (download new version from our site again).
2. Open the Global.asax in site root folder and add spacebar to the end of the file. Maybe IIS reads old dll file.
3. write me about result.

Write about result. I'll wait.
Last fix must help you.

P.S.
Otherwise I'll write simple TSQL and you will remove double Slug.
Avatar

Posted: 4 years ago

#1723 Quote

pankildesai1988

Posted: 4 years ago

#1723 Quote
Yes we are using the latest version 1.37

Also did the update on Global.asax as well as did IIS Restart.

But Still have the same issue.

Avatar

Posted: 4 years ago

#1724 Quote

Support

Posted: 4 years ago

#1724 Quote
I haven't any ideas.

1. Backup database and run this TSQL script into your database


delete
from UrlRecord
where EntityName='Product' and LanguageId=0 and IsActive=1
  and Id not in
    (select TOP 1 WITH TIES U.Id
    from UrlRecord U WITH (NOLOCK)
    where U.EntityName='Product' and U.LanguageId=0 and U.IsActive=1  
    ORDER BY ROW_NUMBER() OVER(PARTITION BY U.EntityId ORDER BY U.Id DESC))


2. Replace dll file from this archive FeedManager_test.zip. And restart your site.
Try to generate Feed file. I added a new message after Read SEO Slug. start.

Write me about result.

Can I call you on Skype?
Avatar

Posted: 4 years ago

#1725 Quote

pankildesai1988

Posted: 4 years ago

#1725 Quote
Hello Support,

Below is the Error.

2016.02.10 08:34:29:3326*******
FeedManagerService. GetAllProducts. feedRecId=1, pageIndex=0, pageSize=1000
               Product. start.
               Product. end.
               FeedProductDefault. start.
               FeedProductDefault. end.
               Read SEO Slug. start.
               Read SEO Slug. start.2
               Read SEO Slug. end.
               Read Category Name. start.
               Read Category Name. end.
               Read Manufacturer Name. start.
               Read Manufacturer Name. end.
               Read Picture. start.
               Read Picture. end.
               Read Product Specifications. start.
               Read Product Specifications. end.
products.Count=626, productSlugs.Count=626, categoriesName.Count=626, manufacturersName.Count=0, pictures.Count=626, feedProductDefaults.Count=3

duration=00:00:01.2740728

2016.02.10 08:34:29:3326*******
ExportOneProduct. product.Id=662. Prepare Dictinary Default Values.
2016.02.10 08:34:31:0707*******
ExportOneProduct. product.Id=7. Prepare Dictinary Default Values.
2016.02.10 08:34:31:6547*******
ExportOneProduct. product.Id=324. Prepare Dictinary Default Values.
2016.02.10 08:34:32:2227*******
ExportOneProduct. product.Id=365. Prepare Dictinary Default Values.
2016.02.10 08:34:33:0508*******
ExportOneProduct. product.Id=302. Prepare Dictinary Default Values.
2016.02.10 08:34:33:3588*******
ExportOneProduct. product.Id=114. Prepare Dictinary Default Values.
2016.02.10 08:34:33:3588*******
PrepareDictinaryDefaultValues. ProductId=114, dicDefaultValues.Count=1
     Key=CategoryMap, Value=Electronics

2016.02.10 08:34:33:3588*******
           Key=CategoryMap, Value=Electronics

2016.02.10 08:34:33:4058*******
ExportOneProduct. product.Id=617. Prepare Dictinary Default Values.
2016.02.10 08:34:33:6888*******
ExportOneProduct. product.Id=618. Prepare Dictinary Default Values.
2016.02.10 08:34:33:7228*******
ExportOneProduct. product.Id=620. Prepare Dictinary Default Values.
2016.02.10 08:34:33:7488*******
ExportOneProduct. product.Id=619. Prepare Dictinary Default Values.
2016.02.10 08:34:33:7918*******
ExportOneProduct. product.Id=92. Prepare Dictinary Default Values.
2016.02.10 08:34:33:8388*******
ExportOneProduct. product.Id=303. Prepare Dictinary Default Values.
2016.02.10 08:34:33:8738*******
ExportOneProduct. product.Id=366. Prepare Dictinary Default Values.
2016.02.10 08:34:33:8998*******
ExportOneProduct. product.Id=238. Prepare Dictinary Default Values.
2016.02.10 08:34:33:9338*******
ExportOneProduct. product.Id=237. Prepare Dictinary Default Values.
2016.02.10 08:34:33:9708*******
ExportOneProduct. product.Id=236. Prepare Dictinary Default Values.
2016.02.10 08:34:34:0068*******
ExportOneProduct. product.Id=527. Prepare Dictinary Default Values.
2016.02.10 08:34:34:0578*******
ExportOneProduct. product.Id=484. Prepare Dictinary Default Values.
2016.02.10 08:34:34:3919*******
ExportOneProduct. product.Id=165. Prepare Dictinary Default Values.
2016.02.10 08:34:34:6709*******
ExportOneProduct. product.Id=325. Prepare Dictinary Default Values.
2016.02.10 08:34:34:7079*******
ExportOneProduct. product.Id=338. Prepare Dictinary Default Values.
2016.02.10 08:34:35:0059*******
ExportOneProduct. product.Id=368. Prepare Dictinary Default Values.
2016.02.10 08:34:35:0489*******
ExportOneProduct. product.Id=245. Prepare Dictinary Default Values.
2016.02.10 08:34:35:0709*******
ExportOneProduct. product.Id=242. Prepare Dictinary Default Values.
2016.02.10 08:34:35:1239*******
ExportOneProduct. product.Id=79. Prepare Dictinary Default Values.
2016.02.10 08:34:35:1549*******
ExportOneProduct. product.Id=102. Prepare Dictinary Default Values.
2016.02.10 08:34:35:1729*******
ExportOneProduct. product.Id=239. Prepare Dictinary Default Values.
2016.02.10 08:34:35:2139*******
ExportOneProduct. product.Id=115. Prepare Dicti
Avatar

Posted: 4 years ago

#1726 Quote

Support

Posted: 4 years ago

#1726 Quote
I didn't any errors now.
I see that you will try export 626 products.

Don't forget to select Default taxonomy category for Google feed. You can select taxonomy category per Nop category and per Nop product too.

Google doesn't allow to export products without taxonomy category. You can select it on first tab.

Try and write me about result.
Avatar

Posted: 4 years ago

#1727 Quote

pankildesai1988

Posted: 4 years ago

#1727 Quote
Hello, Support

I am getting below error.
ExportOneProduct. product.Id=712. Prepare Dictinary Default Values.
2016.02.10 08:34:39:3711*******
Error. Cann't export product Id=712, errorMessage='', hexadecimal value 0x03, is an invalid character.
2016.02.10 08:34:39:3711*******
ExportOneProduct. product.Id=710. Prepare Dictinary Default Values.
2016.02.10 08:34:39:4201*******
Error. Cann't export product Id=710, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:4201*******
ExportOneProduct. product.Id=559. Prepare Dictinary Default Values.
2016.02.10 08:34:39:4551*******
Error. Cann't export product Id=559, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:4551*******
ExportOneProduct. product.Id=706. Prepare Dictinary Default Values.
2016.02.10 08:34:39:5091*******
Error. Cann't export product Id=706, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:5091*******
ExportOneProduct. product.Id=707. Prepare Dictinary Default Values.
2016.02.10 08:34:39:5541*******
Error. Cann't export product Id=707, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:5541*******
ExportOneProduct. product.Id=80. Prepare Dictinary Default Values.
2016.02.10 08:34:39:6121*******
Error. Cann't export product Id=80, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:6121*******
ExportOneProduct. product.Id=269. Prepare Dictinary Default Values.
2016.02.10 08:34:39:6492*******
Error. Cann't export product Id=269, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:6492*******
ExportOneProduct. product.Id=558. Prepare Dictinary Default Values.
2016.02.10 08:34:39:7032*******
Error. Cann't export product Id=558, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:7032*******
ExportOneProduct. product.Id=271. Prepare Dictinary Default Values.
2016.02.10 08:34:39:7462*******
Error. Cann't export product Id=271, errorMessage=The Writer is closed or in error state.
2016.02.10 08:34:39:7462*******
ExportProducts. PageIndex=0, duration=00:00:11.7576725
2016.02.10 08:34:39:7462*******
ExportProducts. Exported 101 products

I did checked the export file and found that the stripping of HTML Charters are not properly working
We have put
&bull
Bullet into html of product description and that is breaking the export.
Avatar

Posted: 4 years ago

#1728 Quote

Support

Posted: 4 years ago

#1728 Quote
1. Error. Cann't export product Id=712, errorMessage='', hexadecimal value 0x03, is an invalid character.
https://en.wikipedia.org/wiki/End-of-Text_character

Try to change product description for product with Id=712. You should  remove this char.

You can try to remove this special char using this TSQL script.

update Product
set FullDescription=replace(FullDescription,'',''),
    Name=replace(Name,'',''),
    ShortDescription=replace(ShortDescription,'','')


I think you added this char when you updated/inserted product's description from another program... You couldn't add it manually.

2. •
We used mapping for all special HTML symbols in old my versions. But Google allows to upload only several HTML symbols...
I decided to remove all special HTML symbols in my last release, because customers like to add any HTML symbols ...

For example these symbols are allowed
•
®
&deg
™

But I removed them too...
I'll think over it, maybe I'll change code back... or create 2 lists "allowed symbols" and "disallowed symbols".

Powered by nopCommerce

Copyright © 2019 FoxNetSoft. All rights reserved