Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Product doesn’t show up after Import, which Data is missing? 
 
crude
Jr. Member
 
Total Posts:  4
Joined:  2009-04-06
 

Hi there, I already posted this in the German forum, but maybe I’m luckier here…

I searched for the solution of this quite a while, but I couldn’t get rid of it. Via API I import downloadable content into magento. In admin everything looks fine, but I can’t see, despite search, the articles in the shop. If I edit the article in admin (even without changing anything) and save it, they appear as I want them to.

Looks like something is beeing added, when I save it manually. What is that? I already tried to compare the db state before and after saving, to find out what to add, but there are several data changes, there has to be a way without sql queries…

So can you tell me, what is missing?
I’d really appreciate any help.

Thx so far, I will add my relevant code:

$newProductData = array(
      
'stock'             => 0,
      
'name'              => trim($prod->langtitel),
      
'autor'             => trim($prod->autor),
      
'websites'          => array(0), // array(1,2,3,...)
      
'price'             => trim($prod->vk),  
      
'tax_class_id'      => $tax,
      
'category_ids'      => array("2"),
      
'status'    => 1
    
);
    if (
$this->debugprint_r($newProductData);
    try 
{
      $this
->proxy->call($this->sessionId'product.create', array($type$set['set_id']$sku$newProductData));
      
//beim suchen bin ich darauf gestoßen, dass die folgende zeile notwendig sei. leider aktiviert sie auch die lagerverwaltung
      //was fuer downloadables recht unsinnig scheint
      
$this->proxy->call($this->sessionId'product_stock.update', array($sku, array('qty'=>100000'is_in_stock'=>1)));
    
catch (SoapFault $e{
      var_dump
($e->getMessage());
      
//print_r($e);
      
echo "ERROR, skipping\n";
    
}

Regards, Thomas

 
Magento Community Magento Community
Magento Community
Magento Community
 
crude
Jr. Member
 
Total Posts:  4
Joined:  2009-04-06
 

I got the solution from the German Forum.
Original Post: http://www.magentocommerce.com/boards/viewthread/46187/

translated from robin2160

This are the fields, which have to exist when creating or importing a product.

Name - name
SKU - sku
Weight - weight
Status - status
Tax Class - tax_class_id
Price - price
Description - description
Short Description - short_description
Website - websites
Visibilty - visibility

URL Key - url_key
pass it or it will be created from the title as you save the product the first time.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top