Skip to Content
Menu
This question has been flagged
4 Replies
6218 Views

Thanks,

Rob

Avatar
Discard

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.

Author

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?

Author

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?

Author Best Answer

I manually created the sequence (product.product) in Odoo from the developer menu, database structure, sequences. Then added the following code in the py file:

sms_part_number = fields.Char('Part Number', help="Enter SMS Part Number")

@api.model   

def create(self, vals):
        vals['sms_part_number'] = self.env['ir.sequence'].next_by_code('product.product') or '/'       

        return super(sms, self).create(vals)

Avatar
Discard
Related Posts Replies Views Activity
1
Nov 24
19837
1
Sep 23
2676
3
May 23
5361
7
Apr 23
48639
1
Dec 22
7532