The time has come to dump that problematic MijoShop store. Redoing all those special OpenCart mods and my own site mods in order to upgrade MijoShop and OpenCart versions does not seem cost effective. Plus all the MijoShop pains would remain. So hello HikaShop. I will document any interesting things encountered, if nothing else for myself next time I have to do this.
Interesting thing #1: HikaShop database conversion routine, dates.:
The conversion routine to bring across your old MijoShop store works pretty well. All the customers and orders and products and so on come across in pretty good order. You have to reimport all the product graphics and relink downloadable products, but that’s to be expected. What wasn’t expected is that the conversion failed to bring across the dates to the new “orders” table. Order date and order modification date were all set to 12/31/1969 or some such. So to fix that run the following SQL queries against your MySQL database.
update yourprefix_hikashop_order
inner join yourprefix_mijoshop_order
on yourprefix_hikashop_order.order_mijo_id = yourprefix_mijoshop_order.order_id
set yourprefix_hikashop_order.order_created = UNIX_TIMESTAMP(yourprefix_mijoshop_order.date_added)update yourprefix_hikashop_order
inner join yourprefix_mijoshop_order
on yourprefix_hikashop_order.order_mijo_id = yourprefix_mijoshop_order.order_id
set yourprefix_hikashop_order.order_modified = UNIX_TIMESTAMP(yourprefix_mijoshop_order.date_modified)