| 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 |
| Interspire field | OpenCart field | |----------------|----------------| | categoryid | category_id (if keeping same ID) | | catname | name (in oc_category_description ) | | catdesc | description | | parentid | parent_id | 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) | status) SELECT categoryid