VirtueMart

Google Sitemap

| VirtueMart

Requirements:
CSVI 7.0 version
VirtueMart 3.0 or higher

A Google sitemap can be created using VirtueMart product export operation with the following steps.

Step 1

Create a template by selecting Component as VirtueMart, Action as Export and Operation as Product in template Details tab.

Step 2

Under File tab set the following optins

  1. Set Export type to XML
  2. Set Website to Custom
  3. Set Export State to Published. This is needed because only published products should appear in the sitemap as unpublished products are not accessible.

Google Sitemap File tab settings

Step 3

To design the layout of the sitemap, under XML layout tab set the following

  1. Fill the header with the text:
    <?xml version="1.0" encoding="UTF-8"?>
    <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
            xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">
  2. Fill the body with the text:
    <url> 
        <loc>[product_url]</loc> 
        <image:image>
           <image:loc>[picture_url]</image:loc> 
        </image:image>
      </url>
  3. Fill the footer with the text:
    </urlset>
  4. Click on apply to save your changes

Google Sitemap XML layout

Step 4

Add the template fields needed for export on CSVI template fields page.

  1. Add the fields:
    • product_url
    • picture_url
    • product_sku
    as shown on the image.
  2. Fill in the column header for the product_url and picture_url fields
  3. Publish the fields product_url and picture_url and to unpublish product_sku field.

Google Sitemap template fields

Step 5 

Finally we are done with setting up the template. Go to CSVI Export page and select the Google sitemap template to download the sitemap file.

References:

Creating Sitemaps - Webmaster Tools Help

Read more ...

Speed up product import

| VirtueMart

When you have a large number of products in your VirtueMart shop the import will take it's sweet time to finish. There are ways to speed up the import, one of the ways is to make use of indexes on your tables. An index can be seen as a list that the database keeps to remember where to find which item.

Product table index

CSVI uses the product SKU as a unique identifier to identify a product. Adding an index on this field will be beneficial because it allows the database to find the product faster as it then keeps a list of all your products. To add an index on the product_sku field we need to take the following steps using PhpMyAdmin.

  1. Go to PhpMyAdmin
  2. Go to the database that contains your site
  3. Go to the virtuemart_products table Structure page
  4. Click on the Indexes link (this is a bit obscure but it is above the Information table)
  5. There will be a line below the indexes that says "Create an index on 1 columns" with a Go button. Click the Go button.
  6. A popup will appear with a form to enter some information. Enter the following information:
    • Index name: product_sku
    • Index choice: Unique
      We set this to unique to be sure there won't be any duplicate SKUs in the database
    • Column: Select the product_sku column
    • Size: 25
  7. Click on Go
  8. The index is now created.

Create the product SKU index

Read more ...

VirtueMart Calculation Rules export

| VirtueMart

This VirtueMart Calculation Rules export tutorial explains how to setup the fields and export the VirtueMart calculation rules.

Read more ...

VirtueMart Product Image Fields

| VirtueMart

This page shows which VirtueMart Product Image fields you can use for import and export.

Read more ...

Why are my products not showing up?

| VirtueMart

There are several reasons why products are not showing up after an import. Here is a list of possible causes:

  • No slug set
    When a product has no slug, VirtueMart will show a Product not found message
  • Not published
    On import, you need to set the published field to Y or 1. Not including this field leaves the product unpublished even if VirtueMart shows it as published
  • No matching shopper group
    Products can be linked to a specific shopper group, if there is no shopper group match, VirtueMart will not show the product
  • Incorrect language
    After you have imported products and go to VirtueMart to check and see if they are there you might find that no products show up. The reason for this is that VirtueMart uses a different language than what you imported them in. For example, your site has 2 languages, English and Dutch where English is your site default language.

    Joomla site language

    (Extensions -> Language manager)

    After you import your first products in the Dutch language, VirtueMart won't show them because it is looking for English products. To see the list of Dutch products you need to go to Extensions -> Language manager and set your Site language to Dutch as default. Now go back to VirtueMart and your products will show up.

Read more ...