Export all products, properties and categories from uCommerce

A while ago I posted about how to Export products from Ucommerce into a CSV type format. The database schema has changed slightly since so today I'm posting an updated version of the code for v9. I've…

Read this article

1p rounding issue on Ucommerce products/discounts

We've been hitting an issue over the past few years where the product's price is `1p` out in certain circumstances e.g. £2 off 2 £30 items -it should equal £56.00 but often results in £55.99.The fix…

Read this article

Delete all orders from Ucommerce

A while ago I blogged about how to delete test orders and baskets from Ucommerce and Delete all products and orders from Ucommerce which I frequently use.As I often want to only clear out the orders…

Read this article

Power Ucommerce facet display names from the CMS

The index changes released in v9 have been great and API is blazingly fast -however it's come with a couple of costs when it comes to configuring the Facet settings via the UI.Setting the DisplayName…

Read this article

Error running Ucommerce scratch indexer Illegal duplicate key definitions

We hit an interesting issue indexing the Ucommerce data the other day which had us going for a while.It turns out that when upgrading Ucommerce to 7.0.6, some new payment providers were added to…

Read this article

Design with data -how to get the longest/shortest product/category name from Ucommerce

Make sure your final Ucommerce e-commerce site looks as good as the designs by using real data…

Read this article

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…

Read this article

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…

Read this article

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…

Read this article

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…

Read this article