Profile: Support
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
•
®
°
™
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".
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.
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?
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.
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.
IIS reads dll from internal cache.
Open the file Global.asax in the site root folder and spabar bar to the end of the file.
After it IIS recompiles internal cache.
Try it and write about result.
This advise will help you.
It's possible.
For your simple format you can use one of preselected feed types (ex. for Kieskeurig 60)
<products>
<product>
....
</product>
</products>
Try this code
<FeedNetWork>
<Id>450</Id>
<Name>sanalpazar.com</Name>
<Image>sanalpazar.png</Image>
<Schema>sanalpazar.xml</Schema>
<ExportMethodId>60</ExportMethodId>
<DisplayOrder>1</DisplayOrder>
<Documentations>
</Documentations>
</FeedNetWork>
You should change ExportMethodId value 99999
link
If you want to add your new personal type you should use value 99999 - CustomCSV.
If you want to add new feed using existing feed type you should use value from parent feed. Ex. 1 for Google.
<FeedNetWork>
<Id>450</Id>
<Name>sanalpazar.com</Name>
<Image>sanalpazar.png</Image>
<Schema>sanalpazar.xml</Schema>
<ExportMethodId>99999</ExportMethodId>
<DisplayOrder>1</DisplayOrder>
<Documentations>
</Documentations>
</FeedNetWork>
I think I found the bug. You use case-sensitive database mode.
Download new version from our site and try. We changed SQL script. I'll be wait for your answer.