1. ekcsvi
  2. RO CSVI
  3. Friday, 07 February 2020
  4.  Subscribe via email
Hi Roland

This is something I can't figure out with CSVI ( working on 2 tables )
Could you help me with that ?

I have some manufacturers unpublished now in virtuemart.

I could I skip their relating products on import or unpublish them ?

Thank you in advance !

Regards
Eric
Accepted Answer
Accepted Answer Pending Moderation
Hello Eric,
You want to unpublish products which has manufacturer set to unpublished. If you are unpublishing all products before import then you can set published field to Y for products for which manufacturer is set active in your import file. This way the products which are unpublished before import will stay unpublished and products which have an active manufacturer will be published. Will this not work for you?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
Hello Eric,

On import it is not possible to skip a row based on a value from the database. What you could do is run an export of all product SKUs for that manufacturer by setting the manufacturer in the filter options of the product export template. After that you run an import of these product SKUs with the published field set to N. That should unpublish all these products.

This way you have I think what you want.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland

"On import it is not possible to skip a row based on a value from the database"

This is sad as I am sure there would be other applications for this option/rule ;)

"That should unpublish all these products"

The problem is I can't do that as before every import I am unpublishing ALL products... :(

I am going to find another way... Thank you anyway for your help !

Best Regards
Eric
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hey Eric,

I have some manufacturers unpublished now in virtuemart.
If your import file has the manufacturer in it, you could skip them based on the manufacturer field.

The problem is I can't do that as before every import I am unpublishing ALL products...
So where is the problem if the products are already unpublished?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Roland

If your import file has the manufacturer in it, you could skip them based on the manufacturer field.

has the manufacturer in it = Yes

You should then explain please, because the only way I see how to do this is a Conditional Rule with a list of all the manufacturers, parsing them and unpublishing then the product if the manufacturer is in the conditional rule... don't see any way how to SKIP the line ( csv row ).

Eric
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hi Tharuna

"You want to unpublish products which has manufacturer set to unpublished" = YES

The idea was to investigate if there is another method more direct than writing a Conditional Rule parsing all suppliers ( by getting "unpublish" information directly in Virtuemart supplier's table )

Beside this, skipping the CSV raw line instead of "unpublishing" would have been a plus ;-)

Regards
Eric
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Eric,

Beside this, skipping the CSV raw line instead of "unpublishing" would have been a plus ;-)
That is what the Skip rule plugin does. Yes, you would need to enter all the unpublished manufacturers in there and update this if the situation changes in the future.

The idea was to investigate if there is another method more direct than writing a Conditional Rule parsing all suppliers ( by getting "unpublish" information directly in Virtuemart supplier's table )
That feature is on the todo list for a future release.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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