Using Google Feed Not Generating

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

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.

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*******

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.

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.

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?

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

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.

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.

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".