Archive

Author Archive

Helpful Security Extras for Zen Cart

March 12th, 2010
Zen Cart Security

Security

First and foremost make sure your Zen Cart is fully patched! No exceptions. Your Zen Cart you just downloaded and installed still needs these.

Now, do these items on Zen Cart’s recommended security list. On this list please ignore the following. If you choose to do these things, your robots.txt cannot be accessed and the php command will not work properly for you in most server environments.

#.htaccess to prevent unauthorized directory browsing or access to .php
files
IndexIgnore */*
<Files *.php>
Order Deny,Allow
Deny from all
</Files>

#add the following to protect against people discovering what version your
spiders.txt file is
<Files *.txt>
Order Deny,Allow
Deny from all
</Files>

Now, lets add some cool stuff to help you stay safe.

Tip #1: Use strong passwords for everything! Change them every 30 days.

Tip #2: When renaming your admin DO NOT use any admin or business related
term. Try banana for example, something like manage, control or anything XXadmin is a dead guess for most hackers to discover your admin directory.

Tip #3: Make sure all admins have their OWN accounts and install this module to track their access more conveniently.

Tip #4: Protect your admin directory with an additional auth when possible. Perhaps you can password protect the directory or allow access by IP address for example.

# password-protect the directory
AuthType basic
AuthName "This directory is protected"
AuthUserFile /home/path/.htpasswd
AuthGroupFile /dev/null
Require valid-user

# deny all except
<Limit GET POST PUT>
order deny,allow
deny from all
allow from 192.168.1.1
allow from .*domain\.com.*
</Limit>

Tip #5: Protect ALL directories from browsing with an index.html file. This file can be blank, it just prevents the directory from displaying in an index to browse. If a folder has an index.anything… It’s protected.

Tip #6: Protect your images directories (all) with the following .htaccess to prevent browsing, executing php files and more. These directories will also need an index file. When done, login to your hosting control panel and change the permissions on both the index.html and .htaccess files to 444 to prevent modification.

#PRO-Webs ver 1.8 1/2010
#Prevent directory viewing and the ability of any scripts to run.
#While a bit overkill this file prevents a wide array of access and executions
#of known exploits in your Zen Cart
#This file and a index.html should have the chmod 444
#This low setting allowance differs from server to server and should be set as
#low as possible and no higher that 644
#Permissions this low will likely need set in filemanager
#Place this in all images directories except BMZ_Cache
Options -ExecCGI -Indexes
IndexIgnore *
RewriteEngine on
RewriteCond %{HTTP_USER_AGENT} libwww [NC,OR]
RewriteCond %{QUERY_STRING} ^(.*)=http [NC]
RewriteRule ^(.*)$ - [F,L]
<Files .htaccess>
order allow,deny
deny from all
</Files>
<Files ~ "\.php$">
Order allow,deny
Deny from all
</Files>
chmod .htaccess files 444

Tip #7: If you have an SSL force all of your admin pages to load in only secured urls with the following htaccess code.

RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteCond %{REQUEST_URI} /admin_dir/
RewriteRule ^(.*)$ https://domain.com/admin_dir/$1 [R,L]

Tip #8: Make sure your cache folder has the correct index.php and .htaccess. Download a fresh version of Zen Cart and upload them to be sure. Now CHMOD, change the permissions of these to 444.

I may be adding to this, as we are always testing… so stay tuned.

admin E-Commerce Marketing, Store Development

Where are your shoppers coming from?

March 11th, 2010

Compete.com has released a very interesting study that all ecommerce store owners should read. This study polled online shoppers about where the look for items to buy, how they shop and what they shop for. I think that although the results may seem as expected… the missing element is how it applies to your business, and what growth in the particular metric you might expect in the future.

Let’s kick this off with polled data …

How frequently do you use the following tools when shopping online?

shopper survey2 Where are your shoppers coming from?

Note the green and red areas where I have noted what I believe to be expected growth/decline of these metrics in the coming year.

I think, and this is my own opinion (take it or leave it), that the areas noted will grow or decline for many reasons, not withstanding the new push among search engines for real time results and the weight they do and will carry in the future.

Coupon sites will continue to grow as they continue to gain authority and social media love from their users… As they rank better, they will be used more frequently. Look for many of these higher ranking sites to start offering “premium” paid types services and exposure.

Emails advertising I believe will decline for a good many reasons, mostly because people are generally irritated by spam mail. Shoppers are even afraid to create accounts on websites for “fear of spam”. Secondly, your email shoppers are far more likely to be a one hit wonder. They shop for price and have little or no loyalty…. IMPULSE

Product reviews is a tricky one…. and while they can be very effective, I believe they will soon be so abused that no one will trust them. Face it, how do you know a “real shopper” said that instead of a savvy marketer? You don’t, and just like many other diseases the web has caused, “fear of fake reviews” will in my opinion join the “fear of shipping” eBay disease in record time.

Shopping comparison sites and portals will continue to grow. Here shoppers can get what appears to be a fair representation of products to compare, see and get information about them in a comfortable… No pressure setting. Everyone will have a favorite, and we will see these continue to grow.

Social networking for ecommerce is still a baby, but expect its effectiveness to grow. Right now for **most ecommerce sites, this is just something you do. However, as we see the decline of reviews and other sharing platforms like gift tagging, this will become the safe way to ask a friend about a product they bought, or compare products for sharing. People on Facebook will seem more “real” and believable, thus more effective. Niche sites are already and will continue to kick ass here!

admin E-Commerce Marketing, E-Commerce SEO

Sportsmanship – Social Values

March 9th, 2010

While I realize that this is completely off topic, I really wanted to share it. This example is about sportsmanship, a VERY good example of what young people can do… If allowed and inspired to do so.

In the NCAA Division II girls softball playoffs, Western Oregon senior Sara Tucholsky, who had NEVER hit a home run before the second inning of the second double header against Central Washington popped one over the fence. Sara, who was incredibly excited to hit her first home run, in a playoff game no less, accidentally overran first base. She turned back to touch the bag and in doing so twisted her right knee and it gave out… Landing her on the ground at first base.

Wait for it…. This is amazing!

Sara was pretty severely injured and would be unable to continue her celebratory first time trip around the bases for a home run ever. Team coaches and trainers could not touch Sara or she would be out at first. If they brought in a pinch runner Sara’s home run would become as a two run single instead.

Opposing team Central Washington senior Mallory Holtman, realized the situation for senior Sara, and inquired to the umpires and coaches if they could carry her around the bases, having Sara touch each base. The umpires and coaches, while astounded, agreed that this would in fact be “legal”.

So Mallory and teammate Liz Wallace quickly picked Sara up, carefully touching her foot down on each bag, and carried her around the bases to get her home run counted as such.

sportsmanship Sportsmanship   Social Values

Image from Values.com

While Central Washington lost the game, they had completed one of the most selfless acts of human kindness and sportsmanship I have ever hear of. So while off topic, from one veteran softball player to another… Hats off ladies, you are incredible people and you hold in your hearts the true spirit of the game…. Congratulations.

admin Off Topic

Ecommerce Spring Forecasting

March 5th, 2010

Are you feeling that “spring is coming” bug? Well, rightfully so, because right now is the time to plan for your spring marketing and tidy up a bit from the winter sales.

Most ecommerce stores have some season trending. This is very unique to both the store and the product line. So a store selling green widgets can be expected to trend sales in a similar manner to another shop selling green widgets… But not exactly, as they are many additional metrics that influence one’s sales.

So you should be planning for your spring and early summer products, marketing and trends now… So that you are prepared for this period in your business. Even especially if traditionally spring is a low volume period for sales.

Here is a checklist of sorts to help you get started for planning any marketing period, including this spring.

Trending: Unless you site is brand new, you should have some sales and traffic data that you can use to trend or predict the data for the upcoming period. I tend to concentrate on sales and traffic. I use both as they can be very unrelated for some websites. There are clearly some periods where even if the traffic is there, conversions are down… So to properly trend our potential for this upcoming period we should use both. You may even have other metrics such as, bounce, average order or similar that are specifically a target for your store.

Gathering the data is the easiest part, as you should be using a proper analytical stat program to record your data. We will use Google Anayltics for our example, as it is very popular.

When gathering your data, we are looking for specific trends within the matching period from previous years to predict, affect and produce a proper marketing plan for the upcoming period. So login to Google Analytics and lets get to work.

So we will pull data for all of March, April, May and June to cover our bases and provide some overlap. You will want to pull at least on year, more if you have them. I would not be concerned with using more than 3 years as things in your business and on the web change very quickly and it’s not likely to be very relevant any longer.

The example store I am using had a 2009 average daily visits of 279 uniques a day. There conversion rate for the year was 3.87%. You can see by the graph that holiday traffic is a crucial part of this store’s success and that spring is rather soft by comparison. You can also see that our spring period it right at or just a bit above average for them.

2009 Traffic

2009 Unique Visits

We can clearly see from this data, that traffic could be improved for this period…. Especially because they have a genuine promotable product line for spring sales. Now let’s have a look at conversions in relationship with this traffic… Do they convert well in this period?

conversions Ecommerce Spring Forecasting

2009 Conversions

We can see that last year, while traffic was average, they converted pretty well the end part of spring. looks very much like March should be our focus area.

Next you will determine your trend. You can use data from previous tears to do this… But if you lack that data no worries, this old restaurant manager has the equation to get you close.

Obviously, any data you do have is clearly relevant… But let’s say you have little or none. To determine your current rate of growth in both of these metrics we will poll the last 4 months. This is a weighted process with the greatest weight on the most recent data.

This applies to any metric. Gather the data for these metrics for Nov 2009, Dec 2009, Jan 2010 and Feb 2010.

We will start with March’s data from last year 8,043 unique visits and a conversion rate of 3.13%.

  • Nov 2009 8,789 & 4.85%
  • Dec 2009 14634 & 4.5%
  • Jan 2010 7,604 & 3.67%
  • Feb 2010 6,395 & 3.52%

For this purpose, with holiday data so much higher we will exclude Nov & Dec, unless we have 2008 numbers… Which we do. Nov 2008 7,419 & 3.18%, Dec 2008 8,861 & 4.00%, Jan 2009 6,146 & 2.99% and Feb 2009 5,742 & 3.22%.

Here is the math:

Period Unique Visits Conv %
Nov. 2008 7419 3.18%
Dec. 2008 8861 4.00%
Jan. 2009 6146 2.99%
Feb. 2009 5742 3.22%
Mar. 2009 8043 3.13%
Nov. 2009 8789 4.85%
Dec. 2009 14634 4.50%
Jan. 2010 7604 3.67%
Feb. 2010 6395 3.52%
YOY Growth
Nov. 1370 1.67%
Dec. 5773 0.50%
Jan. 1458 0.68%
Feb. 653 0.30%
Trend Weight
Nov. 18.49% 1.67% 12.50%
Dec. 65.15% 0.50% 12.50%
Jan. 23.72% 0.68% 25.00%
Feb. 11.37% 0.30% 50.00%
Current Trend 22.07% 0.53% Up
Forecast
Last Year March 8043 3.13%
This Year March 9818 3.66%
Daily Visits 318

The math is easier than it looks….

Step 1: YOY growth, which is simply current year minus previous year.

Step 2: Trend. Like I said we will weight this for the most current monthly data. So 100% being the whole, we will use 12.5% from Nov & Dec, 25% from Jan and the remaining 50% from most current Feb. Something like this:

  • 1 part : Nov. 18.49% plus Dec. 65.15% = 83.64 divided by 2 = 41.82%
  • 1 part: Jan. = 23.72%
  • 1 part: Feb. =11.37%
  • 1 part: Feb. =11.37%

= The whole (88.28) divided by 4 = (22.07%) Current Trend

Last year March (8043) apply trend 22.07% = (1775 growth) This year March forecast (9818) unique visits… Into 318 average daily visits.

Check our math:

Last year average daily visits March = 260

This year forecast = 318

% of predicted growth = 22.3%

**Note that rounding changes these just a hair, but not to worry this should be pretty reliable data.

So this “math” can be applied to the entire period as a whole, or each month individually computed. The point here is to have an idea of what to expect, AND and basis to measure the effectiveness of your marketing this spring. For example if you did nothing last spring, and you know (above) what to expect if you do nothing this spring… Then you have a pretty good benchmark to measure the effectiveness of a marketing campaign this spring.

admin E-Commerce Marketing, Small Business