Can you explain how it should be sorted please? Currently, products (by brand) are sorted alphabetically by product name, then numerically by the numbers that follow them. This from left to right and then down. So if everything is entered correctly, it also follows up nicely (see photo).

But maybe I'm not completely up to date with the request?

Do you mean you want to see all color tubes from (all) different brands sorted together?