Get Products Displayed Even If Import File Does Not Contain Required Fields
Date: June 27, 2014
VirtueMart import is definitely faster and more convenient way to add merchandise to your web store database. Product import from the file, unlike manual VirtueMart add product, shorts out lots of routine tasks related to product details input, making product management flexible and time-saving in that way.
Product import expects you to have file, where necessary products and associated details are provided. To upload this file with success you should proceed with a couple of settings and within short span of time desired entities will be transferred to VirtueMart database. Still there is the “buts”. The datafeed that undergoes import procedure should be inspected before you start importing, since some of the fields are required and if values are not included in these fields or misused, imported products will not be available at the front-end.
Suppose you designate settings for products that are out of stock. Among the variety of actions available you select “Do not Display Product” one. Correspondingly, if you upload products and somehow omit the field responsible for stock or 0 value is provided in this field, these products will not be accessible at the front-end.
What is the way out is such a situation? What should be done in order to perform VirtueMart add product operation successfully and make products displayed for shoppers? You come to the conclusion that missed data should be added to the file to be imported. Although, huge datafeeds editing can be burdensome and wasteful. If you want to quickly and effortlessly input details right in the course of VirtueMart import you can do it with the help of Store Manager for VirtueMart.
How does Store Manager sort the situation out? This solution allows to substitute missed or wrong values by default ones directly in the process of data import to VirtueMart.
What Is Default Value?
Default values can be defined as prearranged entities that are implemented at the time of data transfer. Despite values provided in the file (if they exist in the file) product related fields will obtain prearranged values if you set default values for them.
When Should Default Values Be Applied?
In order to import VirtueMart products you have to specify import settings throughout several steps of the import wizard. Logically, you have to indicate what file products are recorded in and set its delimiters. For example, you’ve got the file that looks like the one disposed below. The file comprises product IDs, their SKUs, names, description, price, currency, categories, weight and weight unit. Fields, responsible for product representation at the front-end are not provided in this file.
Afterwards Store Manager offers you import options for accurate data transfer. You may specify the import method, price import method, manufacturer import option or perform after import operation if necessary.
If you are done with this, you continue with fields mapping. File columns are being associated to related database fields. “Set Default Values” accessible on the toolbar, respectively, is responsible for default values applying. After you click on this button “In Stock” and “Published” fields will be filled with predefined values.
After VirtueMart import of products are complete, you will find out that the fields, you applied default values for, are filled in Store Manager application. After import these very merchandise will be displayed for shoppers, so that they can add them to the cart.
Store Manager for VirtueMart eliminates product management inconveniences and lets store owners adjust or input information right in the time of file import to VirtueMart. Read more on this topic at http://virtuemart-manager.com/useful-articles/tips-tricks/use-expressions-and-modify-data-right-in-the-process-of-import-to-virtuemart
Download free trial version of Store Manager for VirtueMart at http://virtuemart-manager.com/free-download