Bulk Category Insert

Bulk Category Insert [HQ]

Gofrugal HQ – Bulk Category Insert (Overview)  

The Bulk Category Insert feature in Gofrugal HQ enables users to quickly create and manage multiple item categories in a single process. It is especially useful for businesses handling large volumes of categories, allowing efficient data entry either manually or through Excel.

Key Functions:  

  • Bulk Creation of Categories:
    Add multiple item categories at once by entering details such as Category Name (List Value), List Order, Online Applicability, Mobile Applicability, and Visibility.

  • Excel-Based Data Upload:
    Supports copy-paste from Excel, making it easy to prepare and upload large datasets in the required format.

  • Flexible Deployment:
    Newly created categories can be:

    • Sent immediately to outlets, or

    • Scheduled to be sent later

Centralized Management:
Ensures all category data is maintained at HQ and distributed across outlets uniformly.


To perform this process:

  1. Open HQ and navigate to Support > Migration > Bulk Category Insert.

  1. Select the required category from the list.

  1. Enter the category name in the List Value field. Then specify the List Order, set Applies Online to Yes or No, Applicable to Mobile Device to Yes or No, and Visibility to Yes or No.

The following explains how to perform this using an Excel spreadsheet:

  1. Open the Excel file and arrange the data to match the screen format.


  1. Copy the data from Excel and paste it into the Bulk Category List Value Insert screen.

Note: You can easily copy and paste data from Excel. Refer to the notes section below the screen for guidance.

  1. Click the Save button.

  1. Click the Send To Outlets button to send the newly created categories immediately or click Later to send them at a later time.

  1. Click the Close button to complete the process.

 

To verify if the categories have been created and synced:

Verify in HQ:

  1. Open HQ and navigate to MDM > Attribute Master Management > Item Attribute Master.

  1. Click on the attribute name Category.

  1. Search for the keyword in the List Value column.

Once filtered, all relevant data is displayed on the screen.

Verify in the Outlet POS:

  1. Open the outlet NetTrade and check the report. The Attribute Master will be displayed.

  1. Navigate to Inventory > Masters > Category.

  1. Check the Category Master to verify the newly created categories.

 

Summary Insight:

The Bulk Category Insert feature simplifies mass category creation, ensures consistency across outlets, and reduces manual effort, making it an essential tool for efficient master data management.

    • Related Articles

    • Bulk Item Insert [HQ]

      The Bulk Item Insert screen allows you to create items quickly and import them from Excel. Ensure that options in dropdown menus, such as Manufacturer, Category, and Supplier, are set up beforehand. To perform this process: Open HQ and navigate to ...
    • Do you know how to add new values at an Item Hierarchy Level at HQ?

      Meaning of Item Hierarchy Level: Item hierarchy level refers to the level of classification or grouping of products in a hierarchical structure. In retail businesses, this hierarchy can include various levels such as department, category, ...
    • Contact Master Bulk Insert [HQ]

      The Contact Master Bulk Insert feature allows you to create multiple contacts efficiently. You can enter contact information individually or upload it from an Excel spreadsheet. Ensure the Excel file follows the same format as shown on the screen, ...
    • Bulk Category Map Tool [HQ]

      Bulk Category Map Tool The Gofrugal HQ Bulk Category Map Tool provides an effective way to manage large product inventories by utilizing a hierarchical categorization approach which guarantees data consistency for online and offline sales. It ...
    • Category Merge [HQ]

      This document outlines the process for merging categories within the GOFRUGAL HQ system. Merging categories can help streamline inventory management, improve reporting accuracy, and enhance the user experience. When to merge categories Duplicate ...