Thread: How to cancel an order via WSI?

Hey guys, I've tried searching a little bit and haven't found anything, perhaps I'm searching for the wrong keywords.

I am attempting to cancel an order via the WSI. We cancel orders in our fulfillment system, but the order remains "Authorized" on the customer's order history.

I'd like cancelled orders to not appear "Authorized" and to show visibility that they've been cancelled.

I assume manually clicking on "Void" in the admin for the order will cancel it, but I was hoping there was some XML I could send through the WSI to do this.

I already have a connector sending data through the WSI, I just need to know the XML format for the cancellation of an order.

Again if this information is already out there and I was simply unable to find it, I apologize and simply providing me with a link to the info would be greatly appreciated.

Originally Posted by sshapiro

Hey guys, I've tried searching a little bit and haven't found anything, perhaps I'm searching for the wrong keywords.

I am attempting to cancel an order via the WSI. We cancel orders in our fulfillment system, but the order remains "Authorized" on the customer's order history.

I'd like cancelled orders to not appear "Authorized" and to show visibility that they've been cancelled.

I assume manually clicking on "Void" in the admin for the order will cancel it, but I was hoping there was some XML I could send through the WSI to do this.

I already have a connector sending data through the WSI, I just need to know the XML format for the cancellation of an order.

Again if this information is already out there and I was simply unable to find it, I apologize and simply providing me with a link to the info would be greatly appreciated.

You could just send a transaction back. From the docs:

HTML Code:

<AspDotNetStorefrontImport Verbose="false">

<Transaction>

            <Set Table="Orders" ID="100002">

                        <Deleted>1</Deleted>

                        <VoidedOn>Some Date</VoidedOn>

                        ....
            </Set>

</Transaction>

</AspDotNetStorefrontImport>

Or you can send direct SQL via ExecuteSQL. All the WSI does is execute arbitrary, inline SQL based on the parameters you send in. You can send in entity XML for it to parse or just straight SQL. We send in stored procedure calls for our more complex business rules.

Originally Posted by tpmorgsls

You could just send a transaction back. From the docs:

HTML Code:

<AspDotNetStorefrontImport Verbose="false">

<Transaction>

            <Set Table="Orders" ID="100002">

                        <Deleted>1</Deleted>

                        <VoidedOn>Some Date</VoidedOn>

                        ....
            </Set>

</Transaction>

</AspDotNetStorefrontImport>

Or you can send direct SQL via ExecuteSQL. All the WSI does is execute arbitrary, inline SQL based on the parameters you send in. You can send in entity XML for it to parse or just straight SQL. We send in stored procedure calls for our more complex business rules.

Thanks for the info! I had considered ExecuteSQL however I was unclear what designated a cancelled order. From your info it appears I just need to set the order to deleted=1 and give it a voidedon date.

Thanks again!