Froogle Merchant Center merged into GoogleBase

Ahh, this is my problem. Is there a second support thread for Kroeger's mod? I've installed it on a 1.3 site, but it keeps telling me the images/ folder is unwritable but its permissions are set to 777. Does every folder and image in the folder need permissions set to the same? The readme instructions don't mention anything

I tried to run it anyways and this is the error I get

Warning: fopen(froogle/froogle.txt) [function.fopen]: failed to open stream: Permission denied in /home/moissan/public_html/admin/froogle.php on line 255

Warning: fwrite(): supplied argument is not a valid stream resource in /home/moissan/public_html/admin/froogle.php on line 256

Warning: fclose(): supplied argument is not a valid stream resource in /home/moissan/public_html/admin/froogle.php on line 257

Warning: fopen(froogle/froogle.txt) [function.fopen]: failed to open stream: Permission denied in /home/moissan/public_html/admin/froogle.php on line 255

Warning: fwrite(): supplied argument is not a valid stream resource in /home/moissan/public_html/admin/froogle.php on line 256

Warning: fclose(): supplied argument is not a valid stream resource in /home/moissan/public_html/admin/froogle.php on line 257

Warning: fopen(froogle/froogle.txt) [function.fopen]: failed to open stream: Permission denied in /home/moissan/public_html/admin/froogle.php on line 263

Warning: fwrite(): supplied argument is not a valid stream resource in /home/moissan/public_html/admin/froogle.php on line 264

Warning: fclose(): supplied argument is not a valid stream resource in /home/moissan/public_html/admin/froogle.php on line 265

Warning: chmod() [function.chmod]: No such file or directory in /home/moissan/public_html/admin/froogle.php on line 266

MrForce:

optikalsaint,
I experienced the same problem with googlefroogle feeder & IH2.

You may want to use the froogle feeder contrib from the same developer site as IH2. The IH2 images are referenced correctly using this feeder.

There's only 1 or 2 basic utility functions different between the two contribs. I'll probably graft the best of both together for my puposes.

You can find it here http://breakmyzencart.com/froogle

Cheers,

I was able to set up andrew's contribution almost without a hitch...

a few issues i came up against

1. making sure you not only that you change the permissions of the folder for the feed but also for the froogle.txt file. (if you generate a feed and you don't see any results this is probably your problem)
2. any kind of trademark symbols don't translate well. before you upload you may want to make sure all your product titles and descriptions do not have any of the TM or registered trademark symbols. You can edit them once they're uploaded but if you have quick updates installed this may be quicker from the zen admin.
3. automatic upload didn't work for me. the best way I found was to set up the bulk uploads at google base.

also...you want to make sure and add this little modification http://www.zen-cart.com/forum/showpost.php?p=226116&postcount=39 because I had no errors when uploading and I'm sure this helped.

using zencart version 1.3.5
quick updates
google analytics
google sitemap
ultimate SEO URLs

mafiasam

thanks andrew...on my first froogle sale I'm gonna buy you a cup of coffee

Hi mafiasam,

mafiasam:

2. any kind of trademark symbols don't translate well. before you upload you may want to make sure all your product titles and descriptions do not have any of the TM or registered trademark symbols. Now I use htmlentities to convert all applicable characters to HTML entities.
   mafiasam:

3. automatic upload didn't work for me. the best way I found was to set up the bulk uploads at google base.Why?
   mafiasam:

also...you want to make sure and add this little modification http://www.zen-cart.com/forum/showpost.php?p=226116&postcount=39 because I had no errors when uploading and I'm sure this helped.What version you use? I fix it 29th July 2006:

1. Add Encodes an ISO-8859-1 string to UTF-8;
2. Use Google Base fields name.

Hi mafiasam,

Originally Posted by mafiasam View Post
2. any kind of trademark symbols don't translate well. before you upload you may want to make sure all your product titles and descriptions do not have any of the TM or registered trademark symbols.
Now I use htmlentities to convert all applicable characters to HTML entities.

okay because I'm still having problems with this i think. where can someone who doesn't know how to code PHP learn how to implement htmlentities? I looked around and had a very hard time understanding this.

Originally Posted by mafiasam View Post
3. automatic upload didn't work for me. the best way I found was to set up the bulk uploads at google base.

Why?

kept giving me a failure message.

Originally Posted by mafiasam View Post
also...you want to make sure and add this little modification http://www.zen-cart.com/forum/showpo...6&postcount=39 because I had no errors when uploading and I'm sure this helped.
What version you use? I fix it 29th July 2006:
Quote:

1. Add Encodes an ISO-8859-1 string to UTF-8;
2. Use Google Base fields name.

---

Good luck,
Andrew

well, I used the latest version. this fix didn't seem to be in the suggested files so....

anyways, some more help with htmlentities would be appreciated....

mafiasam:

kept giving me a failure message.
What messages?

mafiasam:

well, I used the latest version.
Last version is v 1.2.8 05.10.2006 23:27. You use this?

a_berezin:

What messages?

Last version is v 1.2.8 05.10.2006 23:27. You use this?

I am using the version you had on your site when i installed it last week. It says "v 1.2 21.04.2006 14:15 Andrew Berezin" in the header of the files.

I went ahead and reinstalled the file you have there on your site and didn't do any modification. we'll see what happens.

Hello Salvatore,

Thank you for submitting a bulk upload to Google Base. We've reviewed your bulk upload and need you to make changes. Your bulk upload has been disapproved due to the reason(s) listed below.

Issues:

1. Promotional text
2. Include recommended attributes

---

1. Promotional text: Please don't include promotional or boilerplate text in your bulk upload. For example, text such as "SPECIAL PHARAOH'S CLUB PRICES! FROM NOW UNTIL ELECTION DAY!" should be removed from your items.

2. Include recommended attributes: We noticed that you haven't included some of the recommended attributes in your "Products" bulk upload. The more information you provide, the better we'll be able to match your items to users' queries. For example, you could include the attribute "payment_accepted" as this information is relevant to your items. Please visit the following links for more information, including a list of required and recommended attributes for "Products" bulk uploads:

http://base.google.com/support/bin/answer.py?answer=27882
http://base.google.com/base/products.html

After you've made the necessary change(s), please upload a new version of your bulk upload. We'll notify you if we need you to make any additional corrections. Otherwise, we'll send you an email to let you know that your bulk upload has been approved.

Sincerely,

The Google Team

Okay has anyone else encountered this problem?
What is the easiest way to edit the info in the froogle feed file and how do i add attributes to the feed automatically?

mafiasam (salvatore)

Issues:

1. Promotional text
   I can't help with your texts :)
2. Include recommended attributes
   This is only recommendation. It's not a critical error.
   But, what additional attributes you want to add to the feed?

a_berezin:

I can't help with your texts :)

This is only recommendation. It's not a critical error.
But, what additional attributes you want to add to the feed?

i was able to add the payment_accepted attribute with no problem.

i have been trying to add the expiration date but it won't accept any of the formats i use. is there any way to get this to work?

I added the header expiration_date and used 11-30-2006 as suggested as text and even used a format from excel 11/30/06 but none of these work. it won't accept the expiration date at all and apparently now these are required so this will have to be worked into the module.

please help.

mafiasam (salvatore)

mafiasam:

i was able to add the payment_accepted attribute with no problem.

i have been trying to add the expiration date but it won't accept any of the formats i use. is there any way to get this to work?

I added the header expiration_date and used 11-30-2006 as suggested as text and even used a format from excel 11/30/06 but none of these work. it won't accept the expiration date at all and apparently now these are required so this will have to be worked into the module.

please help.

mafiasam (salvatore)

well, in my last ditch effort to get this to work I actually was able to get the date format right. my problem was that I was putting the year at the end not at the front. needed to be like this 2006-11-07. opened the froogle.txt with excel. used excel to add the column/header and was able to do all my text edits and formatted the date column to be text only. seems to work. when saving the froogle.txt in excel it prompts that the document "may contain features that are not compatible with text(tab delimited). do you want to keep the workbook in this format?" I click yes and then click no when closing excel.

it works but since this expiration_date header is required shouldn't this be added to the mod?

I was testing the frooglegoogle feeder and I got this error message:

Froogle Data Feeder started 2006/10/11 15:13:30 Feed file - /home/public_html/username/feed/froogle.txt
Warning: chmod() [function.chmod]: Operation not permitted in /home/username/public_html/googlefroogle.php on line 91
Froogle File Complete In 5.717361 Seconds 307 Records

How can I fix it?

check the permissions of the folder.. should be 755 or 777

if that doesn't work, ask your host about chmod.. if its allowed or not through PHP

Thanks for the help. Now I have another problem. I got this from google base when I tried to upload my files from my admin section:

Bad image_links: The image_links in your bulk upload are not working correctly. For example, the image_link for the item titled "Canon Wordtank G55 Electronic Dictionary" does not work:

http://www.books-japan-online.com/images/large/canon-wordtank-g55_LRG.jpg

The correct image_link for this item is:

http://www.books-japan-online.com/images/canon-wordtank-g55.jpg

Please check that all the image_links in your bulk upload are working, or we will be unable to display your items' images.

I am using the latest version of image handler along with utlimate SEO.

mafiasam:

but since this expiration_date header is required shouldn't this be added to the mod?
Certainly! But what date use as expiration_date? May be use admin-setup constant?

Alright I checked the includes/images/large folder and their are no files their. I am using the latest version of image handler on books japan online. On my other site cool tech central I am still using the older version of image handler. They both have the medium and Lage folders in includes images, but the don't show up in on the updated version of image handler. Anyone having this same issue?

Just found out that Image handler2 doesn't actually create an image,
it creates cache images
thats whats stored in the BMZ folder. so is their away to get the original files to generate in googlefroogle.php?

function zen_froogle_image_url($products_image) {
global $product_image_module;
if($products_image == "") return "";
require($product_image_module);
return (HTTP_SERVER . DIR_WS_CATALOG . $products_image_large);

a_berezin:

Certainly! But what date use as expiration_date? May be use admin-setup constant?

Well, it looks like they expire after thirty days anyway. the only time that you may not want them to expire in thirty days is if you have a sale and the item price is going to change within those thirty days.

for instance I set my expiration date for 2006-11-30 for most of my items but google base ended up setting the expiration date on those items to 2006-11-09 which is thirty days after I posted them.
the items i entered with 2006-11-07 were sale items I wanted to expire on election day here and their expiration posted for that date...2006-11-07...which is what I wanted.

So I guess that a constant would be a thirty day expiration after the generation of the file. I'm not sure how you would grab the expiration date for specials/sale items but i'm sure you know more about that than I do.

ctcentralinfo:

Just found out that Image handler2 doesn't actually create an image,
it creates cache images
thats whats stored in the BMZ folder. so is their away to get the original files to generate in googlefroogle.php?

function zen_froogle_image_url($products_image) {
global $product_image_module;
if($products_image == "") return "";
require($product_image_module);
return (HTTP_SERVER . DIR_WS_CATALOG . $products_image_large);

If you're using IH handler change php return (HTTP_SERVER . DIR_WS_CATALOG . $products_image_large); to ```php
return (HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $products_image);

That worked for me but I am not sure if that's the most efficient way to fix the problem.

This option is only if you're using IH2 otherwise the original code should work just fine.

BlessIsaacola:

If you're using IH handler change php return (HTTP_SERVER . DIR_WS_CATALOG . $products_image_large); to ```php
return (HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $products_image);

> 
> That worked for me but I am not sure if that's the most efficient way to fix the problem.
> 
> This option is only if you're using IH2 otherwise the original code should work just fine.

That did the trick, thanks again.

mafiasam:

So I guess that a constant would be a thirty day expiration after the generation of the file.
OK! I will generate expiration_date as generation date +30 days.
mafiasam:

I'm not sure how you would grab the expiration date for specials/sale items but i'm sure you know more about that than I do.
Not now.

Download and test.