VirtueMart

15 November 2022 | VirtueMart

This tutorial explains how to create a VirtueMart Products import template, add the fields and how to run the import. Step by step we show you how to perform each task. A video will show you the steps in action so you can follow that as well.

Read more ...

25 January 2020 | VirtueMart

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

Read more ...

30 August 2021 | VirtueMart

This tutorial explains how to create a VirtueMart Products export template, add the fields and how to run the export. Step by step we show you how to perform each task. A video will show you the steps in action so you can follow that as well.

Read more ...

13 April 2020 | VirtueMart

Once that ICEcat settings are done as per the document Setting up ICEcat data,  Product import can be done as a normal import. Make sure the template settings are done as per the linked document since it is not explained here.

An example import for Virtuemart is explained below.

 Required fields for Virtuemart product import

• product_sku
• manufacturer_name

CSVI would identify the product details using product_sku and manufacturer_name from ICEcat tables. The other fields required can also be added to the import template fields. This example will explain how product_desc can be imported from ICEcat table to Virtuemart product table.

An example CSV file would look like

CSVI will now look for matching product information in ICEcat table using the above product_sku and manufacturer_name fields and imports product_desc to the Virtuemart table.

Please note the above import happens only if ICEcat option is set to Yes in template options else product_desc will be read from csv file or nothing will be imported if empty.

If any fields which are not needed to be populated by ICEcat data can be selected from Skip fields option and CSVI will ignore those fields.

Read more ...

08 March 2023 | 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.

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

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.

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 ...