If($Response->Meta->Size > 1000){

$size = 1000;
} else{
$size = $response->meta->size;
}

for ($i = 0; $i < $size; $i++){
intermediateProducts::query()
->insert([
'id' => $response->rows[$i]->id,
'code' => $response->rows[$i]->code,
'can_sale' => $response->rows[$i]->attributes[1]->value,
'group' => $response->rows[$i]->pathName,
'first_category' => $response->rows[$i]->attributes[2]->value,
'second_category' => $response->rows[$i]->attributes[3]->value,
'finally_category' => $response->rows[$i]->attributes[4]->value,
'finally_category_code' => $response->rows[$i]->attributes[5]->value,
'quantity' => $response->rows[$i]->quantity,
'sale_price' => $response->rows[$i]->salePrices[0]->value,
'rrc' => $response->rows[$i]->attributes[0]->value,
'purchase_price' => $response->rows[$i]->buyPrice->value,
'barcode128' => $response->rows[$i]->barcodes[0]->code128,
'vendor_code' => $response->rows[$i]->article,
'name' => $response->rows[$i]->name,
'factory_name' => $response->rows[$i]->attributes[6]->value,
'brand' => $response->rows[$i]->attributes[7]->value,
'model' => $response->rows[$i]->attributes[8]->value,
'code_model' => $response->rows[$i]->attributes[9]->value,
'description' => $response->rows[$i]->description,
'images' => $response->rows[$i]->images->meta->href,
'gender' => $response->rows[$i]->attributes[10]->value,
'size' => $response->rows[$i]->attributes[11]->value,
'second_size' => $response->rows[$i]->attributes[12]->value,
'site_size' => $response->rows[$i]->attributes[13]->value,
'color' => $response->rows[$i]->attributes[14]->value,
'factory_color' => $response->rows[$i]->attributes[15]->value,
'filter_color' => $response->rows[$i]->attributes[16]->value,
'characteristic' => $response->rows[$i]->attributes[17]->value,
'second_characteristic' => $response->rows[$i]->attributes[18]->value,
'model_vendor' => $response->rows[$i]->attributes[19]->value,
'model_gender' => $response->rows[$i]->attributes[20]->value,
'model_gender_color-taste' => $response->rows[$i]->attributes[21]->value,
'weight' => $response->rows[$i]->attributes[22]->value,
'volume' => $response->rows[$i]->attributes[23]->value,
'package_size' => $response->rows[$i]->attributes[24]->value
]);
}

будет ли краш бд?

Просто не очень приятно читать простыни кода. Ну хотя бы в monoscape форматни

заливай на govnokod.ru

Не поможет

Поэтому "хотя бы"

хз будет ли но имхо лучше разбить на чанки по 500 и в insert запихнуть масив с масивов так бд намного легче будет