Migration from virtuemart 3.0.6.2

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.2
-- PHP version -- : 5.4.40
-- Error-message(debug-mod must be tuned on) -- : No error message
all hk_id in vm_prod table is the same

Hi

I tried to migrate from virtuemart 3.0.6 (i have 1700+ product in virtuemart)

the import process run success but with only 1 new product inserted

when i go to hikashop product panel, it become a blank screen

when i go to database and found that hikashop_vm_prod table have 1700+ records but all have the same hk_id

when i deleted the new inserted product in hikashop_product table , the blank page problem gone

any way to have a fix on this?

i understand that the import do not support 3.0.6 yet but we really love hikashop and would like to migrate to it

It created 1700+ record in hikashop_vm_product table with hk_id 36285

The product with id 36285 is the first product imported from vm amd it is the only record imported

Please take note of the symbol described in first posts as I suspect the import process write all record imported into row 36285 and thus there is no error during import proces . But actuallt the process failed as it only genarated one new product record for 1700+ vm product record
And the hk_id is duplicated for all 1700+ record in the table mentioned above

Dear Jerome

i am not sure if you read my written symptoms above, there is at least 1 complete record imported to hikashop product table with id 32685, and genarated 1700+ record in hikashop_vm_product table with hk_id 36285

as i think this is important to find out the cause

For the language table you mentioned, i found a o5hyg_virtuemart_products_en_gb
So what should be check further?

prefix in database
product template

above two option is it important for the import?

Dear Nicolas

Yup, there are 1700+ record in hikashop_vm_product table for my vm_product which is correct, however, all the 1700+ record using the same hk_id which is 32685, and in hikashop product table there is only 1 new row with id 32685

I think this is script problem as i am using the import on 3+ version which did not state supported

Do you mind to share the code where to check so that mayb i can help to make it 3+ support as well

Dear Nicolas

Thanks for your location of script, i found that the insert script for hikashop_vm_product using vm_product_sku as key whereby VM3 sku is not a neccessary field

i genarate a random number to all product in virtuemart sku using below
UPDATE `prefix_virtuemart_products` SET `product_sku` =
(SELECT concat(
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' ),
ELT(FLOOR(1 + (RAND() * (50-1))), 'a','b','c','d','e','f','g','h','i','j','k','l','m ','n','o','p','q','r','s','t','u','v','w','x','y', 'z',
'A','B','C','D','E','F','G','H','I','J','K','L','M ','N','O','P','Q','R','S','T','U','V','W','X','Y', 'Z' )
)
) WHERE product_sku="";


However, after the import all product image are showing barcode.png

still finding out and would be appreaciate if you can highlight the cause

yup, there are still problem on image import, but are able to correct with minimal efford

VM 3 media table is product or file is always 0 for product

change both line of 'file_path' => 'vmm.file_url', (i manually stripe images/stories/virtuemart/ using sql query)'

and this lead to a success import rfom VM3