VirtueMart

25 August 2019 | 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
4. Set Action to Export
5. Set Component to VirtueMart
6. Set Operation to SnelStart
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.

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 -> Export

Select the template created earlier

Click Export

The export is run

The Log details page will be shown with information regarding the export if the Enable logging is enabled in the template

Read more ...

16 August 2023 | VirtueMart

Required fields

You must have the Custom Fields for All plugin for VirtueMart installed and the Custom Fields for All plugin for CSV Improved.

Background information

The ability to import custom field filter values and filter them using the Custom Fields For All. Please note custom fields for all fields are not available as individual template fields. They are grouped under custom_title, custom_value and custom_param fields so they are differentiated with standard VirtueMart custom fields.

Creating the custom field

Before you can start to import your values, you first need to create a custom field with a plugin of the Custom Fields For All 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: CF4ALL (Remember this name as you will need it later in the CSV file)
   3. Show Title: Yes
   4. Published: Yes
   5. Parent: Don't change
   6. Cart Attribute: No
   7. Description: Change as you like
   8. Default: Don't change (Make sure this field is customfieldsforall)
   10. Tooltip: Don't change
   11. Layout position: Don't change
   12. Admin Only: No
   13. Is a list?: No
   14. Hidden: No
   15. Select a plug-in: Custom Fields for All plugin
4. Click Save
5. Go to the bottom of the page and notice there are some settings that can be set.
   
   
   
   For this example fill the parameters with:
   
   1. Metal
   2. Plastic
   3. Wood
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";"product_parent_sku"
"10001";"CF4ALL";"customfieldsforall";"Wood";"Product with filter";"0";"100";""
"100011";"CF4ALL";"customfieldsforall";"Plastic";"First Child Product with filter";"1";"";"10001"
"100012";"CF4ALL";"customfieldsforall";"Metal";"Second Child Product with filter";"1";"";"10001"

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 customfieldsforall.

custom_param

The custom_param fields holds all the values you want to assign to the product.

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.

product_parent_sku

The SKU of the parent product if it is a child product.

Results after import

After import the custom field values can be checked in VirtueMart Product edit page and on Custom fields tab.

Parameters with pricing

You can also add pricing to the custom fields if you have chosen for the price variant. The field custom_price must be added to the import file. The CSV file looks like this:

"product_sku";"custom_title";"custom_value";"custom_param";"custom_price";"product_name";"product_in_stock";"product_price";"product_parent_sku"
"10001";"CF4ALL";"customfieldsforall";"Wood";"9.99";"Product with filter";"0";"100";""
"100011";"CF4ALL";"customfieldsforall";"Metal";"9.99";"Child product with filter";"0";"";"10001"

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";"product_parent_sku"
"10001";"Color~Size";"customfieldsforall~customfieldsforall";"Blue~M";"Product with filter";"0";"100"
"100011";"Color~Size";"customfieldsforall~customfieldsforall";"Red~L";"Child product with filter";"0";"100";"10001"

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

Results after import

After import the custom field values can be checked in VirtueMart Product edit page and on Custom fields tab.

For child product there is an option to inherit parent values. So child product gets its own values and an option to inherit parent values.

Multiple parameters with multiple values

It is possible that you have multiple filter fields that you want to assign to a product with multiple selected values 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";"product_parent_sku"
"10001";"Color~Size";"customfieldsforall~customfieldsforall";"Red#Blue~S#M";"Product with filter";"0";"100";""
"100011";"Color~Size";"customfieldsforall~customfieldsforall";"Green#Orange~L#XL";"Child product with filter";"0";"100";"10001"

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

Results after import

After import the custom field values can be checked in VirtueMart Product edit page and on Custom fields tab.

 

Multiple parameters with the same name

In case you want to assign the same custom field to one product but with different values you can do so by adding the custom_multiple field to your import file. The CSV file looks like this:

"product_sku";"custom_title";"custom_value";"custom_param";"custom_multiple";"product_name";"product_in_stock";"product_price";"product_parent_sku"
"10001";"CF4ALL~CF4ALL";"customfieldsforall~customfieldsforall";"Metal~Plastic";"Y~Y";"Product with filter";"0";"100";""
"100011";"CF4ALL~CF4ALL";"customfieldsforall~customfieldsforall";"Wood~Leather";"Y~Y";"Child product with filter";"0";"100";"10001"

Results after import

After import the custom field values can be checked in VirtueMart Product edit page and on Custom fields tab.

Override and Disabler

It is also possible to set the override and disabler values to the custom field on import.

To set override for a custom field use custom_override field. This field can take two values Y or N.

To set disabler for a custom field use custom_disabler field. This field can take two values Y or N.

An example content with custom_override field is

"product_sku";"custom_title";"custom_value";"custom_param";"custom_multiple";"product_name";"product_in_stock";"product_price";"product_parent_sku";"custom_override"
"10001";"CF4ALL~CF4ALL";"customfieldsforall~customfieldsforall";"Metal~Plastic";"Y~Y";"Product with filter";"0";"100";"";""
"100011";"CF4ALL~CF4ALL";"customfieldsforall~customfieldsforall";"Wood~Leather";"Y~Y";"Child product with filter";"0";"100";"10001";"Y~N"

Result after import

An example content with custom_disabler field is

"product_sku";"custom_title";"custom_value";"custom_param";"custom_multiple";"product_name";"product_in_stock";"product_price";"product_parent_sku";"custom_disabler"
"10001";"CF4ALL~CF4ALL";"customfieldsforall~customfieldsforall";"Metal~Plastic";"Y~Y";"Product with filter";"0";"100";"";""
"100011";"CF4ALL~CF4ALL";"customfieldsforall~customfieldsforall";"Wood~Leather";"Y~Y";"Child product with filter";"0";"100";"10001";"Y~N"

Result after import

Multi language import

Starting from 7.5.0 version CSVI has support for importing custom fields for all for multiple languages. The example content explains how to import custom fields for all for Dutch and Russian languages. Same format can be followed for other languages. Follow the below steps to import multi language custom fields.

1. Make sure that you have needed languages installed in Joomla language manager
2. Set the multiple languages in VirtueMart Configuration page.
3. Create custom fields for Custom fields for all for Size and Color as explained above
4. Update available fields in CSVI
5. Run the import by setting custom values as in the below example content.

"product_sku";"custom_title";"custom_value";"custom_param";"product_name";"product_in_stock";"product_price";"custom_param_de_de";"custom_param_ru_ru"
 "10001";"Color~Size";"customfieldsforall~customfieldsforall";"Red#Blue~S#M";"Product with filter";"0";"100";"Rood#Blauw~S#M";"красный#синий~S#M"

You can now check the imported values on VirtueMart Custom fields page.

The custom fields values can also be seen from VirtueMart Products page for the default language in Joomla. For example if the default language set in Joomla Language manager is Russian then the values imported in field custom_param_ru_ru can be seen in VirtueMart Products page and on Custom fields tab. 

 

Export of Custom Fields For All

Custom fields for all fields can be exported in two ways. They can be added as individual template field or use custom_title, custom_value and custom_param field in your export template to get custom fields for all field values. These fields can be added as any other template field for export template. If you do not see the CF4ALL fields then update available fields.

Troubleshooting

When running the import of custom fields for all, if the values are not added to a product. Make sure that you have CSVI customfields for all plugin installed and enabled. 

CSVI shows a message if the plugin is not installed in the debug log area on import.

More articles on this subject

Read more ...

18 December 2020 | VirtueMart

This tutorial explains how to create a VirtueMart ratings 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.

Read more ...

10 November 2020 | VirtueMart

Creating the 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, say for example VirtueMart Product availability import
4. Set Action to Import
5. Set Component to VirtueMart
6. Set Operation to Product availability
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.

Adding the template fields

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.

Required fields

• product_sku

Criteria

Run the import

The import can be run by following these steps:

1. Go to Components -> RO CSVI -> Import
2. Select the template created earlier with name VirtueMart Product availability 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 RO 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

Video showing the process

 

Example file

product_sku,product_in_stock,product_available_date
H0183SH,5,2017-06-07

vm_productavailability_import.csv

Read more ...

31 August 2021 | VirtueMart

This tutorial explains how to create a VirtueMart Manufacturers 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.

Read more ...