Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Google Sitemap Generator Rate Topic   - - - - -

 
  • dominos_2004
  • Senior Member
  • Members
  • Join Date: 02-Jan 06
  • 257 posts

Posted 14 October 2006 - 02:16 AM #21

Without an error, I can't go any further.


OK, thanks
CS-Cart 3.0.3

 
  • dominos_2004
  • Senior Member
  • Members
  • Join Date: 02-Jan 06
  • 257 posts

Posted 14 October 2006 - 02:36 AM #22

Without an error, I can't go any further.


just for information, i'm using also "SOFTplus GSiteCrawler", and them google sitemap works perfect!

You can see example:
CS-Cart 3.0.3

 

Posted 14 October 2006 - 02:53 AM #23

just for information, i'm using also "SOFTplus GSiteCrawler" (http://gsitecrawler.com/), and them google sitemap works perfect!

You can see example:

http://www.indymart.net/sitemap.xml

Mine works perfect also and it is totally automated:

http://www.sculpting...=google_sitemap

Larry
SculptingStudio.com
DigitalOcean VM

Ubuntu 14.04

Nginx


 
  • dominos_2004
  • Senior Member
  • Members
  • Join Date: 02-Jan 06
  • 257 posts

Posted 14 October 2006 - 03:40 AM #24

Mine works perfect also and it is totally automated:

http://www.sculpting...=google_sitemap


Yes you are right but small different my urls all html files not php
CS-Cart 3.0.3

 
  • flasher
  • Senior Member
  • Members
  • Join Date: 26-Sep 05
  • 335 posts

Posted 16 October 2006 - 03:18 PM #25

Hi, great idea, I have been working on my site www.tapetechtools.com and love the cs-cart software. I set up everything and got this:

<?xml version="1.0" encoding="UTF-8" ?>
- <urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
- <url>
<loc>http://www.tapetecht...tools.com</loc>
<lastmod>2006-10-16</lastmod>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>
- <url>
<loc>http://www.tapetecht...ry_id=166</loc>
<lastmod>2006-10-16</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>
- <url>
<loc>http://www.tapetecht...ry_id=160</loc>
<lastmod>2006-10-16</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>
- <url>
<loc>http://www.tapetecht...ry_id=168</loc>
<lastmod>2006-10-16</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>
- <url>
<loc>http://www.tapetecht...ry_id=159</loc>
<lastmod>2006-10-16</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>



This is a small part of the file produced. Is this the correct way? and or how does google read a product from this.

 

Posted 16 October 2006 - 06:19 PM #26

Hi, great idea, I have been working on my site www.tapetechtools.com and love the cs-cart software. This is a small part of the file produced. Is this the correct way? and or how does google read a product from this.

Yes, your last tag shoudl be </urlset> and the text should be UTF-8 encoded. You have to submit your feed to google and based on the <changefreq> setting, this will determine the approximate time google will read your feed again.

Larry
SculptingStudio.com
DigitalOcean VM

Ubuntu 14.04

Nginx


 
  • zoom4267
  • Senior Member
  • Members
  • Join Date: 27-May 06
  • 847 posts

Posted 18 October 2006 - 12:53 AM #27

just for information, i'm using also "SOFTplus GSiteCrawler", and them google sitemap works perfect!

You can see example:

http://www.indymart.net





thanks for posting that site. i am using it now and its done. i have been playing with google for ever and couldnt get anything loaded up there. it took 10 minutes and VOILA!!

thanks a million!!
Lisa

http://www.skytopdesigns.com Web designs and Development

 
  • Alto
  • Junior Member
  • Members
  • Join Date: 20-Oct 06
  • 25 posts

Posted 20 October 2006 - 08:11 AM #28

i have try to install google sitemap and i have the same error. i think this is in the code in box 3. I explain , when i put the code , i see that the php tags are closed bedore the end of the file :
<?php 
//======================================================================= 
// File:        GOOGLE_SITEMAP.PHP 
// Description: Google Sitemap Generator. 
// Created:     2006-10-12 
// Ver:    $Id:    google_sitemap.php 2 2006-10-12 00:0:00Z lsb $ 
// 
// Copyright 2006 (c) RENS Management, LLC. All rights reserved. 
//======================================================================== 

if ( !defined('IN_CSCART') )    { die('Access denied');    } 

$products=$categories=array(); 
$categories_all=db_get_array("SELECT category_id FROM $db_tables[categories] WHERE membership_id=0 && avail='Y'"); 
$products_all=db_get_array("SELECT product_id FROM $db_tables[products] WHERE avail='Y'"); 
while (list(, $cats) = each($categories_all)) $categories[]=$cats['category_id']; 
while (list(, $items) = each($products_all)) $products[]=$items['product_id']; 

header("Content-Type: text/xml;charset=utf-8"); 
$lastmod = date("Y-m-d", time()); 
$siteurl = utf8_encode(htmlentities("$http_location")); 
echo <<<START 
<?xml version="1.0" encoding="UTF-8"[COLOR="Red"]?>[/COLOR]
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84"> 
   <url> 
      <loc>$siteurl</loc> 
so the end of the code doesn't work, i try to change but i don't find the good solution, if someone have an idea.
thanks.

 

Posted 02 November 2006 - 10:45 PM #29

i see that the php tags are closed bedore the end of the file.

Voulez-vous dire la pièce j'avoir accentué dans le rouge ?
echo <<<START 
<?xml version="1.0" encoding="UTF-8"[color=red]?>[/color]
Ce n'est pas une étiquette de fermeture parce qu'il est contenu dans une corde. J'ai attaché le code dans un dossier de fermeture éclair.

Attached Files


Larry
SculptingStudio.com
DigitalOcean VM

Ubuntu 14.04

Nginx


 
  • mpjbay
  • Senior Member
  • Members
  • Join Date: 30-Oct 06
  • 234 posts

Posted 21 November 2006 - 12:00 AM #30

has anyone implemented this in .4?

=)
Matt Johnson

http://ecoitsf.com/

 

Posted 21 November 2006 - 09:39 AM #31

has anyone implemented this in .4?

=)


Yes,
www.southeastauto.com.au/index.php?target=google_sitemap

although it doesn't keep the appropriate formatting, and also requires the header from include/admin (line 19) to be removed prior to being displayed.
Buggy at best on 1.3.4 SP1 but google seems to like it so far

============GOOGLE ANAYLTICS=======================
Sitemap Type Submitted Last Downloaded Sitemap Status URLs submitted
index.php?target=google_sitemap Sitemap Web 20 hours ago 20 hours ago OK 76

============GOOGLE ANAYLTICS=======================
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 

Posted 21 November 2006 - 10:18 AM #32

One thing I should mention is that MAKE SURE it's in UTF-8,

notepad will let you choose between CTF-8, ANSI and UNICODE.
Save it as UTF-8!
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 
  • Alto
  • Junior Member
  • Members
  • Join Date: 20-Oct 06
  • 25 posts

Posted 23 November 2006 - 08:50 PM #33

I use google sitemap on my cs-cart 1.3.4, and it run perfectly, but i have activate the seo module and i would like to know if it is possible to have the link in google sitemap like the name of the page rewriting ?
To have http://www.xxxxx.com/page-c168.html instead http://www.xxxxx.com...category_id=168

 
  • mpjbay
  • Senior Member
  • Members
  • Join Date: 30-Oct 06
  • 234 posts

Posted 07 December 2006 - 09:58 PM #34

what exactly does a site map do?
Matt Johnson

http://ecoitsf.com/

 
  • Zyles
  • Senior Member
  • Members
  • Join Date: 06-Nov 06
  • 596 posts

Posted 07 December 2006 - 11:15 PM #35

I use google sitemap on my cs-cart 1.3.4, and it run perfectly, but i have activate the seo module and i would like to know if it is possible to have the link in google sitemap like the name of the page rewriting ?
To have http://www.xxxxx.com/page-c168.html instead http://www.xxxxx.com...category_id=168


This would be cool, I'd like that aswell.
Marketing tip:

Did you know a targeted e-mail marketing campaign can bring conversion rates up to 3.9%? By using reliable e-mail marketing software you can upsell to existing customers on a tight budget. If you are not using e-mail marketing you are missing out big time. I recommend and use Aweber.

 

Posted 07 December 2006 - 11:24 PM #36

what exactly does a site map do?


When google analytics is used
www.google.com/analytics/
It allows the 'googlebot' / bot to see the updated pages and will usually index pages based on the changes. Makes things more efficient.

This thread explains how to make an automatic one however xenu's Link sleuth is a rather good product itself

Before
site.com/index.php
site.com/product123.php

After.
site.com/index.php
site.com/product123.php
site.com/products234.php
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 
  • mpjbay
  • Senior Member
  • Members
  • Join Date: 30-Oct 06
  • 234 posts

Posted 07 December 2006 - 11:36 PM #37

ah. thanks =)
Matt Johnson

http://ecoitsf.com/

 
  • Zyles
  • Senior Member
  • Members
  • Join Date: 06-Nov 06
  • 596 posts

Posted 13 December 2006 - 11:07 PM #38

I'm trying to get this to work, however I also get a blank page and it doesn't seem to run the code for some reason.

The CS-Cart and apache errorlogs give no information.

Has anyone found this bug?

It wont even execute any output with "echo 'foo';" ...

The admin.php?target=google_sitemap outputs correctly, however not index.php.


--------

Edit: Well this is strange, now it works. I will start working to see if I can get the urls in SEO version.
Marketing tip:

Did you know a targeted e-mail marketing campaign can bring conversion rates up to 3.9%? By using reliable e-mail marketing software you can upsell to existing customers on a tight budget. If you are not using e-mail marketing you are missing out big time. I recommend and use Aweber.

 
  • Zyles
  • Senior Member
  • Members
  • Join Date: 06-Nov 06
  • 596 posts

Posted 13 December 2006 - 11:29 PM #39

Ladies and gentlemen of the SEO crowd. Let me present to you the 2 line fix in order to get SEO urls in sitemaps. :D

Thank god it was a simple fix! Here is the full google_sitemap.php code, replace it with your old:

<?php
//=======================================================================
// File: GOOGLE_SITEMAP.PHP
// Description: Google Sitemap Generator.
// Created: 2006-10-12
// Ver: $Id: google_sitemap.php 2 2006-10-12 00:0:00Z lsb $
//
// Copyright 2006 © RENS Management, LLC. All rights reserved.
//========================================================================

if ( !defined('IN_CSCART') ) { die('Access denied'); }

$products=$categories=array();
$categories_all=db_get_array("SELECT category_id FROM $db_tables[categories] WHERE membership_id=0 && avail='Y'");
$products_all=db_get_array("SELECT product_id FROM $db_tables[products] WHERE avail='Y'");
while (list(, $cats) = each($categories_all)) $categories[]=$cats['category_id'];
while (list(, $items) = each($products_all)) $products[]=$items['product_id'];

header("Content-Type: text/xml;charset=utf-8");
$lastmod = date("Y-m-d", time());
$siteurl = utf8_encode(htmlentities("$http_location"));
echo <<<START
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<url>
<loc>$siteurl</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>\n
START;

// process categories
foreach ($categories as $category) {
$link = utf8_encode(htmlentities("$http_location/$index_script?$target_name=categories&category_id=$category"));
fn_convert_php_urls($link);
echo <<<LINKS
<url>
<loc>$link</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>\n
LINKS;
}

// process products
foreach ($products as $product) {
$link = utf8_encode(htmlentities("$http_location/$index_script?$target_name=products&product_id=$product"));
fn_convert_php_urls($link);
echo <<<LINKS
<url>
<loc>$link</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>\n
LINKS;
}

echo <<<END

</urlset>
END;
exit;
?>


The only thing I had to change was adding "fn_convert_php_urls($link);" at two locations.

Make sure you are running latest 1.3.4-SP2 and have SEO turned on, then try your output at index.php?target=google_sitemap to see if it rewrites the urls.

If you do not use SEO, do not run this code because I have made no checking if SEO is enabled or not.

Enjoy!
Marketing tip:

Did you know a targeted e-mail marketing campaign can bring conversion rates up to 3.9%? By using reliable e-mail marketing software you can upsell to existing customers on a tight budget. If you are not using e-mail marketing you are missing out big time. I recommend and use Aweber.

 
  • Zyles
  • Senior Member
  • Members
  • Join Date: 06-Nov 06
  • 596 posts

Posted 14 December 2006 - 12:12 AM #40

For those of you who wish to include manufacturer pages in your sitemap XML file with SEO urls I made some radical changes.

Edit: addons/seo/func.php

Find: "//Convert topics links"

Below this function you need to create a new function:

//Convert manufacturer links
} elseif ($res['target'] == 'manufacturers' && !empty($res['manufacturer_id'])) {
$name = db_get_field("SELECT manufacturer FROM $db_tables[manufacturer_descriptions] WHERE manufacturer_id='$res[manufacturer_id]' AND lang_code='$cart_language'");
$link = fn_generate_name($name, 'm', $res['manufacturer_id']).'.html';


Then save your file. Next you need to edit your google_sitemap.php file again and replace all code with this:

<?php
//=======================================================================
// File: GOOGLE_SITEMAP.PHP
// Description: Google Sitemap Generator.
// Created: 2006-10-12
// Ver: $Id: google_sitemap.php 2 2006-10-12 00:0:00Z lsb $
//
// SEO modifications by Zyles
//
// Copyright 2006 © RENS Management, LLC. All rights reserved.
//========================================================================

if ( !defined('IN_CSCART') ) { die('Access denied'); }

$products=$categories=array();
$categories_all=db_get_array("SELECT category_id FROM $db_tables[categories] WHERE membership_id=0 && avail='Y'");
$products_all=db_get_array("SELECT product_id FROM $db_tables[products] WHERE avail='Y'");
$manufacturers_all=db_get_array("SELECT manufacturer_id FROM $db_tables[manufacturers] WHERE avail='Y'");
while (list(, $cats) = each($categories_all)) $categories[]=$cats['category_id'];
while (list(, $items) = each($products_all)) $products[]=$items['product_id'];
while (list(, $manufacs) = each($manufacturers_all)) $manufacturers[]=$manufacs['manufacturer_id'];

header("Content-Type: text/xml;charset=utf-8");
$lastmod = date("Y-m-d", time());
$siteurl = utf8_encode(htmlentities("$http_location"));
echo <<<START
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<url>
<loc>$siteurl</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>\n
START;

// process categories
foreach ($categories as $category) {
$link = utf8_encode(htmlentities("$http_location/$index_script?$target_name=categories&category_id=$category"));
fn_convert_php_urls($link);
echo <<<LINKS
<url>
<loc>$link</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>\n
LINKS;
}

// process products
foreach ($products as $product) {
$link = utf8_encode(htmlentities("$http_location/$index_script?$target_name=products&product_id=$product"));
fn_convert_php_urls($link);
echo <<<LINKS
<url>
<loc>$link</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>\n
LINKS;
}

// process manufacturers
foreach ($manufacturers as $manufacturer) {
$link = utf8_encode(htmlentities("$http_location/$index_script?$target_name=manufacturers&manufacturer_id=$manufacturer"));
fn_convert_php_urls($link);
echo <<<LINKS
<url>
<loc>$link</loc>
<lastmod>$lastmod</lastmod>
<changefreq>daily</changefreq>
<priority>0.5</priority>
</url>\n
LINKS;
}

echo <<<END

</urlset>
END;
exit;
?>


After this is done, check our sitemap out and look at the bottom. If all is well, you should see your manufacturer pages with rewritten urls.

Enjoy!
Marketing tip:

Did you know a targeted e-mail marketing campaign can bring conversion rates up to 3.9%? By using reliable e-mail marketing software you can upsell to existing customers on a tight budget. If you are not using e-mail marketing you are missing out big time. I recommend and use Aweber.