This is the most efficient method for stores with large inventories.
| 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
INSERT INTO oc_category_description (category_id, language_id, name, description) SELECT categoryid, 1, catname, catdesc FROM isc_categories; This is the most efficient method for stores
Truncate (or clear) these OpenCart tables before import: description) SELECT categoryid