Interspire To Opencart Migration -

| Data Type | Interspire Tables | |-----------|-------------------| | Categories | [prefix]_categories | | Products | [prefix]_products | | Product-Category mapping | [prefix]_product_categories | | Customers | [prefix]_customers | | Orders | [prefix]_orders , [prefix]_order_products , [prefix]_order_addresses | | SEO URLs | [prefix]_seo_urls |

OpenCart uses: /index.php?route=product/product&product_id=123 (or SEO keyword paths) interspire to opencart migration

INSERT INTO oc_category (category_id, parent_id, status) SELECT categoryid, parentid, 1 FROM isc_categories; INSERT INTO oc_category_description (category_id, language_id, name, description) SELECT categoryid, 1, catname, catdesc FROM isc_categories; | Interspire field | OpenCart field | |----------------|----------------| | productid | product_id | | prodname | name (in oc_product_description ) | | proddesc | description | | prodcode (SKU) | sku | | prodprice | price | | prodweight | weight | | prodinventory | quantity | | prodstatus | status (1=Enabled, 0=Disabled) | | | custfirstname | firstname | | custlastname | lastname |

Then insert descriptions, SEO URLs, and category links. | 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 | status) SELECT categoryid