Next-Cart

XLS to OpenCart Import

Import products, customers, orders, blog posts, and other supported store data from XLS to OpenCart securely and accurately while preserving data relationships throughout the transfer.
No Downtime,
No Coding Required
Keep your store running during migration. No coding or technical skills required.
Free Demo Available
Preview a sample of your data in the target store before starting the full migration.
1-Year License
with Repeat Migrations
Repeat your migration when needed, including new or updated data, within your plan’s data limit.
Expert Technician Support
Get expert help with connections, configuration, migration issues, and data validation throughout your migration.

How to Migrate XLS to OpenCart

Connect the source and target, choose the supported data and options, and review the results. The steps below describe the tool workflow; expert-led and custom projects may follow an agreed plan.
Upload your source XLS files
Connect your target: OpenCart
Configure and start the migration
Review results & post-migration options
1
Upload your source XLS files

Upload the XLS files containing the data you want to migrate.

What Can You Migrate from XLS to OpenCart?

Review supported data, source-to-target mappings and any listed conditions. Custom fields, plugin data and URL redirects may need additional review.
Products
Product Categories
Taxes
Manufacturers
Customers
Orders
Coupons
Reviews
Blog Posts
CMS Page
All relationships (categories, variants, images, etc.) preserved

Customize your setup with additional options

Recent Data Migration
Clear Target Store Data
Strip HTML Tags from Category and Product Names
Transfer Embedded Images to Target Store
Create 301 Redirects for SEO URLs
Preserve Product IDs & Category IDs
Preserve Order IDs and Customer IDs
Compatibility Overview
XLSXLS
OpenCartOpenCart
Version Range
-
1.x - 4.x (and newer)
Special Variants
-
Multistore / Multisite
Language & Localization
-
Multilingual, Multicurrency, RTL, Localized URLs
Main Editions
-
Open-source distribution
Product Types: Simple Product
Product Information: Name, SKU, Barcode, Tags, Manufacturer, Status
Product Pricing: Regular Price, Sale Price, Tier Price, Quantity Discounts
Product Options: Name, Type
Product Variants: Variant Attributes, Weight, Dimensions, Stock Quantity, Status
Product Images: Main image, Gallery Images
Product Inventory: Manage Inventory, Stock Status
External Links / Relationships: Categories, Manufacturers
Product Attributes & Custom Fields: Attribute Value, Attribute Types
Product Downloads: File name, File URL, Download Limit, Download Expiry, Downloadable File
Product SEO / Structured Data: Meta Title, Meta Description, Meta Keywords, URL Path
Category Information: Name, Description, Status, Meta Title, Meta Description
Category Structure / Hierarchy: Parent Category, Subcategories, Sort Order
Tax Rules: Tax Rule, Country, State, Rate percent
Manufacturer Information: ID, Name, Description
Manufacturer Branding : Logo Image
Customer Information: First Name, Last Name, Email, Phone, Status, Date Created
Customer Addresses: ID, First Name, Last Name, Company, Address 1, Address 2, City, Province, Country, Zip Code, Phone
Order Information: Number, Status, Currency, Subtotal, Discount, Tax, Total, Payment Method, Shipping Method, Shipping, Note, Created Date
Product Details: Product Name, SKU, Quantity, Unit Price, Line Total, Tax, Discount, Options
Customer Details: First Name, Last Name, Company, Street, City, Province, Country, Postcode, Phone
Order Relationships: Linked Customer, Linked Products
Coupon Information: Code, Description, Discount Type, Discount Value, Status, Start Date, End Date
Usage Restrictions: Minimum Spend, Products, Categories, Usage Limit
Review Information: Title, Comment, Rating, Status, Date
Reviewer Information: Email, Name
Post Information: Title, Content, Tags, URL Path, Status
Post Images: Featured Image
Post Categories: Category
Post SEO / Structure Data: Meta Title, Meta Description
Post Comments: Name, Email, Comment, Date
Page Information: ID, Title, Content, URL Path, Status, Created Date, Updated Date
Page Images: Featured Image
Page SEO / Structure Data: Meta Title, Meta Description
XLSXLS
OpenCartOpenCart
Product Types
Simple Product
Simple Product
Name
Name
SKU
Model
Barcode
UPC / EAN / ISBN
Tags
Tags
Manufacturer
Manufacturer
Status
Status
Regular Price
Price
Sale Price
Special Price
Tier Price
Tier Price
Quantity Discounts
Tier Price
Name
Option
Type
Type
Variant Attributes
Option
Weight
Weight
Dimensions
Length / Width / Height
Stock Quantity
Quantity
Status
Status
Main image
Image
Gallery Images
Additional Images
Manage Inventory
Subtract Stock
Stock Status
Stock Status
Categories
Categories
Manufacturers
Manufacturers
Attribute Value
Attribute Value
Attribute Types
Type
File name
File name
File URL
Download Links
Download Limit
Download Limit
Download Expiry
Expiry
Downloadable File
Download
Meta Title
Meta Title
Meta Description
Meta Description
Meta Keywords
Meta Keywords
URL Path
SEO Keyword
Category Information
Name
Category Name
Description
Description
Status
Status
Meta Title
Meta Title
Meta Description
Meta Description
Parent Category
Parent Category
Subcategories
Subcategories
Sort Order
Sort Order
Tax Rules
Tax Rule
Tax Rule
Country
Country
State
State
Rate percent
Rate
Manufacturer Information
ID
ID
Name
Name
Description
Description
Logo Image
Image
Customer Information
First Name
First Name
Last Name
Last Name
Email
Email
Phone
Telephone
Status
Status
Date Created
Date Added
ID
ID
First Name
First Name
Last Name
Last Name
Company
Company
Address 1
Address 1
Address 2
Address 2
City
City
Province
Zone
Country
Country
Zip Code
Postcode
Phone
Telephone
Order Information
Number
Order ID
Status
Status
Currency
Currency
Subtotal
Subtotal
Discount
Discount
Tax
Tax
Total
Total
Payment Method
Payment Method
Shipping Method
Shipping Method
Shipping
Shipping Method
Note
Comments
Created Date
Date Added
Product Name
Name
SKU
Model
Quantity
Quantity
Unit Price
Price
Line Total
Total
Tax
Tax
Discount
Discount
Options
Options
First Name
First Name
Last Name
Last Name
Company
Company
Street
Address
City
City
Province
Zone
Country
Country
Postcode
Postcode
Phone
Telephone
Linked Customer
Customer ID
Linked Products
Products
Coupon Information
Code
Code
Description
Description
Discount Type
Type
Discount Value
Discount
Status
Status
Start Date
Start Date
End Date
Date End
Minimum Spend
Total
Products
Products
Categories
Categories
Usage Limit
Usage Limit
Review Information
Title
Title
Comment
Text
Rating
Rating
Status
Status
Date
Date Added
Email
Email
Name
Name
Post Information
Title
Title
Content
Content
Tags
Tags
URL Path
SEO Keyword
Status
Status
Featured Image
Image
Category
Category
Meta Title
Meta Title
Meta Description
Meta Description
Name
Name
Email
Email
Comment
Comment
Date
Date
Page Information
ID
ID
Title
Title
Content
Description
URL Path
SEO Keyword
Status
Status
Created Date
Date Added
Updated Date
Date Modified
Featured Image
Image
Meta Title
Meta Title
Meta Description
Meta Description

XLS to OpenCart Migration Cost

This migration requires Custom Migration. Enter your data volumes for an initial estimate; the final scope and price depend on a review of your requirements.
1. Service
XLS requires the Custom service.
2. Data Volume
Source Platform
XLS
Target Platform
OpenCart

These four data types are used to estimate the price. Other supported data, including categories, coupons, and reviews, is also migrated at no extra charge.

Custom Jobs
+$100.00

You can increase your plan’s data limit, upgrade your service, or add custom work while your license is valid.

You only pay the price difference, and your license expiry date stays the same. Custom work is reviewed and quoted separately.

Learn about upgrades (Opens in a new tab)

Frequently Asked Questions

What you need to know before migrating your store data from XLS to OpenCart.

Which worksheet and header layout should I use for an XLS product migration?

Put the agreed product table on the first worksheet of products.xls, with its column headers in the first nonempty row. Do not place report titles or notes above the table. Keep product_id values and the agreed column names unchanged so products and variations stay linked correctly.

The default import fills product descriptions for unmapped destination languages with the default product content. This is a fallback copy, not a translation. Create and map the intended languages first, then check that untranslated content has not appeared in a language-specific storefront.

For OpenCart 3, Next-Cart maps the store assignments supplied by the source. Unmapped assignments can fall back to store 0. In imports from another platform without source store assignments, it uses the first configured mapping or store 0. Confirm the mapping and inspect product availability in each intended storefront.

When variants are converted into product options, Next-Cart adds together the stock of the variants that share each option value. For example, M–Red with 5 units and M–Black with 10 units give Size M a quantity of 15. If the variants do not manage stock, the option values use the main product’s quantity instead.

This preserves quantities for individual choices, not a separate stock record for every original combination. Do not add the totals for Size and Color together: they describe the same inventory. Combination-specific SKUs and prices are not generally retained by this conversion. This applies to the OpenCart 1.5, 2, 3 and 4 connections; ordinary source options are handled separately.

Yes. The standard XLS template accepts image URLs for the product and its variants. The first URL in an images field is the main image; additional comma-separated URLs supply gallery images. Keep those URLs directly accessible and preserve the links between products and variants. The destination may use only one image per variation, so a source variant gallery is not a guarantee of a separate gallery in the new store.

The OpenCart 4 import rebuilds supplied related-product references using the migrated product IDs and writes links in both directions. The OpenCart 4-to-OpenCart 4 connection also handles these mappings. Include the referenced products and check the final selections. This answer concerns related-product links, not separate cross-sell or up-sell extensions.

For OpenCart 1.5–4, Next-Cart copies the main image and gallery to the new store. Supported option-value images are handled separately. A gallery for a source variant does not automatically become a gallery for every combination of OpenCart options. Test products with different option pictures, especially when the source uses an image extension. Images inside descriptions require the separate copying option where available; check their links before removing the old hosting.

For migrations that include customer accounts, check whether the source provides usable password-verification data and whether the matching Customer Password Plugin supports both versions. Customer names and email addresses alone are not enough to retain existing passwords. Review the FAQ for your exact source-to-OpenCart pair, install any required compatible plugin before customers sign in, and test migrated accounts. Prepare password resets or activation for accounts whose credentials cannot be used.

Yes. The default import limits product names and SEO title, description and keyword fields to 255 characters before writing them. Review long names and SEO text in the test results and shorten them deliberately if important wording would otherwise be cut.

In the reviewed OpenCart 3 update connection, selecting quantity updates the mapped main product’s quantity, not the quantities stored for its option values. It does not repeat the variant-to-option stock aggregation used during the initial migration.

Data Update is a paid add-on for selected fields of records linked to the previous migration. Keep those links, continue that migration and leave target-data clearing off. Changes to option-level stock or product combinations need a separately confirmed update method; a successful product-quantity update does not confirm that those details were refreshed. A compatible source connection and the selected update fields are required.

Available services depend on your migration path. Standard Migration lets you use the tool yourself with technical support. With Managed Migration, our technicians carry out the agreed migration. Custom Migration covers tailored requirements, with the migration carried out by you or our team as agreed. Data types must be supported by both connections; choosing expert handling does not by itself add unsupported data.

Where a self-service Demo Migration is available for your migration path, you can try it for free before purchasing. It transfers a small sample of supported data so you can check the result. Add-ons and custom work are not included in the self-service demo. For a file-based, custom or technician-assisted evaluation, contact us first to agree the test scope and any applicable cost.

Your data types and quantities determine the Entity Points total and the plan you need. The cost also depends on your chosen service, add-ons, and any custom work. Use the pricing calculator for an estimate; custom work is reviewed and quoted separately.

If you are migrating from a live store, it can normally keep taking orders while Next-Cart copies its data. The migration does not delete or change the source data. Plan the final update and the switch to the new store separately so recent orders and other changes are included. For file-based migrations, changes made after an export require a fresh export; an uploaded file is not a live connection to the store.

Yes. Your license allows repeat runs for the same store and migration path for 12 months from purchase, within your plan’s data limit. Continuing the previous migration can add eligible new records without importing the same mapped records again.

Changing records already migrated is separate: the paid Data Update add-on can update selected fields where your source, target version and those fields are supported. Keep the existing migration links and leave target-data clearing off. It does not automatically update every field or provide continuous synchronization.

Yes. While your license is valid, you can increase your plan’s data limit and upgrade to a higher service where it is available for your migration path. You can move from Standard Migration to Managed Migration or Custom Migration, or from Managed Migration to Custom Migration.

If you already use Custom Migration, you can add custom work after a review and quote. You pay only the additional amount, and your license expiry date stays the same.

Start Your XLS to OpenCart Migration Today!

Move your store from XLS to OpenCart with a secure, guided migration tailored to your business.