dm18k Posted September 7, 2005 Posted September 7, 2005 I am not sure if this was posted before or not. I set up OSC not knowing a single thing about it. Now I know enough to keep everything in order. Since the first day I opened my shop I really never spent to much time changing my order status. Times have changed so I added a few new things to my order status. Pending: Processing: Payment Pending: Shipped: Back Order: Order Cancelled: I like to make everything as clean & easy as possible and in order. I have over 3000 Pending Orders... These are old orders, from when I didn't know much about order status. My Question is... How can I change these old order status: Shipped with out Notify Customer I would hate to flood people with emails saying your order status has changed to: Shipped when nothing will be shipped. Reason I want to do this is because I like to just come to my admin main page and click on Pending and view all my orders ready to be processed. Thank you for taken your time to view this post,
♥Monika in Germany Posted September 7, 2005 Posted September 7, 2005 I am not sure if this was posted before or not. I set up OSC not knowing a single thing about it. Now I know enough to keep everything in order. Since the first day I opened my shop I really never spent to much time changing my order status. Times have changed so I added a few new things to my order status. Pending: Processing: Payment Pending: Shipped: Back Order: Order Cancelled: I like to make everything as clean & easy as possible and in order. I have over 3000 Pending Orders... These are old orders, from when I didn't know much about order status. My Question is... How can I change these old order status: Shipped with out Notify Customer I would hate to flood people with emails saying your order status has changed to: Shipped when nothing will be shipped. Reason I want to do this is because I like to just come to my admin main page and click on Pending and view all my orders ready to be processed. Thank you for taken your time to view this post, <{POST_SNAPBACK}> hi, you could write a php page to get recordsets from back then (by date), and add a new line to the table order_status_history with the help of the script, line by line. Another option would be a nested sql query used in the insert statement in phpmyadmin to the same table. You'd need a current mysql database that can use subselects (I just had a client NOT have this feature - antique database version, and had to use the php page method). :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
dm18k Posted September 7, 2005 Author Posted September 7, 2005 hi, you could write a php page to get recordsets from back then (by date), and add a new line to the table order_status_history with the help of the script, line by line. Another option would be a nested sql query used in the insert statement in phpmyadmin to the same table. You'd need a current mysql database that can use subselects (I just had a client NOT have this feature - antique database version, and had to use the php page method). <{POST_SNAPBACK}> haha :thumbsup: ummm I know a little of what you said.. but i got lost after you said Hi, :-" There is no contributions? or something along them lines? Thanks
♥Monika in Germany Posted September 8, 2005 Posted September 8, 2005 haha :thumbsup: ummm I know a little of what you said.. but i got lost after you said Hi, :-" There is no contributions? or something along them lines? Thanks <{POST_SNAPBACK}> not that I know ... :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.