Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Archive shipped orders?


Guest

Recommended Posts

s where o.orders_status != 4 and o.orders_status = s.orders_status_id

 

!= 4 is the code in orders.php, 4= the orders_status_id for shipped

 

Is it possible to have 2 codes archived?

Link to comment
Share on other sites

s where o.orders_status != 4 and o.orders_status = s.orders_status_id

 

!= 4 is the code in orders.php, 4= the orders_status_id for shipped

 

Is it possible to have 2 codes archived?

 

Figured it

 

add

and o.orders_status != 101 

 

101 = 2nd code archived, in this case refunded

 

so it looks like

 

where o.orders_status != 4 and o.orders_status != 101 and o.orders_status = s.orders_status_id

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...