VirtueMart Product Import – Supported File Formats
Online store performance depends on how efficient and workable are techniques you use for product management. VirtueMart import of products is proved to be the fastest way to arrange products and associated data, using which store proprietors can short out lots of monotonous tasks.
Store Manager for VirtueMart allows its users to import product data via fully-functional import wizard instrument. Of course, it is a great asset, since huge data sets can be transferred to VirtueMart, products that need renewing, will be updated or new ones will be added to the catalog. Nevertheless, there are some factors that determine VirtueMart data import success and accuracy.
Quite often online merchants find out that the import medium they use do not accept this or that files or information provided in the file is not sufficient. To avoid mishaps or inaccuracies in the process of VirtueMart import from the file you should be informed of file formats Store Manager accepts and main file requirements. Below in this article we enumerate file formats accepted and provide file examples that can be downloaded.
Comma Separated Values File (CSV)
This is almost the most widespread file format used by store owners. CSV files can be defined as text files where information is arranged in columns and rows. The first row of this file includes column names. Special characters (file separators) are used to detach information in .csv file.
Extensible Markup Language File (XML)
Other format supported by Store Manager for VirtueMart import utility is .xml. Extensible markup language file is characterized by tree structure, product and associated details come in lines, enclosed in tags (opening and closing).In order to properly organize .xml file, check sample or download zip .xml file
Excel File (XLS/XLSX)
XLS/XLSX spreadsheets stand for electronic tables and text within Microsoft Excel. Files of this type structurize information within rows and columns and may incorporate several sheets. Each product record is placed in separate row, the first one providing field names.Download .xls file or click here to download zipped file
Open Document Spreadsheet (ODS)
One more file format, Store Manager allows to import from, is ODS, created by OpenOffice utility. These files are saved in UTF-8 encoding, each product is recorded in separate row and the first row traditionally includes field names.
Text File (TXT)
TXT also belongs to the list of files Store Manager for VirtueMart supports. Text spreadsheets carry sequence of strings or electronic text and can be processed by any utility that reads text. Initial line of text file contains names of the fields.
Notwithstanding VirtueMart import file format used for data upload, you should consider the fields it incorporates. Having product name and SKU only, you can add new products and get them displayed at the website. Although, you may find it insufficient and definitely would like to add more details to your VirtueMart products. In such a way, it’s recommended to include product price, the category or categories products will be placed to, product description, quantity, images and other details. If you are going to renew already existing products, the file should possess product identifier (ID or SKU) and fields to be updated.
Store Manager for VirtueMart provides more possibilities for flexible and fast data upload performing. It accepts information provided in .csv, .xml, .xls/.xlsx, .ods, .txt files and you can choose between them.