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.

Hi Nicholas,

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

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

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.

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.

Helen

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

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. So I want to capture this info just so I am not at fault for losing it.

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. I checked the dates and this doesn't seem to matter either.

Perplexing.

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