1 vote from 1 votes

Magento Product Import – Supported Files

When you perform Magento import to database, you use a file to store all the product referred details, required to bulk add or update merchandise. File format determines how data are organized within the spreadsheet, in other words, it defines the way information is encoded for storage.

As it is generally known, nowadays there is a variety of file formats and, respectively, some may be supported by the import tool you use, whereas some are not compatible with it. Commonly used files for data exchange, supported by almost all import tools, are those of .csv format. Store Manager for Magento supports this file type and a couple of other file formats.

The table, provided below, lists all Magento import file formats Store Manager allows to import from, their characteristics and file samples.

Supported format Filename extension Note Samples
Comma-Separated Values File .csv A file of this type accumulates tabular data (number and text) in plain text form. Each line of .csv file represents one record. Data fields are detached from one another by separator, usually by comma, although other characters (semicolon, tab character) can be used. The first row of the file incorporates field names. Files of this type can be processed by any tool that operates with text files. Download sample of .csv file or Click here to download zipped file
Extensible Markup Language File .xml A text-based file, written in a markup language that determines a set of rules to encode a document in a way that is both - human and machine-readable. Markup symbols are used to describe the content of a file. Lines, that appear in .xml file, are enclosed into tags. First comes blue line indicating that this is .xml file. Each succeeding line has a pair of opening and closing tags around it and is called an element. Magento import file of .xml format consists of nodes, each containing information on one product.

Example of .xml file or Click here to download zipped file

Excel File .xls/.xlsx This file format is native of Microsoft Excel. Filename extension .xls stands for spreadsheets, created in Microsoft Excel versions released before 2007, whereas later versions use the .xlsx filename extension. When you open .xls/.xlsx file used for Magento import you can see data arranged in table, consisting of rows and tables. When you import data from .xls/.xlsx file that embraces several sheets, you can indicate what sheet products should be taken from.

.xls file or Click here to download zipped file

Sample of .xlsx file or its zipped version

OpenDocument Spreadsheet .ods Spreadsheets of this type are normally created by OpenOffice application. Files, that bear .ods extension, include spreadsheets, where data are organized in columns and rows. Correspondingly, when carrying out Magento data upload from .ods, you should choose the sheet products will be taken from.

Sample of .ods file or Click here to download zipped file

Text File .txt A text file is arranged as a sequence of lines or electronic text and can be read or opened by any tool that reads text and therefore is supposed to be universal.

Example of .txt file or Click here to download zipped file

Supported format Filename extension Note Samples

To sum up, we should emphasize that Store Manager application does not impose restrictions on the file, you import products from and recognizes information organized within .csv, .xml, .xls/.xlsx, .ods and .txt files. Moreover, you can map file fields to corresponding database fields, so that their names can differ. To successfully accomplish Magento data import from the file, follow instructions provided here - www.mag-manager.com/useful-articles/magento-product-management/magento-import-products/

You are not sure whether your file is suitable? Mail it and we will tell you what’s missing. Check my file!

Tags: Magento import, Magento import products, Magento import from file, Magento product upload, Magento product import

    Free upgrade to Magento 2 supported version