VirtueMart
Product Status
| VirtueMart | CSVI Import | CSVI Export |
|---|---|---|
| In Stock | product_in_stock | product_in_stock |
| Booked, ordered products | product_ordered | product_ordered |
| Low Stock Notification | low_stock_notification | low_stock_notification |
| Purchase Quantity Steps | step_order_level | step_order_level |
| Minimum Purchase Quantity | min_order_level product_params |
min_order_level product_params |
| Maximum Purchase Quantity | max_order_level product_params |
max_order_level product_params |
| Availability Date | product_available_date | product_available_date |
| Availability | product_availability | product_availability |
VirtueMart Products import
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.
VirtueMart Product Dimension Fields
This page shows which VirtueMart Product Dimension fields you can use for import and export.
VirtueMart Products export
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.
ICEcat Product Import for 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
| product_sku | manufacturer_name | product_desc |
| 80D0846 | LEXMARK ACCESSORIES | |
| 14V0801 | LEXMARK ACCESSORIES |
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.