Google Base Feeder Support Thread [OLD]

Quote:

---

Originally Posted by willieray25

when i click disapproved this is all they tell me.

---

Try changing the expiration date to 31. Google doesn't seem to like expirations 365 days into the future.

See if that makes a difference...
JOhn ><>

Quote:

---

Originally Posted by davewest

Actually... it's not that hard! Look in the add-ons for ubc/isbn mod or click...

This mod "Creates UPC and ISBN input field in products.php and stores the information in the products TABLE in the database." It doesn't display them, just creates what the feeder needs.

Once you install and add all your UPC's, then you can use them as the offer ID or by them self, with a simple click in the admin googlebase feeder settings.

The code looks like it may be looking for the auction mod as will so you may have to install it too.

---

I'll check it out and get back to you. Thanks for the info!

Quote:

---

Originally Posted by davewest

Actually... it's not that hard! Look in the add-ons for ubc/isbn mod or click...

This mod "Creates UPC and ISBN input field in products.php and stores the information in the products TABLE in the database." It doesn't display them, just creates what the feeder needs.

Once you install and add all your UPC's, then you can use them as the offer ID or by them self, with a simple click in the admin googlebase feeder settings.

The code looks like it may be looking for the auction mod as will so you may have to install it too.

---

Quote:

---

Originally Posted by hypercoyote

I'll check it out and get back to you. Thanks for the info!

---

Yeah, this doesn't really help. All it does is add the UPC fields to the form where you fill out the product info. I was able to get that once I installed Auction Site Attributes. What I need is for Google Base Feeder to pull in those records from the table to the XML file it outputs.

Quote:

---

Originally Posted by hypercoyote

Yeah, this doesn't really help. All it does is add the UPC fields to the form where you fill out the product info. I was able to get that once I installed Auction Site Attributes. What I need is for Google Base Feeder to pull in those records from the table to the XML file it outputs.

---

If both auction and upc area installed and you turned them on in admin -> Configuration -> Google Base Feeder Configuration -> Activate Auction Site Attributes

Then upc should show up and you could also use it for the offer ID. If not, then something else must be going on.

Quote:

---

Originally Posted by davewest

If both auction and upc area installed and you turned them on in admin -> Configuration -> Google Base Feeder Configuration -> Activate Auction Site Attributes

Then upc should show up and you could also use it for the offer ID. If not, then something else must be going on.

---

Thank you! Yeah, I didn't realize there was even an option to activate ASA on base feeder.

Okay, as far as I can see, it's pulling everything into GB feeder. Of note is the product_type field is only set to 32 characters (at least on my installation it was), which doesn't allow much room for Google's category tree. I increased the size of that field in my products table to 100 characters using PHPMySQL, which I think will be enough for any category. I may bump it up a bit more. It looks like the feeder picks up the extended field without any problem. So that is one major problem solved, thanks a lot!

Now, does anyone know a solution or fix to the no-space problem in the product description? After feeder strips out the HTML, it doesn't replace the line breaks with spaces, so much of the text runs together. If I knew where the code for that was, I'd replace it myself or add an exception for < br > tags to be replaced with spaces.

edit - ignore this post

Wow, the santizer is causing more problems than just absence of spaces. It's stripping off the '&' in my categories as well (Media &gt; DVDs &amp; Videos) which results in gibberish to google feeder. Instead of translating to (Media > DVDs & Videos), it's just seeing it as (Media gt; DVDs amp; Videos).

Quote:

---

Originally Posted by hypercoyote

Wow, the santizer is causing more problems than just absence of spaces. It's stripping off the '&' in my categories as well (Media &gt; DVDs &amp; Videos) which results in gibberish to google feeder. Instead of translating to (Media > DVDs & Videos), it's just seeing it as (Media gt; DVDs amp; Videos).

---

Look a coupla pages back in this thread.. I posted my fix for the ampersands as well the fix for quotations in description and product titles.... my fix incorporates Dave's fix for the "<" and ">" characters..

If you would be so kind as to post how you addressed the spaces, that would be nice??:smile:

I'll give that fix a shot. LOL, the only thing I could come up with was to put a space at the end of each of my lines in the HTML. Very low tech, but it worked.

Quote:

---

Originally Posted by DivaVocals

Look a coupla pages back in this thread.. I posted my fix for the ampersands as well the fix for quotations in description and product titles.... my fix incorporates Dave's fix for the "<" and ">" characters..

If you would be so kind as to post how you addressed the spaces, that would be nice??:smile:

---

Is this the fix:

// $str = str_replace(array("&lt;", "&gt;"), array("<", ">"), $str);
// 10-01-2009 Updated to correct quotation marks and ampersands in product titles and descriptions
$str = str_replace(array("lt;", "gt;", "quot;", "&quot;", "amp;"), array("&lt;", " &qt; ", "&quot;", "\"", "&"), $str);

I put it in my code but as far as I can tell, it didn't make a difference. When you put in &'s and >'s, do you store them in XML friendly format into your table or do you store them in plain format? I actually have it in their both ways

Media > DVDs & Videos

and

Media &gt; DVDs &amp; Videos

both of them still come out as

Media gt; DVDs amp; Videos

in the feeder xml.

I mean, do I need to put quotes around them or do something else?