Google Base Feeder Support Thread [OLD]

ElTel78:

Hi, I found what was causing the errors. I had setup the payments wrong and in the content I was using the words 'Free Shipping', which apparently you are not allowed to use. I was testing this and it is now coming up 17 or 17 inserted (although I get a few warnings about expriration - which I am researching now).

On the topic of expriration, it is currently set to 365 days in Zen Cart. Apparently Base products expire after 30 days right? So should I set it to 30 days in Zen Cart to remove the warnings? If I remove those warnings I have no errors or warnings whatsoever, then I can build on my feed. I am going to be constantly refreshing my feed probably once a week anyway.

A couple of other questions. How long until these products within the feed to become active? And is there a way of optimizing a feed or does this great module already take care of the SEO side of it?

Thanks
Terry

Terry...so it seems to be going in the right direction! :clap:

I get the expiration thingy too and my feeds seem to be okay.

It takes a couple of days for the feeds to become active..at least that is my experience.

You need to check your Google Merchant Dashboard. It will show everything...active products...etc...patience with Google is the key here.

Also, if you use quotations of any kind that will be kicked back by Google.

Bridgett

Terry, how are setting the expiration in Zen Cart?

Also, free shipping is kinda tricky with Google Feeder. I kinda adjustment mine because I got kicked back too.

Bridgett

I would like to change the details within the sql to fit my needs.

For example, it reads this now:

Details

Price: $ 11.00
brand: ? (for some reason my shop name shows up)
condition: used
product type: Tops
payment notes: GoogleCheckout

I like the price...brand I want to change...condition I was to change...product type I want to change.....

:clap: waving to numinix for help :clap:

or if anyone else knows that would be great too.

I would like it more personalized to my store.

Go to 'Google Base Feeder Configuration' and 11 options down you see it says 'Expiration Date Adjust'? It is set to 365, so after reading Googles guidelines realised that feeds expire after 30 days if not refreshed. So I changed it to 30 and all of the warning messages disappeared. I was going to update the feed every 2 weeks anyway as I am going to be constantly working on my new site as it is going to be a big one :/

At the moment I am planning how to change my content so products dont get removed. I think I have it figured out to keep both Googles natural listings (serps) and Google base both happy, unfortunatly the products I am promoting require similar descriptions so I have to be careful about duplicate content :)

With regards to your problem, have you tried making a few alterations within the Google Base Feeder Config under 'configuration' in your admin section? Thats where I am stripping down most of the data so mostly content will show in Google Base.

Numinix, a question for you...

Compressing the feed file option in 'Google Base Feeder Configuration', how does that work exactly? Does it strip down data within the feed itself or is it a zip compression to enable a quicker download/upload for bigger feeds?

Nice work on the module by the way, thanks :)

Terry

PinkLeopard:

Kim, I am not sure about the ISBN information.

But here is what it shows on the Google Merchant site (speaking just for me)

Item URL

Details

Price: $ 11.00
brand: ? (for some reason my shop name shows up)
condition: used
product type: Tops
payment notes: GoogleCheckout

Contact information at the bottom.

The feeds generated only show the links to your store.

Hope that helps

Bridgett

Thanks, Bridgett...Does anyone have the Book product working with this mod? :frusty:

I want Google to get ISBN, ISB13 and all data.

Kim

Kim, just a thought. But you may need to change the sql to pick up the ISBN numbers or may hack that barcode and change to your needed info.

Again, I am just a novice but wanted to suggest those two ideas to you.

Bridgett

I didn't realise that the product description was obligated to be more than 15 characters - this was my problem so look out for this all!

On the same note.. >> is there any way to reduce this - so that maybe only 10 characters are needed for the product description or maybe even none at all??

_thanks all

davewest:

Actually... it's not that hard! Look in the add-ons for ubc/isbn mod or click...

This mod "Creates UPC and ISBN input field in products.php and stores the information in the products TABLE in the database." It doesn't display them, just creates what the feeder needs.

Once you install and add all your UPC's, then you can use them as the offer ID or by them self, with a simple click in the admin googlebase feeder settings.

The code looks like it may be looking for the auction mod as will so you may have to install it too.

Can I add to these files ISBN-13 and load? For books and non-books, I need ISBN, ISBN-13 and UPC.

kburner:

Can I add to these files ISBN-13 and load? For books and non-books, I need ISBN, ISBN-13 and UPC.

May this might help. Take a look:

http://www.zen-cart.com/forum/showpost.php?p=402267&postcount=86

In am trying get this mod to load UPC, ISBN and ISBN13 details to Google. I am using sql 1.7.3a and pulled 1.4.3 sql. I loaded this sql.

ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model; 
ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;
ALTER TABLE products ADD products_isbn13 varchar(32) NULL default NULL after products_isbn;

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'UPC', 'GOOGLE_BASE_UPC', 'false', 'Include products UPC?', @configuration_group_id, 31, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'UPC', 'GOOGLE_BASE_ISBN', 'false', 'Include products ISBN?', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'UPC', 'GOOGLE_BASE_ISBN13', 'false', 'Include products ISBN13?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

But do not see it when I go into admin/cofig/google base feeder config. Does it load automatically?

kburner:

In am trying get this mod to load UPC, ISBN and ISBN13 details to Google. I am using sql 1.7.3a and pulled 1.4.3 sql. I loaded this sql.

ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;
ALTER TABLE products ADD products_isbn13 varchar(32) NULL default NULL after products_isbn;

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'UPC', 'GOOGLE_BASE_UPC', 'false', 'Include products UPC?', @configuration_group_id, 31, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'UPC', 'GOOGLE_BASE_ISBN', 'false', 'Include products ISBN?', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'UPC', 'GOOGLE_BASE_ISBN13', 'false', 'Include products ISBN13?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');

You need to use this module:
<http://www.numinix.com/zen-cart/admin/numinix-product-fields>

numinix:

You need to use this module:
http://www.numinix.com/zen-cart/admin/numinix-product-fields

I loaded numinix product fields. I see in admin for products, but fields still do not show on product as customer looks on website.I did a test order and added isbn fields and customer can not see it.:frusty:

Tried searching for this, but looks like the search engine doesn't like Â

Several of my site feeds have been rejected due to format errors, finnaly downloaded Notepad++ instead of TextPad and it became immediately evident that the rejected items all had  many times in the Description of the item.

Not sure why it wad there, it appears that it might be there from html description like text format codes. Bold or Font Color???

any help is appreciated, beats having to download and search and replace before manually uploading.

:cheers:
JOhn ><>

Stuff4Toys:

Tried searching for this, but looks like the search engine doesn't like Â

Several of my site feeds have been rejected due to format errors, finnaly downloaded Notepad++ instead of TextPad and it became immediately evident that the rejected items all had  many times in the Description of the item.

Not sure why it wad there, it appears that it might be there from html description like text format codes. Bold or Font Color???

any help is appreciated, beats having to download and search and replace before manually uploading.

:cheers:
JOhn ><>

Try this:

http://www.zen-cart.com/forum/showpost.php?p=817924&postcount=1922

PinkLeopard:

Try this:

http://www.zen-cart.com/forum/showpost.php?p=817924&postcount=1922
I must be using an older version or a different mod, I have a googlefroogle.php

Is this the same mod, or should I uninstall and install the latest version?

Stuff4Toys:

I must be using an older version or a different mod, I have a googlefroogle.php

Is this the same mod, or should I uninstall and install the latest version?

You can check your version under a file called numinix_version. It will tell you which version you installed.

I have the lastest and I needed to make to changes so that alien language and quotes were acceptable for google feeds.

It's google_base.php (includes/classes). Try fixing that.

Personally, I think it is best to do those two (2) fixes. Just my opinion.

Hope that helps.

Has anyone noiticed that their product titles are repeated on the google search results page? Anyone know how to stop this??

_thanks

g_force:

Has anyone noiticed that their product titles are repeated on the google search results page? Anyone know how to stop this??

_thanks

How is your cron set-up?

How many times within a 24 hour period?

Thanks.

PinkLeopard:

Try this:

http://www.zen-cart.com/forum/showpost.php?p=817924&postcount=1922

OK, I have 1.7.4 on all my sites.

Developers Tool Kit, I found it!

includes/classes/google_base.php

JOhn ><>

Thanks for pointing out this file.

Question? Can I cause it to convert quot; with "

Can I do the following in line 189?

$str = utf8_encode(str_replace(array("®", "©", "™", " ", "quot;"), array('(r)', '(c)', '(tm)', ' ', '"'), $str));

or will that muck things up?
JOhn ><>