Import each multiple sheets and use the ID to next sheet as foreign key

[chammeow]

I have this project where user need to import data to insert to different database table.

In my excel file I have 2 sheets named below:
merchant_branch
merchant_items

First I need to insert data from merchant_branch and use the ID to merchant_items foreign key.

Here's my code:
class MerchantImport implements WithMultipleSheets
{
public function __construct(Merchant $merchant)
{
$this->merchant = $merchant;
}

public function sheets(): array
{
    return [
        'merchant_branch' => new MerchantBranchImport($this->merchant),
        'merchant_items' => new MerchantItemsImport(),
    ];
}

}

=============

class MerchantBranchImport implements ToCollection, WithHeadingRow, HasReferencesToOtherSheets
{
public function __construct(Merchant $merchant)
{
$this->merchant = $merchant;
}

public function collection(Collection $rows)
{
    foreach ($rows as $row) 
    {
        $latest = Merchant_branch::orderBy('id', 'DESC')->first();
        $accountNumber = 'MB' . str_pad(($latest ? $latest->id : 0) + 1, 8, "0", STR_PAD_LEFT);

        $merchantBranchInsert = Merchant_branch::create([
            'merchant_id' => $this->merchant['id'],
            'account_number' => $accountNumber,
            'name' => $row['branch_name'],
            'contact_number' => $row['contact_number'],
            'email' => $row['email'],
            'password' => bcrypt($row['password']),
            'picture' => $row['picture'],
            'longitude' => $row['longitude'],
            'latitude' => $row['latitude'],
            'address_line' => $row['address_line'],
            'preferred_merchant' => $row['preferred_merchant'],
            'mdr' => $row['mdr'],
            'mdr_type' => $row['mdr_type'],
            'tags' => $row['tags'],
            'is_active' => $row['is_active']
        ]);

        $branchHours = [];
        for ($i = 1; $i <= 7; $i++) {
            $branchHours = [
                'merchant_branch_id'=>$merchantBranchInsert->id,
                'day'=>$i,
                'open'=>'10:00:00',
                'close'=>'19:00:00'
            ];
            Merchant_branch_hours::create($branchHours);
        }
    }

    return $merchantBranchInsert;
}

how can I pass the ID of the merchant branch from sheet 1 to sheet 2.
Please help.

[patrickbrouwers]

You would have to store it somewhere in a cache, to be able to fetch it in the other sheet.

Alternative is two implement it as two different imports and give the merchant id to the 2nd import.

[chammeow]

So I need to create different import class per sheet? I will try this one. Thank you in advance.

[chammeow]

@patrickbrouwers this is resolved. I used the "store it somewhere in a cache" approach. Thank you very much!