Froogle Merchant Center merged into GoogleBase

Hi Andrew,

Thanks - the expiration date works fine :smile:

Just one small thing I noticed ...

1. I see you've hard-coded the OFFER_ID directly in googlefroogle.php:

$output = "title \t description \t link \t price \t image_link \t expiration_date \t label \t id" .

(so it can't be set true/false anymore) but the code for setting OFFER_ID true/false is still showing in admin->configuration->googlefroogle config - did you maybe forget to take that out? :smile:

No, I don't forget it. ID is Required attribute.
Google so quickly changes rules! Now all Recomended attributes became Required attributes -- http://base.google.com/base/products.html

Yes, they change the rules very quickly :smile:

What I was saying was that there is still an option to turn it off/on in admin->configuration->GoogleFroogle Configuration (which now does nothing). :smile:

Ok! I return Offer Id setting: id/model/false. If you select "false", feeder generate EMPTY field (not skipping).

Hi Andrew :smile:

I didn't mean 'put the true/false switch back in' - you are right: since OFFER_ID is now a required attribute then OFFER_ID needs to be hard-coded since everyone will need it set 'true'.

I just meant: 'take the switch to set it true/false out of the config in admin' :smile:

Pixxi:

I just meant: 'take the switch to set it true/false out of the config in admin' :smile:If try to look update_1_2_9.sql you may see more interesting for you.

Hi Andrew,

Thanks - even better still :-) :smile:

A (little) bug though ...

This version is giving an extra tab ( \t ) at the end of the feed - whether options are selected or not - because the tabs are at the end of the data values.

Maybe move the "\t" to before the data values on lines 109 - 115, instead of after (as now), and remove the tab at the end of line 108?

Eg.

zen_froogle_sanita($products->fields['products_name'], true) . "\t" .
								zen_froogle_sanita($products->fields['products_description']) . "\t" .
								str_replace('&', '&', zen_href_link(zen_get_info_page($products->fields['products_id']), 'products_id=' . $products->fields['products_id'] . $product_url_add, 'NONSSL', false)) . "\t" .
								number_format($currencies->value(zen_add_tax($price, zen_get_tax_rate($products->fields['products_tax_class_id'])), true, GOOGLE_FROOGLE_CURRENCY), 2, '.', '') . "\t" .
								zen_froogle_image_url($products->fields['products_image']) . "\t" .
								zen_froogle_expiration_date($products->fields['products_date_added'], $products->fields['products_last_modified'], $products->fields['products_date_available']) . "\t" .
								zen_froogle_get_category($products->fields['products_id']) .
								(GOOGLE_FROOGLE_OFFER_ID == 'model' ? "\t" . $products->fields['products_model'] : (GOOGLE_FROOGLE_OFFER_ID == 'id' ? "\t" . $products->fields['products_id'] : '')) . 
								(GOOGLE_FROOGLE_IN_STOCK == 'true' ?  "\t" .  $products->fields['products_quantity'] : '') . 
								(GOOGLE_FROOGLE_SHIPPING != '' ?  "\t" . GOOGLE_FROOGLE_SHIPPING  : '') . 
								(GOOGLE_FROOGLE_MANUFACTURER == 'true' ?"\t" . zen_froogle_sanita($products->fields['manufacturers_name']) : '') . 
								(GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW == 'true' ? "\t" .  GOOGLE_FROOGLE_PRODUCT_TYPE : '') .
								(GOOGLE_FROOGLE_LANGUAGE_DISPLAY == 'true' ? "\t" .  $languages->fields['code'] : '') .
								(GOOGLE_FROOGLE_CURRENCY_DISPLAY == 'true' ? "\t" .  GOOGLE_FROOGLE_CURRENCY : '') .
								"\n";

Got it installed right after a month.. It created the .txt file.. When I upload it I get this:
Froogle Data Feeder started 2006/10/17 21:16:57 Feed file - /home2/lhhgbh1/public_html/feed/froogle.txt Upload started... Upload Failed Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put() [function.ftp-put]: Opening ASCII mode data connection for froogle.txt.
Upload failed...

Anyone know whats wrong?

Don't know if you've tried it since and got the same result, but Google Base was down for maintenance last night for a few hours - I tried a feed then too and got an error (although a different one from yours). It went through just now fine.

I just tried it and it says succesful, so I went straight into my Google Base to view items and they werent there yet.. How long does it take to show the upload accepted or the items to appear because when I go into my Bulk upload section it doesnt even show that it received the upload.. The uploading from a website is new to me, I have done submissions directly to Base before.. Thanks for the tip.. Glad I went back and did it..

It can take a few hours sometimes before it shows, occasionally longer. It should appear eventually. :smile:

I've noticed a couple of problems...

1.The date is not showing up in text format or the program is not converting it to the appropriate date format that google suggests which is 2006-10-18.
It shows up as 10/18/2006 and I'm not sure if google will accept that. - I am not sure because I modified the figures before sneding the file.

2. My froogle.txt file shows 316 records (actual products) but everytime I upload it I only see 314 items. ?? uploaded twice same result.

I've just checked my feed file with a text editor and the dates are showing correctly as 2006-10-19. How are you looking at your feed file? Eg. if you load it into Excel, Excel will change the date.

Have you looked in your Google Base admin to see if you have an error with any of the products in your feed?

Well I have two sites and the Flag one goes through perfectly..

My Suchatees one says it creates the txt file with no errors.. When i try to upload it to google, it says succesful, yet it doesnt show up on Google.. Then i tried to physically go in and add it to google using the upload feature and it says it uploaded fine, but when I wait a while and go back there, there is nothing, no date, no rejection, no items.. nothing..

If you look at your feed file with a text-editor (after generating it), are the dates correct?

Once you've uploaded a feed it can be a while before Google shows/processes it.

Are there any errors showing in your Google admin for the upload? Are they giving you errors about the dates?

Thats the thing, its not saying anything, whether it was accepted, or whether there are errors or nothing.. just shows the file name which is correct, and the rest is blank...

This mod seems to be installed correctly, I'm not getting any errors. But the feed file is empty :( I have the permissions set to 777 and even that doesn't work :(

is the "feed" folder set to 777 as well? if the file is writeable but the folder isn't.. it won't generate anything (pretty sure of that, could be wrong though)

I was just coming to post! I am a dummy lol, somehow I missed uploading the googlefroogle.php file to my main zen directory :blush: That file is definitely needed :lol:

what is the chmod function used for in this contribution? unfortunately I can't seem to get it to work on my new server since its not running phpsuexec (that i know of).. so it keeps throwing me warnings about chmod. It seems to work properly though.. just curious