How to import products in batches by magento-magento Chinese tutorial

How to import products in batches by magento-magento Chinese tutorial

Admin

On March 16,201 1

-
Leave a comment

66 views

How
UseMagento
OfBatch Import
/Export configuration?How
InMagento
FastBatch
OfImport
A large number of product images?Where can I download magento batch import plug-ins?

Magento's "Import/Export" (Import/Export) tool is a very practical and efficient function. This article introduces how to use this tool.

You can use the import/export tool to import all products in batches. For example, using this function to add 100 products at a time is very simple. You only need
Create a CSV or XML file and ensure that all fields of the file correspond to the database. Enter information about your product and import it to the database using the import tool.

Export (export) is also very simple. Magento allows you to export all products of the entire site. If you need to reinstall the website or upgrade the website, exporting data is very necessary and practical.

Next let's talk about how to export (export) in magento)

Go to the management background and go to system-> Import/Export-> profiles.
This name may be a problem at first, but when you realize that the "Import/Export" (Import/Export) tool can import and export almost any data, you will understand why this menu
It is not just to write "Import and Export Products.

What you want to do is transfer all products from the local test environment to the Real Server (and vice versa). Fortunately, after magento is installed, there will be a configuration file (profile) it is called export all products. click Edit and open it.

Note that the file name is filename and path, because this is the location of your magentosave. CSV file. If Excel (or other forms in the spreadsheet Editor) uses different delimiters, you can also set the delimiters in the data format.

Run profile. Click "Run profile in pop-up" and wait for. magento
Now, you can use ftp to log on to the/var/export folder. You can see a. CSV file.
File appears. After the magento operation is complete, you can download the file to the local computer.
How to import product data

By default, there is also a configuration file named "import all products" for all products ". path: System-> Import/Export-> profiles. click Edit to import all products "import all products ".

Go to the Upload File page and select the CSV file you just exported.

Click Save and edit save and continue editing. this step uploads the CSV file. Then, on the run profile page, select the CSV file and click Run profile in pop-up.
 
Warning: please do not close the window during importing/exporting data)
---------------------------------------
Your server PHP settings allow you to upload files not more than 32 m at
Time. Please modify post_max_size (currently is 32 m) and
Upload_max_filesize (currently is 32 m) values in PHP. ini if you want
Upload larger files.

Make sure that data encoding in the file is consistent and saved in one of supported encodings (UTF-8 or ANSI ).
-------------------------------------

Further explanation:

There are two main considerations for Product Import: editing product data tables and uploading images.

I. Prepare the product information file. The imported product information should be in CSV or XML format.
If you enter the background management interface system-> Import/Export-> profiles, you can export some product data to see the format example.
Note: For how to set the main field (column) values in the product data table, see magento background Product Information Management and editing.

Ii. Go to the background management interface system-> Import/Export-> profiles
Create a new profiles. In fact, the system has built several commonly used profiles, one of which is called: import all products.
In the file information section of the profiles, you can set the options.
Data transfer: Local/remote server, interactive
1) if you select local/remote server, the following three options are displayed:
Type: local server/remote FTP
File Name: for example, import.csv
Path: for example, var/import. The path here is relative to the magento installation directory.
When you select remote FTP, You can import edited files from the remote FTP server.
Number of records: number of imported records, that is, the number of imported product information.

2) If data transfer selects interactive, none of the options above exists. This method requires uploading files on the Upload File page.

Iii. Select 1) Import mode. Assume that the path is set to var/import. Then you need to store the configuration file. Next, perform the following two steps:

A) Upload the excelfile in the csvor xmlformat (the extension name should also be .csv) to the $ magento_installed_dir/var/import directory. The name should be the same as the file name in the configuration;
B ).
If an image is uploaded, the image should be uploaded to the $ magento_installed_dirmediaimportproductspic directory or its subdirectory. False
Set the image value of a data column in the CSV file to/productspic/ugg001.jpg. In this case, upload the ugg001.jpg file of the product.
To the $ magento_installed_dir/import/productspic/directory.

In this way, images are correctly stored when the product is imported. Of course, if the CSV file has an image column, but the image itself is not uploaded, The magento import program will automatically ignore this column.

In addition, the magento import program determines whether to update or add new records based on the SKU attribute of the product.

At the same time, magento consumes system resources and time to import product data in batches. Therefore, you need to relax the server resource restrictions, script running time, and other optimization performance measures.

Note that the bulk import file encoding format must be ANSI or UTF-8 encoded to ensure that the import file is recognized and read by the magento system import product.

Remember: before importing a CSV file, upload the product image to media/import/, and add "/" before the column Image value. Otherwise, the product image cannot be displayed on the foreground.

To help new users learn how to import product information in batches as soon as possible, we provide a product data table setting template for your reference.

Download magento batch Import Product Data Sample Table: import_example_products.csv