Google Base Feeder Support Thread [OLD]

[PinkLeopard]

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

[g_force]

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

[kburner]

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.

[PinkLeopard]

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/showpo...7&postcount=86

[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\'),');

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

[numinix]

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?

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

[kburner]

You need to use this module:
http://www.numinix.com/zen-cart/admi...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.

[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.


JOhn ><>

[PinkLeopard]

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.


JOhn ><>

Try this:

http://www.zen-cart.com/forum/showpo...postcount=1922

[Stuff4Toys]

Try this:

http://www.zen-cart.com/forum/showpo...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?