Further to this, it would be fantastic if the system could use a specific sequence based of something about the product. IE: the products Internal Category. Upon saving the product, the system should check if Internal Reference is empty, if it is empty it should check which internal category the product belongs to, and then apply one of the chosen sequences.

So maybe you would have:

FOOD-XXXXX

CONS-XXXXX

ELEC-XXXXX

CLTH-XXXXX

for food, consumables, electronics, and clothes.

Just an idea.

Completely agree, although I'm trying to get away from "Intelligent" part numbers. But for starters I just want a sequence that is incremented whenever a new product is created. Any help out there?

OK, I've created a sequence manually, then added this to the python file that inherits product.template:

def create(self, vals):

vals['ref']=self.pool.get('ir.sequence').get('product.product')

return super(object, seld).create(vals)

I'm getting an error. Any ideas?