Sign in Subscribe

Tim Gaunt

Delete all products and orders from Ucommerce

Here's an updated script to delete all the products, orders and any other testy type data from Ucommerce. This is an updated version of my previous script to delete all product and order data from Ucommerce and accommodates Ucommerce's new database schema for prices. BEGIN TRAN

Drop/Kill all connections to a SQL Database

Every now and again you need to get exclusivity to a database e.g. to do a database restore but someone is connected. You can manually find who it is using EXEC sp_who but that can result in having to manually kill the various connections. This is a little

Error editing Ucommerce marketing campaign

We came across an odd error recently which was thrown when editing a marketing campaign in Ucommerce. It was a fresh install (albeit via nuget) and was along the lines of: UCommerce.EntitiesV2.DynamicOrderPropertyTarget needs to implement any of the following interfaces: UCommerce.Marketing.Targets.IDisplayTarget, UCommerce.Marketing.Targets.IPurchaseOrderTarget,

How To: Automatically set Umbraco folder permissions after AppVeyor deploy

We've been playing more with AppVeyor over the past few weeks to automate the deployment of our sites and one of the things we got caught out with was the Umbraco folder permissions which we do with PowerShell on the server. It turns out it's really

How To: Quickly Set Umbraco File and Folder Permissions with PowerShell

In 2010 I blogged about how to set Umbraco folder permissions using PowerShell. This has been a really handy snippet -but it's always been a bit of a pain when dealing with new servers, remembering where SetFolderPermission.ps1 is, creating missing (old) folders and not setting the permissions

How To: Return the customer to your site after paying with WorldPay

Stripe is generally our go-to PCI compliant payment gateway but from time to time we're asked to use alternatives such as WorldPay. For the most this is fine but redirecting the shopping from WorldPay on a successful transaction is a bit of a pain and there are a

View the property values in SQL for latest version of a page in Umbraco

I've previously blogged about how to download any Umbraco document as a CSV from SQL but we hit a slightly different issue today and needed to view the values for a property in SQL. By default Umbraco stores each property as it's own row in the