The Blog

A Very Merry Christmas and a Happy New Year

We’d like to say a big thank you to all of our clients for your business in 2014 and we wish you a peaceful and enjoyable festive season. We look forward to working with you again in the new year.

Best wishes,

Gav, Ben, Jack, Matt, Amy, Camilla, Dean, Amee and Andy.

Brand New Website for Chemist4u Launches

This month, we have launched the brand new website for online pharmacy, Chemist4u. They had outgrown their exisiting eCommerce website and needed a better approach to servicing their worldwide customer base.

We delivered a multi-channel, custom designed and built eCommerce application in a verytight, 10 week window. The multi-site Magento installation will feature new front-end websites and brands in the upcoming months, all utilising the single database and installation for management.

The fully responsive website features an import of over 10,000 individual products and has been developed to conform to point-of-sale pharmacy regulations (WWHAM).

The new site boasts an integrated stock management and pharmacy system, along with a prescription management service.

igoo have fully trained Chemist4u on daily management of their new website and continue to provide on-going support.

If you would like to know more about our eCommerce solutions, we’d love to hear from you.

igoo Christmas Hours

The igoo team will be out of the office from 22nd December to 2nd January, however during this time, we will still be available for support and maintenance requests via the support@igoo.co.uk email address.

For our maintenance clients, support will also be available on our normal phone number – 0151 291 7799. We will be back in the office, with batteries recharged, from the 5th January.

Turn Your Clothes into Cash with Roberts Recycling

A new website for Roberts Recycling is currently in the igoo pipeline.

igoo created their first two websites several years ago and this year, we’re developing a multi-site for the local recycling company. Their five new websites will be managed simply through one CMS system, allowing the company to serve even more of the North West region.

Head to the igoo blog for follow their progress and to hear more about what’s going on in the igoo offices.

Paving the Way for Landscape World

Last month, we launched the brand new website for paving specialists, Landscape World. We have given their identity a refresh and the site has been re-designed to provide a easy and enjoyable shopping experience.

Their new site, which is built on the powerful Magento eCommerce platform and is mobile friendly, displays all products simply and provides a streamlined checkout process.

If you would like to hear more about how we could transform your brand and website, please get in touch with us today.

New Site for Stigma Rotary Launches

We were delighted to launch the redesigned website for Stigma Rotary this month. As a world leader in the manufacture of high quality tattoo machines, they required a website to showcase their four main products.

The new site features detailed artist galleries, displaying their portfolio of work, along with an interactive stockists map for easy purchasing.

Summit Sport Outdoor is Up and Running

This November also saw Summit Sport Outdoor make it’s first journey into the world of web.

They approached us earlier this year as they needed a strong web presence for their new sport and outdoor education venture.

The new website features detailed information about the range of services on offer and features hand-drawn illustrations throughout.

If you’re interested in custom artwork for your brand and website, we would love to hear from you.

igoo Spotlight on George Roberts Scaffolding

We’re shining our client spotlight on one of the world’s largest independent scaffolding suppliers, George Roberts Scaffolding.

George Roberts first approached igoo in 2013, requiring a strong web presence to catalogue their full selection of products and allow customers to find everything they need in one place.

Their website, which was launched later that year, reinforces the existing company brand and boasts a range of improved features including an online shop, detailed case studies and regular news.

Black Friday Sales Reach Fever Pitch

It’s been impossible to hide from the furore of Black Friday this week, and as the big day finally arrives, so have the millions of shoppers who are frantically searching for a bargain.

Luckily, some of our clients have fantastic offers available, which are really too good to miss…

Peaches and Cream - 10% off all products until noon on Saturday

Weavers Door - 10% off until midnight tonight

Designer Menswear Boutique - 25% off until Sunday

Boudoir Boutique - 10% off all black items until Sunday

Jersey Beauty Company - Free skincare gift when spending over £45, today only

Olivia Divine - 20% off today

Happy Shopping!

Removing Test Orders from Magento

Once you’re ready to go live on a Magento project you probably want to remove the masses of test orders placed. The below SQL query will set everything back to normal for orders, invoices, shipments and wishlists.


SET FOREIGN_KEY_CHECKS=0;
TRUNCATE `sales_flat_creditmemo`;
TRUNCATE `sales_flat_creditmemo_comment`;
TRUNCATE `sales_flat_creditmemo_grid`;
TRUNCATE `sales_flat_creditmemo_item`;
TRUNCATE `sales_flat_invoice`;
TRUNCATE `sales_flat_invoice_comment`;
TRUNCATE `sales_flat_invoice_grid`;
TRUNCATE `sales_flat_invoice_item`;
TRUNCATE `sales_flat_order`;
TRUNCATE `sales_flat_order_address`;
TRUNCATE `sales_flat_order_grid`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sales_flat_order_payment`;
TRUNCATE `sales_flat_order_status_history`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_shipment`;
TRUNCATE `sales_flat_shipment_comment`;
TRUNCATE `sales_flat_shipment_grid`;
TRUNCATE `sales_flat_shipment_item`;
TRUNCATE `sales_flat_shipment_track`;
TRUNCATE `sales_invoiced_aggregated`;
TRUNCATE `sales_invoiced_aggregated_order`;
TRUNCATE `sales_payment_transaction`;
TRUNCATE `sales_order_aggregated_created`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;
ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_payment_transaction` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_aggregated_created` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;

This is tried and tested on Magento 1.7.0.1. Make a full backup just in case.

You can find us on Twitter & Facebook