Froogle Merchant Center merged into GoogleBase

Hi again Andrew,

I have uploaded a feed to Google and it is live already - thanks again for your hard work.

Looking at my products, I noticed some of the images are missing so I looked at the feed and the URL to the images defaults to the large image directory but as I am using IH2 there are no large images in that folder. Is there a way that I can change the output of the code to write to my images folder rather than the large images directory?

Many thanks again.

Kindest regards,

Hamish

BigMacYin:

Hi again Andrew,

I have uploaded a feed to Google and it is live already - thanks again for your hard work.

Looking at my products, I noticed some of the images are missing so I looked at the feed and the URL to the images defaults to the large image directory but as I am using IH2 there are no large images in that folder. Is there a way that I can change the output of the code to write to my images folder rather than the large images directory?

Many thanks again.

Kindest regards,

Hamish

Please view post #186 of this thread - it outlines a fix for IH2

Thanks getyourgameshere.com, that worked perfectly - much appreciated.

Warmest regards,

H

Good morning.. For the last two days I have tried to upload my items again for this month.. I cant get my CRON job to work so I have been doing it manually myself.. Anyhow when I try to upload it I am getting the following failed message:

: /Warning: ftp_put() [function.ftp-put]: froogle.txt: Permission denied on server. (Overwrite) -r--r----- 1 ftp root 0 Dec 18 05:51 froogle.txt
Upload failed...

I just want to make sure it isnt something I have done, and maybe its Google.. Anyone else having any problems with them? I dont believe I have changed anything since my last upload.. Thanks..

Usually, when you get that error it means you have tried to upload your Froogle feed twice in the same day - Froogle only allows one upload, but whether that is once per midnight-to-midnight day, or once per 24 hour period is uncertain.

That error is what I got after trying to do it just once though..

lhhgbh:

That error is what I got after trying to do it just once though..

lately i have been having the same error (i upload once every 2-3 days). I suspect this is a problem on Google's end.. because I can't even upload using my FTP client - it just says permission denied. Not sure whats going on with it but I can assure you its not the mod doing it.

Sometimes Google Base doesn't even accept my login credentials.. just don't understand it. Probably because its being pounded by the Christmas season and retailers trying to get up there on Google base :P

Just downloaded v.1.3.1 GoogleFroogle mod.

Analyzing the new googlefroogle.sql I discovered it did not contain SQL included in update_1_2_9.sql.

For example INSERTS for the following three configuration menu keys (as contained in update_1_2_9.sql):

'GOOGLE_FROOGLE_DIRECTORY'
'GOOGLE_FROOGLE_EXPIRATION_BASE'
'GOOGLE_FROOGLE_EXPIRATION_DAYS'

do NOT appear in googlefroogle.sql.

QUESTION: Do all fresh installs of v.1.3.1, after patching with googlefroogle.sql, then also need to be patched with update_1_2_9.sql ?????

If I am not mistaken it appears this same issue would apply for all mod versions since version 1.2.10

Or are those three configuration keys deprecated?

Woody

Hi Woody,
Excuse, my mistake - has forgotten to add it in googlefroogle.sql.:(
Fixed.
Thank you!

Thanks Andrew!

Woody

a_berezin:

Hi Woody,
Excuse, my mistake - has forgotten to add it in googlefroogle.sql.:(
Fixed.
Thank you!

I diownloaded new version then ran uninstall.sql. Then googlefroogle.sql

Receive error during DB patch attempt (via phpmyadmin):

 MySQL said: 
#1136 - Column count doesn't match value count at row 17 

-Woody

Woodymon:

Then googlefroogle.sql

Received error during DB patch attempt (via phpmyadmin):

MySQL said:
#1136 - Column count doesn't match value count at row 17

Something wrong here:

(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @t4, 2, now(), NULL, 'zen_cfg_select_option(array('now', 'product'),'),

And maybe a mistake comma in descriptions on line 28 & 30.

line 35: remove commas from description (or replace with dashes).
line 34-36: insert NOW() for date_added.
line 34: change now() to NOW() for last_modified.

After those fixes to googlefroogle.sql the DB successfully patched.

Attached is repaired googlefroogle.sql (for GoogleFroogle v.1.3.1)

Thanks. Fixed.

a_berezin:

Thanks. Fixed.

Thanks for updating Andrew.

1. So everyone should now use googlefroogle.sql in Andrew's latest version (disregard my attachment above... forum moderator please delete that post).

UPDATE:
2. However I continue to have issue with the new googlefroogle.sql

Specifically:

(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @t4, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),

Note that configuration_description above contains two commas and a semi-colon, which produces errors on importing into the database (at least it does for me).

The commas act as delimiters to separate the dB fields, and the semi-colon identifies the end of the SQL command. Maybe these characters need escaped? Maybe others don't have this issue?

I'm not SQL expert so I may be wrong on the above but the new SQL does not work for me.

'Expiration Date Base:<ul><li>now - add Adjust to current date </li><li>product - add Adjust to product date (max(date_added - last_modified - date_available))</li></ul>'

If I remove the semi-colon and change the two commas to dashes, as in above description, then all is ok. At least it works for me.

Not criticism just want to ensure all is ok with sql patch ;-)

3. Also if installing this new version of mod everyone be sure to upload the new /googlefroogle.php file. Although version id tag in the php file header remains the same, inspection of the file identified a new line of code (line 61):

echo "Processing: Feed - " . (isset($_GET['feed']) && $_GET['feed'] == "yes" ? "Yes" : "No") . ", Upload - " . (isset($_GET['upload']) && $_GET['upload'] == "yes" ? "Yes" : "No") . NL;

Woody

Woodymon:

The commas act as delimiters to separate the dB fields, and the semi-colon identifies the end of the SQL command. Maybe these characters need escaped?No You are mistaken
Woodymon:

inspection of the file identified a new line of code (line 61):

echo "Processing: Feed - " . (isset($_GET['feed']) && $_GET['feed'] == "yes" ? "Yes" : "No") . ", Upload - " . (isset($_GET['upload']) && $_GET['upload'] == "yes" ? "Yes" : "No") . NL;

With what purpose you tell it? It is absolute nothing means!!! Now I have removed this line. What has changed?

a_berezin:

No You are mistaken
When I process the SQL, I observe errors with those commas and the semi-colon. When I remove the commas and semi-colon it imports fine. But no biggy. Just thought I'd report a workaround if others observed the same issue.[/QUOTE]

a_berezin:

With what purpose you tell it? It is absolute nothing means!!! Now I have removed this line. What has changed?
Andrew, I suppose we have a language/communication barrier. Sorry if my words were confusing. I was not meaning to say there was any issue with the line of code. I was pointing out to everyone that the new version included a new line of code and thus people should be aware, to ensure they upload the new file. That was all. I have no idea why my comment would prompt you to now remove that new line of code ;-)

Sorry that I was not or cannot be any more clear. Happy holidays!

Woody

a_berezin,

Thanks for a great contribution. I've added the model number to the feed because I needed it when I use the feed for other things. I also attached the changed file.

Pete

Oops goofed I put in model (which is reserved for car stuff) instead of model_number, its changed now.