Introduction
The
Import/Export module under admin> Tools>Import/ Export section, mainly enables the user to export or import the information of Customers and Products among the TomatoCart stores. It implements the switch of the information of Customers and Products between several parallel systems.
Import/Export
Figure 1 shows the window of Import/Export module under admin> Tools> Import/ Export section.
Figure 1 the Import & Export window
The detailed features of the module include:
- Export the information of Customers in the database. A downloadable file will be generated after a successful export.
- Upload a local file, describing the Customers information, to the system, and resolve it. Finally it will be stored in the database after successful resolved.
- Export the Products information from the database. A downloadable file will be generated after a successful export.
- Upload a local file and a local package to the system, describing the information of Products and Product images respectively, and then resolve these two files. Finally the information will be stored in the database after successful resolved.
Note:
- Only the import/ export of simple products, excluding virtual/ downloadable products and gift certificate, are supported in this module.
- The exported information of Customers is without password information due to different operating systems. In need of the password information, users can manually edit the Customers module in the backend.
Click the “Customers” tab under Admin> Tools> Import/ Export, you will see the default setting of Export as shown in Figure 2.
Figure 2 Export customer
File Type:There are two file types: CSV(default)and XML. Users can choose one type as they need.
Fields terminated/ enclosed by:In case of CSV file, users have to specify “Fields terminated by” (character separator) and “Fields enclosed by” (unit separator). The default seperators are ,and “ respectively. In case of XML, these two fields are not editable.
Compression:Users can choose ZIP or NONE from the dropdown list. NONE is the default setting. A zip file will be exported when the ZIP is selected.
A download window appears after clicking the “Export” button as shown in
Figure 2.
Figure3 shows the window of Import Customers.
Figure 3 Import customer
The operation process is the same as Export customer, please refer to that section for details.
Note: In case of a compressed file, a resolution error will occur, unless users specify the uploaded compressed file as ZIP format.
Click “Import” and a success window will appear after a successful import, as shown in Figure 4.
Figure 4: Successful Window
Note: If the same record of the Customers information is contained in the system database, it will be directly covered after import.
Figure 5 shows the default information page to export products.
Figure 5 Export product
As with this section, please refer to Export Customers section mentioned above.
Figure 6 shows the default information page to import Products.
Figure 6 Import product
As with this section, please refer to the Import Customers section mentioned above.
Note: Considering the slow resolution process when the data are numerous , please be patient to wait either a successful window or a failure window. Don’t refresh the window when it’s in process.