kc web design has launched Cirrus one – A new weather app for mobile devices with a unique feature…you can design your own icon layout!
A few years ago we had an idea for a weather app. We started to create an iOS only version but soon decided the dev costs would be too high for a side project at a small web design studio so we shelved what we had and left it for a while. About 9 months ago we decided to revisit the idea of a weather app because in the past few years we still hadn’t seen anything come on the market that had that one killer feature that we’d always wanted to add. We also decided that native apps wasn’t the way to go so we designed and built a web based app that would work on all mobile devices.
This week we are launching Cirrus One slowly out into the wilderness. We’ve already had a few great reviews and the new weather app is also now in the Google Chrome Web Store. We want it to build slowly so we can keep a eye on server performance and the API’s we’ve used and make sure the experience stays consistent for everybody. With any new release it’s important to take things slowly and make sure everything is working as it should before diving in to a huge launch with thousands of users.
Over the next 6 months we have a great list of features we’re going to add including a new desktop version that will work as a chrome app, weather alerts so you know if you sunny day out fishing is going to change to a rainy day out! There will also be additions for user uploaded background images, more weather icons such as moon phases and much more.
While developing a series of websites using the great Woocommerce for WordPress the development process we’re using at kc web design kent meant we needed to make copies of existing website designs and then redevelop them into new websites. Part of the process we went through at kc web design kent was changing the design and then adding a different set of products but to do this we first have to delete the existing ones. Adding products in Woocommerce is made very easy with the CSV import suite and updating existing products using a merge CSV import but there is no easy way to delete all products, especially when there are thousands of them. A nice feature in Woocommerce would be a way to bulk delete products but until that appears in the core or until someone makes a plugin the only way to delete products on-mass is to do it directly on the database.
Working directly on the database is always a bit scary, especially if you don’t know MySQL syntax and how to write complicated queries. Because of the way Woocommerce uses posts to store product data and the fact that products can have variations and custom post types, it can make it very difficult to know where all the data is stored. Woocommerce spreads the product data across posts, terms, taxonomies, term_relationships and post meta which makes things tricky if you want to do it in a visual SQL client. The best way is to use a few SQL queries. On this recent project at kc web design kent we needed to delete a lot of products and so after a bit of searching around on Google we came up with these queries.
Before using these remember to backup your database in case anything goes wrong. You’ll also need to change the default table prefix (wp_) to whatever you have used in your database. And remember, its always good practice not to use the default wp_ prefix on any WordPress websites. The queries below also have to be run in this order.
DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
INNER JOIN wp_terms AS terms
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';
Drai Fine Art are a UK based fine art dealer selling art globally. Drai came to kc web design, Kent needing a brand, business cards and a new e-commerce website to manage, sell and promote high-end art.
The website was built using Expression Engine with a custom shop tailored to their needs. The website was built to be PCI compliant and utilises advanced payment systems for a seamless buying process. The design was created to stand out in the crowded fine art marketplace and give Drai a unique feel to go with their unique way of dealing with fine art paintings.
We also built the website on the latest HTML5 and CSS3 technologies and made it responsive so that it works on mobiles and tablets.
The new updated version of the Eazzee.co.Uk website has been completely redesigned to focus the website more on products. Our brief was to re-focus the site with a new web design to improve customer confidence and ease of ordering while adding new features and streamlining the buying process.
With an improved basket facility and options to order without registering, the new site was designed to be bolder, less cluttered and easier for customers to order. Some of the major new features we’ve added in this update – as well as a complete over-haul of the look and feel – are:
- Improved basket security and customer confidence features
- New ‘my account’ feature to allow order history and previous artwork history & to show most bought products
- Easier ordering options for logged in users with access to advanced features to make repeat ordering easier
- Improved product display – price matrix and product details layout now easier
- Improved delivery calculations and euro pricing
- Improved ordering process and can now order without registering
- iPad/iPhone ready
As well as the main site web design project we also re-built the Eazzee web shops system that allows Eazzee customers to have their own e-commerce shop selling Eazzee products. This system is mainly aimed at clubs and organisations that want to sell embroidered or printed products to their members directly from Eazzee and make money from it.
- Webshops – new design and admin system
- Easier management and customisation
- More options for clubs and organisatons such as ‘collect from club’