I am looking for an easy way to be able to quickly update the product sort order on any category page via export or import. I have looked into several extensions but have been limited due to the issue of having 1000's products per category which by default would result in a CSV with over 150,000 characters in a particular cell. Even if I do find an extension it will take about the same amount of time to organize the data for import as if I was to organize data for a direct import into a database via a correctly formatted CSV (I dare say!).
I am familiar with MySQL and phpMyAdmin and I am very comfortable with exporting and importing directly into it, and even more comfortable with triple checking data before importing for precise characters, etc, but I am not so familiar with Magento's database handling and the indexing.
Is it viable to export the "catalog_category_product" table and amend it for re-import and does anyone know if there would be any other tables involved in this? Or which tables? And any further steps apart from a backup(!).