I just created a half dozen new categories and about 25 sub-categories from them. I usually don’t use the drag and drop editor, but this time I felt like I could do it faster that way.
The bug creates one CATEGORY record for every record in the PRODUCT OPTION table. The tell-tale sign is the ghost categories have no “Last Mod. By” or “Last Modified” info and all have numbers sequentially higher than the last real category you created.
This is not an ongoing bug — just one that I saw tonight, (I’m sure if it was going on longer more people would have complained and they’d fix it).
Had I been doing an upload / import I would have blamed myself for uploading the wrong table or something — because that’s what this error looks like.
The facts: (Tonight) The Drag & Drop Editor has a serious problem, (confirmed by Customer Support Rep “Viet” who tested it on his own store at approx 3:00AM on Dec. 3, 2010).
Check your CATEGORIES database if you’ve been working on that database.
Here’s the steps to check and see if you have any extra categories that you did not create:
- goto Admin
- click Categories
- click List All
- if “Last Modified” column is not visible:
- click Customize
- check off “Last Modified“
- click Save
- (return to List All screen)
- click the little arrow next to “Last Modified” column heading
- (click again to reverse sort order)
What you are looking for is categories with no “Last Modified” date, (or Last Mod. By info), and which have numbers higher than your last created category, and are named like your product options…
Make sure the bug is fixed before deleting all the extra categories… they just come back with higher numbers in the state the bug is in.