93 Oldsmobile Cutlass Ciera S - fuel pump?

I have a 93 Oldsmobile Cutlass Ciera S, 139k miles, Automatic. Up until this point it had been running fine. I was driving and it was doing great, then I slowed to a stop and it stalled. I tried to start it again, and it wouldn't start up. My boyfriend(a boat mechanic) checked my fuel line and found that my fuel pump had died. So, he replaced it with a part from Advanced Auto Parts. He also replaced the filter.
We then tried to start the car and it stalled. So we tried it a few more times, thinking the fuel pump just hadden't gotten the fuel all the way up, and it idled fine. As soon as you put it into gear and press the gas, it stalls out. So, he checked the gas return line while it was idling and it had not one drop coming through it.
We think it may be that the fuel pump they sold us may be the wrong one. A neighbor told me that they make two fuel pumps, one sends out a higher volume of gas than the other, I think he said that one is formultiport injection, and the other is throttle body. My car has multiport injection. The neighbor said we probably got the one with the lower amount, which would make sense why its "starving" for gas and stalling out when we press the gas pedal.
We asked Advance auto and they only sell that one kind.
I was wondering if my neighbor is right, and if they do have different kinds of fuel pumps for my car.
Any other suggestions of what may be wrong are greatly appreciated.

Thank you,
Carly