Overview
WebSell Integrated customers should be using the System Five version 7.0.0.x or greater. Use these steps to update Websell.
- Connect to the Server computer
- Look for Websell Database service
- Stop the service
- Download the latest version(Use version (v7) compatible for all setups)
- Open the zip file
- Copy all the files except the settings folder
- Replace the existing files. The folder is usually in c:\Windward\Websell
- After the files are replaced, you can start the service again.
Upgrade the Staging Tables
You will also need to run the following SQL on customer Live and Training Zen databases.
If this step is skipped, it could result in corruption of the database and Websell will stop working.
ALTER TABLE "nscStagedOrderLine" DROP CONSTRAINT "FK_NSC_StagedOrderLine_NSC_StagedOrder_OrderId" # ALTER TABLE "nscStagedOrderCustomer" DROP CONSTRAINT "FK_NSC_StagedOrderCustomer_NSC_StagedOrder_OrderId" # ALTER TABLE "nscStagedOrderPayment" DROP CONSTRAINT "FK_NSC_StagedOrderPayment_NSC_StagedOrder_OrderId"
Additional information in this WebSell technical article