Apsona ShopAdmin - a free tool for import/mass update/reporting

[Bewitching]

Hey kman55,
I'm not seeing doubles. I did only look at a few categories, and I didn't blush LOL
If you could tell me which ocategories you are having a problem with, I'll look again.
My store has over 7,000 products & I don't run into too many issues with Apsona ShopAdmin
The first upload of your products is always the one that will cause you a headache.

I can take a guess at what the issue may be:
Are you listing some of your products in two or more categories?
Like product A, a "25w light-bulb" is in Category B "lighting" and Category C "light-bulbs" ?
That will cause a HUGE headache if your spreadsheet doesn't have the categories properly formatted.
Here is how it has to be on your spreadsheet:
Master category is the MAIN category for your product. A product can have only ONE Master category.
Category is where you'll again list the Master category, but also list any other categories you want that product to be in.
I attached a photo example from my spread sheet so you can see what I am talking about. (Visuals help greatly! LOL )
( I run a Pagan store, so I hope YOU aren't offended )
Do you see how my first product has 2 categories listed, and ONE Master Category?
The two "categories" listed must be within the same cell, but on different lines.
And you must use the following format for categories:
Top category, colon, space, sub-category.
Categories and sub categories must be separated by a colon, then space.
Like this:
Jewelry: Pendants & Charms
Jewelry: Pentagrams/Pentacles

Hope this is what you were looking for & I didn't confuse you more than you already were.
If you need more answers, I'll do my best to help.
Good Luck,
Kathleen