Google Base Feeder Support Thread [OLD]

So my site grapediscounts.com is finally up. Working out some last minute tweaks and I went to go run Google Feeder for the first time and when I go to create the feed it just opens up my site in a separate window. Anyone know the cause of this?

stlnyc:

So my site grapediscounts.com is finally up. Working out some last minute tweaks and I went to go run Google Feeder for the first time and when I go to create the feed it just opens up my site in a separate window. Anyone know the cause of this?
Make sure you uploaded all the files and they are in their proper place. Most likely the googlefroogle.php file did not upload to your server root.

i installed this add on on 2 sites, one of them i am having a problem opening the XML file, it says "The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. A semi colon character was expected. Error processing resource 'file:///C:/Documents and Settings/Tamy/Desktop/testfile.......
<link>http://www.mysite.com/index.php?main_page=product_info&products_id=26</link>------------...Looking on the Internet and searching this thread could not find anything helpful and yes i uploaded the files more than 2 times

Hi Im having issues with inserting products , I get an XML error
0 of 1 items inserted - Processed on Apr 13, 2010 5:30 pm PDT

Detected file format: XML
Feed Level Messages
Error: XML formatting error - Error

Our system encountered an error when processing your data feed.
Learn more.
Examples:
Examples:
Line Nr. Column Nr.
14 82

Looks like the = sign is position 82 on line 13
which is

rxalex:

Hi Im having issues with inserting products , I get an XML error
0 of 1 items inserted - Processed on Apr 13, 2010 5:30 pm PDT

Detected file format: XML
Feed Level Messages
Error: XML formatting error - Error

Our system encountered an error when processing your data feed.
Learn more.
Examples:
Examples:
Line Nr. Column Nr.
14 82

Looks like the = sign is position 82 on line 13
which is

<link><http://www>.*** URL REMOVED ***.com/index.php?main_page=product_info&products_id=15307&currency=USD</link> Can you help me fix this?

I got the same problem when i started, then i played with the output file by replacing the & in the URL to & I also changed the encoding of the XML Document in the first line to

Now i am getting about 300 item listed but that is less than half of the items i want to list, Also i am wondering what encoding to use since i think my database encoding is missed up (It always show when i open the Admin page "This page is in Filipino. Translate it using google toolbar") even though all the text in English.

I also wounder if there is a way to have the & replaced automatically by & in the configuration?

This has probably been mentioned in the previous 200+ pages of this thread, but whatever.

My base was adding the attribute costs to my products even though there were some attributes that were free. It made my product appear to cost much more than others.

To fix this I changed /includes/classes/google_base.php line 468 from

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price");

to

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1'". /*" and options_values_price > 0".*/ " order by options_id, price_prefix, options_values_price");

This allows attributes that have a zero cost to be used in the price calculations instead of the attributes that have an additional cost.

vatertime:

This has probably been mentioned in the previous 200+ pages of this thread, but whatever.

My base was adding the attribute costs to my products even though there were some attributes that were free. It made my product appear to cost much more than others.

To fix this I changed /includes/classes/google_base.php line 468 from

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price");

>  
> to
>  
> ```
$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1'". /*" and options_values_price > 0".*/ " order by options_id, price_prefix, options_values_price");

This allows attributes that have a zero cost to be used in the price calculations instead of the attributes that have an additional cost.

Thanks, i will remember your post if i ever get this thing to work.:laugh:

IF it not one thing it is the other, probably it is google's fault.:unsure:

:clap: Well, i finally got a satisfying result.
Just in case the details may help others, here they come.
I had a few problems a long the way, some of which is invalid characters that i had to clean up, I added those characters to the Sanitizer function to have the done automatically from this point forward.

Now i have a clean XML file that i can open with my browser, i submit it to google and waited a few minutes, it came back with

0 of 979 items inserted

Unfortunately the documentation from google does not give you enough details to catch the errors of the bad words, so after looking for a possible solution i came a cross a thread that say the word "free" could be causing that, and sure enough it was, and after cleaning up my XML file from the word "free" submitted again and now i have

978 of 979 items inserted

I will check on the item that was not inserted but for now i think that is good enough. I hope this helps.

So I installed this mod, but when I click on 'create product feed' it re-directs the pop-up window to google.com ... ?

I'm currently using Google Base Feeder 1.7.4 for Zen Cart Version 1.3.8a.When I "Create Product Feed" I get 7000 products out of 8000.Where is 1000 products? How can I fix it? Thanks in advance.

jackyer:

I'm currently using Google Base Feeder 1.7.4 for Zen Cart Version 1.3.8a.When I "Create Product Feed" I get 7000 products out of 8000.Where is 1000 products? How can I fix it? Thanks in advance.
Go to your admin/configuration/google_base_feeder_configuration
and set debug to true and see whats going on. Set image handler to false and see it that makes a difference. Make sure you delete the feed file from inside the feed file on root directory. You may have to keep playing around with it until it creates the whole 8000 products for you.

DELETED

Figured it out - so stupid!!!

thanks :frusty:

I just installed Google Base Feeder 1.7.4 on a 1.3.9a store. The store was just upgraded from 1.3.7. The Google Base Feeder was working perfectly in the old store. However, in the new store, every time I try to upload the file, I get this message:

Processing: Feed - No, Upload - Yes
Upload started...
Login failed:
Connected to: uploads.google.com
Upload failed...

I have checked and double checked the login info and it is correct. I set it all up over 24 hours ago, so everything should be working. I uploaded the file manually at Google and it worked perfectly, so it must be something in Zen-Cart that is causing the problem. I have seen previous posts where people had the same issue, but they did not post again so I'm not sure how the issue was resolved. If anyone has any suggestions I would appreciate it!

Thanks!

Hi

I have a google base feeder problem. My web created installed Google Base Feeder for me. Basically, she did steps 1-3 in the installer. But in step 6, when I go to set up the configuration, I don't see any options (there is nothing to set up).

I am using zencart 1.3.8. Can anyone help?

Also, is this where I should post this? I could not find a place to "POST a new thread". If someone can help me on this also, I'd appreciate it.

Linda

lruskauff:

Hi

I have a google base feeder problem. My web created installed Google Base Feeder for me. Basically, she did steps 1-3 in the installer. But in step 6, when I go to set up the configuration, I don't see any options (there is nothing to set up).

I am using zencart 1.3.8. Can anyone help?

Also, is this where I should post this? I could not find a place to "POST a new thread". If someone can help me on this also, I'd appreciate it.

Linda

She did not do the installation correctly if you cannot see the options in the configuration. Perhaps she did not upload the sql patch?

Hi

After reading the directions I thought I'd try it myself. So I backed up my database and then tried to run the googlefroogle.sql. I cut and pasted it, ran it, but same thing??

Anyone?

Linda

lruskauff:

Hi

After reading the directions I thought I'd try it myself. So I backed up my database and then tried to run the googlefroogle.sql. I cut and pasted it, ran it, but same thing??

Anyone?

Linda

You'll need to be sure all the files were uploaded in the right directories. It sounds like a file or files are missing.

Does your database use a prefix?

I'm not sure what that is, could you elaborate?

Also, could you please give me a link to help describe directories. I'm not quite sure on the order of these yet, which is why I get help. But I'm learning.