- Posts: 2
- Thank you received: 0
Order Bug?
1 week 3 days ago #5
by Gunnar
Order Bug? was created by Gunnar
Hi support,
I cannot delete an order. I set the order to canceled, but still I get the info, that it should be canceled first.
I cannot delete an order. I set the order to canceled, but still I get the info, that it should be canceled first.
Please Log in or Create an account to join the conversation.
1 week 3 days ago #6
by Viet Vu
Replied by Viet Vu on topic Order Bug?
Hi,
You should set the order status as "Cancelled" and the payment status as "Pending" before deleting an order.
You should set the order status as "Cancelled" and the payment status as "Pending" before deleting an order.
Please Log in or Create an account to join the conversation.
1 week 2 days ago #7
by Gunnar
Replied by Gunnar on topic Order Bug?
I set it to cancelled and pending but still I cannot delete.
Please Log in or Create an account to join the conversation.
1 week 2 days ago #8
by Viet Vu
Replied by Viet Vu on topic Order Bug?
Hi,
Email us your website info, we will have a look at it because we could not replicate this issue from our end.
You can find the email in the website footer.
Email us your website info, we will have a look at it because we could not replicate this issue from our end.
You can find the email in the website footer.
Please Log in or Create an account to join the conversation.
1 week 1 day ago - 1 week 1 day ago #10
by Viet Vu
Replied by Viet Vu on topic Order Bug?
Hi,
Thanks for the report — you've found a genuine bug, and I can explain exactly what's happening.
When an order is cancelled, Solidshop is supposed to restore the reserved stock and mark the order as safe to delete. Due to a packaging mistake on our side, the database flag that tells the "Canceled" status to do this was missing from the public releases, including your 1.2.0. So cancelled orders never get marked as restocked, and the delete check keeps refusing them — even though the status is correctly "Canceled". The error message is misleading; your order data is fine.
Two steps will sort out your site:
1. Delete the existing order #fb67ea08
Open the order in the administrator, click the payment status badge and change it to Refunded. This runs the stock-restore routine that the cancellation should have run (no email is sent to the customer, and since nothing was actually paid, no money movement is involved — it only updates the label and restores stock). After that, deleting the order will work normally.
2. Fix future cancellations
Run this one-line query against your site's database (phpMyAdmin → SQL tab). Replace the #__ prefix with your site's table prefix — you can see it in Global Configuration → Server → Database Tables Prefix:
UPDATE `#__sshop_statuses` SET `triggers_restock` = 1 WHERE `code` = 4 AND `type` = 0;
From then on, cancelling an order restores its stock immediately and the order can be deleted right away — no payment status change needed.
This is permanently fixed in the next Solidshop release, which will apply the same correction automatically during update — so the manual query is safe to run now and won't conflict with the update later.
Sorry for the confusion the error message caused, and thanks again for the clear report — it helped us pin this down quickly.
Thanks for the report — you've found a genuine bug, and I can explain exactly what's happening.
When an order is cancelled, Solidshop is supposed to restore the reserved stock and mark the order as safe to delete. Due to a packaging mistake on our side, the database flag that tells the "Canceled" status to do this was missing from the public releases, including your 1.2.0. So cancelled orders never get marked as restocked, and the delete check keeps refusing them — even though the status is correctly "Canceled". The error message is misleading; your order data is fine.
Two steps will sort out your site:
1. Delete the existing order #fb67ea08
Open the order in the administrator, click the payment status badge and change it to Refunded. This runs the stock-restore routine that the cancellation should have run (no email is sent to the customer, and since nothing was actually paid, no money movement is involved — it only updates the label and restores stock). After that, deleting the order will work normally.
2. Fix future cancellations
Run this one-line query against your site's database (phpMyAdmin → SQL tab). Replace the #__ prefix with your site's table prefix — you can see it in Global Configuration → Server → Database Tables Prefix:
UPDATE `#__sshop_statuses` SET `triggers_restock` = 1 WHERE `code` = 4 AND `type` = 0;
From then on, cancelling an order restores its stock immediately and the order can be deleted right away — no payment status change needed.
This is permanently fixed in the next Solidshop release, which will apply the same correction automatically during update — so the manual query is safe to run now and won't conflict with the update later.
Sorry for the confusion the error message caused, and thanks again for the clear report — it helped us pin this down quickly.
Last edit: 1 week 1 day ago by Viet Vu.
Please Log in or Create an account to join the conversation.