Supported formats

• CSV
• XML
• Excel
• TXT

CSV

.CSV format stores tabular data in plain text. This file type has a pretty simple structure and can be read by many programs. Nowadays it becomes very popular and is used by different applications to exchange data. In e-commerce CSV is also wide used to import data to online stores. The great majority of internet merchants use CSV files, that’s why the process of import should be fast and easy.

File2Cart is an automated data import service that was specially designed to make data import simpler and more rapid. Now you can move all entities you need via CSV file to your shopping cart, including such popular platforms as Magento, PrestaShop, VirtueMart, etc.

Requirements for CSV:

• your CSV file should have UTF-8 encoding
• one product should be in one row
• every row should end in \r (Carriage Return) and \n (Line Feed)
• number of columns in other rows should be equal to the number of columns in first row
• first row should be a header
• categories and products should be in one file
• required fields: Product ID, Product Name, Product Description, Price
• product price should be in format 1,000 (or 1.000) for $1 (e.g. 36,990 (or 36.990) for $36,99)
• recommended field delimiters: ",", ";" or "|"
• description that has commas or more than one word should be written in quotation marks (e.g. "My product, my product.")

Example

You can download sample CSV files (csv, ~3kB): CSV with absolute image URL | CSV with relative image URL | CSV with image name only

XML

.XML is a markup language that is both human- and machine-readable. It contains different rules for proper encoding of the documents. It was designed to ease and enhance usability over the Net. XML is used to present not only documents but also data structure. That’s why XML is widely used in e-commerce these days to contain info about products, customers, prices, etc.

Providing simple, safe and swift import of your data, File2Cart supports over 30 shopping carts, including Magento, PrestaShop, VirtueMart and many other. Move products, images, categories and more from your XML datafile to your store for reasonable price.

Requirements for XML:

• your XML file should have UTF-8 encoding
• every child element should have equal number of sub-child elements (even if Several sub-child elements are empty)
• categories and products should be in one file
• required fields: Product ID, Product Name, Product Description, Price
• product price should be in format 1,000 (or 1.000) for $1 (e.g. 36,990 (or 36.990) for $36,99)
• Symbols '<' and '>' that are not tags should be written as & lt (without space) for '<'; & gt(without space) for '>'

Example

You can download sample XML files (zip, ~2kB): XML with absolute image URL | XML with relative image URL | XML with image name only

Excel

XLS / XLSX are file extensions for a spreadsheet file format created by Microsoft^TM for use with Microsoft^TM Excel.

XLS file format is known as the Binary Interchange File Format (BIFF). Data inside all Office Document files are stored in series of fixed-size streams. The location of each fixed-size stream is described by several sector allocation tables. These streams contain meta-data information about the document, such as the author name, subject, and individual sheet names.

XLSX file format is a combination of XML architecture and ZIP compression for size reduction. So, in other words, it is an archive that contains separate xml files with different data that you can.

Requirements for XLS/XLSX:

• one product should be in one row
• number of columns in other rows should be equal to the number of columns in first row
• first row should be a header
• categories and products should be in one file
• required fields: Product ID, Product Name, Product Description, Price
• product price should be in format 1,000 (or 1.000) for $1 (e.g. 36,990 (or 36.990) for $36,99)
• If you want to import customized data (e.g.: font, size, color, background, etc) it has to be written in HTML tags in your file

Example

You can download sample XLS/XLSX files (xls/xlsx, 3kB):

XLS with absolute image URL | XLS with relative image URL | XLS with image name only

XLSX with absolute image URL | XLSX with relative image URL | XLSX with image name only

TXT

.TXT is a file format that shouldn’t be strictly formatted. Its structure is usually series of plain text lines. TXT file is very simple and it can be opened by every editor that supports text recognition. It is universal, consequently it is good for data storage.

Import all necessary entities (including products, categories and so on) to your store with File2Cart. TXT import to more than 30 shopping carts (Magento, PrestaShop, Virtumart and many more) becomes much faster and easier.

Requirements for TXT:

• your TXT file should have UTF-8 encoding
• one product should be in one row
• every row should end in \r (Line Feed) and \n (Carriage Return)
• number of columns in other rows should be equal to the number of columns in first row
• first row should be a header
• categories and products should be in one file
• required fields: Product ID, Product Name, Product Description, Price
• product price should be in format 1,000 (or 1.000) for $1 (e.g. 36,990 (or 36.990) for $36,99)
• recommended field delimiters: ",", ";" or "|"
• description that has more than one word shold be in format "many words description" (e.g. "My product is the best.")

Example

You can download sample TXT files (zip, 1kB): TXT with absolute image URL | TXT with relative image URL | TXT with image name only