So, after some days I got back to it, and managed to solve it.
The problem was that the contract I had deployed did not have any data in it.
So, the storeproducts had a length of zero (nothing on it), so I belive that is the reason why it did not work
Second thing that might have done is I got a newer version of Nextjs and Web3
Also recreated the whole ...
Since these are public endpoints, they are probably monitoring your usage by your IP address. So you can only do 10K requests/5min from your IP. It doesn't matter if you have more applications or accounts (since you don't need an account to use these endpoints anyway)
If you're looking for a higher rate limit BSC node, you should check out my company moralis....