error while importing data from mijoshop 3

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.

1054 Unknown column 'SAR' in 'field list' SQL=INSERT IGNORE INTO jos_hikashop_discount (`discount_type`,`discount_start`,`discount_end`,`discount_quota`,`discount_quota_per_user`,`discount_published`,`discount_code`,`discount_currency_id`,`discount_flat_amount`,`discount_percent_amount`) SELECT 'coupon',date_start,date_end,0,uses_customer,status,code,SAR,case when type = 'F' then discount else 0 end,case when type = 'P' then discount else 0 end FROM jos_mijoshop_coupon WHERE coupon_id > 0

Hi,

appears while importing from mijoshop, products are imported correctly, but orders and address not.

Hi,

The Mijoshop import is compatible with Mijoshop 2.x ; not with Mijoshop 3.
I guess that the database structure is different ; that's why you got the SQL error and some data are not imported properly.

Regards,

Don't know much about that but, I assumed the problem was the default currency of my hikashop which was SAR, saudi arabian riyal. When I changed it to dollar, and tried importing again, it continues to import with no problem but it stopped at "downloadable products" step. with that error below.
----
1054 Unknown column 'mjd.remaining' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_download` (`file_id`,`order_id`,`download_number`) SELECT hkf.file_id,hko.order_id,(50- mjd.remaining) FROM `jos_mijoshop_download` AS mjd INNER JOIN `jos_mijoshop_download_description` mjdd ON mjd.download_id = mjdd.download_id INNER JOIN `jos_hikashop_file` AS hkf ON ( CONVERT(hkf.file_name USING utf8) = CONVERT(mjdd.name USING utf8) )INNER JOIN `jos_mijoshop_product_to_download` AS mjpd ON mjd.download_id = mjpd.download_id INNER JOIN `jos_mijoshop_order_product` AS mjop ON mjpd.product_id = mjop.product_id INNER JOIN `jos_hikashop_order` AS hko ON hko.order_mijo_id = mjop.order_id WHERE mjd.download_id > 0
----

Are there any plans to update the mijoshop import thing? soon? or to fix this problem.
thank you

Hi,

I created a task in the TODO list but I can't provide any schedule.

When we create the first mijoshop import ; it was for a customer request, which allow us to have a guy on the project at full time and which also gave us the package and a "sample store".

Regards,