VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: ncaipen on August 06, 2013, 03:31:17 AM

Title: CSVI Import category association issue
Post by: ncaipen on August 06, 2013, 03:31:17 AM
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]
Title: Re: CSVI Import category association issue
Post by: Maxim Pishnyak on August 06, 2013, 13:25:02 PM
VM version?
Title: Re: CSVI Import category association issue
Post by: ncaipen on August 06, 2013, 14:07:54 PM
Yes, I am using VM 2.0.22a
Title: Re: CSVI Import category association issue
Post by: Maxim Pishnyak on August 06, 2013, 19:39:07 PM
That's bad, cos reporting this issue to CVSI author is not a simple thing. Paid subscription is necessary.
Title: Re: CSVI Import category association issue
Post by: ncaipen on August 06, 2013, 20:17:55 PM
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]
Title: Re: CSVI Import category association issue
Post by: Maxim Pishnyak on August 09, 2013, 00:08:41 AM
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?
Title: Re: CSVI Import category association issue
Post by: npac on August 17, 2015, 14:42:12 PM
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!