Is it common for the site to immediately send the received coins to its superwallet (master node) upon X confirmations?
No. Not at all and would normally be considered very bad practice as in bitcoin you don't spend from addresses but from transactions, so "accumulating" in one address doesn't really work. Sending from that address would again have to reference all the forwarded transactions. (There are special cases like green address in its original implementation but no, that's a thing of the past.)
And how would u know when a payment is sent to one of the derived addresses?
You watch the bitcoin network? Either through proxies or with a full node. Check out the insight.bitpay.com API.
Let's assume the case with a derivation path of m/k'/0/i, where m is the master node, ever user has a k node and i is his i'th purchase transaction.
I would strongly advise to hold that logic in the server, only.
eCommerce sounds like one central server, so there is really no big need to fan out too much in the HD wallet structure. You should also look into BIP44 on transaction discovery.
Your business logic has to keep track what purpose an address has but if that website never has to send refunds, it would typically only have an extended public key. Now if it receives to
m / 44' / 0' / i' / 0 / j
any bip44 compatible wallet would find and be able to spend the funds if you provided it with at least the xpriv key for
m / 44' / 0' / i' / 0
but typically
m / 44' / 0' / i'
One minor thing you have to keep track of, is the gap between addresses that don't receive a payment. If your server observes a gap of more than 20, you would have to help your wallet to find those funds if it's strictly bip44 which would only bridge gaps up to 20. If your last transaction is to index 1220 and you don't see transactions to 1255 and 1257, you could send a satoshi to 1239 and your wallet would find the rest.