Categories
View Replies (11)

Resolved Virtue mart import categories with rules

  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
Accepted Answer
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. # Permalink
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You have rule to Find and Replace for matching categories. May be some of the categories does not match strings in the rule and are in category_path field which creates new categories? Easy way to check this is to find a product which creates new category and check what you see in category_path field with rules in import preview page. You can find the product from newly created category in VirtueMart and use that as sample product for testing.
Kind regards,

Tharuna

=========================
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
I know, but I have in rules to take name of <skupina>Kovčki, in ostala orodja</skupina> and replace with Ročno orodje|Lmm|DDV/DDV 22%.

and it created new category under
DDV
L DDV 22% in ostala orodja

And that was many cases, I deleted these new categories, try many variations in rules, but all I did I make it worse.

So in the end I just unpublished newly created.

Product get category - Ročno orodje|Lmm|DDV/DDV 22% in ostala orodja

- not ideal but is ok

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hi,

The categories must be created because that is when they are in the category_path. If 98% is good enough for you, then it might be enough. If they are unpublished, they won't give a problem anymore either.
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. # 3
DarkoF
DarkoF
Accepted Answer Pending Moderation
Hi so this working 98% times I get correct category, there are some newly categories created in import, but I just unpublished them. I try to find reason, why they are created but after a while I just give then I just give up.

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 4
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. # 5
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. # 6
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. # 7
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. # 8
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. # 9
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. # 10
  • Page :
  • 1


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