IMPORT

all kind of files.

CSVI is a versatile management tool for importing all kinds of data into many different extensions.

Learn More

EXPORT

the easy way.

Export your data into different formats to different locations, automatic or manual. The choice is yours.

Checkout our Features

IMPORT AND EXPORT INTO AND FROM JOOMLA! 3 HAS NEVER BEEN SO FAST

CSV Improved enables you can import and export data into and from different Joomla! components.
Every component features its own import and export types to allow control over every part of the component.
Using a system that works based on a set of pre-defined fields you can match your fields with the CSV Improved fields to ensure a correct import. This way you can import all kinds of files from different kinds of sources,
for example from your supplier.
Using the same set of pre-defined fields you can set your own export fields to export for an accounting package, order list, order picking list and many other uses.

 Template based import/export Multi-component Support  Automated import/export Rule engine Field mapper Multi-source IMPORT/EXPORT

Learn More

Background information

The ability to import custom field filter values and filter them using the Multiple Customfields Filter for Virtuemart.

Creating the custom field

Before you can start to import your filter values, you first need to create a custom field with a plugin of the VirtueMart2 multiple customfield plugin type. Take these steps to create the custom field:

  1. Click on Custom Fields in the left menu in the Products section
  2. Click on New
  3. Fill in the following fields:
    1. Custom Field Type: Plug-ins
    2. Title: Color (Remember this name as you will need it later in the CSV file)
    3. Published: Yes
    4. Parent: Don't change
    5. Cart Attribute: No
    6. Description: Change as you like
    7. Default: Don't change
    8. Tooltip: Don't change
    9. Layout position: Don't change
    10. Admin Only: No
    11. Is a list?: No
    12. Hidden: No
    13. Select a plug-in: VirtueMart2 multiple customfield plugin
  4. Click Save
  5. Go to the bottom of the page and notice there are some settings that can be set.
    Multiple Customfields filter plugin

    Set the Output template to multiselect-chosen.

    For this example fill the parameters with:
    1. Green
    2. Blue
    3. Yellow
    4. Pink
    5. Grey
  6. Click on Save & Close
  7. The Custom field has now been created

Creating the CSV file

An example CSV file for existing products looks like this:

"product_sku";"custom_title";"custom_value";"custom_param";"product_name";"product_in_stock";"product_price"
"10001";"Color";"param";"Blue#Pink#Grey";"Product with filter";"0";"100"

Let's have a closer look at the fields

product_sku

This is the unique code for a product.

custom_title

The name of the custom field. The correct name can be found on the Custom Fields page in VirtueMart in the column named Title. This is the name used in step 3.2 when creating the custom field.

custom_value

This must always be param.

custom_param

The custom_param fields holds all the values you want to assign to the product, each one separated by a #.

product_name

The name of the product.

product_in_stock

The number of products that there are in stock.

product_price

The price of the product. This field is required for the parent product otherwise the selections will not show up.

Multiple parameters

It is possible that you have multiple filter fields that you want to assign to a product, for example Color and Size. The CSV file looks like this:

"product_sku";"custom_title";"custom_value";"custom_param";"product_name";"product_in_stock";"product_price"
"10001";"Color~Size";"param~param";"Blue#Pink#Grey~M#L#S";"Product with filter";"0";"100"

If you have 2 custom titles, there must also be 2 custom values and 2 custom parameters.

Latest Updates

  • Time for change

    25 July 2019 in News

    Moving For almost 14 years, this site has been the home of CSVI Pro. We have seen the likes of Joomla 1.0 moving to Joomla 1.5, then Joomla 2.5 and finally Joomla 3.0 and been by it's side all the way. Supporting each and every version of Joomla. This is not going to change, only the place from...

    Read More ...

  • CSV Improved Pro 7.12.0 released

    16 May 2019 in News

    CSV Improved 7.12.0 As 2019 is speeding by we have been working hard on this release and the new features it brings. There is a lot to look forward to as we added some productive features. Templates Using templates is now even easier than before. Templates can be backed up directly from the...

    Read More ...

  • CSV Improved Pro 7.11.0 released

    07 January 2019 in News

    CSV Improved 7.11.0 We kick off 2019 with a new release which contains some notable fixes and additions. No major changes this time so it will be a smooth update. HikaShop The export of custom field values was not working but funny enough this issue has been around for quite some time and only...

    Read More ...

My Member Software

My Member Software

My Member Software is open source club membership software with which Associations, Clubs, Foundations and even companies can administrate their members and is integrated in the Joomla CMS.

You can use RO CSVI to easily import your user data into My Member Software, create Joomla user accounts for your members and even perform batch updates on member data.