x-cart 4 had only a single column order status, whereas x-cart 5 has two columns : payment and shipping status, that apply to a single order
since our client had had modifications done to the list of statuses in x-cart 4, there is some confusion over which were the
original status codes and their descriptions in x-cart 4 :
what we have now is :
Code:
mysql> select status from xcart_orders group by status;
+--------+
| status |
+--------+
| B |
| C |
| D |
| F |
| H |
| I |
| P |
| Q |
| R |
+--------+
which translate to
Code:
<option value="Q">New Order</option>
<option value="H">Order on Hold</option>
<option value="I" selected="selected">Order in Picking</option>
<option value="P">Payment Accepted</option>
<option value="C">Order Has Been Shipped</option>
<option value="F">Payment Declined</option>
<option value="B">Cancelled by Customer</option>
<option value="D">Order Cancelled</option>
<option value="R">Purchase Refunded</option>
what were the original statuses and their descriptions, so I can correctly determine what was added, and what, if anything, was changed ?