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.

Thank you.

Hi

I believe that comes from a third party Mod, maybe from Mike Beebe? I would check with him to see if there is a newer version available.

Andy

Please feel free to review / rate our software

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.

safeandsound.

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

ASP and PHP mods - www.dlss.ca/products.asp
A Tremendous Home - Home Decor and Design, D-I-Y Projects, Home Life, Recipes - www.ATremendousHome.com

Cheers to Mike for solving this.

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.

Any suggestions?

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.

Thanks,
David

I received your email. We can go from there to determine what is going on.


Mike Beebe
President,
DataLinks Software Solutions
www.dlss.ca
Rate Me Here

ASP and PHP mods - www.dlss.ca/products.asp
A Tremendous Home - www.ATremendousHome.com
Buy Cigars Online www.CigarSmokeShop.net

Mike,

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.

Glad to hear!



Mike Beebe
President,
DataLinks Software Solutions
www.dlss.ca
Rate Me Here

ASP and PHP mods - www.dlss.ca/products.asp
A Tremendous Home - www.ATremendousHome.com
Buy Cigars Online www.CigarSmokeShop.net

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.

Any suggestions?

I am pretty sure Mike's feed generator has a setup file and in there you can mark products as in stock.
Check there.

David

There is this line in the DLSS Google Merchant Feed.

default_nostock = "in stock"

But the instructions say to leave it as is.

I'll give Mike another shout. I've been bugging him so much lately, I am starting to feel like a pest.

Perhaps because your products structured data shows as out of stock?

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Thanks Peter!

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?

I'm guessing Google must be reading my product Availability from another source other than my feed.

For example, searching this product in Google Images
Lucas Oil 32oz Heavy Duty Oil Stabilizer - 12 Pack

Opening the feed, this product shows this going in:
<g:availability>in stock</g:availability>

Testing the same product with the Google Structured Data testing Tool, it shows this coming out:
http://schema.org/OutOfStock

quote:

---

I'm guessing Google must be reading my product Availability from another source other than my feed

---

Yes, Google will crawl your site and check the info there against the feed.
You need to get the schema issue fixed.

David

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

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:

pInStock = rs("pInStock")
to
pInStock = 1

Correct?

Yes the line in red



Change it to pInStock = 1

That will mean that pInStock becomes greater than 0 and will set pStock to output http://schema.org/InStock to all of your products in the feed.

David