VIrtuemart import issues

Thank you for such a nice ecommerce extension. I started with the basic and migrated the data from a Virtuemart site. I just upgraded to the Essential. I have a couple of questions.

I have several orders with status pending. These did not migrate in. How can I capture this data?

I have some products with Virtuemart item attributes. These did not migrate in. (These are attributes that create a different price and different sku depending on selection.) How can I add this?

I have some products with Virtuemart item attributes. These did not migrate in. (These are attributes that create a different price but same sku depending on selection.) How can I add this?

All products have both a Virtuemart short and long description. These migrated into the Hikashop description area together. Most often, these are duplicate descriptions. What is the best way to clean this up?

Thanks for your help,
Helen

Any help would be greatly appreciated.

Sorry for the delay. It seems that the reply I had wrote to you didn't work

So here I go again:

We don't have any problem with the pending orders. Although, I suppose that it comes from the fact that the pending status is not a default status in HikaShop. You should look in the menu System->Order statuses to see if the pending status was created by the import. If not, create it manually via the interface and then, via phpmyadmin, set the value P in the column category_keywords of the table hiakshop_category for your pending status entry. Then, try to run the import again.

Item attributes cannot be migrated by the import as both systems are completely different. I don't have a solution for that. You will have to add your attributes manually as characteristics/options in your products in HikaShop.

For the description, you can fix that by running that query via your phpmyadmin:

Hi Nicholas,

Seems I never got the email that you responded... technology :silly:

If I run the import again to capture the pending, will it import EVERYTHING again?

Yes, I figured out the attributes. Seems that they came in as variants but without a Characteristic parent so they were more for reference as I rebuilt them. I only had a few products like that, thank GOD!

For the description fix, please tell me what this will do before I do it.

Thanks,
Helen

Hi Nicholas,

Ran the description sql fix. Worked great!

Still need to know if the second running of the import will screw up what has already been imported and edited.

Thanks,
Helen

Hi,

If you import again, it will try to import everything again yes. I don't know what you changed so I can't say if that's going to be bad or not.
In that case, the best would be to do a back up of your website with akeeba backup. Restore it on your local web server and do the import there. If everything is still working, then you can do the import on your website.

Maybe I can do it this way with your guidance:

Make another copy of my site.
Import again.
Verify that I have those pending orders.
Grab JUST these new sql tables that contain that info and restore on my much edited Hikashop site.

I would need to know which tables carry this info. I am thinking jos_hikashop_order and jos_hikashop_order_product.

Just let me know.
Thanks.

Yes, that's the only two tables.

Before you do again the import, you will have to open the entry vm_import_last_vm_order of the table jos_hikashop_config in order to change it to 0. Otherwise, the orders won't be imported.

Also, when you do the import, please activate the debug mode in the configuration of joomla. That way, if you get a mysql error, it won't be just ignored and you will see why the import doesn't work.

Hi Nicholas,

I made a copy of my site and a new database. Set the value P in the column category_keywords of the table hiakshop_category for the pending status entry (Note: both created and pending have the value P now.). Set the entry vm_import_last_vm_order of the table jos_hikashop_config to 0 and deleted all from jos_hikashop_order and jos_hikashop_order_product. Set Joomla config to debug. Ran import again. No errors in degug that I saw.

It only inported the orders/sales so that was nice, but it still did not import the pending orders.

I must have forgotten to do something. :huh:

Helen

I checked the code and I still don't see why that would do that.

Me either. I will try to hand enter them into the database.

But why do you need them ?
created orders are orders which were not paid by the customer. So basically, you don't need them, no ?

PayPal marks 99% of orders pending. The rest are usually cancelled because they are duplicates or the customer changed their mind. Then my client, the Website owner, has to go into the site and update the order as paid and shipped or cancelled, just like normal. But my client got lazy last year and left all orders pending. :whistle: So I want to capture this info just so I am not at fault for losing it.

Then just change all the created orders to confirmed, import them and change them back to created.
That should be easy to do with a query.

update jos_vm_orders set order_status='C' WHERE order_status ='P';

to change the orders from pending to confirmed in VM.

update jos_hikashop_order set order_status='created' WHERE order_status='confirmed';

to change the orders from confirmed to created in HikaShop.

Excellent idea! I will give it a try and let you know how it goes.

Good idea. Didn't work either. I am looking at these orders and do not see anything unique about them other than the status.

I have also just noticed that it only pulls 1/2 of the cancelled, 1/3 of the refunded, and 2/3 of the shipped. [strike]I checked the dates and this doesn't seem to matter either.[/strike]

Perplexing. :blink:

Looks like all orders placed or modified AFTER 12-01-2010 were not imported.

I don't see a problem with that date for HikaShop.
Did you update VM at that time ? Maybe something changed in VM and the orders data is not the same before and after.
Could you provide a SQL export of two orders information from the jos_vm_orders table via phpmyadmin, one order from before, one from after (check that only the one before was exported) ?
That way, we would be able to check the differences.