VMconnector is a complete solution that allows you to automate and integrate Virtuemart by connecting it to almost any data source - from CSV files and spreadsheets through to databases, accounting system and any other data source your can think of!

  • Automate store management tasks using our open source .NET client (or create your own client!)
  • Quickly update stock levels and product details by connecting VirtueMart to any product database
  • Synchronise sales figures with your existing accounting systems or spreadsheets
  • Integrate any external application with VirtueMart!
  • And loads more.... click here for more details

Live Demo

Seeing is believing. 

Try VMConnector right now, free of charge! 

Connect to our test server and manage products, categories and more in a real VirtueMart store environment.

Get started with the demo

For Store Owners

VMConnector could seriously help you save time and revolutionise the way you work.

With VMconnector you can automate product uploads, downloads and synchronise sales figures with your accounting systems and spreadsheets, and a whole lot more.

Information for Store Owners

For Developers & Integrators

VMConnector allows you to deliver unprecendeted levels of integration and functionality to your clients' VirtueMart setup. 

Integrate VM with product databases, accounting systems, automate store migration with bulk uploads and downloads and much, much more.

Information for Developers

VMConnector Demo Tutorial

User Rating: / 0
PoorBest 

The best way to understand how VMConnector works is to take a few minutes to read through this tutorial, and then try our live demo, where you can work on a real VirtueMart store in our test server.

VMConnector is installed on our test server, so all you need to do is install the free OpenSource VMClient, connect to the server, and you're good to go.

We also have a number of tutorials and walkthroughs available on our YouTube channel.

Download and configure the VMClient

  1. Download the DEMO VMCCLIENT: Download link

    VMCClient: Download VMCClient

  2. Extract the ZIP file to a temporary folder and double click on "setup.exe" to install.
    • IMPORTANT NOTE:
      • Remove any other VMCClient installation before trying to install this DEMO version.
      • The VMCClient DEMO is a locked version and you cannot use it for your shop. When you are done with the tutorial demo, remove it and install the latest VMCClient from the main install procedures.
    • The MS Framework 3.5 is required, the "setup.exe" will download and install it if required from Microsoft web site.
    • System requirements:
      • Supported Operating Systems: Windows Server 2003; Windows Server 2008; Windows Vista; Windows XP
      • Processor: 400 MHz Pentium processor or equivalent (Minimum); 1GHz Pentium processor or equivalent (Recommended)
      • RAM:96 MB (Minimum); 256 MB (Recommended)
      • Hard Disk: Up to 500 MB of available space may be required
      • CD or DVD Drive: Not required
      • Display: 800 x 600, 256 colors (Minimum); 1024 x 768 high color, 32-bit (Recommended)
  3. VMCClient starts automatically.
    (Please note that the VMCClient is open source vb.net, and you can customize it if required, to get data from any existing product database or source. For more advanced integrators or programmers, you can even build your own client [ php, c++, Java, ...] to call VMConnector web services functions). 

Using the VMClient on the demo server

Make sure the VMCClient is up and running (you can also have a look to the flash demo )

  • On the "Controls" tab, use the following details to connect to the test server:
    • URL: http://www.idtsa.com/demo
    • ID: demo
    • Password: demo

  • Select the "1 - Orders" tab and click "Get VM Sale Orders ..." button. (All VM Orders are downloaded as no special criteria were specified on the "Controls" tab page).

  • Click on "Export Order rows to file" button, override default file name "VMOrders.xls" to "Virtuemart.xls".

    Virtuemart Sale Orders, Customers, and ordered products are exported to an MS Excel Spreadsheet:


    Virtuemart Sale Orders Exported

  • Once orders have been downloaded, select the "2 - Customers" tab and click "Get Customers based ..." button.
    (All VM Customers information are downloaded based on previous sale orders downloaded).

  • Click on "Export Customer rows to file" button, override default file name "VMOrderCustomers.xls" to "Virtuemart.xls" (click Yes to replace the file).
    (We want to get all different sheets in the same MS Excel file "Virtuemart.xls")

  • Once customers have been downloaded, select the "3 - Products" tab and click "Get Products  based ..." button.
    (All VM products information are downloaded based on previous sale orders downloaded).

  • Click on "Export Product rows to file" button, override default file name "VMOrdersProducts.xls" to "Virtuemart.xls" (click Yes to replace the file).
    (We want to get all different sheets in the same MS Excel file "Virtuemart.xls")

  • IF you are a QuickBook user, you can click on the QuickBooks tab (only after downloading all 3 previous tabs), and export Customers and Invoices to QuickBooks IIF file. Please note that this is ONE IIF file implementation and it may vary according to QuickBooks version and accounts.
  • Select the "Catalog Categories" tab and click "Get VM Catalog Categories ..." button.

    • All VM Catalog Categories information are downloaded based on category name selection text field. If you write "hand|tools|...", you will get only categories containing the words (hand or tools).

    • Once the Categories are downloaded, if you click to select Category rows (+Ctrl or +Shift), and click on the "Get VM Products based on your Category selection" button. You will download only Products and child products related to the category rows previously selected.

      Specific category selection using part of category's name:

      Get Virtuemart catalog selected=

  • Click on "Export category rows to file" button, override default file name "VMCatCat.xls" to "Virtuemart.xls" (click Yes to replace the file).
    (We want to get all different sheets in the same MS Excel file "Virtuemart.xls")

  • Select the "Catalog Products" tab and click "Get All VM Catalog Products..." button.

    • All VM Catalog Products information are downloaded based on default shopper group.

    • If you want to download products with another shopper group prices, please click on the desired Shopper Group line and download again the products.

  • Click on "Export product rows to file" button, override default file name "VMCatProd.xls" to "Virtuemart.xls" (click Yes to replace the file).
    (We want to get all different sheets in the same MS Excel file "Virtuemart.xls").

  • The last "Product Types" tab is used to query and validate all product types and parameters + values to update VM catalog products with a visual reference for valid names and values.

  • Once these steps have been performed, locate your "Virtuemart.xls" file and open it.
    You can see that all previously exported sheets are in one single "Virtuemart.xls" file.

  • To update Virtuemart catalog products and categories, you can manipulate related Excel sheets, product and category rows or cells. More specific rules are specified within MS Excel commands help for VirtueMart Catalog Maintenance
    MS Excel products updates ready for upload to Virtuemart


  • Once you have updated the "Virtuemart.xls" spreadsheet, do not forget to save it.

  • Switch to the VMCClient, select "Catalog Products" tab and click "Import Excel file..." button. Select the "Virtuemart.xls" file and click ok.

    • Please note that the XLS sheet imported, correspond to the name specified in the bottom right end conner: "Please enter XLS sheet name".

    • This sheet name is used to export and import data to and from the spreadsheet.

  • If the import is fine, you can then click on the "Upload VM Products" button. After a confirmation all the XLS product lines will be uploaded to Virtuemart according to the "product_action"command field (productAdd, productUpdate, productDelete). See MS Excel commands help for VirtueMart Catalog Maintenance for more information on this.

  • For "Catalog categories", do the same as for  "Catalog Products" but on "Catalog Categories" tab.

  • IMPORTANT NOTE:To avoid having many different users uploading uncoherant data to our DEMO database, we have disabled the upload web services functions in the DEMO tool. Of course, all the VMConnector web services functions are available in our evaluation and production version.

    • Test VMConnector on your own server

    Now, if you feel like testing it on your own server you can download the VMConnector evaluation versions!

    buy

    Download the demo

    Want to try out VMConnector?

    Download the free live demo client here.

    Join our mailing list!

    Sign up to our mailing list and stay up to date!



    YouTube Channel

    youtube

    Check out the official JoomConnector YouTube channel for product demos, tutorials and screencasts!

    VMConnector News