Categories
View Replies (2)

Resolved importing categories at the same time as product

  1. DanBrad01
    DanBrad01
  2. RO CSVI
  3. Friday, 26 February 2016
  4.  Subscribe via email
I have a csv that i download from a supplier so i can't amend the csv prior to import.

i need to get the categories to import in to virtuemart automatically, below are the two fields with example data from the csv.

"CategoryID","Category"
"5255","PCGamesConsole-Gameboy"

how would i get the category to import as below with subcategories?

Level 1 Category - PCGamesConsole
Sub Category - Gameboy
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

You will need to create a VirtueMart Category import template. On the Options tab make sure you change the category separator to - instead of / as your file is using a - as separator. Set the Use file for configuration to No.

For the fields, you add a skip field for the category ID because you can't import that, the IDs are controlled by the database. As a second field you add the category_path field.

With that you can import your files and CSVI will create the category tree 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. # 1
DanBrad01
DanBrad01
Accepted Answer Pending Moderation
perfect that worked, many thanks
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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