Google Base Feeder Support Thread [OLD]

[numinix]

Thanks that fix reduces the amount of products rejected by google but I am still left with a significant amount of rejects. Should I apply the same zen_froogle_sanita to title as well? What's the difference between zen_froogle_cleaner and zen_froogle_sanita?

Thank you!

Just two different functions written to make the descriptions look better. Yes you can run sanita on the title as well.

However, I've created an XML version which is complete. I'm currently waiting for Google to process my file before releasing publicly as there is an issue with bullets in the description. If the bullets were created using wingdings, they are very difficult to remove. If anyone has experience with sanitizing symbols such as a bullet (not created using <ul><li>...</li></ul>, but actual symbols cut and paste), please post your sanitization function. A simply $str = str_replace("•", "", $str); doesn't work and actually returns an error.

I even tried making the description only display letters, numbers, and spaces. The bullets still remained!

[mbheald]

Jeff,

I am so excited about using this mod, Thank you so much.

I just installed the latest version (v1.4.10) in my store (Zen Cart version 1.3.7.1) and it appears to have installed properly. when I run the command to create the feed, it only give me 21 records of 1128 products I have available in my store. Can you help me fix this?

Matt

[numinix]

Jeff,

I am so excited about using this mod, Thank you so much.

I just installed the latest version (v1.4.10) in my store (Zen Cart version 1.3.7.1) and it appears to have installed properly. when I run the command to create the feed, it only give me 21 records of 1128 products I have available in my store. Can you help me fix this?

Matt

Are the filters off? Do you use any other scripts for posting products? A commercial script by MagicOne called Zen Manager is a POS that stores products in the zen cart database improperly and cannot be pulled using conventional methods. If you are using this script or somethign similar to create your listings, you may encounter that error.

How long does it take to process the feed file? Perhaps it is timing out.

[numinix]

v1.5.0 GOOGLE BASE FEEDER

1. now in XML RSS 2.0 format;
2. chmod's the file to 0655 on close;

A major update which creates an xml file that can then be uploaded to Google Base. You can also use the xml file as a valid rss feed and run a regular cron job to regenerate the xml file. I haven't written an XSL stylesheet to display images or prices etc as this would cause the feed to not validate with Google Base. However, this is a good prototype for a future RSS feed generator or possibly the same script with different parameters to also include an xsl stylesheet, etc.

[numinix]

The link will be back up soon. Just adding a couple of things that I don't want to have to create a new release for.

[mbheald]

I just checked and all filters are off. I use easypopulate to update my products, does this one cause problems? The feed only takes a few seconds to create.

[numinix]

Download is back up.

I'll look into your issue later on tonight.

[motti]

Hi

I am using version 1.4.8 which SQL update should i use, i see their 3 different ones

Thank you

[numinix]

Hi

I am using version 1.4.8 which SQL update should i use, i see their 3 different ones

Thank you

Use the SQL updates for the versions in between. So in this case 1.4.9b and the latest update located in the root directory.

How do I call on the weights of each products to be added to the txt file

You'll have to edit the product_query to include p.products_weight. Didn't you ask this question previously? I gave you a more detailed response previously. There is no advantage to adding this attribute to your Google Base feed.

[jmcdog]

numinix, did you ever find the solution to this? I have bullets all through my descriptions and str_replace doesn't work (as you noted). I tried applying the function html_translate to see if one of these would strip it out:
$value = preg_replace("/¿/", "&#192;", $value);
and I tried to find a hexidecimal entity(like 0xD7FF ??) for the bullet without success.

Just two different functions written to make the descriptions look better. Yes you can run sanita on the title as well.

However, I've created an XML version which is complete. I'm currently waiting for Google to process my file before releasing publicly as there is an issue with bullets in the description. If the bullets were created using wingdings, they are very difficult to remove. If anyone has experience with sanitizing symbols such as a bullet (not created using <ul><li>...</li></ul>, but actual symbols cut and paste), please post your sanitization function. A simply $str = str_replace("•", "", $str); doesn't work and actually returns an error.

I even tried making the description only display letters, numbers, and spaces. The bullets still remained!