I've switched over to ShipRush and my "Pending Shipping Records" (Control/Shift/F8) has 10 years of orders in it. I know the SQL table is dbo.Shipping and I think the sql column that controls this is "DateProcessed" with the Default setting being "NULL" If I want to clear out the DateProcessed "Pending Shipping Records" in RMS what Value do I need to have in the "DateProcessed" column? If you have the sql query handy you might save me screwing things up. :-)
*This post is locked for comments
I tried that and it worked like a champ. It cleaned up a whole lot of records for me. Thanks
If you want the orders to show as shipped and not appear as pending without deleting any records, the Shipping.Status column needs to be '1'. You can use any date you like as the DateProcessed. I would set the DateProcessed to the same value as DateCreated. Try something like this: (backup the database first in case this produces the wrong results).
UPDATE Shipping
Set Status = '1', DateProcessed = DateCreated
Where Status = '0'
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (