import the order

I would like to write a PHP script to import the order of products within specific product categories.

I struggling with locating how the orderings are stored to the database.
Could you possibly direct me on how this is achieved?

Thanks.