Category Import

The Category Import allows you to import Categories and Sub-Categories from a .CSV file.  The category import program will lookup Categories by CategoryName, if the CategoryName currently exists in the database the import program will update the existing record and if the CategoryName does not exist the import program will insert a new record in the database.

  Click here to download sample CSV

To access the Category Import, navigate to the store admin menu and click the "Setup -> Import" option:

Step 1: Choose Import type

Select the Product Import tab at the top of the Import Data management page.


Then select the "Categories" radio button.


Step 2: Choose a File

From the Product Import tab click the Browse button.


Step 3: Select a File Name

Navigate to the file you want to import, and click Open.


Step 4: Import Now

To import the selected coupon spreadsheet, click the Import Now button to upload the file

When the import is complete, a message stating that the import was successful is displayed.

Note: This process may take several minutes, depending on the number of records to be imported. You should also allow time for the data to be processed: for example, it should take about half a minute to import 100 products, five minutes to import 1,000 and so on.

To get a sample import file you can export using the built in export manager in SmithCart or click here to download the sample files


Import Field Specification

Field Name Field Format Required
CategoryName String Yes
ParentCategoryName String  
DepartmentID Integer  
SortOrder Integer  
Share Boolean  
CatSEOURL String  
CatDescription String  
MinOrderAmount Decimal  
MinOrderQty Integer  
Featured Boolean  
Delete Boolean  




Add Feedback