Google Base Feeder Support Thread [OLD]

batteryman:

Sorry for the confusion, I am a beginner on php so I need a little more guidance. mmm now that I think about it alot more lol

The breadcrumbs are the trail that lead to a product on top of the a zencart site. the link that say:

Home :: Notebooks :: Sempron :: ACER ASPIRE 3050-1270 AMD SEMPRON 3400+ 2.0 GHz 14.1" 120GB 1GB VH LAPTOP

I need this to e displayed in a column along with each product.

That was an example from your site. which I think I need to be linked to and you need to be linked to me. You offer the electronics and I offer the batteries to them. that is a side note.

In that case, the breadcrumbs are already included in the PRODUCT_TYPE which is a list of each category starting from the top level.

If you want to exchange links, please use the webform located on my website by going to Link Partners located on the left hand side menu.

BlessIsaacola,

In the meantime, try changing the function that is used to filter the description. Scroll down to the area of the code that outputs the description stored in the SQL and replace zen_froogle_cleaner() with zen_froogle_sanita().

Let me know if that helps. I've decided that the next version will be in XML format to avoid problems with illegal characters in the description.

batteryman:

I use the google feed for 5 different product search engines

1. Google Base
2. Yahoo Shopping
3. Nextag
4. MSN Product Live
5. Bizrate / Shopzilla

They all are pretty much the same however some need a couple different attributes an I have thousands of products so to find those 2 items that I need would be very cumbersome.

There's an opportunity numinix,

Develop this mod to support multiple feeds.

Considering Google Checkout mod plan to integrate GoogleBase

Woody

I would need coaxing to undertake a universal feeder.

I pretty much have to develop for myself and I do not use shopping comparison websites so their is no benefit for me. Writing them would take considerable time and I would be lucky to see donations enough to cover a single days work. I do greatly appreciate the few donations I have received and will continue to lend support to the zen cart community.

I'm currently reqriting the GBF in XML format to solve a lot of the members problems even though they currently do not affect my own feed.

Also, I requested for you to email me so that I can provide you with Andrew's RSS 2.0 module so that you can document it and release it to the public. I don't have time to do this myself and would appreciate it if you could. Once we have a documented and workable version, we can look into adding admin support in a future release.

Yes if one doesn't utilize the feed services it is difficult to keep up-to-date on the attributes and upload requirements for each.

Maybe somebody else with the skills can build an all-around feeder mod supporting various product search sites. Maybe fork off Fork off Andrew's GoogleFeeder, Sitemap XML or similar mods. Or look at mods to port from OSC.

You have the latest RSS2 mod from Andrew? What is last date change? Feel free to provide a link to it and I will download/compare with what I have. We probably should take this discussion elsewhere and not cloud this thread.

Currently the Google Base Feeder supposrt all 5 methods I mentioned before. I would just need to add the weight and breadcrumbs for each product. I believe this would be very simple to add if you could please just help with that.

Thank you

also i would like a copy of the rss feed mod as well if it is possible.

batteryman:

Currently the Google Base Feeder supposrt all 5 methods I mentioned before. I would just need to add the weight and breadcrumbs for each product. I believe this would be very simple to add if you could please just help with that.

Thank you

also i would like a copy of the rss feed mod as well if it is possible.

The weight can be added just like any of the other product fields. In the SQL products_query, have it pull p.products_weight. Then have an output to create the proper heading and then in the second output have it output $products->fields[products_weight];

Have the Feeder installed - working a treat on file creation after a couple of mods. I have one simple question - I can't upload via FTP at Google Base, so I'm going for the .txt file upload. Firstly, it wouldn't accept CSV files, so I converted the .txt to TSV (tab separated values) instead. Now it's saying it can't accept files with /:, characters in them - which makes URLs impossible, even if I've escaped them with a \ character. Short of rewriting the file into XML, is there a way round this?

Thanks in advance - and much love to the mod creators.

numinix:

BlessIsaacola,

In the meantime, try changing the function that is used to filter the description. Scroll down to the area of the code that outputs the description stored in the SQL and replace zen_froogle_cleaner() with zen_froogle_sanita().

Let me know if that helps. I've decided that the next version will be in XML format to avoid problems with illegal characters in the description.

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!

gaekwad:

Have the Feeder installed - working a treat on file creation after a couple of mods. I have one simple question - I can't upload via FTP at Google Base, so I'm going for the .txt file upload. Firstly, it wouldn't accept CSV files, so I converted the .txt to TSV (tab separated values) instead. Now it's saying it can't accept files with /:, characters in them - which makes URLs impossible, even if I've escaped them with a \ character. Short of rewriting the file into XML, is there a way round this?

Thanks in advance - and much love to the mod creators.

Please ignore me - I am a moron. I was providing the web address for the 'file name' on the Base upload screen. :frusty:

Numinix,

I got a message back from the google base people. This is regarding the payment_accepted, and payment_notes attributes. They said that neither of them are needed for bulk uploads, and if your google checkout and google base accounts are connected, and you have made a successful sale already, then the google checkout badge should appear next to the products.

I have not yet tested this since my store is not live just yet.

Thank you for this great module

BlessIsaacola:

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!

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

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

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.

**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.

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.

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.

Download is back up.

I'll look into your issue later on tonight.

Hi

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

Thank you

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

avel