VirtueMart
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.
Export shows product without tax
Sometimes an export looks like it has no tax. This could actually be correct.
What is happening?
When a file is uploaded and there is no product tax included in the upload, the product gets a product_tax_id of 0. After checking the product in VirtueMart, it does show a tax rate.
However, the database still says 0. After saving the product, the database will still be 0. This happens because the tax rate has not been changed in anyway, so VirtueMart leaves it as it is. There are 2 ways to make this work:
-
Change the tax on the product page to another value and then change it back. VirtueMart will then save the new tax value.
-
Import a tax rate or tax id via CSV Improved
Now CSV Improved can export a product price with tax.
No product SKU found
The message "No product SKU found" is a very common one and the cause is almost always the same. Delimiters.
When importing a file, usually a CSV file in this case, the data is separated by delimiters. For CSV Improved to understand the file that is being imported it needs to be told what delimiters the file is using. Let me show you with an example.
The delimiter setting in CSV Improved:
The file:
~product_sku~^~product_name~^~category_path~
~Wb1~^~Product1~^~Home/New Products~
~Wb2~^~Product2~^~Home/Products~
~Wb3~^~Product3~^~Home/Products~
The ^ separates the fields and the ~ encloses the text. Now CSV Improved knows how to read the file. Make sure both delimiters always match.