Help Online

First Steps

Virtuemart Prodcuts Manager is an application that basically allow you import products from excel to a virtuemart online store. To use the application you have to create an account in this site and add your virtuemart store(s) connection required data to your account. Later you have to download the application from the site and install it on your computer. Now, you can import or export hundred products secure and faster.

About the Application:

After install the application you can use it providing your email and password of your account of our site and choosing one of your stores to log in.

Once you login successful you can work with the products of your chosen store.

IMPORTANT! Before any operation you have to know:

To import or update products from excel you have already defined in you virtuemart store all categories that you assigned to products in excel, otherwise, you cannot import or update any products from the application to your store. This version 1.0 of VM Products Manager only focus in products managment.

Before using the application, please, you must check System Requirements in Home Page.

About Excel Model:

Excel Model filled with your products is the source from the application get the products to import or update in your store.

Something you have to know is that Excel Model always has to be in Microsoft Office 2003 format.

Excel Model has columns header that you must know the meaning of each one, and they are described below:

ItemCode: This is the that identify the product, in Virtuemart is Product SKU.
Note: This field is required in all operations with products.

ItemName: This is the name of product, in Virtuemart is Product Name

ShortDescription: This is the short description of product, in Virtuemart in the Product Description section is Short Description

LargeDescription: This is the description of product, in Virtuemart in the Product Description section is Description

Category: This is the category or categories of product, in Virtuemart is Product Categories.
Note: If your product has one category just type the name (Ex. CategoryName), but if your product has more than one category you must type the names of the categories separated by (|). (Ex. CatName1|CatName2|CatName3). We recommend that the name of every category be unique, for best behavior of the application.

InStock: This is the quantity of this type of product in the store, in Virtuemart in the Product Status section is In Stock.
Note: If when you import products you leave this field empty by default the appliaction assing it 10.

Price: This is the price of product, in Virtuemart in the Product pricing section is Cost price.
Note: If when you import products you leave this field empty the product stay without price.

PriceOverride: This is the price of product that override the original price, in Virtuemart in the Product pricing section is Override.

About Product Image:

When the application import all products from excel it create image for every imported products. Usually, all images of products is saved in the folder: ...images/stories/virtuemart/product/. The name of every image matchs with the product_sku of product that it belongs. So, if product_sku of any product is ltk65399 the corresponding image is ltk65399.jpg. Note that image is jpg extension.

All that means when you finish to import all your products you have to copy all images of products into ...images/stories/virtuemart/product/ with the name of product_sku that correspond to the product that every image belong.

About products thumbtails you can change the configuration of virtuemart under Templates tab and make that products thumbnails be generated automaticly with size you wish.