My website recently got moved to a new Windows server recently and, ever since then, when I run the Google Merchant Product Lister asp, the output xml file will keep ending prematurely and, at the end of the xml file I get this message: "<font face="Arial" size=2> <p>Microsoft SQL Server Native Client 11.0</font> <font face="Arial" size=2>error '80004005'</font> <p> <font face="Arial" size=2>TCP Provider: An existing connection was forcibly closed by the remote host. </font> <p> <font face="Arial" size=2>/GMerchLister.asp</font><font face="Arial" size=2>, line 223</font> "
If I keep running the script about 50 times, finally I can get the entire xml file to populate in full but this is a huge hassle. I spoke with my host company servelink and they do not know what settings they need to change on their end, does anyone have any ideas? The Google Merchant Product Lister asp file worked flawless for me for years and only started giving me this issue when my site was moved to new server.
I have been working with Servelink and Mike Beebe on this exact issue. It's certainly not an ECT issue. With my feed containing over 5000 products, I cannot get a good export no matter what.
I hope it will get resolved soon, but again, not an ECT issue at all.
The driver used needs a few parameters for backwards compatibility of a few OLEDB datatypes in order to fully be compatible with the ECT database. Servelink techs are now aware of it, and if they have not fixed your issue email me. Working with Dave, I have resolved it.
Mike Beebe President, DataLinks Software Solutions www.dlss.ca Rate Me Here
I am posting this here as to not start a new thread and waste bandwidth. This is not an exact issue match but similar.
I purchased the Google Merchant feed and submitted it to Google. There are 2 issues with the feed that I can't seem to get resolved. I am wondering if anyone can shed some light on this.
1) Under Feed Issues, it is showing "Bad XML tag". I have inquired but can't seem to figure out what this is or how to resolve it.
2) I have 15,690 products. However the feed shows 316 products submitted (97% disapproved). Checking the GBase file, it seems to only have 316 products in it. I have inquired but am unable to figure out why only 316 of 15,690 products are showing.
Hi, Mike can probably help, but just so you know, you can download the xml feed file to your computer, and open it in your browser to confirm that all of your products are there.
I uploaded the new feed to Google. I must say it's exciting seeing that green checkmark under the Status of so many products. Most products have been accepted, some still need to be crawled and others need a little tweaking. I might hit you up again for some further advice, but for now I am very happy with the Google Merchant feed.
It's nice to see my products show up in the search results (image results) on Google, now that my GMC feed is working. The only thing is, every one of my products shows a bright red line underneath which reads "Out of Stock". I don't have any products set to "out of stock". I don't use stock management at all.
I'm guessing there is an attribute in the schema that is making all of my products show as Out of Stock.
I am currently using the DLSS Schema Markup but I don't see anything in there that has to do with product availability.
Perhaps because your products structured data shows as out of stock?
"availability" : "http://schema.org/OutOfStock",
Peter
Professional ecommerce web hosting services Shared hosting Windows & Linux | Dedicated servers | Domains | SSL Ecommerce Templates specialists since 2003 https://servelink.com
I was looking in the Google Merchant Feed/GBase.xml file and it shows <g:availability>in stock</g:availability> after each product listing.
I guess I was looking in the wrong place. I know nothing about schema markup (Thats why I purchased the DLSS Product Schema Markup). Where/how can I change the Availability from out of stock to in stock?
Thanks for the info David. I was wondering if Google read my site or just went by the feed.
I'm waiting to hear back from Mike, but it seems that if Google is checking my schema info, my product_schema.asp file shows this about halfway down:
pInStock = rs("pInStock") IF pInStock > 0 THEN pStock = "http://schema.org/InStock" ELSE pStock = "http://schema.org/OutOfStock"
I don't know if this is causing the out of stock message in some way, shape or form but it is the only schema information that I see pertaining to Availability.
I don't have my stock management turned on (never have). But maybe Google is reading the 0 there and hence showing products as Out of Stock.
That bit of code is checking the database to see if there is a quantity set in the products table. If you have never set anything, then it will be 0 there, and that will trigger the out of stock.
I just had a look at my file from Mike and it seems like it expects that you are using stock management.
Ideally you would turn on stock management, set a parameter (there is one) to hide stock levels to the customer unless they are under a set amount, then use the quick entry tool in the admin to set a really high number for stock on all of your products. Like 1000000
Alternately you could modify the file to overcome that too, buy changing this line pInStock = rs("pInStock") to pInStock = 1
And that will change the output to show all products in stock.
Maybe that will get you by until you get with Mike on his best solution.
Thanks David, I will certainly give it a try. Given the amount of products in my database, I think I'll elect the latter suggestion to edit the pInStock line. Just to be sure, the complete change would be:
Google Merchant Product Lister issues
Posted - 11/19/2018 : 05:35:37
