Batch Export and Import of magento Products

How to use the "Import/Export" (Import/Export) tool to add, modify, and delete products in magento [
BK | Rd

4 ') sa7z) Jr + e �z2ph -@

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

6 s: J [5x
'*/

You can use the import/export tool to import products in batches. For example, using this function to add 100 products at a time is very simple. You only need to create one
CSV or XML files, and ensure that each field of the file corresponds to the database. For example, you can import all the information of your product and then use the import tool to import the database.
) O8/: S
{/6 p

Vs4 '! R ([n

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. WV; ehqplvf

: Njg/, tgj ~. P

[B] Next let's talk about how to export (export) in magento [/B]
{J ++ ~ W8s

/Ar4qs "X" P

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 tool can import or export anything, you will understand what this menu is
It's not just about "Import and Export Products.
0ma "u'ai] l
D

* E} + xho7tc

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. ({I ~ V_hiLZ-U

! X # T % ylu ^ R2 ~

Pay special attention to the two points: file name filename and Path, because this is the location where your magentosave .csv file. if Excel (or other form spreadsheet editors) uses different delimiters, you can also set them in data format.]; l1N-BT, O4}

D4fk
NSO |
U

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.
3f [|/In # w0e (P

! Ew.j.gz A: kr

[B] How to import [/B]
: Y | Vah

& Vc0f9dwi

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 ".
Squax

O0v5jZ-Vxuhh

Go to the Upload File page and select the CSV file you just exported. $ s
I
R1r # BT �o

# Q [og (W

Click Save and edit save and continue editing. In this step, the CSV file will be uploaded. Go to the run profile page, select CSV, and click Run profile in pop-up)
$ I
Y/ljjp (dw3tg

+ /? X7y? S *] V

[B] further explanation: [/B]
-Q: u1h! S @ % Wem

B. gqp8q! OT

Product Import is generally divided into two parts: one is the field itself, and the other is the image
"GV & H $ E: O 'a
Gg2u1 '0l * E (S

Dh3edj
Y2K

[B] I. [/B] Prepare the product information file. The imported product information should be in Excel format in CSV or XML format.
Vyr. c9v! U2d

If you enter the background management interface system-> Import/Export-> profiles, you can export some product data to see the format example j2ndn! L

Mimsxh

[B] II. [/B] Go to the background management interface system-> Import/Export-> profiles
-M9_h4 ^ FF-G # F

Create a new profiles. In fact, the system has built several commonly used profiles, one of which is called: import all products. % wn5v! Y
G5z u-K8F

In the file information section of the profiles, you can set the data transfer: Local/remote server, interactiveq + dna z option.
^ G6 {

] 'Q-I "C8} 'L ^

1). If you select local/remote server, the following three options are displayed:! U | % R! I) | ef

Type: local server/remote FTP
N/A % ZQ
C % Q �fn1b7dk # d
W

File Name: for example, import.csv

|; M. ujo -? T

Path: for example, var/import. The path here is relative to the magento installation directory.
L & Hz (I) P // 0d/9z

When you select remote FTP, You can import edited files from the remote FTP server. N8h
L_hr + wh's

'G, L * uev5 [! H

2) If data transfer selects interactive, none of the options above exists. This method requires uploading files on the Upload File page.
C: p_ek "C/@ 4AR, FP {@

YJ/{f5o @ % L "N. M
D ;_

[B] III. [/B] 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: 2 P (@ DWD
D

| "'T0ubdq tv7 ~ |

A) Upload the csvor xmlformat excelfile (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 configured for this configuration.
GSS ^ '_ (qof

3cy8hv3w3 | r

B ).
If an image is uploaded, the image should be uploaded to the $ magento_installed_dir/Media/import directory or its subdirectory. Assume that the CSV file contains
The column Image value of the data entry is/M/6/mobile.jpg. you should upload the product file mobile.jpg
$ Magento_installed_dir/Media/import/M/6 directory. G4 @ + EG ^ r N5 {_ # w'h

0 h % Oa. 0000u + T; M' W

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.
Tty5gwdf # GL

L #] % ij6rez

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