Problems following data import from OScommerce

[wdkstudio]

I have attempted to import data manually from an os commerce db into a zen cart db. Everything appeared to have gone well, imported customers, orders, products etc.
However, I now get the message that there is a product listed in the top level and I cannot add more categories. I have seen the forum entries on this. My problem is that the product doesn't show up in the admin under categories so I dont know which product it is or how to delete it.

If any one has any sensible suggestions this would be much appreciated

Thanks

WDK

[DrByte]

That means that when you imported your data, you put records into the products_to_categories table but left the categories_id set to 0. You'll need to find those records and set the correct categories_id.

[wdkstudio]

Thanks for the super fast response. Still getting to grips with sql and phpadmin.

Does that mean manually changing the categories id? Is that in the products_to_categories table or somewhere else?

Cheers

WDK

[DrByte]

Does that mean manually changing the categories id?

Probably, yes.

Is that in the products_to_categories table or somewhere else?

Yes

[wdkstudio]

Thanks. Found and deleted the 'loose' product and everything is now fine.

I appreciate your help

Cheers