Is possible to add product category in bulk through the import Excel Template

Is possible to add product category in bulk through the import Excel Template

Environment

6.6  integrated with SAP 

Product Query

Is this possible to  add product category in bulk   through the excl import template.

Resolution/Work Around: 

Yes, user can add product category in bulk through the excel import option.
Follow the below shared steps to through the excel import option:

1. Management consoles >>Administration >> Application setup >> Import data >> Select Product category sheet  >> Click on OK button


2. While preparing excel you should fill three column like   product category id, product category description, product code  (id) ,GenerateIntegrationEvent and EnterpriseName .
You can also choose multiple line product code while inserting data in excel.



3. Now save the excel file and Import through Data Import option in Management console.

Note: Please refer attachment to download excel template format and Save the excel file as xlsx format .



    • Related Articles

    • How to Active-Inactive Bonus Buy through Excel Template

      Environment 6.6 integrated with SAP Product Query Is this possible to Active-InActive the existing bonus buys through the excl import template. Resolution/Work Around: Yes, user can Active-InActive the existing bonus buys through the excel import ...
    • How to Active-Inactive Bonus Buy through Excel Template

      Environment 6.6 integrated with SAP Product Query Is this possible to Active-InActive the existing bonus buys through the excl import template. Resolution/Work Around: Yes, user can Active-InActive the existing bonus buys through the excel import ...
    • Loyalty Adjustment Journal Excel File (Template & UI)

      Requirement: Provide the details template file to import the Loyalty Adjustment Journal screen. below is the screenshot for the same: Solution: Attached is the required Excel format (file name: Loyalty Adjustment Journal Excel File (Template)) to ...
    • Gift Certificate Import template in iVend MC

      Environment: iVend Version 6.5 Update 6 Problem Statement: We have gift cards set up with an unlimited expiry (mandatory by law), although it's allowed to book away any remaining GC balance in the GL accounts after x period after initial use. GC for ...
    • Unable to import Excel file with UDF

      Environment: iVend 6.6 with SAP B1 9.2 Problem Statement: Product Masterfile unable to re-import with user defined field (UDF) Symptoms: On exporting the product master from iVend from Export Data functionality, after making changes in the exported ...