1. Doomas
  2. RO CSVI
  3. Sunday, 23 October 2016
  4.  Subscribe via email
Hi,

I have now switched my CSVI version from 5 to 6. In the 5.21.2 Version it was possible to select a category(options -> category) and export all products with all child products(they have no category assigned) included. In Version 6.6.3 this doesn't work anymore, just the parent products will be exported.

I saw this thread https://csvimproved.com/forum?view=topic&catid=44&id=32879&start=24
And there you state the following:


If you only want these couple of products in an export file, you can use the Product SKU filter. The combination you want isn't possible because for the system there is no relation between these child products and category.


The product sku filter does not work for me. Because I don't know the child products sku's before the export.

I can see why the SQL statement does not work. But wouldn't it be possible to include an Option to export also every child product to any parent product that will be exportet like in CSVI 5.

Thanks!

Regards
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi,
Yes, now it works. Many Thanks! And great support, by the way....

Will this patch be include in in future releases?

Regards Thomas
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Thank you for your feedback. Yes, this will be included in our future release.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!