Programmatically Adding Magento Products & Incrementing Sku?

Question

I'm trying to write a script to add 10 products to Magento using php/mage.

This is what I have so far, in Magento 1.8.1

<?php
ini_set('memory_limit', '-1');
ini_set('display_errors', '1');
error_reporting(E_ALL);
require '../app/Mage.php';
$app = Mage::app('default');
set_time_limit(0);
$product = Mage::getModel('catalog/product');
$sku = 1;

do {
$product->setName(trim(strip_tags('Unnamed Product')));
$product->setDescription(trim(strip_tags('Description')));
$product->setShortDescription(trim(strip_tags('Short Description')));
$product->setSku($sku);
$product->setPrice(trim(strip_tags('19.99'))); # Set some price
$product->setWeight('1');
$product->setCreatedAt(strtotime('now'));
$product->setTypeId('simple');
$product->setTaxClassId(2); // taxable goods
$def_attribute_set = Mage::getModel('catalog/product')->getResource()->getEntityType()->getDefaultAttributeSetId();
$product->setAttributeSetId($def_attribute_set);
$stock_data=array(
'use_config_manage_stock' => 1,
'qty' => trim(strip_tags($data[13])),
'min_qty' => 0,
'use_config_min_qty'=>1,
'min_sale_qty' => 0,
'use_config_min_sale_qty'=>1,
'max_sale_qty' => 9999,
'use_config_max_sale_qty'=>1,
'is_qty_decimal' => 0,
'backorders' => 0,
'notify_stock_qty' => 1,
'is_in_stock' => 1
);
$product->setData('stock_data',$stock_data);
$product->setWebsiteIds(array(Mage::app()->getStore(true)->getWebsite()->getId()));
$product->setStatus(1);
$product->setVisibility(4);
$product->save();
$sku++;
} while ($sku<=10)

?>

I'm trying to tell it to add products, increment the sku by 1, and keep adding and incrementing till it gets to 10. However it only adds one product and then does nothing?

Is there a better way to programatically add products to magento and increment the sku? Also trying to figure out how to get Magento to check for the sku and skip it if it exists and have had zero luck with that as well.

Answer 1

This is happening because for when $sku is 1 and you save the product at the end of the loop, Magento assigns a product id to the product. All subsequent changes will me made the the first product that was created since $product refers to that product object only.

So this will create 1 product and it's sku will be set to 10. Magento identifies if it is an existing object or a new one by determining if $product->getId() has an id in it or if it is set to null. If it is already set then it considers it as an Update operation rather than an insert to create a new one.

To fix this add $product->setData(null); right after the do loop starts:

do {


    $product->setData(null);

.. So on...

}

Answer 2

PeaceLoveCoding,as you doing auto increment value to product,then you need to get last product sku.

Then you need start auto increment value from

$LastProduct=Mage::getResourceModel('catalog/product_collection')->getLastItem();

$LastProduct->getSku();
$sku = 1 +(int)$LastProduct->getSku();