Google Base Feeder Support Thread [OLD]

Posted this a few days ago and still no response. Any help would be appreciated. Thanks!

phycel:

Ok -- I tried to weed my way through this thread to find my answer -- but nothing has worked so far.

I installed this mod on one of my client's sites and it worked perfectly.

Now I have installed it on another client's site - only difference being he has larger quantities and more products/categories. They are hosted with the same company, using the same plans, etc. But when I try to create the product feed xml, the window pops up, says it's done, but nothing happens. I check the feed folder and there is no file there. I made sure the feed folder chmod is 777 and I even tried re-uploading all the files to make sure I didn't miss anything. I also uploaded a php.ini file with the following code:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

> 
> So, any thoughts to what I may be doing wrong with this one?  I just can't seem to figure out why this install would be different from the others.  Everything was done the same.
> 
> Thanks in advance for your time.  Great Mod!
> 
> Rene

surf7.net:

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

In reply to the email from surf7.****net, in another Thread RSS2 Feed Contribution ****a_berezin posted a fix for this problem it is shown below. Anyone know if this fix will work for google base feeder. I have not tired it. Don't know to much about mysql and databases.

The Possible fix is:

Please execute this sql to restore deleted records:
Code:
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

                                                                                              __________________

sgflowers:

i am getting an error from the feed

Error Bad data Line #
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4

i attached a zip of the feed xml

any ideas?

still getting this error any one can help - not sure if it is a configuration issue
when it say line 4 do i have to literally look at line #4 on the code?

taf:

In reply to the email from surf7.****net, in another Thread RSS2 Feed Contribution ****a_berezin posted a fix for this problem it is shown below. Anyone know if this fix will work for google base feeder. I have not tired it. Don't know to much about mysql and databases.

The Possible fix is:

Please execute this sql to restore deleted records:
Code:
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

                                                                                              __________________

This looks like it might be something that is very important and could cause some serious problems. Are there any Master Zenners out there that might have any insight at all on this?

I removed my base feeder recently and ran the uninstall.sql file included in the package from the download section. I was concerned after seeing this because I do not want to break my store just trying to uninstall a component.

Luckily I did backups of the database but some people may not be so lucky. I am not sure either if it affected anything at all.

Like I said some expert insight is desperately needed regarding the unistall.sql file included with this package.

here is the code from that file....

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;


#REMOVE #'s to remove UPC/ISBN support:

#ALTER TABLE products DROP COLUMN products_upc;
#ALTER TABLE products DROP COLUMN products_isbn;

thanks in advance

mafiasam

okay the reason I uninstalled this contribution in the first place was because it worked once and then just started failing without even throwing errors. It just sat there when I attempted to create the file. Just gave me a blank page.

So I uninstalled and reinstalled. It continues to do the same thing even after I tried every trick in this thread.

1. added a php.ini file - no help
2. added the timeout changes to .htaccess - actually killed the entire site with a server error
3. all the necessary files and directories are chmod to 777.

This contribution just simply does not work at all.

Problem is I need to upload a file to google base because my items have expired.

It seems that there should be another contribution or way to get a file to upload to google since this contribution does not work on everyone's installations.

PLEASE - any advice is appreciated. desperate at this point.

The mod doesn't work with wordpress. You can search that keyword in the thread for a fix.

numinix:

The mod doesn't work with wordpress. You can search that keyword in the thread for a fix.

is there another solution that would work with wordpress?

It seems that Live Product search is not working with WordPress either.

I am so upset about this. Now I have to untangle WordPress from Zen cart.

Or does anyone know if there will be compatibility in the next release?

I'm not a full time programmer and I usually charge for any additional changes to the scripts other than the additions I've made. Most of the scripts have been created/modified for my own website and then I share them with the community. As my external projects to Zen Cart grow, I will be spending less and less time updating these scripts.

I don't have the time right now to find out how the two are conflicting, but you may want to check all of the function names etc. I've never used wordpress...

RobM:

Seem to be having a few problems.

On Google Base, it shows the kettle as being here: http://www.prideofthefleet.org.uk/summit-jug-kettle-24v-p-1243.html

When the actual link for the kettle on the site is http://www.prideofthefleet.org.uk/summit-jug-kettle-12-24-volt-p-298.html

As you can see when you click the link that Google Base gives, it takes it to a "Product Not Found" page, even though the Product is in the title, and the breadcrumbs.

It does this for all the products i've added (only 3 so far).

The product hasn't been switched to any different categories so i've no idea what could be causing the difference in links?

Any help appreciated.

Still have this original problem...

Also noticed the following:

Say I added some products to Zencart and ran the Google Base uploader, it would add the previously added products.

Then when I add more products and run it, it'l add the ones that it should have added last time.

It's like it's always one step behind?

Is it possible to produce a .txt file instead of an xml one?

I prefer the txt file as it is easier to work with and I like to add additional product information to it. The size of a txt file is also less than half of the equivalent xml file.

OK, I got the mod working. The file is created with all my stuff in it, but when I try to view it, I get:

XML Parsing Error: not well-formed
Location: http://www.doodlebuckets.com/store/feed/domain_products.xml
Line Number 4, Column 30:<title>Doodlebuckets Mother & Baby Store</title>
-----------------------------^

and I cannot import it into Excel because of this error. Help please!

Looks like I need to put a filter on the titles you guys are inputting in the configuration. For now, please use & instead of & in the configuration for any fields that are included as text in the feed.

numinix:

Looks like I need to put a filter on the titles you guys are inputting in the configuration. For now, please use & instead of & in the configuration for any fields that are included as text in the feed.

Brilliant deduction Clouseau! When I view the feed, it comes up nicely and imports into Excel :) For those who have the same issue, you change the Store Name in admin/configuration and get rid of the & as Nummie has instructed above.

Doodlebuckets:

Brilliant deduction Clouseau! When I view the feed, it comes up nicely and imports into Excel :) For those who have the same issue, you change the Store Name in admin/configuration and get rid of the & as Nummie has instructed above.

I've corrected this in the current unreleased version (1.6.4). Many new additions including Magic SEO URL support. I'm just a little reluctant to release it because MSU is a commercial script that costs $89 and I'll probably not see ten cents from my addition :p. Either way, I'll at least release all of the bug fixes in the next couple of days... and there are a lot hehe.

Hi Numinix

I will contribute for your addition, I know it is worth it.

Can you open a new Thread for it? I got few minor issue and I don’t want to hi jack your Thread. I been told it is wrong in the :)

Thank you again

motti:

Hi Numinix

I will contribute for your addition, I know it is worth it.

Can you open a new Thread for it? I got few minor issue and I don’t want to hi jack your Thread. I been told it is wrong in the :)

Thank you again

Motti, are you confusing the Google Base Feeder with the RSS script again? I have been developing an add-on for the RSS script to use Magic SEO URLs as well, but it won't be freely available and therefore I cannot publicize it in the forum. I will however add a link and description to my website ;)

Am I? :smile: I am lost again, some one pass me a map

You know what I mean , and I will check your web site for it

Thank you

Hello Folks,

I have tried to install the newest version. My older version got me dissaproved from Froogle for pricing issues, so I thought that I would try the newer version. I get errors when when I try to run the sql. It says something like keys already exist. When I run it, It runs but says 0 records processed. I'm not sure how to troubleshoot this. I came across a thread that was about the same problem, and he said it was in his admin but did'nt say how to fix it. I have my admin renamed and copied the files into the appropriate folder.

Any help would be appreciated.

Thanks,
Tom

CarolinaReefs:

Hello Folks,

I have tried to install the newest version. My older version got me dissaproved from Froogle for pricing issues, so I thought that I would try the newer version. I get errors when when I try to run the sql. It says something like keys already exist. When I run it, It runs but says 0 records processed. I'm not sure how to troubleshoot this. I came across a thread that was about the same problem, and he said it was in his admin but did'nt say how to fix it. I have my admin renamed and copied the files into the appropriate folder.

Any help would be appreciated.

Thanks,
Tom

You do not need to re-apply the install.sql patch if you are upgrading from a previous version. Instead, please use the upgrade patches between your current version and the latest version (if they exist). Then upload all of the files in the package, overwriting the old ones.

If you do not know your previous version, please run the uninstall.sql and reinstall the install.sql. You will need to re-enter your admin configuration settings. These steps are described in the readme.txt. Perhaps it should be called the ignoreme.txt :laugh: