Sign in Subscribe

Topic

Useful Script

A collection of 30 posts

Search every page in Umbraco for a string

As part of a rebrand, a customer had changed their email address in Umbraco and although it was instantly reflected on the website (yay for CMSs!), they wanted us to double check that the old email address had been completely removed. Although we can't remove it from the

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 also added a second script that outputs the categories

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 is surprisingly (annoyingly) simple -you need

Delete all orders from Ucommerce

A while ago I blogged about [how to delete test orders and baskets from Ucommerce](https://thesitedoctor.co.uk/blog/deleting-test-orders-and-baskets-from-ucommerce/) and [Delete all products and orders from Ucommerce](https://thesitedoctor.co.uk/blog/delete-all-products-and-orders-from-ucommerce/) which I frequently use. As I often want to only clear out the orders as

Power Ucommerce facet display names from the CMS

ProductDefinitionFieldRepository = Ucommerce.Infrastructure.ObjectFactory.Instance.Resolve>(); private static Dictionary> AllDisplayNames; public static FieldDefinition DisplayNameFromUcommerce(this FieldDefinition self) { var displayName = GetProductDefinitionFieldDescriptions(self.Name); foreach (var description in displayName) self.DisplayNames[description.CultureCode] = description.DisplayName; return self; } private static void EnsureProductDefinitionFields() { if (AllDisplayNames != nul

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 `uCommerce_Definition` with duplicate Guids which then caused an issue. We found it

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

There's little more frustrating that finalising a store and loading in the product data only to find it doesn't look as beautiful as the design. This is usually because the designer has chosen a product title from the site which looks good in the design rather

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

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