VirtueMart 2 + 3 > Security (https) / Performance / SEO, SEF, URLs

Product SiteMap.xml with CSVI Tutorial

(1/4) > >>

PRO:
Creating a product sitemap is easy if you have
Openoffice + CSVI
http://www.csvimproved.com/

Create a CSVI export file
Makes sure it has the product_url field.

Export.
!Important LOOK at the urls, and make sure they are the structure of your site.
FOR EXAMPLE,
If your main shop link is    /shop-online/
BUT, that item is not supposed to be in the url. You can use replacements in CSVI, or a "find and replace" in openoffice calc.


Add a column BEFORE the url column.
Paste this into the column.
<url><loc>

Then, you want to copy that all the way down to the end of the products.

Next add a column AFTER the url column.
past this
</loc></url>

COPY that all the way down.

NEXT, you have to concat the columns into 1

Create a 4th column.
Paste this into it
=CONCATENATE( A1; B1;C1 )
Hit Enter

NEXT,. you have to drag the formula all the way down to the bottom of the products.

NEXT,
Copy Concatenated Column.

Go into the 5th Column, and "right click, and choose "paste special"
On the "Paste Special Page"
UNCHECK "paste all"

Then, UNCHECK, "formulas"

Then click OK.

Now, your column should look like this

<url><loc> www.example.com</loc></url>

COPY that column,

Paste it into a notepad, or text editor file.

Paste this at the top
<?xml version="1.0" encoding="UTF-8"?>

  <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">


THEN,

Paste this at the bottom
</urlset>


THEN, save the file as

.xml

Now your file is ready to upload to your site, and submit to google.




lindapowers:
Hi Pro

Interesting post.

Better this method than Xmap or any other solution out there?

Why?

Thanks

PRO:

--- Quote from: lindapowers on January 09, 2013, 02:49:34 am ---Hi Pro

Interesting post.

Better this method than Xmap or any other solution out there?

Why?

Thanks

--- End quote ---

I have not tried xmap for products

This is what I use

lindapowers:
Hi Pro, yep I ask it cause I have seen this commented several times in the forum as being the best method for creating a sitemap.

I read something that said that Xmap and other components don't index the images for products.

Regards

CenturionSigns:
Possibly a stupid question, but can I have 2 sitemaps?  One created by xmap for content and one for products?  Call them different names and submit both to Google?

Navigation

[0] Message Index

[#] Next page

Go to full version