WooCommerce to OpenCart Migration

If you prefer to work with exported data instead of connecting your WooCommerce 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 WooCommerce to OpenCart Using CSV Files

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

Step 1. Export WooCommerce Data and Connect OpenCart

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

In your WordPress admin, go to Products > All Products > Export. Select the columns, product types, and categories you need, then click Generate CSV. Include the product IDs, SKUs, descriptions, prices, stock quantities, attributes, category assignments, and image URLs needed for mapping. See the WooCommerce product export guide for the available export settings.

For customers, orders, and coupons, use a suitable export extension, such as WooCommerce Customer / Order / Coupon Export, or have your developer prepare the files. These records are separate from the built-in product export. Export each data type to its own file and retain customer IDs, order IDs, product references, and order line items so the records can be linked during mapping.

Keep variable products and their variation rows identifiable. Review how sizes, colors, variation SKUs, prices, and stock should be represented in OpenCart before starting the transfer. If you also need category descriptions, category images, or SEO fields, provide those details in a suitable export rather than relying only on the category names in your product CSV.

When exporting product or category images, choose public image URLs where available. This helps LitExtension retrieve the images during migration. Keep your WooCommerce 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 or configure supported redirect options.

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 WooCommerce 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 WooCommerce 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 WooCommerce 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.

WooCommerce to OpenCart Data Mapping

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

Review variable products separately: WooCommerce variations and OpenCart product options use different structures, so confirm the required handling of option combinations, SKUs, prices, and inventory with our experts. Product attributes alone do not establish how variations 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 WordPress pages, blog posts, custom fields, or plugin-managed data, contact LitExtension experts to review your requirements.