Hi folks,
One of my clients has a store that's hooked up to a back-end system which includes a "Partially Cancelled" status for orders. They use this in situations such as a customer cancelling an order for a back-ordered product. MM doesn't explicitly support this status; but after looking at the DB manual, I think there may be something equivalent.
I see that there's a "status" field in the OrderItems table, but the manual doesn't tell what values are defined. Are they the same as for the Orders table? If we can set a "Cancelled" status for individual OrderItems, that might be sufficient for the client's purposes.
Are we allowed to create our own status values and store them in any of these tables (Orders, OrderItems, and/or OrderShipments)?
Any other ideas, such as doing something creative with OrderShipments, OrderReturns, etc.?
Thanks --
One of my clients has a store that's hooked up to a back-end system which includes a "Partially Cancelled" status for orders. They use this in situations such as a customer cancelling an order for a back-ordered product. MM doesn't explicitly support this status; but after looking at the DB manual, I think there may be something equivalent.
I see that there's a "status" field in the OrderItems table, but the manual doesn't tell what values are defined. Are they the same as for the Orders table? If we can set a "Cancelled" status for individual OrderItems, that might be sufficient for the client's purposes.
Are we allowed to create our own status values and store them in any of these tables (Orders, OrderItems, and/or OrderShipments)?
Any other ideas, such as doing something creative with OrderShipments, OrderReturns, etc.?
Thanks --
Comment