Get Product id before save event in observer

Question

how can I get product id from new product before save event.I have used below code but it will create blank product in database every time.

$newProduct = $product->duplicate();
echo $product_id = $newProduct->getId();

any other way to get product id before product save.

score 3 · Accepted Answer · answered Jan 17 '14 at 11:18

What you could do is load the next value in the product table's auto_increment field. This should most of the time give you the id that will belong to the next product created.

$product = Mage::getModel('catalog/product');
$product_entity_table = $product->getResource()->getEntityTable();    
$resource = Mage::getSingleton('core/resource');
$connection = $resource->getConnection('core_read');
$result = $connection->showTableStatus($product_entity_table);
$next_product_id = $result['Auto_increment']);

score 2 · Answer 2 · answered Jan 17 '14 at 09:45

2

You cannot get the new product id before saving it because the product does not have an ID before it is added to the db.
But I don't see the problem here. $product->duplicate() will call save() on the new product. You should get a valid id.

answered Jan 17 '14 at 09:45

Marius

197,939
53
422
830

Thanks @marius but it create duplicate product and display it on grid.and it did not give current new product id but it will give id of just created duplicated product.i don't want duplicated product id but need new product id that i have creating. – Zahirabbas Jan 17 '14 at 10:19

score 0 · Answer 3 · answered Jan 17 '14 at 09:52

0

You can try below code -

Mage::getSingleton('core/resource')->getConnection('core_read')->fetchOne('SELECT last_insert_id()')

after

$newProduct = $product->duplicate();

answered Jan 17 '14 at 09:52

Tejas Shah

598
4
10

1

This will still have the issue of two products as the duplicate will create a product. – David Manners Jan 17 '14 at 10:04

Get Product id before save event in observer

3 Answers3