1. bvgeleuken
  2. RO CSVI
  3. Sunday, 16 October 2016
  4.  Subscribe via email
I have a export file from a CRM solution. I sell CD's. In the CRM we keep our inventory.
One off the fields is the genre of the CD
The genre is a category or subcategory in Virtuemart.

But when a Genre is a subcatagory in Virtuemart it's not recognized as subcategory but CSVi will create a new category.
I can not export a parent category from the CRM because there is no such hierarchy.
How can CSVi check if a genre is a category or subcategory?

Quick example.
CD1 Genre = Rock --> Category in Virtuemart is Rock
CD2 Genre = Alternative Rock --> Subcategory in Virtuemart with parent Rock

But when I import a new category Alternative Rock is created.

Thanks
Accepted Answer Pending Moderation
Hello,
But when a Genre is a subcatagory in Virtuemart it's not recognized as subcategory but CSVi will create a new category.
I can not export a parent category from the CRM because there is no such hierarchy.
How can CSVi check if a genre is a category or subcategory?

You need to have category_path field like category/subcategory so CSVI recognises the parent and child categories and relates them. You have not attached your import file or debug log to give more information here. Post the information requested in Looking for a useful answer? on top of this page to help.

Quick example.
CD1 Genre = Rock --> Category in Virtuemart is Rock
CD2 Genre = Alternative Rock --> Subcategory in Virtuemart with parent Rock

But when I import a new category Alternative Rock is created.

The category Alternative Rock will be created and linked to the parent category Rock if category_path is given as a path like Rock/Alternative Rock.
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
As I said I can not export a parent category from the CRM because there is no such hierarchy.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
There is no way CSVI can recognise if its a parent category or child category without category_path. You need to import parent and child category to have the path properly set in VirtueMart. If you know the parent categories, you can have them set in your import file manually before doing an import. I don't see any other way here. But again, can you send a sample import file to check?
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. # 3
Accepted Answer Pending Moderation
Hello,

Something came to my mind, one way to do this is to create replacement rules. Let's say the category in your XML file is Shoes. Using a replacement rule you can replace this with Women/Shoes for example. This way CSVI will have the complete path. Only downside is, you will have to do this for all categories.
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
  • Page :
  • 1


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