Categories
Coupons and Promo Codes eCommerce & Shopping Online Kavoir & Whatever Magento Tips PayPal & Ecommerce

Avalanche Coupon Code (Magento Theme)

Avalanche Magento themeJake (fastdivision.com) was kind enough to offer me a coupon code so that my readers can enjoy the Avalanche Magento theme at 15% discount. In case you haven’t read my review of the Avalanche theme, it is the current sensation going on in the Magento-sphere. In the shortest words, I think it’s the best Magento theme because of 3 reasons:

  1. It is built by someone who’s insanely good at the website stuff (HTML, CSS, PHP, design, user experience, etc.). and who pursues perfection.
  2. It has unparalleled support – read my review and you will know. Better yet, join the club to experience yourself!
  3. The theme is very very good (best is a pretty strong word and I’ll leave it to you) in all aspects I can think of AND it’s being pushed to be better every day. Read Jake’s blog. He’s just finished working on and released a mobile version of Avalanche.

Coupon Code for Avalanche

OK here’s the coupon part. If you have made up your mind to purchase Avalanche, use this coupon code when checking out:

KAVOIR
Click To Open/Copy

Just enter it in the “Enter coupon code” text box at the end of the checkout page:

Avalanche coupon code for 15% off

And you will have the 15% discount off the normal pricing of $199 and $399 which would then be $169.15 and $339.15 respectively. Always nice to save a few bucks.

Enjoy!

Categories
Coupons and Promo Codes Domains

Cheapest GoDaddy Promo Code – $0.99 / Year .COM

Just found out some dirt cheap GoDaddy coupon code for new .com registrations:

INDY500 - $0.99 for 1st year
FLOWERS - $1.49 for 1st year
leap149 - $1.49 for 1st year

Which enables you to get any new .com name for just $0.99 – $1.49 for the first year. Not sure if you can claim it more than once per account but I believe one can’t. I used it to quick register one .com domain and never tried it a second time.

This is probably the cheapest GoDaddy coupon code ever for new domain registrations.

$2.95 / year .COM from GoDaddy

Another tip for getting cheap .com names from GoDaddy is this one:

http://www.godaddy.com/domains/search-danica.aspx?isc=goft006ec

It gives you the opportunity to register any new .com names for as many years as you want at just $2.95 per year (plus ICANN fee). That’s right, for just $15, you could have a .com name for 5 years. At normal pricing, $15 would only get you one or two years.

I found out this one by discovering one of the GoDaddy AdWords ads. They give amazing offers to traffic from AdWords campaigns.

In my opinion, though $1.49 may seem a lot cheaper than $2.95, I’d still opt to go with the $2.95 / year route because I can register multiple years. $1.49 would just get you locked in and then pay normal next year and so on. GoDaddy doesn’t release many renewal coupon codes as it does new registration codes.

$7.49 / year .COM renewal code

Zine10

This code gives you $7.49 / year renewal price for .com names at GoDaddy. It’s said to have been working for at least the last 2 years so hopefully it would go on working.

Categories
Business and Marketing Coupons and Promo Codes Free Web Templates Internet Tools My Personal Reviews

Webmium Review – WYSIWYG Website Builder

Webmium 40% Discount Promo Code: KAVOIRWebmium may not have much to look at on their website – for which they better hurry up and get a better design – it’s actually very very easy and intuitive to use.  With adequate features, abundant site templates to choose from, and hundreds of online marketing guides, it’s the combo solution for people who want to get their business website up in less than 10 minutes, without having to spend an arm and a leg to tackle the challenges of web design, web development, web hosting, and web marketing. Webmium has it all.

Unbelievably Easy and Intuitive

After a few minutes of clicking and typing, my first site on Webmium was up and running – Xi’an Jobs. I didn’t have to think once to get my job done. Everything seemed to be right there when I needed it. I felt like a breeze being pushed by the wind, naturally and comfortably and never did I have to sweat any effort to accomplish the whole website which is decent enough for most undertakings. Your site is well modularized so that you can freely switch between themes / layout and move around objects without jeopardizing anything. Your content is never hard coded.

A WYSIWYG Website Editor Better than Desktop Programs

Everyone can learn and start doing it in a minute. In fact, it’s so intuitive and easy that everything including editing text, uploading image, adding contact form and creating another page is accomplished within one editor page. Check out the editor screenshot:

webmium website editor

You don’t get any more WYSIWYG than this. Lots of desktop website creator programs such as Adobe Dreamweaver and Microsoft Expression Web available on the market who claim to be WYSIWYG don’t come up close. You have to view the produced web page in a browser to see the final results. But with Webmium, it’s all in there, 100% WYSIWYG and never again do you have to scratch your head and ask why the hell does it look so different in the browser from that in the editor.

Free Entry Plan – Very Good for SEO

Best of all it’s free and they’ve got tons of FREE templates to choose from. You should get one up on Webmium right now. Sign up with them. It’s definitely worth the time to have an external page of content up for the sake of SEO. Be sure to create useful, original and rich content or Google won’t buy it just because it’s on a distant IP. Webmium has an auto-submission feature that after you have published your site it will automatically submit the site to search engines like Google.

My tiny site about Xi’an Jobs ( http://xian.webmium.com/ ) was indexed by Google 8 hours after being published at Webmium. Definitely looks promising from the perspective of SEO.

Quick Built-in Guides to Kick Start Your Online Marketing

For small business owners who don’t know how to have their own website online, Webmium is the no-brainer choice. It has got hundreds of articles and guides in the Marketing Academy on how to do it and what the best practices are, about not only the technical aspects but also the marketing part. It’s a perfect companion for starter small businesses owners who want to have their website up today, in the minimum effort and cost possible. And you are well guided along the way with built-in tips while you are building your online presence.

What can be improved about Webmium?

It’s a greatly simple and useful solution for starter business owners but there are definitely ways that Webmium can be improved. I’ll just lay out a few of the problems I met when playing with it:

  1. Currently there’s no way I can add text beside the logo. It’s either a logo or a text but you can’t combine.
  2. I don’t seem to be able to align social buttons such as facebook like buttons and tweet buttons together. Weird.
  3. Unable to modify footer attribution to add copyright notice, etc. I guess it’s because I’m on the free plan. You would probably be able to do that after upgrading to the PRO plan.
  4. For now, each account is limited to one website / domain. I think they can definitely offer the ability to create and manage multiple websites under one account in the PRO plan.

Other than these, Webmium is looking a prosperous future if they keep shaping it better.

Upgrading to PRO? Use a Promo Code!

Webmium was kind enough to offer an exclusive promo code to the readers of Kavoir.com. If you want to take advantage of the PRO plan that offers all the easiness to build a small business website as well as unlimited storage and bandwidth, use promo code:

KAVOIR
Click To Open/Copy

Like this:

Webmium Promo Code

When you are upgrading but before making payment. It would give you a nice 40% discount off the listed price.

Categories
PHP Tips & Tutorials

PHP: Strip or Trim Extra Whitespaces Inside a String

There are raw strings that contain extraly unwanted whitespaces (tabs, spaces, new lines) that you want to get rid of so as to form a normalized string that has only a single spaces between words and sentences. For instance, you may want to transform this string:

Morning   is here,   sunshine
   is here.    Morning is    here.

Into this:

Morning is here, sunshine is here. Morning is here.

How to achieve this in PHP?

Just use this function:

function purge_inside_whitespaces($text) {
	while (preg_match('/\s{2}/', $text)) {
		$text = preg_replace('/\s{2}/', ' ', $text);
	}
	return $text;
}

Basically, it keeps scouring through the $text string passed to it and removes any continuous whitespaces and replace them with single spaces, until it can’t find any more continuous whitespaces.

Note you would need to apply trim() to get rid of any whitespaces in the beginning or at the end of the string, because if there are any there, a single space would still remain after applying purge_inside_whitespaces().

Categories
Music

Inspirational Music & Uplifting Tunes

People close to me would know that I play piano for fun – not an advanced player but the best I can do is Beethoven’s Moonlight Sonata (only the 1st movement, -_-). I think everyone could learn one or two musical instruments and amuse themselves. Music is such a great endowment to us. It dispels the dismay, enriches our emotions and reignites the dreams for a beautiful life. A week ago I found some very nice music tunes at Audio Jungle (link to their most popular pieces) that is so inspirational and upbeatly pleasant. I can’t help but being motivated to be happy and creative. They are so simple yet so masterly composed. Listed below are what I like most. Hopefully they would resonate in you as well.

Live My Life

A Fortunate Day

Clouds

Seeing is Believing

A Way To The Top

Positive Thinking

Translation

Energetic Corporate Pack

Business Music Pack

Top Classical Music

For people into classical music, here’s one of my sites: Top Classical Music. It tries to collect the best pieces of classical music arranged by authors and their epoch. Since fine MP3 files with impeccable quality are hard to come by, it’s very far from complete. I’ll try and get more pieces on the site when I can.

Here’s also a top 100 classical music board in Chinese.


Epic

Fill My Heart

Good New Day

Inspiration

Inspiring Uplifting Rock Intro

Movie Theme

Positive Hip Hop Pack 1

Starry Night Drive

Uplifting Energetic Emotional Dance

Inspiring Uplifting Corporate Pack

Ambient Piano

Inspiring Piano Bundle

Sweet Bliss

Epic Blockbuster Cinematic Trailer

Uplifting Trance

Epic Inspiration

A Real Estate

To Heroes

Cinematic Theme

Uplifting Inspiring Rock

Epic Action Hybrid Trailer

Romantic

The Nature 170 MIX

End

Categories
SQL / MySQL Tips and Tutorials

MySQL: LOAD DATA LOCAL INFILE only imports 1 or 2 rows?

It is common to import CSV files into MySQL database. You can do this with phpMyAdmin with small CSV files but with large ones, you would probably encounter the memory error and had to switch to MySQL command line “LOAD DATA LOCAL INFILE” to do the job.

It looks like something like this:

LOAD DATA LOCAL INFILE 'your.csv'
INTO TABLE `your_table`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(field1, field2, field3)

And then you encounter another problem that it only imports the first 1 or 2 rows and then it stops. After some researching and trying, I was sure it’s something to do with the “LINES TERMINATED BY” directive. Depending on the platform that the CSV file is created on, the line delimiter may be

  1. \n
  2. \r\n
  3. \r

And you need to be correct on the line delimiter to properly parse the CSV file.

So the solution is to try them all one by one and see which one of them works. Chances are, one of them would make the whole command successfully import ALL rows.

Another simple approach is to deprive the whole command of the “LINES TERMINATED BY” directive and let MySQL do the call. It’ll probably detect things right but in my case, this doesn’t work but specifying ‘\r’.

Categories
Internet Tools My Personal Reviews

Invoicera Review – Online Invoice Software & Client Billing Software

Let’s be honest here. One of the most dreaded dreams for any working professionals perhaps is generating timely and professional invoices. Important as they are for ensuring timely payments, it is a pain to sacrifice time and make an effort to track down all the details. If you are having a tough time preparing invoices and the accompanying reports, a valued solution that lies with you is Invoicera. Invoicera is a completely web hosted application that effortlessly works towards getting the invoice generation job done, in a professional manner.

A sturdy online invoicing and billing application, Invoicera provides you with a self explanatory user interface along with poignant and much sought after set of features and functionalities. Thus it seamlessly simplify and streamline the entire process of generating and sending invoices.

Invoicera control panel

Language Multiplicity and Multicurrency support

This is a major factor, which gives Invoicera an edge over various other online billing systems in the market. Invoicera supports 11 different languages and more than 100 currencies.

Effortlessly Manage Your Clients

In the client section apart from managing and adding your new clients you can also view their account statements and create custom fields and entries which you deem necessary.

To overview the complete details of any particular client there is an automated Report generator, which gives you the ease of analyzing the dealings and business you have had with the customer.

Incredible Time Tracking

With its expert time tracking capabilities, you can be rest assured to track down every minute of your time that you have spent on the projects for your clients. It completely nullifies all the worries surrounding time tracking and you can easily keep a check on how much time you have spent on a particular project.

Template Customization Service

In case you are not technically trained in customizing the look of the invoice / setimate templates, Invoicera provides you with the option of Invoice Template Customization service. This will provide you with the expert services of seasoned technical experts and you can easily customize the look of the invoice that you send, as per the need of your business.

Schedule Your Invoices Easily & Charge Late Fee from Defaulters

A stand out point of Invoicera is that unlike other similar apps, with Invoicera you can easily schedule each of the invoices needed to be delivered. You can simply schedule the date and time on which you need to send out the invoices to the users and the intuitive online invoicing solution that Invoicera is, it will make sure that invoices are delivered right on scheduled time. Besides, with just a click of the mouse, you can add the late fee charges and get reimbursed for the same.

Other Benefits That Invoicera Offers:

  • Login and carry out some invoicing tasks wherever you have access to the Internet either via PC or laptop,
  • Flexible pricing depending on your usage levels,
  • Constant updates and support,
  • No large up front application costs,
  • Data security and backup

In Short

Invoicera is vast enough to confound all the different invoicing requirements of your web site and you assure yourself productive gains by availing its services. Besides, their customer support and related services are impeccable and unmatched. Thus if at any time you stumble, Invoicera provides you with enough options to continue the smooth sailing.

Invoicera - online invoicing