1. mac4life
  2. RO CSVI
  3. Wednesday, 24 January 2018
  4.  Subscribe via email
Hi

How can I change this Google Shopping export from:

<g:google_product_category>Speicher>HDD>3.5“ Festplatten</g:google_product_category>

to

<g:google_product_category>Speicher > HHD > 3.5“ Festplatten</g:google_product_category>


the category_path seems to be not correct?
blank space are mssing?

Thanks

PHP version 7.0.27
Joomla! version 3.8.3
VirtueMart 3.2.12
CSVI Pro 7.4.1
Accepted Answer Pending Moderation
Hello,
the category_path seems to be not correct?
blank space are mssing?

The category path Speicher>HDD>3.5“ Festplatten (without space) is of correct format. Having a space will make the category_path look good but when it comes to database even a space is counted as a character. So Speicher>HDD>3.5“ Festplatten is not same as Speicher > HDD > 3.5“ Festplatten as per database. If you still want the spaces to be added in export you can create a replace rule in CSVI to find '>' and replace with ' > ' and apply the rule on category_path field.
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
Accepted Answer Pending Moderation
Hi
I thought that with space is correct, according to the Google Google Merchant Feed specifications.

Ok, thank you for the rule tip.

Thank you, excellent Support.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hi

If you still want the spaces to be added in export you can create a replace rule in CSVI to find '>' and replace with ' > ' and apply the rule on category_path field.


If a make a find and replace rule
This doesn't seem to work.
What I'm doing wrong?

By the way, Google merchant gives this error, if you don't add a space within the google product category :
WARNING: Unknown Value "google product category".

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
If a make a find and replace rule
This doesn't seem to work.
What I'm doing wrong?

Can you post a screenshot on how you have the replace rule set up? Without any details on your rule it is hard to say what would be wrong.
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. # 4
Accepted Answer Pending Moderation
Hi

I've attached the rule.

rule.png
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
In your rule change the Method option to be Regular text instead of Regular expression and check the export.
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. # 6
Accepted Answer Pending Moderation
Hi

Now the result looks like that:
<g:product_type>Speicher>RAM > Memory>DDR2 SDRAM (240pin)</g:product_type>


Should look like that:
<g:product_type>Speicher > RAM > Memory > DDR2 SDRAM (240pin)</g:product_type>


' > ' gets replaced only once …
rule --> Always replace , mmmh
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,

The multiple values option is not applicable here because you only 1 replacement. You need to set the Find value to (>;) and the Method needs to remain Regular expression. This will give you this (as in my test)
Parent > Level 1 > Level 2 > Level 3


Let me know if it works for you.
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. # 8
Accepted Answer Pending Moderation
Hi Rolandd

For some unknown reason, it just doesn't work.

It will replace the second > and ad a space only
Parent>Level 1 > Level 2>Level 3


rules1.png
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,

Can you post me the template you are using for export? You can export the template via Maintenance -> CSVI Pro -> Backup templates. This way I will have both your template and replacement rules so I can test as if it is yours.

Just to be sure I tested with your category name as well and you can see the result in the image. First is the before and then the after the replacement.
Attachments (1)
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. # 10
Accepted Answer Pending Moderation
Hi

Backup template attached

csvi_templates_20180206.xml
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
In your export template settings on Options tab you have set category separator to be / and since there is no matching > found in the category, replacement rule does not work. Change the replace rule to find for (/) replace with / and run the export. See if it works.
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. # 12
Accepted Answer Pending Moderation
Hi Tharuna

Replaced the rule to find for (/) and " / " works now.

Result:
Parent > Level 1" > " Level 2 > Level 3


Level 1 always gets 2 spaces …
So I needed to make a second rule:
Find " / " and replace " / "

Result:
Parent > Level 1" > " Level 2 > Level 3


Solved
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
Glad to know that you got it solved.
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. # 14
  • Page :
  • 1


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