You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi guys,
I have a problem with customers somehow managing to pay an out of date price for goods. The only way I can think this may be happening is if they put an item in their shopping cart but do not purchase, placing the order at a later date when the item price has changed.
I should point out that I use my own database of products and a remote add to put items into the cart, not sure if that makes a difference.
Assuming my guess is correct, is there some way that I can 'clean out' all customer shopping carts (cron?) to ensure that they are paying the correct price for goods after a major price restructure?
Thanks in advance for any help.
RobH
Offline
Remote add to cart products are placed into the shopping carts with a prefix of "REMOTE-" which means that the checkout script will not try to recheck the prices for those items when orders are completed, since they are not generally in ccp's database where they can be updated. If you don't know which carts have remote product or if all of them do then the quickest way to remove them is to run a raw sql statement in "Raw Database Admin" of
DELETE FROM ccp0_cart
which will remove all cart information (gbu0_cart for UK).
John
Offline
Hi John, thanks for the reply. Will this statement remove just the cart contents or will it delete customer accounts etc as well?
Cheers
H
Offline
Just the carts.
Offline