QB Issue Resolution:
in the spreadsheet format there is a cell for category, sub categories must have the parent, a colon, and the sub category. ie. parent:sub
I have seen one user post that the only way he could get it to work was to enter it as, parent : sub
You do have to use the format you can find in the menu gear>tools>import and select products and down load the sample file format
Resolution for Issue 'How can I import the category when I am importing Product details from and excel file?' available: Yes (Solved).
Source: Intuit Community forum.
How can I import the category when I am importing Product details from and excel file?: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.Support for excel file
Quickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!
Error Recovery for excel file [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.
Additional Support Options: