Shopping cart locking
I use a pending table to store the data in the shopping cart. Once the customer checks out to pay for the items in the WorldPay, they can in the same time open another browser and login again and add to the shopping cart. Once the payment is done in the first browser and a transaction id sent back from the WorldPAy to the site, whatever in the pending table is copied to the final transaction table. These then will store the items that has been paid for and those that has been added to the basket in the second browser. Results: the customer paid for certain items but not for others that has been added in the second browser.
I did use a locking mechanism where, i lock the shopping cart if the customer proceed to checkout. As a result the customer will only be able to pay for whatever they initially added before they checked out and they cannot add anything else until they pay or cancel the payment from the PayWorld website.
I feel this is not a good idea as it limits the customers(innocent customers) choice to change and edit the shopping cart after the check out.
Can anyone please help me with this issue?