In your admin panel edit the attribute “Authors” and set the order as Custom.
Now you can use a csv to edit all your products and attributes for each one. The order you will set there, that’s the order that will be displayed in each product.
About Woocommerce default csv import / export function you can read more here: https://docs.woocommerce.com/document/product-csv-importer-exporter/