Sign in Subscribe

Insights

Sharing our knowledge, experience and insights

Search the blog

More articles

Ucommerce not always updating Parent SKUs on variants

The team have just been caught out with this sneaky bug in the new Ucommerce Product GUI in version 9.4.2.21145 that we first spotted in 2021. When editing a SKU on a parent product in the new GUI, it doesn’t update on the product's

An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.

Today, we encountered a new issue that we had not seen before. When trying to update a database's logins after restoring it from prod, the usual stored procedure we run (sys.sp_change_users_login) didn't seem to function as we would expect. EXEC sp_change_

The Ultimate AI-Powered Video Generation Guide: From Text to Talking Avatars in Minutes

Embarking on the journey of AI-driven video generation can feel like stepping into a sci-fi novel. But with the right tools and a sprinkle of guidance, you’ll be crafting compelling content faster than you can say “artificial intelligence.” Let’s face it—creating high-quality video content is a headache.

The Real Cost of Building and Running an Efficient Engineering Team

When businesses consider internalising their development efforts—whether through a self-managed offshore partner or by creating a dedicated internal team to replace an external software partner—it’s tempting to focus on the apparent cost savings of hiring a few skilled engineers. After all, the promise of reduced expenses and

MailChimp.Net.Core.MailChimpException: akamai_503

We hit an interesting error the other day that doesn't appear to be covered much on Google, so hopefully, this helps someone else. After sustained attacks on one of our busier sites, we started getting our direct MailChimp API requests rejected with a generic error: MailChimp.Net.Core.

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

How to store a basket against a user in Ucommerce efficiently

TLDR; If you want to tie a basket to the logged in user, don't follow the Ucommerce documentation if you're using a platform with a Guid as the member ID as it's a performance nightmare, instead use our alternative approach. The Issue We recently

High database CPU usage while checking out on Ucommerce

We noticed the other day that a client's site was running really slowly and when calling `ExecuteBasketPipeline` or checking out was returning a mismatch in the number of affected rows. We initially thought the issue was caused by the basket being updated twice but actually it was caused

UCommerce Vague scratch indexer errors, not quite what it seems

I hit a problem recently where I was working with Ucommerce and linking it up to Sitefinity as the e-commerce solution. As part of this task due to the customer's requirements, we decided to manually set up Ucommerce and then export the Ucommerce_X SQL tables in the

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