Zen Cart Logo
Forums / All Other Contributions/Addons / Google Base Feeder Support Thread [OLD]

Google Base Feeder Support Thread [OLD]

Locked

Views: 806,275

Results 541 to 560 of 3,556
This thread is locked. New replies are disabled.
20 Oct 2007, 10:15 PM
#541
yairoz avatar

yairoz

New Zenner

Join Date:
May 2007
Posts:
60
Plugin Contributions:
0

Google Base Feeder Support Thread [OLD]

Hey there

First of all I want to say thanks for this great contribute... It is very powerful and helps me a lot with traffic so thanK U :clap:

Recently I started to use Magic SEO and I've got the new html urls now...
The problem is that the base feeder is talking th epld PHP urls... so now I'm afraid of having duplicated pages in google...
Is it possible for the script to use the new urls names??

Thank you for your help

20 Oct 2007, 10:36 PM
#542
warefare avatar

warefare

New Zenner

Join Date:
Oct 2007
Posts:
15
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

Here a quick solution:

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;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Base Feeder Configuration', 'Set Google Base Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

Insert that first .. then insert

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, 'Auction Site Attributes', 'GOOGLE_BASE_ASA', 'false', 'Activate Auction Site Attributes?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('),
(NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'UPC\', \'ISBN\', \'false\'),'),
(NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL),
(NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),'),
(NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?<br />default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('),
(NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL),
(NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL),
(NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL),
(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
(NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL),
(NULL, 'Show Tax Region', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display Tax Region?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL),
(NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?<br />Default=0', @configuration_group_id, 24, NOW(), NULL, NULL),
(NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\', \'do not display\'),'),
(NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas <br>(i.e. computers,software,televisions)<br>Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL),
(NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas <br>(i.e. computers,software,televisions)<br>Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL),
(NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?<br />pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'pounds\', \'kilograms\'),'),
(NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array(\'top\', \'bottom\', \'full\'),');

and finally open up phpmyadmin and go to the table "configuration_group", click on "show" and find the entry
Google Base Feeder Configuration, change the language_id to your personal language_id e.g. 43 for germany, 1 for england/usa ETC.

this is to display the configuration in the admin panel !

now i just have to figure out what a "Documents Feed" is supposed to display O.o

20 Oct 2007, 11:46 PM
#543
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Google Base Feeder Support Thread [OLD]

it creates a feed of your document product types. If you don't have any, don't worry about it...

20 Oct 2007, 11:47 PM
#544
warefare avatar

warefare

New Zenner

Join Date:
Oct 2007
Posts:
15
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

I tried to find out why it's not displaying special characters in my xml feed.
e.g. ü,ö,ä

Here's my solution

function zen_xml_sanitizer ($str) {
		$_strip_search = array("![\t ]+$|^[\t ]+!m",'%[\r\n]+%m'); // remove CRs and newlines
		$_strip_replace = array('',' ');
		$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", "    " 

=> "");        
		$str = html_entity_decode($str);
		$str = strtr($str, $_cleaner_array);
		$str = preg_replace($_strip_search, $_strip_replace, $str);
		$str = strip_tags($str);
                /*
		$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
		$str = htmlentities($str);
		$str = str_replace('&amp;', '&', $str);
                */ 

		return $str;
	}

/*
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
$str = htmlentities($str);
$str = str_replace('&', '&', $str);
***/ **

Could that create another bug ? My XML file looks fine so far.

21 Oct 2007, 12:10 AM
#545
yairoz avatar

yairoz

New Zenner

Join Date:
May 2007
Posts:
60
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

thank u for the quick replay
I tried warefare's first solution but still I keep getting the php urls and not my new Magic SEO urls... I couldn't find any plcae to chnage the language in phpmyadmin but I think it is set fine, I see it in english as I want....

Anyway, any other solution?

21 Oct 2007, 6:16 AM
#546
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Google Base Feeder Support Thread [OLD]

YairOz,

Do the php urls work?

If so, then why do you care if the url's are in SEO format? This is for linking from Google Base and has nothing to do with search engines. For SEO, all that matters are the page URL's that are indexed.

21 Oct 2007, 10:47 AM
#547
warefare avatar

warefare

New Zenner

Join Date:
Oct 2007
Posts:
15
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

YairOz:

thank u for the quick replay
I tried warefare's first solution but still I keep getting the php urls and not my new Magic SEO urls... I couldn't find any plcae to chnage the language in phpmyadmin but I think it is set fine, I see it in english as I want....

Anyway, any other solution?

Deinstall Magic SEO Urls
Install Ultimate SEO URLs
=> follow the instructions in the readme (there is a configuration thingy you have to set, although I think it was causing problems)

=> follow my constructions and replace the function as stated above (zencart_sanitize_xml)

.. now you've got nice seo url's in your xml file
oh and don't forget to define the special characters in the seo mod configuration

ä => ae, ü => ue, ö => oe, ß => ss etc. !

21 Oct 2007, 5:05 PM
#548
yairoz avatar

yairoz

New Zenner

Join Date:
May 2007
Posts:
60
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

Hey there

numinix:

YairOz,

Do the php urls work?

If so, then why do you care if the url's are in SEO format? This is for linking from Google Base and has nothing to do with search engines. For SEO, all that matters are the page URL's that are indexed.

I still see pages with the old php urls indexed in google, and sometimes google and even some other visitors are looking at pages with php urls (I don't know how they are doing it, I can't do it...)

Are you sure that google and no other search engines are looking at those links for indexing?

21 Oct 2007, 7:47 PM
#549
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

I have just installed and run. I get no errors but this is all that is in the file generated.

<?xml version="1.0" encoding="UTF-8" ?>
  • <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
  • <channel> <title>Funky Moose</title> <link>GOOGLE_BASE_ADDRESS</link> <description>GOOGLE_BASE_DESCRIPTION</description> </channel> </rss>

I must have missed something somewhere as I have over 1500 products that should be in the feed.

Any ideas?

MG

23 Oct 2007, 8:28 AM
#550
robm avatar

robm

New Zenner

Join Date:
Nov 2006
Posts:
88
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

RobM:

I installed this yeterday and everything went OK.

Just went into Tools > Google Base Feeder and tried to create a product feed.

I'm getting the following error:

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/10/17 11:11:02
Feed file - /home/httpd/vhosts/prideofthefleet.org.uk/httpdocs/feed/google_base.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id DESC]

> 
> When I go to upload the feed I get the following error message:
> 
> ```
Google Base FTP content:
Connected to: [URL]ftp://uploads.google.com[/URL]
Connection failed: [URL]ftp://uploads.google.com[/URL]
```Any ideas?

Anyone? :smile:
23 Oct 2007, 10:12 AM
#551
robm avatar

robm

New Zenner

Join Date:
Nov 2006
Posts:
88
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

Done another install of the latest version and installed the SQL patches etc.

It's creating the product feed fine but when it comes to uploading I get this:

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/10/23 11:10:55
Feed file - /home/httpd/vhosts/prideofthefleet.org.uk/httpdocs/feed/domain
Processing: Feed - No, Upload - Yes
Upload started...
Login failed:
Connected to: uploads.google.comWarning: ftp_login() [function.ftp-login]: Login incorrect.
Upload failed...

Is the address not uploads.google.com?

I use the same username and password at base.google.com and it logs in fine so not sure where to go from here?

23 Oct 2007, 5:38 PM
#552
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Google Base Feeder Support Thread [OLD]

I use the same username and password at base.google.com and it logs in fine so not sure where to go from here?

That is your mistake. Read the readme.txt.

23 Oct 2007, 7:09 PM
#553
taf avatar

taf

New Zenner

Join Date:
Jun 2007
Posts:
58
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

Hi,

I'm in the UK and have been having problems with getting my items to show on google product search, they are in google base fine, but not showing when i do a search in google products. I found this information on a forum:

<-------
the problem is that you submitted to the wrong country. im assuming
that you want to submit your items to google base uk. there's this re-
direction issue that sends uk providers to the us.
so this is what you should do. delete your current files, and log in
to base.google.uk (not from the my accounts link, that'll send you
to .com). create new bulk uploads, using different filenames.

its weird, but submitting to google base us will get your items on
both uk and us properties, but wont work for product search.
--->

I was just wondering if i need to be careful when doing the bulk upload. I'm a bit confused since when I log into http://base.google.co.uk/ it shows the same settings as http://base.google.com. ftp account looks the same etc..

I'd be interested to hear other people opinions on this. I have seen a few other emails from people in the UK that seem to be having problems with this as well.

Thanks.

24 Oct 2007, 8:42 AM
#555
robm avatar

robm

New Zenner

Join Date:
Nov 2006
Posts:
88
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

numinix:

That is your mistake. Read the readme.txt.

Sorry - i've now setup my Google FTP account and copied the same details into Zencart.

Getting the same error though.

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/10/24 09:41:42
Feed file - /home/httpd/vhosts/prideofthefleet.org.uk/httpdocs/feed/googlebase.xml
Processing: Feed - No, Upload - Yes
Upload started...
Login failed:
Connected to: uploads.google.comWarning: ftp_login() [function.ftp-login]: Login incorrect.
Upload failed...

24 Oct 2007, 8:53 AM
#556
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

MikeyG:

I have just installed and run. I get no errors but this is all that is in the file generated.

<?xml version="1.0" encoding="UTF-8" ?>
  • <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
  • <channel> <title>Funky Moose</title> <link>GOOGLE_BASE_ADDRESS</link> <description>GOOGLE_BASE_DESCRIPTION</description> </channel> </rss>

I must have missed something somewhere as I have over 1500 products that should be in the feed.

Any ideas?

MG

I still don't get any product in my file and can't find a solution can anyone help?

Thanks

MG

24 Oct 2007, 6:20 PM
#557
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Google Base Feeder Support Thread [OLD]

Did you migrate your store from OSC? How do you add products? What restrictions have you put on in the configuration?

25 Oct 2007, 4:43 PM
#558
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

numinix

store is a fresh install or 1.3.7. Products added through catalogue/catagories, maually over the last year. Have had a google froogle feed which I have deleted files and config database settings for and now tried to install a fresh install with your google base mod.

No problems or erros with install but no products in xml file.

Regards

MG

25 Oct 2007, 6:23 PM
#559
toggi3 avatar

toggi3

New Zenner

Join Date:
Oct 2007
Posts:
2
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

I just installed it, the configuration works, but tools > google base feeder in the admin seems to not exist.. anyone able to help me out?

25 Oct 2007, 6:34 PM
#560
toggi3 avatar

toggi3

New Zenner

Join Date:
Oct 2007
Posts:
2
Plugin Contributions:
0

Re: Google Base Feeder Support Thread [OLD]

Ignore the last post, my mistake was so terribly stupid I would like it stricken from our timestream if it were possible.