CSVI Import category association issue

[ncaipen]

Hi all,

I'm having an issue when I attempt to import products with attached categories.  Upon import, the category and product appear to import correctly until I go to the category page and notice that there are no products associated with the category that was just created.  When I look at the product details, the product appears to be associated to the correct category there, but not on the product category landing page.  I have tried using the fields category_path and category_id but I get the same results.  I am using the product csv template to create both the products and the categories.  The categories that are on my upload spreadsheet are new, but I can reproduce the issue if the categories are already created before import as well.  Hopefully that makes sense.  Any help would be appreciated.  Thanks!

[attachment cleanup by admin]

[Maxim Pishnyak]

VM version?

[ncaipen]

Yes, I am using VM 2.0.22a

[Maxim Pishnyak]

That's bad, cos reporting this issue to CVSI author is not a simple thing. Paid subscription is necessary.

[ncaipen]

Thanks for your replies.  I am just wondering if I may be doing something wrong when uploading the file?  I have attached an xls version of the spreadsheet (since I can't attach csv files here) and also a screenshot of the options I am selecting when uploading the file.  If you could take a look and let me know if it looks right to you I would greatly appreciate it.  Thanks! 

[attachment cleanup by admin]

[Maxim Pishnyak]

It's not necessary to show your stuff.

I already saw this issue earlier.

I could live with this bug in product list (VM backend).

And you?

[npac]

I run into the same problem today - and after hours and hours of trial and error  i found a solution :
As long as you are importing new products or new categories on Virtuemart, you have to make sure that they are actually published!
It seems that CSVI is not publishing your new products by default.

And just looking at the Virtuemart user interface in joomla, you may see all your newlly imported products (or categories) published, but in the database they are not!

So the solution is : include the "published" field on your export CSV. When you put your new products, just make sure that there is a "1" in each new product in the "published" column.

This will solve your problem!