No further import after refresh

I deleted all the 419 products and tried importing just the orders. Victory: it imported all the orders!

Now I only need all the products, so I try again with only ‘Categories/Products’ checked.

1st attempt: nothing is being imported ( and no messages)
1st refresh: nothing is being imported (and no messages)
2nd refresh: nothing is being imported (and no messages)
3rd refresh: nothing is being imported (and no messages)

I go back to the import page, refresh & emptied cache & history, entered the database info again and checked all the boxes. I now waited half an hour. Result: no product imported.

I did a new clean install with a new database (all categories were duplicated, a big mess) and everything imported okay, except for the Products/Categories. The first run went fine and I imported a little over 1000 products. But then, refreshing doesn’t help, reloading the form page doesn’t help. It seems that it only allows just one run. Help!

Hey Annekee!

First backup you db/site before doing ANYTHING, ALWAYS but to rid yourself of the duplicate category issue, open the .php file and comment out line 89, like this (if you dont code, you’re just adding two forward slashes BEFORE it):

//add_woocommerce_term_meta($term[‘term_id’], ‘order’,$category[‘sort_order’]);

upload/save the file and refresh your page/site to load your edited version. Done! Import categories with a smile. This was solved in another thread unclearly but that did it for me.

As for the products, I had no problems with it except the time out issue so I just temp edited my php.ini file to allow for REAL long execution time so I didnt have to keep refreshing.

I was not importing pictures from previous site really so I did not even look into the issue involving that.

Hope I helped ya. That’s all it came down to after many hours of pain.

Credit to amitramani for his work but unclear explanation. See his post about the image issue if interested.

Thank you amirand! Meanwhile, I’ve moved on. I did a migration locally with Mamp (with a local images folder) and tried it that way. First of all, the ini execution time setting is, indeed, obligatory. I don’t know how to find out if the commenting out worked, because one mayor issue is still not resolved: upon refresh, nothing gets added anymore.

Migration only works (in this case: locally) when there are no products in the database – and thus in one run.

The images were transferred fine though. I migrated a little over 10.000 products, and 25% had one small image per product. It took about 5 to 6 hours. But remember, that was locally. I suppose doing this online, if it works at all, would only be possible if you keep it running the whole day (and night).

I still love the plugin, just because the author took the trouble. But when you post it here, I think you really need to take notice of the errors and try to resolve them…

Hey annekee,
Yea I was using WAMP while doing all of the stuff I mentioned and because of the php.ini ‘rules’ like execution time, file size allowed, etc., I had to do the whole waiting to refresh thing cuz of timeouts. Took FOREVERRRR! So I adjusted the time allowed to like 10 minutes haha, clicked import ONCE and voila! haha I would ONLY do this locally and then upload the db to the actual server because of how long it takes aka “whole day & night” haha and I dont have to worry so much about errors.

Great plugin but yea, fixes should be fixed immediately, just like posts. Glad you got it working.

A tip on zeroing tables if doing it online:
WooCommerce – Store Toolkit By Visser Labs (required to zero tables if necessary)