VirtueMart
VirtueMart Media Items import
A template can be created by following these steps:
- Go to Components -> CSVI Pro -> Templates
- Click New
- Give the template a name, say for example VirtueMart Media import
- Set Action to Import
- Set Component to VirtueMart
- Set Operation to Media
- Click Next: Select Source
- Source is set default to Load from your computer. No need for change.
- Click Next: Select options
- The default values are OK, change if needed.
- Click Next: Select fields
- Nothing needed here as we set to Use column headers as configuration in step 10.
- Click Next: Finalize
- All done here
- Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
- Go to Components -> CSVI Pro -> Templates
- Click on Template fields
- In the Search Tools select your template
- 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.
- Go to Components -> CSVI Pro -> Import
- Select the template created earlier with name VirtueMart media import
- Click Select file
- Select the file to import
- Click Preview
- You now see a preview of the file as to how CSVI sees the file
- Click Start import
- The import is run
- The Log details page will be shown with information regarding the import if the Enable logging is enabled in the template
"product_sku";"file_url";"file_title";"file_meta";"file_description"
"H01";"hammer.jpg";"Hammer";"hammer wood";"A wooden hammer"
"H02";"hammer2.jpg";"Hammer Deux";"hammer plastic";"A plastic hammer"
Multiple images
"product_sku";"file_url";"file_title";"file_meta";"file_description"
"H01";"hammer1.jpg";"Hammer left";"hammer wood";"A wooden hammer from the left"
"H01";"hammer2.jpg";"Hammer right";"hammer wood";"A wooden hammer from the right"
"H01";"hammer3.jpg";"Hammer top";"hammer wood";"A wooden hammer from the top"
Product documents
"product_sku";"file_url";"file_title";"file_description"
"H01";"hammer1.pdf";"Hammer document";"A technical description of the wooden hammer"
Delete media
"file_url";"media_delete"
"images/stories/virtuemart/product/hammer1.jpg";"Y"
Can I use picture_url for import?
No you cannot. This field in only meant to export a fully qualified URL to your image.
To import images you need to use the following fields:
- VirtueMart 1
product_image
product_thumb_image - VirtueMart 2
file_url
file_url_thumb
VirtueMart Manufacturer Categories import
A template can be created by following these steps:
- Go to Components -> RO CSVI -> Templates
- Click New
- Give the template a name, say for example VirtueMart Manufacturer category import
- Set Action to Import
- Set Component to VirtueMart
- Set Operation to Manufacturer Category
- Click Next: Select Source
- Source is set default to Load from your computer. No need for change.
- Click Next: Select options
- The default values are OK, change if needed.
- Click Next: Select fields
- Nothing needed here as we set to Use column headers as configuration in step 10.
- Click Next: Finalize
- All done here
- Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
Adding the template fields
Template fields can be added by following these steps:
- Go to Components -> RO CSVI -> Templates
- Click on Template fields
- In the Search Tools select your template
- 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 import
The import can be run by following these steps:
- Go to Components -> RO CSVI -> Import
- Select the template created earlier with name VirtueMart manufacturer categories import
- Click Select file
- Select the file to import
- Click Preview
- You now see a preview of the file as to how RO CSVI sees the file
- Click Start import
- The import is run
- The Log details page will be shown with information regarding the import if the Enable logging is enabled in the template
Video showing the process
Creating manufacturer category
"mf_name";"mf_email";"published"
"Manufacturer 1";"This email address is being protected from spambots. You need JavaScript enabled to view it.";"Y"
"Manufacturer 2";"This email address is being protected from spambots. You need JavaScript enabled to view it.";"Y"
Using VatTax percent for Virtuemart order export
Requirements
- CSVI 6.5+
- Joomla 3.0+
- VirtueMart 3.0
Most of the times user wants to export tax percent as separate columns in the export file for Virtuemart order export. This article explains on how to acheive these tax results as separate columns.
For example if there are three VatTax percent in Virtuemart as shown below
To get these columns in export file, First Update available fields, so these tax percent comes in the list of template fields for Virtuemart order export template. Then these fields can be selected as normal template fields.
Virtuemart stores these tax percent values in order_billTax field if present. CSVI will retrieve these tax values from order_billTax field for added tax percentage for export. A sample export file data is listed below.
| virtuemart_order_id | Tax 20% | Tax 7% | Tax 10% |
| 1 | 42.25 | 7.29 | 0 |
| 2 | 41.25 | 0 | 0 |
| 3 | 0 | 7.29 | 0 |
Export VirtueMart retail prices
Exporting retail prices in VirtueMart is a little complicated because of the shopper groups that prices are assigned to. Since we cannot ask VirtueMart for a price for a specific shopper group we need to workaround that, and this is explained here. This is only related to retail prices, not the product_price field since the product_price field has no calculations applied.
Retail price fields which can be exported are
- basepricewithtax
- discountedpricewithouttax
- pricebeforetax
- salesprice
- taxamount
- discountamount
- pricewithouttax
Preparing the template
The first step is to select a shopper group for which you want to export the retail prices.
- Load the product export template you want to use or make a new one.
- Click on the Options tab
- Set the Shopper group name price option to the shopper group you want to export. In this example that is the -default- group.
- Save your template
Preparing the user account
Since we cannot tell VirtueMart directly which shopper group to use we must do so indirectly. This is done by changing the shopper group settings of the user account that is going to perform the export.
- Go go to VirtueMart
- Click on Orders & Shoppers
- Click on Shoppers
- Find the user account that is going to perform the export or create one
- Edit the user account
- In the option Shopper Group choose the exact same group as you chose in your export template. In this example that is the -default- group. You can only choose 1 shopper group here, if there are multiple only the last shopper group will be used.
- Save the user account
Note: If you have chosen All shopper groups in your export template, you must choose a shopper group here that has no prices assigned to it. It is recommended to create a shopper group just for this purpose.
Running the export
Now that the template and user account have been setup we can run the export to get the retail prices.
- Login to the website with the user account that needs to run the export
- Go to Components -> CSVI Pro -> Export
- Load the export template
- Click on Export
- The exported file will now contain the retail prices of the -default- shopper group
To get the prices of other shopper groups repeat this process for each shopper group you want to export.
Managing multiple shopper groups
In case there are multiple shopper groups for which you need to run exports it is recommended to create a specific user account for each shopper group so you don't have to keep changing the account settings.