error while importing data from mijoshop 3

  • Posts: 2
  • Thank you received: 0
10 years 3 months ago #187072

-- 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.

Last edit: 10 years 3 months ago by ialmotery.

Please Log in or Create an account to join the conversation.

  • Posts: 26232
  • Thank you received: 4035
  • MODERATOR
10 years 3 months ago #187074

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0
10 years 3 months ago #187166

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

Please Log in or Create an account to join the conversation.

  • Posts: 26232
  • Thank you received: 4035
  • MODERATOR
10 years 3 months ago #187212

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.069 seconds
Powered by Kunena Forum