Magento order status does not show

If you don't find the order status inside Admin >> Sales >> Orders than simple open you phpmyadmin and paste below script on sql user interface.


Step1:- First check if  "sales_order_status" table is empty than paste the below script ....

 INSERT INTO `sales_order_status` (`status`, `label`) VALUES ('canceled', 'Canceled'),
('closed', 'Closed'),
('complete', 'Complete'),
('fraud', 'Suspected Fraud'),
('holded', 'On Hold'),
('payment_review', 'Payment Review'),
('pending', 'Pending'),
('pending_payment', 'Pending Payment'),
('pending_paypal', 'Pending PayPal'),
('processing', 'Processing');

Step2:- It's not necessary but  if  "sales_order_status_state" table is empty than paste the below script ....

INSERT INTO `sales_order_status_state` (`status`, `state`, `is_default`) VALUES
('canceled', 'canceled', 1),
('closed', 'closed', 1),
('complete', 'complete', 1),
('fraud', 'payment_review', 0),
('holded', 'holded', 1),
('payment_review', 'payment_review', 1),
('pending', 'new', 1),
('pending_payment', 'pending_payment', 1),
('processing', 'processing', 1);

No comments:

Post a Comment