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
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
perfect that worked, many thanks
Log in to reply to this topic.