WordPress database error: [Duplicate entry '34974' for key 1]
INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (644595553, 1, 408, 1642, '2010-03-10 19:14:49');

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND referer = referer_id AND osystem = os_id AND useragent = ua_]
SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE visit_id = AND referer = referer_id AND osystem = os_id AND useragent = ua_id

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2010-03-10 19:14:49', 0, 2)' at line 1]
INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, '2010-03-10 19:14:49', 0, 2);

modestmerchant.com Blog - Your Guide to Starting a Retail Business
Nov8th

Options when cash runs tight

The Modest Merchant Administration Read on

It’s the off-season for beach goods. You do what you have to when the bank account shrinks. About 9 months into the company, money was getting tight. While Sunfitters was covering all the business expenses for the warehouse, inventory, utilities and other essential services — it was NOT covering my salary. Read the rest of this entry »

Nov8th

Public relations, we’ve got ink!

The Modest Merchant Marketing Read on

Thanks to Gretchen Mather, a PR friend of mine, we interviewed with Practical eCommerce Magazine in the Spring to profile Sunfitters.com. We got some link juice and some visibility in print. One reader had a fair criticism. We could do better with selection. But we do what we can.

May18th

Lackluster SEO via blogging with Yahoo Stores

The Modest Merchant Marketing, Technology Read on

If the marketing plan of your Yahoo Store involves link building, you need to read this. Yahoo allows storefront managers to install Moveable Type or Wordpress on their Yahoo Merchant account with just a few clicks. This is a step in the right direction. But it falls short of the delivering the intended benefit Read the rest of this entry »

May4th

Why we prefer UPS for ecommerce

The Modest Merchant Operations Read on

ups-logo.gifAfter processing your orders, someone has to deliver that last mile to your customer’s doorstep. In the U.S., there are three primary choices for delivery: (1) USPS, aka your local postal service; (2) FedEx; and (3) UPS. We use UPS. In this article I will share why we chose UPS, and give you some tips getting the most from them.

Read the rest of this entry »