How to Create Custom Categories in Bulk

This article will cover how to create custom categories in bulk. This is a great tool if you are looking to have multiple categories and sub categories.

  1. First, you will need to map out your categories. We recommend using a tool called WriteMaps. That website will allow you to get all of your categories mapped out in one place. It makes it much easier to visualize the flow of categories and sub categories. Using WriteMaps (or any other service) is entirely optional, but it may help make category organization easier.
  2. Next, open up Microsoft Excel and create your categories spreadsheet (feel free to use our template as a guide, BulkCustomCategories.csv). Your spreadsheet can contain the following column headers. 

    • Parent category key – All categories must have a parent category. If you are creating the head category the parent category key will be “Category Root.”
    • Category Name – This is the name of the Category.
    • Category Key/ID – This is the unique identifier that separate each category.
      NOTE: all letters must be lower case and no spaces are allowed.
    • Category Header – This is the title that will show up on the page when you click on the category.
    • Visible – By selecting "yes" the category will be visible on the site.
    • List subcategories on cat page – Mark "yes" if you have subcategories.
    • Custom URL (Optional) – This allows you to create a unique URL for your category.
    • Display Sub Image (Optional) – After creating the categories you will have the option to upload images. If you want the images to display for your sub categories mark this column yes.
    • Priority (Optional) – This is used to rank one category over another. In order for ranking to take place. Categories must be under the same parent category.
  3. Save your spreadsheet as a .csv file.
  4. In the search bar in the left-side menu, search for "bulk" and click on the "Bulk Category Loader" section.
  5. You can leave the selector fields as their defaults, or change them to preference.
  6. Click the "Choose File" button and select the file you just created.
  7. Click the "Upload File" button.
  8. Map your Column headers with the correct categories from the drop downs. This tells our system which column contains which information.
  9. Click the "Update Categories" button.
  10. Our system will tell you how many categories were created and how many were updated
  11. To view your categories navigate to “Browse Categories”


This text will not appear on the finished article.


Bulk category loading has not yet been implemented for the Manage platform. Stay tuned for updates!

If you have any questions, feel free to reach out to us by emailing or calling 480-779-7278!

RevolutionParts Logo