• Google+
  • VirtueMart Manager RSS
  • VirtueMart Manager YouTube
  • Follow VirtueMart Manager on Twitter
  • VirtueMart Manager on Blogger
  • VirtueMart Manager on FaceBook
8 AM - 7 PM (GMT) / 3 AM - 2 PM (EST)

How to Import Data from Excel Files to VirtueMart?

The maintenance of product details, their stock, price, categories assignment is indispensable for relevant VirtueMart catalog setting up. VirtueMart import from file is supposed to be the most widespread and productive way of data management, that ensures full-fledged product catalog administrating.

The commonest pattern of VirtueMart import is information appending to database from .csv format file. Nevertheless, oftentimes web shop proprietors have to deal with Excel files. Information that should be uploaded to VirtueMart might be sent in Excel files from wholesalers you cooperate with. It will require extra work to be done, when converting Excel files to .csv files. Moreover, it can be accompanied with mistakes and data structure violation.

Store Manager for VirtueMart helps you out comprising the possibility to carry out VirtueMart Excel import via the import wizard instrument. It allows you to seamlessly transfer Excel data from the file to VirtueMart just in several steps.

The mechanism of VirtueMart Excel import undertaking is quite approachable and presents no hardship. First of all you should heedfully look through the records, the file incorporates and ascertain nothing is missed and accurate values are specified.

The following facts about VirtueMart import from Excel files should be covered:

  1. When handling data with Store Manager you have numerous advantages. One concerns database backup fulfilling. Before any bulk procedure carrying out (including data import) you have the possibility to backup VirtueMart database and on condition that some malfunction occurs when updating store content you may proceed with database recovery.
  2. Store Manager confirms import of locally saved images as well as remote ones, what contributes to swift VirtueMart imagery management. Images upload can’t be executed until FTP connection is set up. Go to Tools -> Preferences -> FTP and indicate FTP details to be able to upload images to VirtueMart.
  3. Not to configure import settings each time you can make use of previously saved import configuration as well as save current import configuration on purpose to use it for succeeding data uploads performing.
  4. By means of Import Options you can specify whether new items are to be added to your web shop, current items must be modified only or both actions should be performed.

As it was mentioned above, VirtueMart Excel import is being carried out via product import wizard. Launch it from main menu, product context menu or product toolbar. Once you have specified the file, data will be uploaded from and selected sheet for import, .xls file will be converted to .csv and further import steps will be identical to .csv file upload steps.

VirtueMart Excel import
VirtueMart Excel import

Check whether product related data have been converted properly on CSV File Settings and Preview step and press Next to continue.

VirtueMart Excel import
VirtueMart Excel import

On Import Options steps you have to designate general product import options, price options, category options, custom fields options, manufacturer options. Note, if the file contains images that should be uploaded, you should check Upload Images box in this window and set up FTP connection.

VirtueMart Excel import
VirtueMart Excel import

VirtueMart Excel import efficiency depends on correctness of file columns and database fields associating. Link columns and fields properly so that data will be uploaded successfully.

VirtueMart Excel import
VirtueMart Excel import

The ability to proceed with Excel files upload to VirtueMart at an easy rate brings new perspectives to online vendors and improves VirtueMart store catalog administrating. Read related article on VirtueMart import from .csv - http://virtuemart-manager.com/useful-articles/product-management/virtuemart-product-import/

By Ira Svedovetska

Privacy Preference Center

Strictly Necessary

These cookies are necessary fro the site ot function.

woocommerce_cart_hash, woocommerce_items_in_card, wp_woocommerce_session_{hash}


These are used to track user interaction and detect potential problems. These help us improve our services by providing analytical data on how users use this site.

_ga, _gid, _gat-_UA-326982215-25, LaSID, LaVisitorId, __utma, __utmc, __utmv, __utmz

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?