Here are a few 'general' suggestions about importing data:

- We recommend that you first create your Category tree (structure) through the Control Panel (so, don't use the Import Feature to actually create the Categories in the database).  Then using the Import Wizard, import just a few products initially, to make sure everything is working properly.

- ProductCart supports up to 4 Category levels (deep) including the ROOT, and Categories that contain products cannot also contain Subcategories (which also means that you cannot add Products to a Category that has Subcategories).

- Completely remove columns (from the Excel template) that do not contain any data (with the exception of course of the 4 required fields: SKU, NAME, PRODUCT DESCRIPTION & ON-LINE PRICE).

Also keep in mind that when, importing products, there is no way to indicate the Grandparent Category, or Great-Grandparent Category.... just the Category and Parent Category.  Remember to define the Category Hierarchy in the Control Panel first, and then Import the products.  For example, if you're Category Tree looks like this:

Root
 - Camping Supplies
    - Tents
        - 4 Person Tents

Then, in a spreadsheet that you are importing, let's say the product is a North Face 4-man tent, you would designate the Category as "4 Person Tents" and the Parent Category as "Tents"... and that's it.  You do not need to reference Camping Supplies (which is the Grandparent Category) in the spreadsheet, as it will find it automatically.  The only time this is a problem is if you have separate Category Trees that have duplicate Category Names.  If this is the case, you should slightly modify the Category Names so they are not exact duplicates.  I hope this helps.