Hi,
Coupon type "Once for new user for first order" never work if due to some reason admin cancelled that first order.
Logically If a new customer's first order is canceled, it should applicable to the very next order but it is not working like this.
Solution:
You need to apply the above code to fix this issue, please let me know if you have any better ideas or you feel anything wrong in my above suggested code.
$userOrderCount = Order::where('user_id', $user->id)->where('orderstatus_id', '!=' , 6)->count();
Thanks.