HomeHome Product Discus... Product Discus...SmithCartSmithCartImport Products that have Several Categories/SubcategoriesImport Products that have Several Categories/Subcategories
Previous
 
Next
New Post
1/26/2011 11:50 AM
 

I have some products that fall into more than 1 Category/Subcategory. How are products assigned to several categories when using the Import function? When using a Product Import spreadsheet, should the product information be repeated for each Category/Subcategory instance?

 
New Post
1/26/2011 2:27 PM
Accepted Answer 

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

 
New Post
7/11/2011 4:52 PM
 
Cart 4.36
DNN 5.6.3
SQL 2008

If I want to have my sub categories 2 + levels deep, how do I setup the import spreadsheet to reflect this? There are only 2 columns, 1 for category and a 2nd for subcategory (which I am assuming perhaps incorrectly is the first subcategory level)...

Also, do I have to have the cateogories and subs defined first or will the import create the cateogries as part of the import?

Doug
 
New Post
7/11/2011 5:17 PM
 
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
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartImport Products that have Several Categories/SubcategoriesImport Products that have Several Categories/Subcategories