Google Base Feeder Support Thread [OLD]

Just to add my thanks to numinix for the regular updates to this excellent module - I've just upgraded to 1.5.1 without any problems.

batteryman:

Well I'm not having a problem with FTP portion of the module. Its when I install the sql portion of the newest version 1.5.1. My site will not display at all and I get the errors right of the batt.

I will send you a screen shot.

There shouldn't be any SQL errors... Are you copying and pasting? It's the exact same SQL file from previous versions...

Yes I am copy and pasting. I began to think on how I set the whole mod up and I did an upgrade to 1.4.10 from 1.33a originally which worked grreat but then I tried to upgrade to 1.5.1 and that where I started to get the problems.

So I went through all of my database removing all the old tables and then I went through my site manually to remove all the old files, after backing up of course.

Then I reinstalled the mod from a fresh start reading the instrutions carefully. I have no website display problems anymore however I cant actually use the mod either. I get BOX_GOOGLEFROOGLE under the Tools menu instead of Google Base Feeder and when I click on it i get this error:

[URL]http://www.batteriesinaflash.com/admin/FILENAME_GOOGLEFROOGLE.php[/URL]

"The requested URL /admin/FILENAME_GOOGLEFROOGLE.php was not found on this server.

 
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."
```Click on it and you will get the same error i get. So i went to the directory to see if the file is there and it is. The permissions are set to 644.

Doesn't make sense to me. Argg...

To uninstall all you had to do was run the uninstall.sql for that version which you are removing. You also can't just upgrade from 1.33 all the way to 1.4.10 without running a lot of sql files. It's better to run the uninstall.sql and then just overwrite your files.

This is what you should do now, run the uninstall.sql for the latest version and if there is a configuration settings profile for "Google Froogle Feeder" you will also need to run one of the older uninstall.sql files that removes "Google Froogle Feeder".

Next, reupload the entire file package except for the files that are for the UPC/ISBN module (in the next release I won't be including these files by default). Then run the googlefroogle.sql file and it should all be installed correctly. The reason you are getting BOX_GOOGLEFROOGLE is because you are missing one of the admin files which defines this constant.

Good luck.

numinix:

The errors should be fixed in version 1.5.0.

Thank you for all your hard work on this. I have one quick questions for you:

Can you please explain how to utilize the RSS Feed that is now supported. I did not see anything in the readme file that explains how to use this.

Thanks!

Hello,

I tried all of your suggestion last night and they didnt seem wot work. Even after I use the uninstall the box_googlefroogle menu option is still in the tools menu.

Whats weird is I installed the isbn and upc support because everything has a common upc but when I try to uninstall it I get an error code:

1054 Unknown column 'p.products_upc' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_upc, p.products_isbn, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = '1413' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Which is probally why you are not adding in the next version as a default.. lol

Well I am going to try it again and see what happens. I will document my steps so you can see if there is an error in what I am doing.

thank you for all your help, I really do appreciate it. I know your mod works perfectly just a small problem with my setup perhaps. we will get it fixed.

Hi.

I firstly would like to say congratulations to all those that had no issues with installing this mod.

Also well done to the mod developer, its a great mod.

Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!

If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.

I am running v1.3.7 and the mod is v1.5.1

It just did not work at all.

Nevermind spending hours trying to find the .xml file, when I had to infact create it myself, only to find it just does not work.

Please do not ask me all sorts of technical questions as I will not be able to answer them. I am a novice and even got help from a programmer and her followed the instrutions to the letter and could not get it to work.

Please I need serious help with this mod as I am not sitting here all day just uplaoding to google froogle, base, MSN live etc etc.

Thanks in advance guys and gals.

TJR Stores:

Hi.

I firstly would like to say congratulations to all those that had no issues with installing this mod.

Also well done to the mod developer, its a great mod.

Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!

If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.

I am running v1.3.7 and the mod is v1.5.1

It just did not work at all.

Nevermind spending hours trying to find the .xml file, when I had to infact create it myself, only to find it just does not work.

Please do not ask me all sorts of technical questions as I will not be able to answer them. I am a novice and even got help from a programmer and her followed the instrutions to the letter and could not get it to work.

Please I need serious help with this mod as I am not sitting here all day just uplaoding to google froogle, base, MSN live etc etc.

Thanks in advance guys and gals.

When you say it doesn't work, did you get any error messages?
Is the feed folder as well as the xml set to read/write/execute?
Have you use any previous version of this mod?

BlessIsaacola:

Thank you for all your hard work on this. I have one quick questions for you:

Can you please explain how to utilize the RSS Feed that is now supported. I did not see anything in the readme file that explains how to use this.

Thanks!

You upload it to Google Base just like the tabbed file. But make sure you've defined it.

You are right though, it does create an RSS feed. However, because it contains g:mpn, it doesn't validate but will still display the title and descriptions in most readers. In order to use it as an RSS feed in general, I'd have to change it to display the products in order from newest to oldest and create an XLS file to display the prices, images, etc. Rather than change this mod, I will just be updating the RSS 2.0 v1.5.7 to v1.5.8 in the next month with added Admin support. v1.5.7 is not currently publicly available and doesn't have any documentation.

batteryman:

Hello,

I tried all of your suggestion last night and they didnt seem wot work. Even after I use the uninstall the box_googlefroogle menu option is still in the tools menu.

Whats weird is I installed the isbn and upc support because everything has a common upc but when I try to uninstall it I get an error code:

Which is probally why you are not adding in the next version as a default.. lol

Well I am going to try it again and see what happens. I will document my steps so you can see if there is an error in what I am doing.

thank you for all your help, I really do appreciate it. I know your mod works perfectly just a small problem with my setup perhaps. we will get it fixed.

Wait for v1.5.2 which will avoid the SQL errors for those not using the UPC/ISBN mod and contains all the updates that I've pasted in the thread as well.

TJR Stores:

Hi.

Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!

If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.

TJR,

I have installed and reinstalled the new version more time than i can count so I consider myself a self proclaimed expert. I can help you however I need more details on what problems you are having and how you installed it.

Here is a really generally summary of what you should do. First of all did you upgrade or start from a fresh install?? I had tried both way. If you started fresh do not install any of the previous sql updates only the current sql for 1.5.1. So what you need to do is run the uninstall sql file and if this was your first tiime install the mod if not run the previous versions uninstall files as well

Then reinstall the googlefroogle feeder files files to your server and then go to your store admin>tools>install sql patches and copy and paste the sql install file into the big open box and then hit send. should take care of your problem

I also had to create a blamk xml file in the folder FEED and upload it to my server. be sure to name the file the same as the file name specified in your configuration in admin>configuration>Google Base Feeder Configuration

hope this helps, numinix spent hours helping me so hopefully I got it right.

numinix:

To uninstall all you had to do was run the uninstall.sql for that version which you are removing. You also can't just upgrade from 1.33 all the way to 1.4.10 without running a lot of sql files. It's better to run the uninstall.sql and then just overwrite your files.

This is what you should do now, run the uninstall.sql for the latest version and if there is a configuration settings profile for "Google Froogle Feeder" you will also need to run one of the older uninstall.sql files that removes "Google Froogle Feeder".

Next, reupload the entire file package except for the files that are for the UPC/ISBN module (in the next release I won't be including these files by default). Then run the googlefroogle.sql file and it should all be installed correctly. The reason you are getting BOX_GOOGLEFROOGLE is because you are missing one of the admin files which defines this constant.

Good luck.

OK, first of all :clap:, I did it all over again and it all worked as you suggested however i did the exact same last night and I had the problem mentioned. Which leads me to believe you have a magic touch or I really should try to work so late when Im exhausted.

I then added all of the modification including the weight and the one that you mentioned above that helps your titles and descriptions and it is all working.

I will now move on to the bread crumb issue I will try to do this on my own cause I have pestered you enough, cant wait for the newest release.

Thank you so much for your time

numinix:

The errors should be fixed in version 1.5.0.

Numinix, I am assuming this code```php
$content["guid"] = '<guid isPermaLink="false">' . $products->fields['products_id'] . '</guid>';

The code is not using the setting from Show Offer ID.

Thanks!

batteryman:

Here is a really generally summary of what you should do. First of all did you upgrade or start from a fresh install??
Yes this was a fresh install.

I had tried both way. If you started fresh do not install any of the previous sql updates only the current sql for 1.5.1.
all i did was install the v1.5.1 sql file.

Then reinstall the googlefroogle feeder files files to your server and then go to your store admin>tools>install sql patches and copy and paste the sql install file into the big open box and then hit send. should take care of your problem

I uploaded all the files where they should go according to the read me file contained in the download. And kept getting all sorts of errors. I cannot give you these errors as I have officially given up on this untill I have had enough coffee to put my head through all this again :laugh::laugh:

I also had to create a blamk xml file in the folder FEED and upload it to my server. be sure to name the file the same as the file name specified in your configuration in admin>configuration>Google Base Feeder Configuration

did this too.

I am stuck, I have done all you said, and it will not work.

My only hope really is for the mod developer to install it for me to see if i did anything wrong, alhough after spending over 3 1/2 hours doing it, checking and re-checking the work I feek and know i followed the read me file to the letter.

Thanks for your help though.

I will give it another go after my head has stopped swelling up. :laugh::laugh::laugh:

Cheers
Rob

I'm going to remove that SQL configuration unless someone feels strongly that it should remain.

g:id and guid are used to uniquely identify the products. Unless your products share the same product id, which they shouldn't, then this will be the most unique number as your zen cart will never reuse the product_id. This isn't something that is displayed by Google Base but is important for updating your products.

TJR Stores:

Yes this was a fresh install.

all i did was install the v1.5.1 sql file.

I uploaded all the files where they should go according to the read me file contained in the download. And kept getting all sorts of errors. I cannot give you these errors as I have officially given up on this untill I have had enough coffee to put my head through all this again :laugh::laugh:

did this too.

I am stuck, I have done all you said, and it will not work.

My only hope really is for the mod developer to install it for me to see if i did anything wrong, alhough after spending over 3 1/2 hours doing it, checking and re-checking the work I feek and know i followed the read me file to the letter.

Thanks for your help though.

I will give it another go after my head has stopped swelling up. :laugh::laugh::laugh:

Cheers
Rob

I'll bet you uploaded the UPC/ISBN files without installing their lines in the SQL... Just wait for v1.5.2 which has removed this and requires you to install that mod separately.

numinix:

I'll bet you uploaded the UPC/ISBN files without installing their lines in the SQL... Just wait for v1.5.2 which has removed this and requires you to install that mod separately.

Thats where i went wrong, as i have no clue what you just said to me!

What is the UPC and the ISBN?

**v1.5.2**** GOOGLE BASE FEEDER**

1. Code optimization;
2. Added g:weight attribute (optional);
3. Added troubleshooting to the readme.txt;
4. Automatically creates the .xml file if it does not already exist;
5. Removed UPC/ISBN mod as required (must now install separately);

cool.

Thanks for the update.

But can someone please tell me what the UPC/ISBN is?

Do I need it for this mod to work?

TJR Stores:

cool.

Thanks for the update.

But can someone please tell me what the UPC/ISBN is?

Do I need it for this mod to work?

You do not need UPC/ISBN for this mod to work as Numinix has explained in previous posts and with 1.5.2 release.

If you're interested in finding out what UPC/ISBN mod is you can read up in that thread located here: http://www.zen-cart.com/forum/showthread.php?t=70442&highlight=upc%2Fisbn

ok thanks.

But I am looking for the google config thing. in zen admin.

Its not there.!!!

I am leaving this mod for now.

I will wait till someone can give me the help i need. it can't simply be done over a forum board.

Thanks for all your help guys and gals, but i think i will have to wait till after the weekend to get this done.