Resolved Export from Virtuemart data import into hikashop

Hello Sanjeev,
You do not seem to have an active subscription with RO CSVI. Support will be given only for active subscription users.

Nope, I have bought it. please check my detail

Your Watchful Key; b8e2e4437955cd90f9580734a39bc2b8

download ID 64804209E7A1E

Hello Sanjeev,
The email used to post this topic and the one used for subscription are not the same. That caused the confusion. I see the subscription for the given download ID.

Now to help you with the issue of migrating data from VirtueMart to HikaShop I need the details on what is not working. Please post some screenshots and also debug log to check. To get the debug log see How to collect debug information? document.

Hello tharuna

Please check screenshot
https://prnt.sc/q_Fgzwg8vAMr
images are not copied

Please let me know the issue.
Thanks
Sanjeev

Hello Sanjeev,
The screenshot message says that image does not exists in the given URL. Do the image exists in the remote URL you are importing?

Yes, but images existed in the path.

Then why are these images showing such type of error?
you can open path
Remote file does not exist: https://probiz.com.au/images/stories/virtuemart/product/14610_500x500.jpg
Remote file does not exist: https://probiz.com.au/images/stories/virtuemart/product/14620_500x500.jpg
Also products are not showing in hikashop

Please reply a little bit fast.
I can give me admin access, so you can check yourself.
please provide email id.

Hello Sanjeev,
Post import debug log, template XML and sample of import file to check. Debug log was requested in my previous reply too. That will give us information on what has gone wrong with import.

To get the debug log see How to collect debug information? document.

To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.

Please debug logs file

Hello Sanjeev,
Your import is completely messed as per debug log. See the below information from debug log. All the fields have got wrong values. There is something wrong either with your import file or settings in import template. I had requested for two more files in my previous post. Please post them so I can check.

2023-06-09	12:13:59	1	[DEBUG]	Process SKU: case,,0,https://probiz.com.au/images/stories/virtuemart/product/headphones

2023-06-09	12:13:59	1	[DEBUG]	Create new slug from Product name

2023-06-09	12:13:59	1	[DEBUG]	Check if the product alias already exists

2023-06-09	12:13:59	1	[QUERY]	 SELECT COUNT(`product_id`) FROM pp3_hikashop_product WHERE `product_alias` = 'with' AND `product_id` != 51

2023-06-09	12:13:59	1	[DEBUG]	Query for Product

2023-06-09	12:13:59	1	[DEBUG]	Executed store

2023-06-09	12:13:59	1	[QUERY]	UPDATE `pp3_hikashop_product` SET `product_parent_id`='0',`product_name`='with',`product_description`='silicon.jpg,Logoline',`product_quantity`='',`product_code`='case,,0,https://probiz.com.au/images/stories/virtuemart/product/headphones',`product_published`='0',`product_hit`='0',`product_created`='0',`product_sale_start`='0',`product_sale_end`='0',`product_delay_id`='0',`product_tax_id`='0',`product_type`='main',`product_vendor_id`='0',`product_manufacturer_id`='0',`product_weight`='0.000',`product_weight_unit`='kg',`product_modified`='1686312839',`product_dimension_unit`='m',`product_width`='0.000',`product_length`='0.000',`product_height`='0.000',`product_max_per_order`='0',`product_access`='all',`product_group_after_purchase`='',`product_min_per_order`='0',`product_contact`='0',`product_display_quantity_field`='0',`product_last_seen_date`='0',`product_sales`='0',`product_waitlist`='0',`product_layout`='',`product_total_vote`='0',`product_page_title`='',`product_alias`='with',`product_price_percentage`='0.0000000',`product_msrp`='0.0000000',`product_canonical`='',`product_warehouse_id`='0',`product_quantity_layout`='',`product_sort_price`='0.00000',`product_option_method`='' WHERE `product_id` = '51,16656,headphones'

I have done the setup with your document,
So I request you please check your self my website admin setting.
I can send you admin access.
https://probiz.com.au/administrator/
support5
support5

Hello,

I have done the setup with your document,

Not sure which document you read to but your template needs few changes before you run export and import.

So I had a look into your site. There are few things to be corrected in your template

1. In export template on File tab Text enclosure is not set. You need to set this to " so the field values are enclosed. See attached screenshot.
2. You are using product_id and virtuemart_product_id field in export and import. When there is an ID field Joomla updates the record in database and does not do an insert. I would suggest you to remove these fields from both of your templates and then check.

When you run the import, preview page will show you field and its values. If the preview page looks good you then proceed with the import. If the field values are not right on preview then something is wrong with template setup. See attached screenshot.

Do these corrections and run the import. Let us know on how that goes.

Hello,
May I know if the export/import is solved? If you need any more help let us know.