Magento

What I need most is some sort of API provided by Magento to update data externally.My products’ manufacturer/drop shipper provides me with the ability to retrieve price and inventory levels from a SOAP web service. I’d build a simple cron script to retrieve a updated info from the manufacturer, and then update the info in Magento via the API. I realize that I can get around this by updating the database directly, but that may not work right with the caching, multiple stores and other things built into Magento, especially as it evolves in the future. An API would be built onto Magento’s core functionality, and would naturally evolve as Magento does.

I would like to minimally be able to have the following functionality from a Magento provided API:

* Update Product Pricing (cost, retail & our price)
* Update Inventory (stock level & status)

Additionally It would be awesome to be able to have the following API Features as well

* Manage Products (Add/Edit/Delete/Disable)
* Manage Categories (Add/Edit/Delete/Disable)
* Manage Attributes & Attribute Groups (Add/Edit/Delete/Disable)
* Manage Tags (Add/Edit/Delete/Disable)

I’d be able to do so much if I could automate these things instead of having to do them by hand in the Magento interface.

Rich

Hi, regarding the 2 first questions:

* Update Product Pricing (cost, retail & our price)

* Update Inventory (stock level & status)

For other queries we will have to wait for API documentation

Awesome, that is exactly what I need right now. I will look forward to the API maturing. Thank you Moshe.

Could one create a new instance of catalog/product, set the attributes/categories/store_id and save it in order to add new product to a shop?

Something like following:

Thanks!

Bojan Hrnkas

I tried the code I wrote above, and I managed to add a new product that way.

Answer was: “OK Product ID: 135”

It would be nice if a expirienced Magento developer or a team member could comment on this, so I can put it in Wiki if it is correct as is.

Further, it would be nice to have a snippet how to get AttributeSetId from name and maybe the same for Categories.

Thanks!

Bojan Hrnkas

Any idea when we will have some basic API documentation to build on?

Can someone help me as to where I use this code, I need to get the updating inventory use in our shop asap!

Hi,
we have to create bulk coupons. Is the API somehow able to do this? (And is magento able to handle hundreds or thousands of coupons?)

thanks
orbi

Here is the code to get an attribute set’s ID by name:

Moshe - 04 January 2008 07:00 AM

Hi, regarding the 2 first questions:

* Update Product Pricing (cost, retail & our price)

// initialize magento environment for 'base' store
require_once MAGE_BASE_DIR.'/app/Mage.php';
Mage::app('base');

// load product data
$product = Mage::getModel('catalog/product')->load($productId);

// update attributes with new values. 'attribute_name' -> $product->setAttributeName($value)
$product->setPrice($price)
  ->setCost($cost)
  ->setMsrp($msrp);

// save the product
$product->save();

* Update Inventory (stock level & status)

// load stock item for specific product
$stock = Mage::getModel('cataloginventory/stock_item')->loadByProduct($productId);

// update stock values
$stock->setQty($newQty)
  ->setIsInStock((bool)$status);

// save stock record
$stock->save();

For other queries we will have to wait for API documentation

Shalom Moshe.....I tried updating the inventory level, but I get this error:

What do you think the problem is?

make sure the db tables are InnoDB…

How do I do that?

Thank you very much for your assistance...it’s very much appreciated.

To check for the format of your tables, you just need to open PHPMyAdmin (http://yourserver/phpmyadmin), go to your magento database and look at the formating.