Currently that feature is not supported in the product import feature, you can only assign one cat/sub cat when importing. To add the product to more then one cat/sub cat you would have to go in the product setup screen and check the boxes to include the additional cat/sub cats you want.

Christian

Ok, after I posted I decided to try it and voila! it works as I hoped it would.

1. You don't need to create the categories first. The will be created as the spreadsheet is processed. Cool!!

2. You only need the 2 columns. As long as a category or sub category is already created either before the import or during the import, the new sub category will be created as a sub of whatever level the categoryname field is. For example If my first record is cat CAT1 and subcat SUB1 the if my next record is cat SUB1 and subcat SUB2 then the product will appear in CAT1->SUB1->SUB2 etc.

However, after my test, I deleted the 1 product imported. then I deleted the category and 2 subs that it created and my site crashed.. Every page I had the Category menu module created on I received the following error:

AssemblyVersion: 5.6.3
PortalID: 0
PortalName: Blue River Trading Company
UserID: -1
UserName:
ActiveTabID: 64
ActiveTabName: Company Info
RawURL: /CompanyInfo.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: baa0259c-788d-4d51-be7e-021d85570559
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Smith.DNN.Modules.CategoryMenu.CategoryMenu.Page_Load
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Smith.DNN.Modules.CategoryMenu.CategoryMenu.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: ASPHOST95


I had to basically recycle the app pool to get it running again by changing something in the web.config file and then saving the file so it would force a re-load of the website.

Doug