跳至内容
菜单
此问题已终结
1 回复
3510 查看

Guys,

I developed a simple module to create relation between ebay listing and product in Odoo. It works perfectly fine but if I want un-bind (remove relation) it won't update record.

# Unbind def

@api.one

def unbind(self, idlist_id):

context = ''

item_id = self.env['idlist'].search([('name','=',self.name)])

if item_id:

print '== Unbind ID from product ======================================================'

print ' item found'

for item in item_id:

print '== Unbind item_number =========================================================='

print ' ', item.id

print ' ', self.name

print ' ', self.item_number

self.env['product.template'].write({'ebay_item_id': '000000000000', 'assigned': False, 'ebay_listed': False})

#self.env.cr.execute(""" UPDATE product_template SET ebay_item_id = '%s', assigned = '%s', ebay_listed = '%s' WHERE ebay_item_id = '%s' """ %(' ',False,False,self.item_number))

self.env.cr.execute(""" UPDATE idlist SET isused = '%s' WHERE id = '%s' """ %(False,item.id))

self.write({'state':False})

print '================================================================================'

raise Warning('Ebay ID successfully UN-BIND`ed')

else:

print '== item not found =============================================================='

I tried direct SQL query and API, none of those method works ;(

WHY ?!?!?!

WHERE is the problem ?!??!

WHAT I'm doing wrong ?!?!?


形象
丢弃
最佳答案

Rob,

On which product_template record(object) are u executing below line?

self.env['product.template'].write({'ebay_item_id': '000000000000', 'assigned': False, 'ebay_listed': False})

here you are just taking product_template class but not any object(record) of it....

so, first get the object of product template record and the apply write on it.. like:

<product_template_object>.write({'ebay_item_id': '000000000000', 'assigned': False, 'ebay_listed': False})

Hope it helps!

形象
丢弃
编写者

Don't get it :) However, I tried also direct SQL and it also won't work :( .... don't get it :(

编写者

Hi Pawan, I think I finally got it :)

相关帖文 回复 查看 活动
3
5月 24
15091
1
9月 15
3500
1
3月 16
22224
1
10月 15
6141
1
6月 16
3407