The first row is skipped when loading product by SKU

Question

This looks very simple but I have been pulling my hair on this for the last hour. I just want to load products data from a PHP array that looks like this:

array
  0 => 
    array
      'sku' => string '1HC220'
      'qty' => string '2'
  2 => 
    array
      'sku' => string '4LANT'
      'qty' => string '2'

The piece of code:

foreach ($products_arr as $row) :
    $sku        = trim($row['sku']);

    $product    = Mage::getModel('catalog/product')->setStore($store_id)
        ->getCollection()
        ->joinField('qty',
            'cataloginventory/stock_item',
            'qty',
            'product_id = entity_id',
            '{{table}}.stock_id = 1',
            'left'
        )
        ->addFieldToFilter('sku', array('eq' => $sku))
        ->getFirstItem()
        ;
        (...)
endforeach;

But the first product in the array always returns NULL. If I var_dump $products_arr I have X products, but in the loop the first is never returned.

If I load the product individually, it is loading, but not as a first row of the array.

I know I am missing something, but can't figure out what.

Answer 1

Add per your code if I have this data it works fine for me

    $products_arr = [0 => ['sku' => 'Test40', 'qty' => 1], 1 => ['sku' => 'Test39', 'qty' => 1]];
    foreach ($products_arr as $data){
        $product = Mage::getModel('catalog/product')->setStore(1)
            ->getCollection()
            ->joinField('qty',
                'cataloginventory/stock_item',
                'qty',
                'product_id = entity_id',
                '{{table}}.stock_id = 1',
                'left'
            )
            ->addFieldToFilter('sku', array('eq' => $data['sku']))
            ->getFirstItem();
        echo "<pre>";print_r($product->getData());die;
    }

Make sure the store ID you are assigning has the following product.

Answer 2

It was not Magento related at all.

When building the array from the CSV file, there was some hidden characters in the SKU that I escaped using $field = preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $row['sku']); I still don't get why those characters were added only in the first element of the array though.

Working now. Thank you guys