CSV Files to Magento Migration

Step-by-Step Guide to Importing CSV Files into Magento

Follow these three steps to prepare your files, check your data, and run the migration in the LitExtension app:

Step 1. Prepare Your Data and Connect Magento

Prepare the data you want to migrate, such as products, customers, and orders. Use separate files for each data type where possible. If an export is split into multiple files, you can upload the parts together.

Sign in to the LitExtension app, open New Migration, and select Files (CSV, Excel, Google Sheets) as the Source Cart Type.

Add your data using one or more of these methods:

• File Upload: Upload CSV, TSV, XLSX, or XLSM files. You can add up to 50 files, with a maximum size of 50 MB per file.
• Google Sheets: Set sharing to Anyone with the link can view, open the tab you want to import, and copy its URL. Each link reads one tab, so add a separate link for each additional tab.
• Link: Add a public link to an individual CSV or Excel file from Dropbox, Google Drive, or OneDrive. The link must open the file without requiring a login.

Review the uploaded-file list and check the File, Data Type, and Rows columns. Correct any incorrectly detected data type. If the same product or customer appears in multiple files, the system uses the record from the file listed first.

Make sure image URLs are publicly accessible. Add the optional Old Store URL if your files contain relative image paths, such as /images/product.jpg, or if you need supported redirect options.

Select Magento as the Target Cart Type, enter the required store details, and follow the connection instructions. Back up your Magento store and pause automated customer emails or workflows that imported records could trigger. Once the target store is connected, continue to Prepare Data.

Step 2. Map Your Fields, Check Your Data, and Configure the Migration

Review Field Mapping to match the columns in your files to the corresponding Magento fields. LitExtension automatically maps recognized file formats. Use the record previews to check the mapped values and adjust any incorrect matches.

Select the correct Product Identifier so rows belonging to the same product are grouped with their variants and images. Check product names, SKUs, prices, quantities, image links, and the fields used to associate related records.

For customers, choose an available ID, email, or phone column as the Customer Identifier. Deselect fields you do not want to migrate, and retain additional columns as custom fields where supported.

Use AI Mapping Suggestions if unfamiliar column names make mapping difficult.

Click Next: Data Check to save the mapping and validate the entire dataset. Data Check does not transfer data.

Review the results before continuing:

• Ready: Records eligible for import, including records with warnings.
• Errors: Problems that prevent affected records from being imported.
• Warnings: Issues that allow import but need review.
• Skipped / Duplicates: Records excluded because of errors or duplication.

Choose whether to skip invalid records and continue, or block the affected data type until its errors are fixed.

To correct problems, download the Results File, review the status information for each row, fix the affected records, and replace the uploaded file. Then click Check Again.

If you edited a file accessed through a shared link, use Refresh link or add the link again before checking the data. The system downloads linked files when they are added, so later edits are not picked up automatically.

Run Data Check again whenever you change a file, Google Sheet, or mapping. The system requires an up-to-date check before migration can start.

Once the data is ready, open Configuration. Select the supported data types you want to transfer to Magento. Reviews are not currently supported through Files Migration.

Choose the additional options available for your migration and review Order Status Mapping where available. Check the selected data types and settings, confirm that you have reviewed the configuration, and proceed to the free demo.

Step 3. Run a Demo, Review the Results, and Run Full Migration

Start Free Demo Migration to transfer a small sample of records to Magento. Keep the source files and Google Sheets unchanged while the migration runs.

When the demo finishes, use View to inspect the migrated records in the Magento admin. Compare them with the source files and check:

• Products: Names, SKUs, prices, variants, images, and inventory.
• Customers: Email addresses and address details.
• Orders: Order statuses, amounts, and associated customer and product information.

Verify the results of any additional options you selected. If you enabled redirects, open sample old URLs and check that they lead to the correct Magento pages.

If you find incorrect or missing information, return to the source data or Field Mapping, make the necessary changes, run Check Again, and select Demo Again.

Once the demo results are correct, click Next: Confirm Orders, review the price, complete payment, and start Full Migration. This transfers all selected records eligible after Data Check. If the source data or mapping has changed, the system requires another check before payment.

Track progress in My Migrations. You can close your browser and return to check the migration later. Keep the required Magento access and image links available until the transfer is complete. LitExtension sends an email when the migration finishes.

After completion, compare the migrated record counts with the eligible records from Data Check and review representative products, customers, orders, and other selected data. Check their values, images, and relationships, then test the relevant customer journeys in your Magento store.