To import item based on Category

In order to import the items based on the category, we have to get the item details import the item to account using csv import.

The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records, if you have the Import CSV File permission.

Before an import, review the information available in Guidelines for CSV Import Files for help formatting your CSV files correctly.

The Import Assistant includes five steps:

• Step One Scan & Upload File
  • Select an Import Type
  • Select a Record Type for Import
  • Choose Import Character Encoding
  • Choose CSV Column Delimiter
  • Select a File for Import
• Step Two Import Options
  • Choose Data Handling for Import
  • Set Advanced CSV Import Options
• Step Three File Mapping (required only for multi-file imports)
• Step Four Field Mapping
• Step Five Save Mapping & Start Import

After completing the item importing , we have to create a csv template which contain the item name and internal id and its corresponding category name and id.

Then perform the category import similar to item import

select the website and commerce category as import type and record type

ap the internal id or name with the category id, then perform import