Magento to OpenCart Migration

If you prefer to work with exported data instead of connecting your Magento store directly, LitExtension Files Migration lets you transfer supported records to OpenCart using CSV, Excel, or Google Sheets. You can upload your files, map the fields, validate the data, and run the migration without manually converting every file into OpenCart’s native import format.

How to Migrate from Magento to OpenCart Using CSV Files

Follow these three steps to complete your Magento to OpenCart migration using LitExtension Files Migration.

Step 1. Export Magento Data and Connect OpenCart

Start by exporting the Magento data you want to migrate, such as products, product categories, customers, and orders.

For Magento 2, open System > Data Transfer > Export. Select Products, keep CSV as the file format, choose the required attributes and filters, then click Continue. Retrieve the completed export from your Magento installation. See the official export guide for your setup. For Magento 1, use the export tools available in your installed version.

Export Customers Main File and Customer Addresses separately where available. Keep identifiers that connect customers with their addresses and orders. For order history, check the CSV export in your Orders grid, then inspect its columns: a summary export may need a fuller export or developer-prepared file to include purchased items and customer relationships.

Keep configurable parent products and their associated simple-product SKUs identifiable in your files. Retain relevant store-view values and image paths. Category descriptions, category images, coupons, or other records may need separate exports. Before uploading, make sure your files contain the details you want to transfer, rather than assuming a product CSV contains every Magento entity.

When exporting product or category images, choose public image URLs where available. This helps LitExtension retrieve the images during migration. Keep your Magento store accessible until the transfer is complete.

Next, sign in to the LitExtension app, create a New Migration, and choose Files (CSV, Excel, Google Sheets) as the Source Cart Type.

Add your exported data using one or more of the following 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, then paste the URL of the sheet you want to import. Each link reads one tab, so add separate links for additional tabs.
• Link: Add a public link to an individual CSV or Excel file hosted on Google Drive, Dropbox, or OneDrive. The file must be accessible without signing in.

Check each uploaded file’s Data Type and Rows, and correct any incorrect detection. If the same product or customer appears in multiple files, the system prioritizes the record in the file listed first.

Make sure your image URLs are accessible. You can also provide the optional Old Store URL to help resolve relative image paths and identify your original store URLs.

Finally, select OpenCart as the Target Cart Type, enter your OpenCart store details, and follow the on-screen connection instructions. Back up your existing OpenCart data and pause any automated emails or workflows that imported records might trigger before continuing to Prepare Data.

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

In Field Mapping, match the columns from your Magento exports to the corresponding OpenCart fields. LitExtension automatically recognizes some common data structures, but you should review the record previews and correct any mismatched fields.

Choose the appropriate Product Identifier to group product records with their variants and images. Review product names, SKUs, descriptions, prices, inventory, categories, and other available fields.

For customer records, select a suitable Customer Identifier, such as an ID, email address, or phone number. You can also deselect fields you don’t need, adjust supported custom fields, or use AI Mapping Suggestions when column names are difficult to match.

When the mapping is ready, click Next: Data Check. LitExtension checks your files for data issues before anything is transferred to OpenCart.

Review the validation results:

• Ready: Records eligible for migration, including records with warnings.
• Errors: Issues that prevent affected records from being migrated.
• Warnings: Issues worth reviewing, although the affected records can still be transferred.
• Skipped / Duplicates: Records excluded because of errors or duplicate entries.

If errors are found, download the Results File to identify the affected rows. Correct the source data, replace the uploaded files, and click Check Again. You can also choose to skip invalid records or hold the affected data type until its errors are resolved.

If you update a file connected through a public link, use Refresh link or add the updated link again. Run Data Check again whenever you change the source files, Google Sheets, or Field Mapping.

Once the data is ready, open Configuration to select the supported entities you want to migrate and configure the available Additional Options.

Review Order Status Mapping where available, confirm your selected data types and settings, and continue to the Free Demo. Note that product reviews are not currently supported through Files Migration; contact our experts if you need to transfer review records.

Step 3. Run a Free Demo and Full Migration

Start Free Demo Migration to transfer sample records from your Magento files to OpenCart. Once the Demo finishes, use View to inspect the migrated records in your OpenCart admin.

Compare the results with your source data, paying particular attention to:

• Products: Names, descriptions, SKUs, prices, options, images, and inventory.
• Customers: Names, email addresses, and available address information.
• Orders: Order items, statuses, totals, and customer relationships.

Also verify the results of any Additional Options you’ve selected. If something is missing or incorrect, update the source files or Field Mapping, run Check Again, and select Demo Again.

When you’re satisfied with the Demo, click Next: Confirm Orders, review the migration price, complete payment, and start Full Migration. LitExtension transfers the selected records that passed Data Check.

You can monitor the process in My Migrations and return later without keeping your browser open. Once migration is complete, review the transferred records in OpenCart and test your product pages, shopping cart, and checkout.

Your Magento store can continue selling during the migration. If new orders, customers, or product updates are created after your files were exported, make sure those changes are accounted for before switching to OpenCart.

Magento to OpenCart Data Mapping

Use the table below to review the Magento fields and corresponding OpenCart fields for your migration. Available fields depend on the migration method, source data, and store setup.

Review configurable, grouped, bundle, and downloadable products separately. Confirm the intended OpenCart structure with our experts before including these product types. A matching product attribute does not establish how parent-child relationships, option combinations, or downloadable files will be transferred.

Not every field is available through every migration method. Product reviews are not currently supported through Files Migration, and password migration requires a compatible store-connected setup. For CMS pages, blog posts, custom attributes, or extension-managed data, contact LitExtension experts to review your requirements.