How to update model by import?

[alejandromora99]

I am trying to update my products model by importing from laravel-excel, here the class:

class UpdateProductImport implements ToModel,WithUpserts,WithUpsertColumns, WithHeadingRow
{

    public function uniqueBy()
    {
        return ['name'];
    }

    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        $product = new Product([
            'name' => $row['nombre'],
            'stock' => $row['stock'],
            'price' => $row['precio'],
            'cost' => $row['costo'],
            
        ]);
        return $product;
    }

    

    public function upsertColumns()
    {
        return ['stock','price','cost'];
    }
}

When trying this I get the error:

SQLSTATE[HY000]: General error: 1364 Field 'trademark' doesn't have a default value (SQL: insert into products (cost, created_at, name, price, stock, updated_at) values (500, 2022-03-23 19:47:43, Assumenda qui rerum., 9990, 4, 2022-03-23 19:47:43) on duplicate key update stock = values(stock), price = values(price), cost = values(cost), updated_at = values(updated_at))

I don't understand why it keeps trying to insert new data if I'm using "WithUpserts", what am I doing wrong?

[patrickbrouwers]

It Laravel tries an insert, it most likely means there's no product with that name yet.