Resolved Complet VM Category export(parents and children)

Hello,
In your product export template settings on Options tab, set Parent products only and child products only filters to Yes and try the export. This should export you both parent and child products.

Hi,

unfortunately this does not work.
It only works if I export all Products. But if I use the category filter, csvi exports only the parent products.

Hello,
If you have your category filter set then try setting both Parent products only and child products only filters to No and do the export. This should fix your issue.

No for me it does not work, maybe I'm doing something else wrong.

However, I tried following settings

[table]
[tr]
[td]
Category: set to one category
Parent products only: No /
Child Products only: No
[/td]
[td]
Exports just parent products of the given category
[/td]
[/tr]
[tr]
[td]
Category: set to one category
Parent products only: Yes
Child Products only: Yes
[/td]
[td]
Exports just parent products of the given category
[/td]
[/tr]
[tr]
[td]
Category: Don't use
Parent products only: No
Child Products only: No
[/td]
[td]
Here it works. Parent and child products are exported.
But it does not really help me because I just need the
products(parent and childs) of one category.
[/td]
[/tr]
[/table]

What I need is all products(parent and children) of one category. I think I tried almost all combinations of options, and I can't find a way to do this. Is it a bug? Or is it with the current version of CSVI not possible?

For now I found following manual workaround. I made an SQL Query directly to the database to get all products an children sku's for a category. Then i use the option "Product SKU Filter" to export the products(parent and children). It works but it is not a really practical solution and I can't automate it.

Hello,

Category: set to one category
Parent products only: No /
Child Products only: No Exports just parent products of the given category

This scenario works for me but not sure why it is not working for you, Is it possible for you to send me your VirtueMart product and category tables mysql dump to check? You can email it to me at tharuna@csvimproved.com.

Category: set to one category
Parent products only: Yes
Child Products only: Yes Exports just parent products of the given category

That is correct, since parent products filter is set to Yes, it would export only parent products.

Category: Don't use
Parent products only: No
Child Products only: No Here it works. Parent and child products are exported.
But it does not really help me because I just need the
products(parent and childs) of one category.

This is also correct. This is when no filters are set, it would export all the products.

What I need is all products(parent and children) of one category. I think I tried almost all combinations of options, and I can't find a way to do this. Is it a bug? Or is it with the current version of CSVI not possible?
For now I found following manual workaround. I made an SQL Query directly to the database to get all products an children sku's for a category. Then i use the option "Product SKU Filter" to export the products(parent and children). It works but it is not a really practical solution and I can't automate it.

I would like to check your data in your database tables so to say why it is not working and to help you here.

Hello,
Thank you for sending your data, it helped me to find the cause for the issue and fix it. Can you load the attached patch file using CSVI maintenance menu and try the export?


patch_vm_product_export_2016_10_24.zip

Hi,
Yes, now it works. Many Thanks! And great support, by the way....

Will this patch be include in in future releases?

Regards Thomas

Thank you for your feedback. Yes, this will be included in our future release.