What is the best way to generate unique numbers to keep track of products? I want to ensure that no product can have the same reference number. It is best if this can be done without Studio, but I am open to solutions with Studio as well.
Yes you can do it from the user interface with using the developer mode. See this example of setting unique reference number for the customer from user interface: Assign Sequential Value For Field Using Automated Action And Sequence
Similarly you can do for the products also.