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

High database CPU usage while checking out on Ucommerce

Performance issues with Ucommerce checking out? It's worth checking the indexes on the queries that are being run. Here are some helpful pointers.…

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

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

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

Bulk delete products by SKU in uCommerce

You may already have come across my script to Quickly delete all products and orders from uCommerce but sometimes you need to delete just a set of products by SKU so here's a new one for you BEGIN…

Read this article