database transfer, products table - master_categories_id values?

[ksolito]

I'm writing a program to transfer categories, categories_description, products, products_description, and products_to_categories from an oscommerce database to a zen cart database. The source database has some products in multiple categories. Can anybody tell me how to identify which of the categories_id values for a given products_id is the master_categories_id? Does it even matter?

[mat123slade]

Same question... Any info on this would help. Thanks.

[Ajeh]

What matters on the master_categories_id is which one most identifies with the Product or would be considered the owner of the Product ...

If you were to remove the indexes on the products table, it is most likely the first record in the products_to_categories table ...

This, however, is messed up by the indexes as it makes the lowest categories_id appear to be first ...

The importance of the master_categories_id is for pricing with things like Sale Maker or in determining the better category to go to when a category is unknown such as from a sidebox or a search ...