1179 replies to this topic

[Roaddoctor]

If you use SPPC, have Customer Groups, and only wish your Retail group specials in your Google XML Sitemap SEO 1.5
In /googlesitemap/sitemap.class.php

ADD to the query

and s.customers_group_id = '0'

so it looks like this

function GenerateSpecialsSitemap($languages_id){
	    $sql = "SELECT p.products_id as pID, s.specials_date_added as date_added, s.specials_last_modified as last_mod, p.products_ordered
			    FROM " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id
		    where p.products_status = '1' and s.status = '1' and s.customers_group_id = '0' and pd.language_id = " . (int)$languages_id . " order by s.specials_date_added desc ";

g'night

[simonhornby]

Hi Jack, Forgive me if this has been covered before but I haven't come across it yet.

Firstly thanks for the great contribution - very easy install and worked 1st time (if only they were all like that!!!)

I have a perfumes website (www.styleperfumes.co.uk) and it is organised so that only 5 categories are visible to the public (For Him, For Her, Gift Sets etc). The rest of the 90 odd categories are hidden from view as they are used for back of house organisation and, basically, mirror the manufacturers list.

So, for exanple, a single product such as a Hugo Boss man's Gift Set will appear in the following categories ->"For Him" (visible), "Gift Sets" (visible) and "Hugo Boss" (not visible).

My question is:- Will this multiple duplication of categories upset Google? If so is there anything I can do about it?

Thanks and best regards

Simon

Edited by simonhornby, 10 March 2012, 22:31.

[Jack_mcs]

If the categories you submit cannot be see on the site, google will not accept them. To fix that, you would have to change the code in this contribution to ignore those categories.

[simonhornby]

Hi Jack Thanks for the prompt reply.

To be honest I would be happy to excluse all categories from the sitemap and only show products and manufacturers. How can I remove categories?

BTW googlebot has been going mad overnight since I installed the sitemaps SEO contribution on my site - over 3000 page hits and counting.

Regards

Simon

[Jack_mcs]

simonhornby, on 11 March 2012, 13:04, said:

Hi Jack Thanks for the prompt reply.

To be honest I would be happy to excluse all categories from the sitemap and only show products and manufacturers. How can I remove categories?

BTW googlebot has been going mad overnight since I installed the sitemaps SEO contribution on my site - over 3000 page hits and counting.

You could turn off the option in the settings. If you do that, you should replace the file with a blank one and remove it fro your google sitemap account.

[zpupster]

heelo forum,


i am getting the error on installing the sql file googlexml_sitemap_seo_v_1.5 on oscommerce 2.3.

[b]SQL query:[/b]
[url="our server"   INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )
VALUES (
'289','Google XML SEO','Google XML Sitemap SEO Options','29','1'
);



[b]MySQL said: [/b][url="ourserver][/url]
#1062 - Duplicate entry '289' for key 'PRIMARY'

i looked in my database-(configuration_group_id) it had added the entry ('289','Google XML SEO','Google XML Sitemap SEO Options','29','1' ) there-- i deleted that entry and tried again still same error, also i checked that database and there is no other
289 for the id??


any ideas how to proceed??

i had this contribution working fine on oscommerce 2.2

thanks,

craig

Edited by zpupster, 21 March 2012, 10:31.

[Jack_mcs]

zpupster, on 21 March 2012, 10:28, said:

VALUES (
'289','Google XML SEO','Google XML Sitemap SEO Options','29','1'
);

i looked in my database-(configuration_group_id) it had added the entry ('289','Google XML SEO','Google XML Sitemap SEO Options','29','1' ) there-- i deleted that entry and tried again still same error, also i checked that database and there is no other
289 for the id??


any ideas how to proceed??

Please try changing the above line to

VALUES (
NULL,'Google XML SEO','Google XML Sitemap SEO Options','29','1'
);

[zpupster]

hey jack ,

thanks for replying.

tried the

 
[color="#000000"]VALUES [/color][color="#666600"]([/color]
[color="#000000"]NULL[/color][color="#666600"],[/color][color="#008800"]'Google XML SEO'[/color][color="#666600"],[/color][color="#008800"]'Google XML Sitemap SEO Options'[/color][color="#666600"],[/color][color="#008800"]'29'[/color][color="#666600"],[/color][color="#008800"]'1'[/color]
[color="#666600"]);[/color]

the sql run did not give me an error or a success.

it just added this at the end of my sql statement-

# 1 row affected.

checked the database table configuration_group table and it inserted the record but it did give it a numerical value of 305 for the id.

thanks,

craig

[zpupster]

hey jack,

i did a find and replace 289 to 555. i did not get a success when i ran the sql. just the #1 row affected.

i checked the database and the admin it looks like everthing is ok. have to look around a bit to see if all works.

thanks you for all your hard work.

craig

[kozak]

Hi Jack,


when i setup the shop the addon was working properly, know that i'm almost finished I tried again and a got errors.


Opening /sitemapproducts.xml
FS_CAT /home/kozak/public_html/brievenbussen/
Server http://cozaki.net
Save Path /
WS_CAT /brievenbussen/


Warning: fopen(/sitemapproducts.xml) [function.fopen]: failed to open stream: Permission denied in /home/kozak/public_html/brievenbussen/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Product Sitemap Generation FAILED!

Opening /sitemapcategories.xml
FS_CAT /home/kozak/public_html/brievenbussen/
Server http://cozaki.net
Save Path /
WS_CAT /brievenbussen/


Warning: fopen(/sitemapcategories.xml) [function.fopen]: failed to open stream: Permission denied in /home/kozak/public_html/brievenbussen/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Category Sitemap Generation FAILED!

Opening /sitemapindex.xml
FS_CAT /home/kozak/public_html/brievenbussen/
Server http://cozaki.net
Save Path /
WS_CAT /brievenbussen/


Warning: fopen(/sitemapindex.xml) [function.fopen]: failed to open stream: Permission denied in /home/kozak/public_html/brievenbussen/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Sitemap Index Generation FAILED!

Array
(
[QUERY] => Array
(
[PRODUCTS] => Array
(
[STATUS] => success
[NUM_ROWS] => 38
)

[CATEOGRY] => Array
(
[STATUS] => success
[NUM_ROWS] => 20
)

)

[SAVE_FILE_XML] => Array
(
[0] => Array
(
[file] => /sitemapproducts.xml
[status] => failure
[file_exists] => false
)

[1] => Array
(
[file] => /sitemapcategories.xml
[status] => failure
[file_exists] => false
)

[2] => Array
(
[file] => /sitemapindex.xml
[status] => failure
[file_exists] => false
)

)

)

you know why?

thx

[kozak]

Sorry Jack,

I found why. I build a shop under a subdomain.
I used as YOUR DOMAIN : www.cozaki.net/brievenbussen in place of www.brievenbussen.cozaki.net
The shop can be accessed by both names but not the sitemapgenerator.

I post it because it could maybe help somebody.

Grtz

kozak

[Eszaraxe]

Maybe the answer is somewhere in this thread, but I haven't found it.

My products sitemap looks like this:

<url>
<loc>http://[my site]/product_info.php?products_id=368</loc>
<lastmod>2012-04-16</lastmod>
<changefreq>weekly</changefreq>
<priority>1.0</priority>
</url>
<url>
<loc>http://[my site]/product_info.php?products_id=126</loc>
<lastmod>2012-02-29</lastmod>
<changefreq>weekly</changefreq>
<priority>0.7</priority>
</url>

I have SEO urls on and the site displays the names of the products also in the address line, shouldn't the names also be shown in the sitemap?

Edited by Eszaraxe, 10 May 2012, 07:45.

[Jack_mcs]

Eszaraxe, on 10 May 2012, 07:45, said:

Maybe the answer is somewhere in this thread, but I haven't found it.

My products sitemap looks like this:
I have SEO urls on and the site displays the names of the products also in the address line, shouldn't the names also be shown in the sitemap?

This contribution works with Ultimate SEO v2.2d. If you have some other url rewriter installed, it may not work. There is another contribution based on this one that may work for you.

[Eszaraxe]

Jack_mcs, on 10 May 2012, 13:27, said:

This contribution works with Ultimate SEO v2.2d. If you have some other url rewriter installed, it may not work. There is another contribution based on this one that may work for you.

Edited by Eszaraxe, 10 May 2012, 17:21.

[chemist4]

I'm getting this on my site error log:

[20-May-2012 00:00:01] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0

Since it happens every Sunday, when I have Google XML Sitemap chron run, I have to assume that is what is causing it. The sitemaps are being generated OK, so nothing is really wrong as far as I can tell, I just wanted to know if this error is anything I should be concerned with.

[Jack_mcs]

chemist4, on 20 May 2012, 21:21, said:

I'm getting this on my site error log:

[20-May-2012 00:00:01] PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0

That's a server problem. You need to ask your host to look at it.

[jjj0923]

I just installed it and and am getting this error:

Quote

Opening /sitemapproducts.xml
FS_CAT /home/sites/www.mysite.com/web/
Server http://www.mysite.com
Save Path /
WS_CAT /
ERROR: Google Product Sitemap Generation FAILED!

Opening /sitemapcategories.xml
FS_CAT /home/sites/www.mysite.com/web/
Server http://www.mysite.com
Save Path /
WS_CAT /
ERROR: Google Category Sitemap Generation FAILED!

Opening /sitemapindex.xml
FS_CAT /home/sites/www.mysite.com/web/
Server http://www.mysite.com
Save Path /
WS_CAT /
ERROR: Google Sitemap Index Generation FAILED!

Array
(
[QUERY] => Array
(
[PRODUCTS] => Array
(
[STATUS] => success
[NUM_ROWS] => 28683
)

[CATEOGRY] => Array
(
[STATUS] => success
[NUM_ROWS] => 1000
)

)

[SAVE_FILE_XML] => Array
(
[0] => Array
(
[file] => /sitemapproducts.xml
[status] => failure
[file_exists] => false
)

[1] => Array
(
[file] => /sitemapcategories.xml
[status] => failure
[file_exists] => false
)

[2] => Array
(
[file] => /sitemapindex.xml
[status] => failure
[file_exists] => false
)

)

)

[Jack_mcs]

jjj0923, on 24 May 2012, 13:48, said:

I just installed it and and am getting this error:

What's happens when you change the Sitemap file setting to alternate.

[jjj0923]

Jack_mcs, on 24 May 2012, 13:52, said:

What's happens when you change the Sitemap file setting to alternate.

same exact error...thanks - I did try that from the instructions

[jjj0923]

strange indeed - I ran it as normal, then switched to alternate - same error - back to normal and it ran - however...

my bad - I did not set properties on xml files - my mistake!

sorry for the wasted posts