Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Orders


dm18k

Recommended Posts

Posted

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,

Posted
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,

 

 

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 ...

Posted
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).

 

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

Posted
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

 

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 ...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...