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 ?!?!?