You can easily add, delete or update your product information to/from your Virtuemart shopping website on a hosting on the internet by pushing a button after entering product properties on .xls Excel documents through vmExcel application that we have developed by using Excel VBA codes. 

Note: This is not a csv uploader program or a component of Joomla. It is a program made of Excel VBA codes which you will use just by entering into the Excel cells without having to enter phpMyAdmin or your website’s admin panel.

Demo Version Download :  vmExcel_Demo.xls (83 Kb)  (You can only use this demo version on our demo website below.)

Demo WebSite : The demo website where you can try demo version. www.excelcozumleri.com/ecshow

Paid Version Download :  Please submit your paid version request and needs from here.

Properties

• Load Data : Reads data related to used fields from VirtueMart database and import them into Excel. 
• New Product : Adds product data which are entered by typing new on "Product id" field to VirtueMart database.
• Update Selected :  Updates data related to line(s) selected by typing x in "Select" field on VirtueMart database. 
• Delete Selected :  Deletes data related to line(s) selected by typing x in "Select" field from VirtueMart database. 

• Category Filtering : You can call for, update or delete products by filtering them according to categories.
• Manufacturer Filtering : You can call for, update or delete products by filtering them according to manufacturers.

Used Fields

You can read and change all fields used in VirtueMart database. We selected below fields which are the most used fields of VirtueMart in Basic and Pro versions that we prepared. You may add other VirtueMart fields that you need in Custom version. 

vmExcel Basic :

It includes below fields which are necessary for the ones who use VirtueMart as a product catalogue.

• product_id    (Product id)
• product_sku    (Product SKU)
• product_name    (Product Name)
• category_name    (Category)
• product_publish    (Published (Y/N))
• product_price    (Price)
• product_s_desc    (Product Short Description)
• product_desc    (Product Description)
• product_thumb_image    (Product Thumb Image)
• product_full_image    (Product Image)
• mf_name    (Manufacturer Name)

vmExcel Pro :

It has been prepared for the ones who use VirtueMart with all shopping functions. It includes fields below in addition to all fields in vmExcel Basic. 

• product_currency    (Currency)
• amount    (Discount Amount)
• product_special    (Special Product (Y/N)
• product_availability    (Product Availability)
• product_in_stock    (Product in Stock)
• attribute    (Product Attributes)
• product_tax_id    (Product Tax Group)

vmExcel Custom :

Other fields which are needed by the customer can be added and which are not needed can be excluded. We can completely customize vmExcel for the customer. 

How to Use It?

1. Download the Demo Version from the download link above and save it to anywhere in your computer.
2. Microsoft Excel 2003 or higher should be installed.
3. Download MySQL ODBC connector driver which suits your operating system from the link http://dev.mysql.com/downloads/connector/odbc/5.1.html and install it on your computer.
4. Open vmExcel by enabling macros.
5. You should know Server Name/IP, User Name, Database Name and Password of the MySQL database to which you will connect and enter these information to related fields in vmExcel correctly.  (not necessary for Demo version)

(You can learn MySQL server name which published on the internet from your hosting firm. If you are to connect to server on the internet, access permission for your computer’s ip should be granted. You can do it by yourself from Cpanel or request from your hosting firm to conduct it.)  

Click here to submit your connection requests and needs to other components and systems through Excel.