Products not showing

[pepe]

Hello all.

 

I'm trying to import products from another database into oscommerce using phpmyadin "Insert data from a textfile into table" function.

Everything seems to be working fine.

 

Data is properly imported, no error, browsing shows everything in place.

Categories are looking good as is products_to_categories.

 

BUT... (there's always a but, isn't it?)

My products simply do not show.

 

For instance i have:

main_cat -> sub_1 -> sub_2 -> prod

 

The categories are, aparentelly, fine. main_cat categories_id is "4" with parent_id "0". sub_1 is "406" with "4", sub_2 is "406196" with "406" and products_to categories tables make "prod" belong to "406196".

 

So... why isn't it there???

 

Thank you all for any help! :)

Pepe