Resolved Import products in main category and sub category

Yes! It's great! Thank you for help

Hello,
If you want your products to be added to parent and child category then you need to have category_path field to have parent and child categories separated by |. Check the example below

"product_sku","product_name","category_path"

"10001","Sample Product","parent-category|parent-category/child-category"

Hi. Thanks. The question is, how do I make a rule for this? In the xml file stands parent-category> child-category, I made the rule of replacing> with /, how can I add parent-category before.

Hello,
There is no rule to read the first category and combine it with category_path. You may need to write your own custom rule to get this working.

Hello,

You can do this with a regular expression. For example your category path is parent>child and you want to import the product in parent|parent/child so it appears in both parent and child category.

Create a rule as shown in the screenshot and apply it to the category_path field. That should do what you are asking for I think.

Let me know how it goes.

Great! Thanks. It works!

Hi!
Please tell me how to make a rule Parent/child for this category node.

<categories>

<category>67</category>

<category>12</category>

<category>50</category>

<category>82</category>

</categories>

I tried to follow the example above. but without success.
Thanks!

- <product>

- <url>

- <![CDATA[ https://mport.lt/store/lavinamieji-zaislai/845-lcd-rasymo-piesimo-lentele-melyna-t20103

  ]]> 

  </url>

  <id>845</id> 

  <barcode>6586883386973</barcode> 

- <categories>

  <category>67</category> 

  <category>12</category> 

  <category>50</category> 

  <category>81</category> 

  <category>82</category> 

  </categories>

- <title>

- <![CDATA[ LCD rašymo / piešimo lentelė mėlyna T20103

  ]]> 

  </title>

- <description>

- <![CDATA[ 

  ]]> 

  </description>

  <price>9.99</price> 

  <prime_costs>3.350000</prime_costs> 

  <quantity>-20</quantity> 

  <warranty /> 

  <weight>0.000000</weight> 

- <delivery_text>

- <![CDATA[ 5 - 10 d.d.

  ]]> 

  </delivery_text>

- <manufacturer>

- <![CDATA[ 

  ]]> 

  </manufacturer>

- <images>

- <image>

- <![CDATA[ https://mport.lt/store/2194-large_default/lcd-rasymo-piesimo-lentele-melyna-t20103.jpg

  ]]> 

  </image>

- <image>

- <![CDATA[ https://mport.lt/store/2195-large_default/lcd-rasymo-piesimo-lentele-melyna-t20103.jpg

  ]]> 

  </image>

  </images>

- <product_with_gift>

- <![CDATA[ False

  ]]> 

  </product_with_gift>

- <barcode_format>

- <![CDATA[ EAN

  ]]> 

  </barcode_format>

  </product>

Hello,

Perhaps you can tell me what the end goal is, how should it look like? I doubt that every category is a parent and child at the same time.

Here is a screenshot of what it looks like now.

Hello,

<categories>

<category>67</category>

<category>12</category>

<category>50</category>

<category>82</category>

</categories>

You need to tell us which of these categories are parent and which of them are child categories. Right now there is no differentiation in the node to say the parent and child category. Give us an example on how you want to process the category ids.

Here is a screenshot of what it looks like now.

The screenshot shows the name of the categories and XML has category ids. We don't know which of these category name belongs to which category id.

Hi
I removed the values from the categories, now it's a number. https://homestock.org/en/virtuemart-4.html
Here's the link to the xml
https://mport.lt/store/modules/elp_export_mport/xml/elp_export_mport_1_5.xml

Hello,
I see you have a node parent for categories in your XML file, you can use that value for category_parent_id field if the category parent id is the same in your database. Also can i ask why you are using category ids here instead of name?

I was unable to import categories . I made a MultiReplace rule and replaced the digit with no value.
Is it possible to solve the problem like in this case?

Hello,

You can do this with a regular expression. For example your category path is parent>child and you want to import the product in parent|parent/child so it appears in both parent and child category.

Create a rule as shown in the screenshot and apply it to the category_path field. That should do what you are asking for I think.

Let me know how it goes.

It was great!

Hello,

Is it possible to solve the problem like in this case?

The problem here is that parent category is a separate node in XML and the child category just have id of the parent category. It is not going to be possible to link two nodes which are two rows in import. But if you know the id for which parent belongs, you can create a Find and Replace operation using RO CSVI Multireplace rule to replace with category name. In the case of first few records in your XML file, 2 value in parent node will be replaced by Mājas (the parent category name) using Multireplace rule. You can then combine the parent node with name node using RO CSVI Combine rule to get something like Mājas/Bērnu preces. So you will need two rules, one is to replace parent id to parent category name, the second one is to combine parent name with name of the category field. Let me know if it is clear.

I made a category combine and MultiReplace rule. The problem is how to import the product into the main category. You helped me make the MultiReplace "Parent / child" Find /(.*)/(.*)/ Replace $ 1 | $ 1 / $ 2 rule and it worked great. how to do in this case?

Hello,
Yes you can considering your category_path has 5 levels and the first level category id is the parent. You need to do two things. In your category combine rule set Combine character to > and save the rule. Create another RO CSVI Multi replace rule like in the attached image and apply it on category_path field. Remember this rule should be applied after the categories are combined. Let me know if that works.

i did it but it looks bad.

Hello,
From the screenshots, it looks like the rule has not been applied. Did you apply the rule on category_path field? You need to follow an order in applying the rules. The rule for creating a parent category should be applied after the other two rules lv kategori and category combine. See attached screenshot.

Can you also post a screenshot on what you see on import preview page? You should see the rule applied on Import preview page if it all is set right. See the attached screenshot to see how the rule works. Is that what you see?

Hi!