Board index Magdeveloper Universal Product Importer (UPI) Offline CVS2XML integration tool UPI 1. The Basics explained (Dataflow, CSV, TXT Excel and Data

1. The Basics explained (Dataflow, CSV, TXT Excel and Data

Universal product support and extra updates and information

pietervdb Site Admin

Posts: 11
Introduction
When you want to start importing products into Magento you will notice that the standard import function is quite limited to process different data.
Below you can find the most common terminology when importing products into Magento. We will start explaining the most import basics first in this thread.


1 What is Dataflow? (Magento Basics)
Dataflow is the import and data engine of Magento. It allows the users to import a CSV file or XMl data file. You can find Dataflow when you login into your control panel. (permissions Administrator)

How to acces dataflow or the import products section of Magento:
-Login to your adminaccount
-goto system>Import/export> hit profiles

Image

1.1 Using dataflow to import or export products
When you are in the panel you can see multiple import and export profiles.
This is the normal way to import and export data.
Number 4 and 1 are the most common used profiles.

Image

1.2 Import profiles: What do you have to know?
-Import all products (profile 3) means when importing, import from all products regardless of the unique SKU.
-Import all products Stock (profile 4) but when encountering an unique SKU update the stock level. This will result in ONLY updating the products, stocklevel or additional data.

1.3 Using dataflow to export products from batch
1-Export your products using export all products. Using profile (1)
2-Click profile 1

Image

After you have clicked profile (1) you will notice above CSV exporting options. You might want to change the export a unique name (e.g. myproducts.csv) in order to remember it later on more easier.

Please notice:
At default the standard export name will be export_all_products.csv
Your CSV will be exported to var/export on your local server. (your webhost)


Remember these settings and hit save and continue editing settings.
1-Click Run profile.
2-Magento now will start exporting your CSV to your Local webhost.

1.4 Dowloading your CSV from Dataflow
Follow 1.3 Launch your favourite FTP client. Your webhost will provide you with your FTP credentials in most cases.
Navigate to your public html folder of your domain and goto your var/export. Here you will find your exported CSV or XML files.

Image

You can drag the .csv file to your desktop or download to a local folder using your favourite FTP client.

CSV, TXT and Excel formats explained

You all may have heared of CSV. It's a formatting of textdata in a specific order with a few simple rules
Data unformated and seperated with a separator symbol. e.g. comma, TAB, ~ l ; or any other character.

CSV format basic example:
text,text,text,text,text

Above example can be a CSV file. However, the above text can be replaced with any text like:

CSV format example with provided information:
Dell,computer,200.95,240.95,A really good computer

There is one thing left to define a good CSV data file. Most CSVs will contain a header..
A header you might as yourself? What is that?
Well...A header defines the type of data your CSV contains and is always the top row of your CSV, if provided. Please view below example:

Full CSV example with headers
product,category,costs,price,description <--header
Dell, computer, 200.95,240.95,A really good computer

Example of above csv with more products
product,category,costs,price,description
Dell,computer,200.95,240.95,A really good computer
Asus,computer,150.95,200,A fine laptop

Above sample in a datafile
Image

Return to UPI

cron