Posted on 16/09/2019 16:34:21
Excellent, thanks. There's one potential breaking change though. It seems that after the upgrade all payments are activated by default, but all the shippings are deactivated. I tracked it down to this SQL statement in the ecom xml updates file:
ALTER TABLE [EcomShippings] ADD [ShippingActive] BIT NOT NULL DEFAULT 1
When this runs, it adds the new column and sets its value to true by default. However, EcomShippings *already had that column* (and it allows nulls) so the above is never executed. I found a database on DW 9.3 that already had it, and it may go back to even before that version.
This means that if you upgrade now, all your shippings are deactivated initially. It would be good to have another update statement in the ecom xml updates file like this:
UPDATE EcomShippings SET ShippingActive = 1 WHERE ShippingActive IS NULL
to ensure all the existing ones are activated.
Thanks!
