Categories
View Replies (7)

Resolved Virtue mart import categories with rules

  1. New
  1. DarkoF
    DarkoF
  2. RO CSVI
  3. Monday, 03 February 2025
  4.  Subscribe via email
Hi all
I try import from xml many products via ROcsvi to virtuemart
this is my XML i delete most and keep just <skupina> wich is relevant for this discussion: 


<izdelek>

<sifra>005560</sifra>

<naziv>KLJUČI VILIČASTO OBROČNI "Green line", kartonska embalaža.</naziv>

<skupina>Ključi</skupina>

</izdelek>



<izdelek>

<ean>4003315079774</ean>

<naziv>KLJUČI VILIČASTO OBROČNI "Green line", kartonska embalaža.</naziv>

<skupina>Ključi</skupina>

</izdelek>



<izdelek>

<sifra>012607</sifra>

<ean>3831093312803</ean>

<naziv>KLEŠČE CEVNE Kotne 45°, "S" čeljust, POPAR.</naziv>

<skupina>Klešče</skupina>

</izdelek>


Since is there more than 7000 product I try to group many <skupina> tags to the same category. Here in example above all Ključi and Klešče can go under one category named Ročno orodje - is a hand tools in English.

So I created Rule see picture:
Screenshot from 2025-02-03 19-42-55.png

My goal is to set

category_path to: Ročno orodje|DDV/DDV 22%|Lmm

This product should be set in 3 categories at import

paren cathegory : Ročno orodje

child unpublich cathegory : DDV/DDV 22% - is for add vat/tax

and parent unpublished category : Lmm

Unfortunately only the last - Lmm - category is set by Rules. Don't know why don't insert all text only last part from the last separator.


Please advise.

Regards
Attachments (1)
Screenshot from 2025-02-03 19-42-55.png Screenshot from 2025-02-03 19-42-55.png
0
Responses (7)
rolandd
rolandd
Accepted Answer Pending Moderation
Hi,

Actually, what I see is correct. So final step would be to repeat the Ročno orodje|Lmm|DDV/DDV 22% as many times as you have the values in the Find field. So if there are 20 strings to find, you need 20 replacement strings.

Once that is done, I believe it should be all good.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
DarkoF
DarkoF
Accepted Answer Pending Moderation
Just to get things clear, when the skupina has a value of Ključi then it should be replaced with Ročno orodje|Lmm|DDV/DDV 22%. Is that correct?

Yes that correct.
  1. more than a month ago
  2. RO CSVI
  3. # 2
DarkoF
DarkoF
Accepted Answer Pending Moderation
So i did
Screenshot from 2025-02-04 17-54-37.png
and result is
Screenshot from 2025-02-04 17-56-17.png
It didn't work
Attachments (2)
Screenshot from 2025-02-04 17-54-37.png Screenshot from 2025-02-04 17-54-37.png
Screenshot from 2025-02-04 17-56-17.png Screenshot from 2025-02-04 17-56-17.png
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hi Darko,

So category_path like these: Ročno orodje|Lmm|DDV/DDV 22% should work.
Indeed, that looks perfectly fine.

Just to get things clear, when the skupina has a value of Ključi then it should be replaced with Ročno orodje|Lmm|DDV/DDV 22%. Is that correct?

If that is the case you need to set a different separator in the rule. The rule now has the same separator as used for the multiple categories. So during replacement, the Ročno orodje|Lmm|DDV/DDV 22% is changed to 3 single values. What you can do is change the separator in the rule from | to # and replace all the | in the Find box to #. Easiest is to do that in a text editor with find and replace and put the new values back. If you then look at the preview you should see that Ključi has been changed to Ročno orodje|Lmm|DDV/DDV 22%.

Give that a try and let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
DarkoF
DarkoF
Accepted Answer Pending Moderation
My categories structure is like these:

Ročno orodje = Parent category Published

Lmm = Parent category Unpublished

DDV = Parent category Unpublished
L DDV 22% = Subcategory of DDV Unpublished


/ = I have selected in template as category separator
| = Pipe should be for parent categories

So category_path like these: Ročno orodje|Lmm|DDV/DDV 22% should work. At least it was working in the past
But rule wich is app-played to xml tag <skupina> just don't replace with this string. Sometimes replace with only Lmm sometimes replace only DDV/DDV 22% and so on.

Hope this helps.
  1. more than a month ago
  2. RO CSVI
  3. # 5
DarkoF
DarkoF
Accepted Answer Pending Moderation
Unfortunately don't working this please see picture
Screenshot from 2025-02-04 10-14-48.png

Should be all these product in all 3 categories should be result category_path like these I think : Ročno orodje|DDV/DDV 22%|Lmm
Attachments (1)
Screenshot from 2025-02-04 10-14-48.png Screenshot from 2025-02-04 10-14-48.png
  1. more than a month ago
  2. RO CSVI
  3. # 6
Anonymous User
Accepted Answer Pending Moderation
Hello,
If you want a product to be assigned to all three categories then category_path should be set as Ročno orodje|Ročno orodje/DDV/DDV 22%|Ročno orodje/DDV/DDV 22%|Lmm. Since you have only one of it product is assigned to last category. Run import with this category_path and check.
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


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