Skip to Content
Menu
This question has been flagged
4 Replies
5623 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
18017
1
Sep 23
1203
3
May 23
4088
7
Apr 23
47087
1
Dec 22
6433