1. laconcorde
  2. RO CSVI
  3. Thursday, 06 February 2020
  4.  Subscribe via email
Thanks, it works! Another question: how do I import products into the main category and sub category. Currently, products are displayed only in a subcategory.
Accepted Answer
Accepted Answer Pending Moderation
Hello,
I did some changes to rules on your site and ran the import. Categories looks good to me. Can you check now?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
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"
Kind regards,

Tharuna

=========================
If you use CSVI, 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. 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.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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.
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. # 4
Accepted Answer Pending Moderation
Great! Thanks. It works!
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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!
  1. 3 weeks ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation

- <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>

Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Here is a screenshot of what it looks like now.
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
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
  1. 2 weeks ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
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?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
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!
  1. 2 weeks ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
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?
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
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.
Attachments (2)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
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?
Attachments (2)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
  1. 2 weeks ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello,
Yes i see the issue here. Looks like all the categories are not of 5 levels in your XML file. The category which is having an issue like for example Ziemassvētku eglītes>Ziemassvētki>Ienākošās preces is a two level category and so the rule did not work. In such case you need to create multiple rules for each level and apply it on category_path. See the attached screenshot for two level categories.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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