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.
LOOK at the urls, and make sure they are the structure of your site.
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.
Then, you want to copy that all the way down to the end of the products.
Next add a column AFTER the url column.
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 )
NEXT,. you have to drag the formula all the way down to the bottom of the products.
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
COPY that column,
Paste it into a notepad, or text editor file.
Paste this at the top
<?xml version="1.0" encoding="UTF-8"?>
Paste this at the bottom
THEN, save the file as
Now your file is ready to upload to your site, and submit to google.