Categories
View Replies (4)

Resolved replace any value with absolute value

  1. baroen
    baroen
  2. RO CSVI
  3. Monday, 24 August 2020
  4.  Subscribe via email
For constructing a Google Merchant feed I need to replace my VM category path with the correct Google category number.
All of my products belong to the same Google category so I can replace any VM category with the Google category's ID.
I guess I have to use CSVI Multireplace rule for this, but how do I configure the rule to replace 'anything' with '33'?
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I see that issue with products with more than 4 categories assigned. I am not an expert in regular expressions so modify the regex in your RO CSVI Multi replace plugin to



(\S+.*)


and give it a try. Let me know on how that goes.
Attachments (1)
Screenshot 2020-08-25 at 11.21.10 AM.png Screenshot 2020-08-25 at 11.21.10 AM.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 (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes, you need to use RO CSVI Multi replace rule plugin to replace the category_path value. You need to do two things

1. Create RO CSVI Multireplace rule and using regular expression, replace everything of category_path value to number 33.
2. Apply this rule on category_path field value in template fields in export template. Note if category_path is empty, rule will have no effect on it and it will still return empty. If you need empty category_path value to be replaced with 33, then in template fields set Default value field to 33.

Check the screenshots for the settings.
Attachments (2)
Screenshot 2020-08-24 at 1.35.37 PM.png Screenshot 2020-08-24 at 1.35.37 PM.png
Screenshot 2020-08-24 at 1.36.01 PM.png Screenshot 2020-08-24 at 1.36.01 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. # 1
baroen
baroen
Accepted Answer Pending Moderation
Hi, this seems to work in most cases. However at some products the result = '33 33 33 33 33 33 33' or '33 33 33'
Do you have any idea how this can happen?
  1. more than a month ago
  2. RO CSVI
  3. # 2
baroen
baroen
Accepted Answer Pending Moderation
Works fine now. Thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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