title: What is the difference between 'state' and 'status' column in table sales_flat_order in Magento
body: <p>What is the difference, is it 'state' means initial  and status means 'final' ?</p>
  
  <p>If that's the case 'status' supposed to update automatically after the payment. </p>
  
  <p>Then what is the difference between  'status' closed and complete ?</p>
  
  <p>what would be the 'status' for recurring profiles, pending ?</p>
  
  <p>Hopefully, I have confused you enough that what I'm trying to say here, any help ?</p>