Wow…pulling my hair out….
I have a set of 30 products. 15 are made of plastic 15 are made of steel.
I tried an import of all the products and things weren’t importing correctly at all. Products aren’t showing in the cat section or the shop. Re-saving the product does make it appear in the cat page. Didn’t check the cat.
I went back and updated the headers as is mentioned earlier in this thread. I added the post_name (permalink) to the csv and still no go on the showing in cat or shop pages. I’ve also messed with my permalink settings thinking this might be the issue with product not showing in the cat and shop pages.
(I fixed the above, after writing all this, by removing the ! from the class-woocsv-product.php as mentioned by freeaanzee)
The following is still a problem.
Then as some point in trying to get things imported the wrong photos started getting assign to the wrong product. ie. The photo for the metal version was attaching to the plastic.
I split my csv in 2… plastic only and metal only.
Now, when I import, for example the plastic only, it’s assigning the first 2 with the correct photo but the other 13 are getting the image for metal assigned to the plastic. Strange as hell.
When previewing the file before hitting import it is showing the correct image but it’s still attaching the metal image.
plastic = blk-cga.gif
metal = m-blk-cga.gif
I cleared the cache, installed a db optimizer to clear out revisions etc. and it is still attaching the metal image.
I’m using OpenOffice to create the CSV and UTF-8 is set to convert in the settings.
Here is a list of my headers…
ID sku post_name post_status post_title post_content post_excerpt category tags stock regular_price sale_price weight length width height tax_status tax_class stock_status visibility backorders featured manage_stock featured_image product_gallery shipping_class comment_status ping_status menu_order
I’m using the latest versions of WP and WC.
I have the Better Plugin Compatibility Control plugin installed and it shows that the CSV import plugin is supported only to 4.2.2. Could this be causing this problem?