Categories
View Replies (2)

Resolved Product category path in Viretuemart export

  1. andrejk
    andrejk
  2. RO CSVI
  3. Tuesday, 21 May 2024
  4.  Subscribe via email
Hello,
VM 3.8.4, Joomla 3.10.12, RO CSVI 8.9.3

I have one product in two categories and in the exported file the category_path is a concatenation of these two categories. For example:
Product is in category: Príslušenstvo k navijakom|ARB príslušenstvo k navijakom
but it is also a product in the category: ARB príslušenstvo 4x4 komplexne|ARB ostatné príslušenstvo

in the exported file it looks like this

<category_path>
<![CDATA[ Príslušenstvo k navijakom|ARB príslušenstvo k navijakom|ARB príslušenstvo 4x4 komplexne|ARB ostatné príslušenstvo ]]>
</category_path>

please how to show only one path category?

<category_path>
<![CDATA[ Príslušenstvo k navijakom|ARB príslušenstvo k navijakom]]>
</category_path>

if I specify a rule to skip one category, the product does not go into the exported file

Best regards
Andrej
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andrej,
if I specify a rule to skip one category, the product does not go into the exported file

You should be using RO CSVI Multi replace rule with regular expression to remove the second category. Skip rule will skip the entire row and not any value.

Also I see you have set | as category path separator in export template. In RO CSVI multiple categories are also separated by | so I would suggest to change category path separator to > or any other symbol in export template so there is no conflict with multiple categories separator.

Now to get one category for a product in export

1. Create a new RO CSVI Multi replace rule
2. Select Operation as Find and Replace.
3. In Find field set regex as below



\[^|]*$\


4. Leave Replace field empty
5. Set Method as Regular expression.
6. Save the rule and apply it on category_path field in template fields page.
7. Run export and check.

See attached screenshot. Run the export and let me know on how it goes.
Attachments (1)
Screenshot 2024-05-21 at 4.11.52 PM.png Screenshot 2024-05-21 at 4.11.52 PM.png
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. # Permalink
Responses (2)
andrejk
andrejk
Accepted Answer Pending Moderation
Hello,

thank you very much Tharuma.

Best regards
Andrej
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


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