Import Tutorials

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.

 

Last Updated: Wednesday, 23 December 2015 07:13

My Member Software

My Member Software

My Member Software is the downloadable open source member administration program with which Associations, Clubs, Foundations and even companies can administrate their members and is integrated in the Joomla CMS.

You can use CSV Improved to easily import your user data into My Member Software.

Read all about My Member Software.