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

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

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…

Read this article

How to: Restore nodes from a SQL backup

We had an odd issue the other day where a bunch of nodes disappeared from one of our Umbraco installs. There didn't appear to be any reason behind why they were gone and the customer assured me that…

Read this article

Periodically hit a url with Windows Scheduler

Sometimes you have a task that you want to run every x minutes i.e. updating order statuses or sending abandoned cart emails. There are a few ways you can do this but our preferred method at The Site…

Read this article

Export/get all customer email addresses from uCommerce

If you running an online web-shop, you'll undoubtably be marketing to your customers so here’s  a simple script for you to generate a list of customers and their emails to import (excluding some of…

Read this article

Export all products and properties from uCommerce

One of the most time consuming parts of building an e-commerce site is getting the data right and often it requires numerous exports. Although uCommerce is generally awesome, mass updating product…

Read this article

IIS Url Rewrite appends trailing slash after page extension

I’m a big fan of IIS’s built in Url rewriting module, if you’re not using it, you should be to lowercase urls, set canonical urls and all sorts it’s great. One thing that caught me out when we started…

Read this article

List all products from child categories on uCommerce

One question I’ve seen batted around a lot is how to list all products from the child categories when viewing a parent category. On the uCommerce demo store Avenue Clothing we simply loop through the…

Read this article