xcart-to-magento

Migrate Data like Customer, Product, and Orders from X-Cart to Magento here i explain it in 2 step.

1) Migrate Product from X-Cart to Magento.
2) Migrate Customer of X-Cart into Magento.

1) How to Migrate Product From X-Cart to Magento.

here, it is provided into three different step.

1) Export

A) Export Data From X-Cart.

Go to X-Cart Back-end select menu Tools => Import/Export.
right hand side there is Link for “Export Data” select it.

Setting  export data follow as per below.

Select CSV delimiter = Comma,
Data rows per file: this field is not important. if you wish to export particular number of record into one csv file then fill how many number of record you want to put in one csv file. as per number of total record it create different csv file.
Do you wish to export images? select Yes for that
Now, Check as per given image.

1export_product_check_true_image

and then Click on Export Button.

Export will done successfully into default directory. you can see it by expand “Export packs” below the Export button.
There is given CSV files. click on particular CSV file and save it in your computer.

x-cart_product_csv_file

all products in your hands now to get images, go into your directory inside Var/tmp/export_YYYYMMDD_HHMMSS file. download this folder.

B) Export Magento Product CSV file for getting CSV format.

Select System => Import/Exprot => Export.

Select “Entity Type = Product and

Export File Format = CSV then Click on Continue.

Through this you will get CSV file Delete All the Data Except Column title and first record data of CSV.

or you can get Sample for Import CSV file from here => Sample For Import Product CSV

2) Setting up CSV File.

Now, Open Exported CSV file of X-Cart and Match column name with Magento CSV file and Paste data into Magento CSV file as per field.
Fill all the field as per given in X-Cart file and remaining filed value put default from First record.

Now, rename export_yyyymmdd_hhmmss folder of images with Import and put inside Media folder.

here, matcing field between X-Cart to Magento for products are given as below

!PRODUCTCODE => sku,
!PRODUCT => name,
!CLEAN_URL => url_key,
!WEIGHT => weight,
!LIST_PRICE => price,
!DESCR => short_description,
!FULLDESCR => description,
!TITLE_TAG => meta_title,
!META_KEYWORDS => meta_keyword,
!META_DESCRIPTION => meta_description,
!AVAIL => qty,
!LOW_AVAIL_LIMIT => min_qty,
!MIN_AMOUNT => min_sale_qty,
!PRICE => special_price,
!MANUFACTURER => turnkeye_brand,

3) Import

Select System => Import/Exprot => Import.

import_csv_in_magento

Then choose the file after which you are going to import. after choose click on Check Data Button.
after successfully checked file click on import.

2) Migrate Customer from X-Cart to Magento.

There are several important things you should know before customers data importing.

  • X-Cart allow to have several customers with the same E-Mail and Magento do not allow it. That is why we will collect the data by unique E-mail.
  • X-Cart store admins, providers and partners in the same table, so we will import usertype ‘C’ (customers) only.

1) Export

A) Export Data From X-Cart.

Go to X-Cart Back-end select menu Tools => Import/Export.
right hand side there is Link for “Export Data” select it.

Setting  export data follow as per below.

Select CSV delimiter = Comma,
Data rows per file: this field is not important. if you wish to export particular number of record into one csv file then fill how many number of record you want to put in one csv file. as per number of total record it create different csv file.
Do you wish to export images? select Yes for that
Now, Check as per given image.

export_customer_checked_true_image

and then Click on Export Button.

Export will done successfully into default directory. you can see it by expand “Export packs” below the Export button.
There is given CSV files. click on particular CSV file and save it in your computer.

x-cart_cusotmer_csv_file

Now you have Customer and Address book.

B) Export Magento Customer CSV file for getting CSV format.

Select System => Import/Exprot => Export.

Select “Entity Type” = Customer and

Export File Format = CSV then Click on Continue.

Through this you will get CSV file Delete All the Data Except Column title and first record data of CSV.

or you can get Sample for Import CSV file from here => Sample for Import Customer CSV

2) Setting up CSV File.

Now, Open Exported CSV file of X-Cart and Match column name with Magento CSV file and Paste data into Magento CSV file as per field.
Fill all the field as per given in X-Cart file and remaining filed value put default from First record.

Here, Association between X-Cart To Magento Customer CSV field are given below.

!TITLE => _address_prefix,
!FIRSTNAME => _address_firstname,
!LASTNAME => _address_lastname,
!ADDRESS => _address_street,
!CITY => _address_city,
!COUNTRY => _address_country_id,
!ZIPCODE => _address_postcode,
!COMPANY => _address_company,
!TITLE => prefix,
!FIRSTNAME => firstname,
!LASTNAME => lastname,
!EMAIL => email,
!PHONE => _address_telephone,
!FAX => _address_fax,

3) Import

Select System => Import/Exprot => Import.

customer_import_magento

Then choose the file after which you are going to import. after choose click on Check Data Button.
after successfully checked file click on import.

For Customer Password Migrate you need to Blowfish key you can find it from X-Cart’s config.php file at the end.

Issue Fixed By: Punit K. Gadhiya