| Data Entity | Interspire Source | OpenCart Target | Migration Notes | | :--- | :--- | :--- | :--- | | | Name, SKU, Price, Description, Stock | Products Table | Must map Quantity, Model (SKU), and Weight. | | Categories | Category Tree, Images | Categories Table | Preserve the hierarchy (parent/child relationships). | | Customers | Name, Email, Password, Address | Customers Table | Crucial: Password encryption differs; a reset mechanism is usually required. | | Orders | Order details, Status, Totals | Orders Table | Preserve Order IDs to maintain reference integrity. | | SEO URLs | Custom URL slugs | SEO URL Table | Map old URLs to new ones to preserve search rankings (301 redirects). | | Images | Product & Category images | Image Folder | Requires resizing to fit OpenCart dimensions. | | Reviews | Ratings, Text, Dates | Product Reviews | Ensure customer IDs are mapped correctly. |
| Issue | Solution | |-------|----------| | Passwords not working | Install “Interspire Password Compatibility” extension or email reset link to all users. | | Images missing | Copy /product_images/ from Interspire to OpenCart’s image/ folder and update image field in oc_product . | | Category tree broken | Ensure parent_id values are migrated correctly – you may need to update after import. | | Order totals mismatch | Recalculate totals using OpenCart’s order total extensions after migration. | interspire to opencart migration
| Interspire | OpenCart | |------------|----------| | custemail | email | | custpassword (rehash) | password – Interspire uses MD5 or SHA1; OpenCart uses bcrypt. You must reset passwords or use a compatibility layer. | | custfirstname | firstname | | custlastname | lastname | | Data Entity | Interspire Source | OpenCart