Magento Commerce SEO

Recently I’ve been delving in to the magneto shopping cart which can be found at MagentoCommerce.com. Magento is a great app which does a good Job with SEO.

Magento SEO Features:
1. Search engine friendly URL’s
2. URL rewriting and management
3. Individual page title tags.
4. Auto-generated site map for display on site
5. Auto-generated popular search terms page
6. Individual page, category and product – keywords and description metadata
7. Site Default title tags
8. Breadcrumbs for site pages

I would recommend Magento over OS commerce for an opensource shopping cart applications. In future post i place to have mini tutorials for Magento commerce

**this free blog is possible due to our clients such as Employee Screening, Employment Screening & Tenant Screening at http://www.interqst.com. Our Internet Marketing book, and web design St. Louis at ArtWorksdesign.com and VRBO by RentExpert.com, and Infrared Heaters the best heaters at Greenisbetter.org.

Connecting with clients Easily

Most of our contact with clients is done through email and phone conversations. This is comfortable for most everyone. Sometimes more functionality is required for that personal touch, or for educational purposes. The following is a list 10 of sites and applications that can be used for that.

1. Skype – it’s easy to use, free to download and has video chat. why not? too bad they don’t have screen sharing functionality

2. DimDim – This is my web conferencing app of choice. compatible with mac and PC. free to use for conferences under 20 users. if thats not enough it’s open source as well, download flavors for linux and windows servers on their sourceforge page

3. WebEx – probably the bast known web conferencing tool, prices start at $39/month for the individual free 14day trial too. This is the corporate choice

4. Vmukti – runs on windows server 2003, and XP written in c#, also open source. you can check it out on SourceForge. it also comes in a professional version with hosted options.

5. WebHuddle – Secure java applet no server install. Open Source and free check the demo: WebHuddle demo

6. OpenMeetings – Open Source web conferencing integrates with moodle, see all the information at their Google Code page. there is also a demo here (note: the password = demo username = demo) you can download the code and install it on your server….oh yeah its free!

7. Adobe Acrobat Connect Pro – it took me a while to figure out how much this costs to use. you’ll need to call adobe for anything beyond their month to month subscription service $375 for their starter pack or $0.32 per user per min.

8. Glance – one click desktop sharing! check out their news section

9. iVisit – for both for desktop and mobile, track your mobile clients with GPS, take a look at their features page. free for 90 days – fully featured for 7.95 per month with a 1 year subscription

10. Gizmo Project – similar to skype, give it a try if you have an aversion to skype.

Linux Command line Reference & MySQL DB Migration – mysqldump

I decided to place this command line sheet for download because I tend to use it for reference quite a bit. I have added a few things from other ssh-command-reference in to this document. Just open the doc in your favorite text editor and search for the command your looking for.

I would like to highlight one Command that I’ve found super useful for large or small Mysql DB Migrations I would like to Give Props to Dreamhost for having this on their Wiki

Large or Small mysql db migration w/mysqldump

I have used this command to move mysql DB’s in between hosts that are too large to move or download with phpmyadmin, Cocoamysql, etc. this has worked on shared and dedicated servers so lets get to it

Requirements:

have ssh access to both web servers
use of a text editor.
old db to migrate from and a new EMPTY db to migrate to
access to both db’s with the administrative user.

The mysqldump command

Now that you’ve got your old db and new EMPTY db with the users and passwords we’re ready to start

Use the following mysqldump command and replace the filler data in your text editor:

1. oldhost
2. oldusername
3. oldpassword
4. olddbname
5. newhost
6. newusername
7. newpassword
8. newdbname

mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname

now that we’ve got the mysqldump command filled in with your new data lets get the actual migration going.

Open a new shell window and log into your server.

note that the ssh user needs to be able to access mysql

now that we are logged into the server, cut the mysqldump command from your text editor and paste it in to your open SSH session at the command promt. and click enter!

there you go. if there are no errors then you should have copied the old DB to the new DB on your new host. If you do have errors try using mysqldump command and specifying –verbose it will show you what is going on with your transfer. Let say you have errors in your DB and the mysqldump keeps failing at these errors. try using the force command –force to push the dump through even if there are SQL errors. remember to clean those up after your on your new more capable host! Lastly use mysqldump –help to get a list of all command associated with mysqldump.

Post Sponsored by – VRBO & Background Check

ssh-command-reference

Web Design Inspiration… are you design impared too?

today It’s all about design and inspiration for the non artistic folk ahem… or design impared. I would consider my self a hack at best when it comes to web design. When at all possible I like to leave the design to the to the designers, AND sometimes I feel like putting myself through the torture of creating a logo from scratch, or a complete web design for friends and family. Let me tell you after ending up looking like this guy a few times I decided there has got to be a better way to come up with foder to fuel my design …. Here are a few trips and trick I use to create designs

Design Inspiration

Where do designers get their inspiration? Talking to clients, using current trends in design, from the project parameters, or maybe right off the ether.

I go to a few sites:
For Logo inspitation check out – http://logopond.com/

For complete web design inspiration check out – http://www.designshack.co.uk

For More in depth design information check out – http://webdesignfromscratch.com/

lastly if you need a color palatte take a look at – http://www.colourlovers.com/

GOT Graphics?

Now That you’ve been inspired the design and creative juices are flowing…or at least trickling where are you going come up with graphics? the subtle aspects of a sites design that add that extra touch. Hell lets bust out the Wacom tablet fire up adobe illustrator and start drawing! oh you don’t have a wacom tablet? Ohhhhhh riiiiiight, how about a graphics editing program? No? Ok forget the wacom tablet too much hassle. but the graphics editing program is essential. I personally I would choose adobe illustrator and photoshop. The reason being is that it’s the industry standard. If you want to go the Open source route use GIMP a great photo and image manipulation app. now that you’ve got an editing program lets go find some images and graphics
For vector images check – http://www.freevectors.net

for Free photos check – http://www.freephotosbank.com

Don’t forget to google as a resource, to find similar sites there are many out there. please provide attribution the authors of images and photos when appropriate.