VirtueMart

RO CSVI Yandex Export for VirtueMart Extension

| VirtueMart

This tutorial explains how to export Yandex details from VirtueMart using RO CSVI.

Requirements

VirtueMart
Export Yandex 

Creating the export template

A template can be created by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Yandex
  7. Click Next: Select Source
  8. Destination is set default to Download. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Fields must be added otherwise there is nothing for CSVI to export. Click Edit template fields.
  13. A new window opens with the Template fields page. You can add new fields by clicking New or Quick Add.
  14. When all fields are added you can close the window
  15. Click Next: Finalize
  16. All done here
  17. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

Add template fields

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Template fields
  2. In the Search Tools select your template
  3. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add
The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

Run the export

The export can be run by following these steps:

  1. Go to Components -> RO CSVI -> Export
  2. Select the template created earlier
  3. Click Export
  4. The export is run
  5. The Log details page will be shown with information regarding the export if the Enable logging is enabled in the template

Video showing the process

 

Read more ...

RO CSVI Google Merchant Export for VirtueMart

| VirtueMart

This tutorial explains how to export Google Merchant details from VirtueMart using RO CSVI

Requirements

VirtueMart
Export Google Merchant
 

Background information

Google Base exports are used to upload product information to Google Product Search. There is no default export as the fields required depend on the products being uploaded to Google Product Search and the country you are importing products for. The document here explains the basic settings on how to create a template, template fields and run the export. It also tells on how to link the template fields to Google Base fields.

To start with you can use the example Google export template attached here.

 

Google Merchant Export - Creating the export template

A template can be created by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Google Merchant
  7. Click Next: Select Source
  8. Destination is set default to Download. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Fields must be added otherwise there is nothing for RO CSVI to export. Click Edit template fields.
  13. A new window opens with the Template fields page. You can add new fields by clicking New or Quick Add.
  14. When all fields are added you can close the window
  15. Click Next: Finalize
  16. All done here
  17. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

 

Google Merchant Export - Add the fields to export

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

Which fields are required for you, depends on the country and the products you want to import in the Google Product Search. Check the attribute requirements to find out which fields are required for you.

Here we will demonstrate some general required fields:

  • id
  • title
  • description
  • google product category
  • link
  • image link
  • condition

Google Merchant Export - Setting up the export fields

First step is to map the Google fields with the RO CSVI template fields:

Google RO CSVI
id product_sku
title product_name
description product_desc
google product category category_path
link product_url
image link picture_url
condition custom

 Now that we know which fields are need to be used, we will add them to the export template fields. Each field will be added with the following settings:

Field name Column header Default value
product_sku g:id  
product_name title  
product_desc description  
category_path g:google_product_category   
product_url link  
picture_url g:image_link  
custom g:condition new

 

Google Merchant Export - Run the export

The export can be run by following these steps:

  1. Go to Components -> RO CSVI -> Export
  2. Select the template created earlier
  3. Click Export
  4. The export is run
  5. The Log details page will be shown with information regarding the export if the Enable logging is enabled in the template

Video showing the process

 

Further reading

  • By default RO CSVI exports the category_path with a /, this is automatically changed on export to the Google Product Search attribute >
  • If your category structure does not match that of Google Product Search, you can use the Replacement feature to replace your category names with those of Google Product Search
  • If the field g:tax is used, the default value must be set to follow the layout country:region:rate:tax_ship. RO CSVI will change this to the appropriate tags on export
  • To add your own shipping rates, use the Field name custom_shipping and Column header g:shipping
  • If the field g:shipping is used, the default value must be set to follow the layout country:service:price. RO CSVI will change this to the appropriate tags on export
  • To add identifier_exists field add the custom template field with column header set to g:identifier_exists and default value set to Yes or No.

Resources

Read more ...

Generation of Thumbnail images in VirtueMart

| VirtueMart

With Virtuemart Product import operation in RO CSVI, images and thumbnail images are imported using the file_url and file_url_thumb fields. Sometimes it happens that even though the images have been imported into the database, VirtueMart shows them as "No image" in its views. This issue is not because of an import problem but to check VirtueMart. This document explains how thumbnails are generated in VirtueMart code. This may help in finding out why thumbnails are not shown on backend as well as on frontend.

Read more ...

Import ICEcat product specifications

| VirtueMart

Import ICEcat product specifications

To import the product specifications from ICEcat the field features must be added to the import file or template. Since the specifications are added to the end of the product description, it is advised to also include the product_desc field.

A sample CSV file would look like this:

product_sku;manufacturer_name;product_name;product_desc;product_s_desc;features
NP-R522-ET01DE;Samsung;;;;

This example CSV will load the Samsung R522-Aura T6400 Edira laptop product information.

Styling the table

The product specifications are added as a table to the end of the product description. The table has an ID called prod_features, this can be used to style the table. Each table row that contains the group name has a class called feature.

Read more ...

VirtueMart Users import

| VirtueMart

A template can be created by following these steps:

  1. Go to Components -> CSVI Pro -> Templates
  2. Click New
  3. Give the template a name, say for example VirtueMart Users info import
  4. Set Action to Import
  5. Set Component to VirtueMart
  6. Set Operation to Users Info
  7. Click Next: Select Source
  8. Source is set default to Load from your computer. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Nothing needed here as we set to Use column headers as configuration in step 10.
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

VirtueMart users info import create template

  1. Go to Components -> CSVI Pro -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

VirtueMart users info import create templatefields

  1. Go to Components -> CSVI Pro -> Import
  2. Select the template created earlier with name VirtueMart Users info import
  3. Click Select file
  4. Select the file to import
  5. Click Preview
  6. You now see a preview of the file as to how CSVI sees the file
  7. Click Start import
  8. The import is run
  9. The Log details page will be shown with information regarding the import if the Enable logging is enabled in the template

VirtueMart users info import process

Read more ...