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.
I'm sorry . . I'm sure I asked this before but can't find the response.
Is there any way in CCP6 to mark ALL orders as fulfilled or shipped at once?
We do all of our processing offline which, of course, leaves the online status of orders as "pending."
We'd like to be able to just go in once a week or month and change them all to completed.
How 'bout in CCP7?
thanks,
stu
Offline
Raw DB commands.
CCP6
UPDATE `ccp0_orders` SET `status` = 'C'
CCP7
UPDATE `ecom_orders` SET `status` = 'C'
You should probably update the status for the items in the order too.
CCP6
UPDATE `ccp0_orderitems` SET `shipstatus` = 'S'
CCP7
UPDATE `ecom_orderitems` SET `shipstatus` = 'S'
Offline