How to duplicate Magento product and add a new SKU with only one "save" action

Question

I want to duplicate a product and give it successively a new sku in an only one save action. How can I do that ?? I have tried this code: ``` $sku = '123456'; $product = Mage::getModel('catalog/product') ->loadByAttribute('sku',$sku); $newProduct = $product->duplicate(); $newProduct->setStatus(1); $newProduct->setSku($sku.'-v2'); $newProduct->save(); ``` but it throws this exception: ``` SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3569-1' for key 'IDX_STOCK_PRODUCT' ``` Thanks for help.

Accepted Answer

```
$newProduct->save();
```

should actually be:

```
$newProduct->getResource()->save($newProduct);
```

How to duplicate Magento product and add a new SKU with only one "save" action

Solution

Problem