Froogle Merchant Center merged into GoogleBase

[BlessIsaacola]

Here is the statistics from the completed task:

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/20 20:03:58
Feed file - DELETED FOR SECURITY REASON
Processing: Feed - Yes, Upload - No
Froogle File Complete In 123.431367 Seconds 10043 Records

As you can see it took 123.43 seconds to generate the file. If I would have set my limit to less than 124 this wouldn't have worked.

[MikeyG]

I have just tried this on a testing machine and I am getting the wrong prices in my feed file.

I am getting my price including tax with tax added to it again. If I view my product in the product/catalogue admin and resubmit it to the site with no changes to the price I get the right price back again.

I cannot do this for 1000+ product though. Any one else had this issue?

thanks

MG

[Woodymon]

The lastest mod generates url using IH2 url if installed. The only issue with this is small, medium and large images are ALL generated on the fly and stored in bmz_cache folders. IH2 doesn't use image/medium or image/large folders at all.

It appears I'm not understanding the process of rendering large images with IH2.

I have latest version of IH2 and v.133 version of Andrew's mod installed on ZC 1.37. And in my feed the image_link urls's for each of my products correctly refers to my large images in /images

My large images don't appear to be generated on the fly. I must ask why would they need to be "generated" since the images are the original large images uploaded to the server. On my product_info _display page when I open the large image pop-up and click properties and check the path it shows the image resides in /images.

Are you using IH2 watermark/overlay function or employing Zen Lightbox and that may requires a re-rendering of the large image?

Just trying to gain a better understanding of the process here. Thanks for your quality feedback.

Woody

[BlessIsaacola]

It appears I'm not understanding the process of rendering large images with IH2.

I have latest version of IH2 and v.133 version of Andrew's mod installed on ZC 1.37. And in my feed the image_link urls's for each of my products correctly refers to my large images in /images

My large images don't appear to be generated on the fly. I must ask why would they need to be "generated" since the images are the original large images uploaded to the server. On my product_info _display page when I open the large image pop-up and click properties and check the path it shows the image resides in /images.

Are you using IH2 watermark/overlay function or employing Zen Lightbox and that may requires a re-rendering of the large image?

Just trying to gain a better understanding of the process here. Thanks for your quality feedback.

Woody

Well, you enlightened me Woody! I have always used watermark on our large image for two reasons: 1. for those stealing our images without paying attention they help us by advertising our website and two to burn our url into our customers mind when they are viewing the large image :)

As result, our large image is generated on the fly and stored in bmz_cache. Of course I have always thought this how IH2 works not knowing it works that way because of my selection to watermark large image.

I temporarily removed watermark and now my large images are also referenced as url/image/filename. The funny thing is some of my products still is referencing the bmz_cache images when using googlefroogle and some are accurately reflecting url/images/filename. I wonder if I need to clear cache before regenerating googlefroogle to make sure it's still not behaving as though I have watermark on large images.

It really doesn't make sense how the Large image works because I have always thought that IH compresses and resize the large images as well. For example I upload very high quality image (sometimes 1200 x 800) to my image folder but my setting for large image on Zen Cart admin side is 600 X 400. If I know that IH2 is simply going to display my large image of 1200 x 800 there is no point uploading such a huge file to the server. I could have simply processed all images to be 600 X 400, compress it and upload it.

I am afraid I will leave the images alone for now because I do not have the time to reprocess 20,000 images.

Thanks for clearing this up.

[BlessIsaacola]

Woody,

I don't know how to explain what's happening technically but I will just tell you what happened

After I change my setting in Admin to remove watermark I ran GoogleFroogle and it didn't complete the process, generated 1MB worth of data. Ran it the 2nd time and it generated 3MB, Ran it the 3rd time it generated 8.01MB which is all the products but the process did not finish. Ran it the 4th time and it generated 8.01MB but this time it finished and displayed all the statistics associated with generating the file.

It's almost like each time it didn't finish, it was able to use certain information from previous session. I still have a feeling it's something to do with generating the image url. If the script is generating images based on whether it's image/large or bmz_cache folder that's some data crunching especially when you have over 10,000 plus products (in my case).

I suppose I could have increased my max_execution_time and it would have ran fine the first time.

[Woodymon]

After disabling watermarks, did you manually clear the bmz_cache before generating the feed?
(just for testing purposes as you still want the watermarks after you get this resolved).

[BlessIsaacola]

After disabling watermarks, did you manually clear the bmz_cache before generating the feed?
(just for testing purposes as you still want the watermarks after you get this resolved).

Nope I did not clear it but googlefroogle works fine in either case as long as the max_execution_time is enough so I am cool! I just found another mod that needed the max_execution_time set to 300 or unlimited.

[birdoasis]

I'm attempting to install the feeder.

But when I run the updates via Zen Cart admin or Phpadmin I get a mysql error that a dublicate field exist, or a whole series of errors.

This is version 1.3.7

Any ideas?

[Woodymon]

when I run the updates via Zen Cart admin or Phpadmin I get a mysql error that a dublicate field exist, or a whole series of errors.

Without seeing at least a few of the errors hard to tell. But likely you have a prefix on your database tables. There is already much in this thread (and other mod threads) about this subject and possible workarounds.

Woody

[Woodymon]

Nope I did not clear it but googlefroogle works fine in either case as long as the max_execution_time is enough so I am cool! I just found another mod that needed the max_execution_time set to 300 or unlimited.

Good to hear you have found a solution to your timeouts and thanks for sharing. Can you report if you're using Andrew's latest mod version, which still includes label and currency fields in the generated feed and which are no longer "supported" by Google? And if so was your feed upload accepted and published by Google? And did you do bulk upload via GoogleBase web interface or did you FTP?
With the number of products you have what is the size of your feed?

Or did you manipulate Andrew's code to remove label and currency attributes?

Woody