I am looking for the simplest way to add a simple Boolean value to an order to indicate if the order was broken within the shipping process. We mail a physical product out that sometimes get's damaged and need a simple way to mark an order as damaged or not.

I then have a separate system outside of Magento where I pull and build reports, so really I just need a way inside of Magento to add this value and ensure it is saved to the database for each order.

Could a Magento expert point me in the right direction, I am very new to Magento and it's a bit of a nightmare sometimes.

Actually after a though, I think it will need to be on each order item and not just the order, as some orders might have items that are not broke but other items that do break

  • Did you ever figure this out? I'm also after a simple boolean flag that can be easily added to orders and read / filtered from the sales/order grid and order info pages.
    – James
    Commented Jul 17, 2014 at 0:44

1 Answer 1


Could you not use the Magento process of adding creating a credit memo for items that have been returned? Then you could simply look for orders that have a credit memo attached to them.

These items will be stored in the table sales_flat_creditmemo

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.