You can sort variants when importing them from excel. But we are using base products to show on category pages and sorting them by hand in BO by draging and dropping them in the right order. This sort order is then used on the site with the default sort option “Sort by Recommended”. So the information is there somewhere on the product but from what i know i cant import/ export this data. So my question is: Can i sort the products with import/ export?
The option to sort the variants from Excel only affects the order of variants in the Variants tab of the product. There’s no tool or import option available to sort products in a category other than drag and drop.