Categories
annoyances business services

Ranting At The Post Office

This morning I had to spend some time at the local post office – someone sent me a registered mail with return receipt that I have missed, so I just had to go. Every time I go to a post office – whether small and local or large and central – it always feels a bit like time travel. A travel to the past, of course.

First thing that came to my mind when I have entered the premises (I never visited this location even though I lived in that zip code for a year) why does the post office needs five windows, when only one clerk is on duty? There must be some serious flaw in design or management, since it takes about 20 minutes (or more) to get from the start of the line to that clerk’s window. Obviously, since the clerk has got almost 15 years before retirement, she’s not in the hurry. However, most of the people who (im)patiently wait in line – are, their time costs money – just like mine. With proliferation of electronic means of communications I can see more and more sense in avoiding post office like a plague. After all, my time is better spent elsewhere.

Second thing is that about 80% of people who wait patiently are older generation, well over 60 years old. The younger the person, the less patient he or she gets. I often found myself to be the youngest person for the whole time I was in the post office.

Next – even thought the cost of postal mailing is usually noticeably less then FedEx, UPS or DHL, people still prefer to use the latter. My guess is that it not only matters how much it costs to get a package from point A to point B, but also – how much effort does it takes. If sending a package costs me just two dollars more but doesn’t include humiliation of 20 minute line in front of 15 empty clerk’s windows – maybe I would agree to pay 2 dollars more.

Last, but not least is the track record. The moniker “United States Lost Office” didn’t come out of nowhere.

Categories
business zealus.com

Administering web store databases – the inside out look (continued)

Web site database administration - www.istudioweb.comTo read the first part of the article – click here.

Since the client is in some sort of the rush before his niche shopping season starts he needs a solution ASAP. The newly acquired web site generates orders that he unable to fulfill given the outdated inventory and pricing.

We’ve offered to create an offline database (MS Access would be a good choice for this case) that will keep the current inventory and extract in into three different importable packages for each web site.

Why Access? Because it exists on almost every computer, and if not – it’s very easy to create a distributable package for Access database. One more serious advantage is that Access doesn’t require any additional licenses to sell end products based on Access. Built-in tools allow very easy importing and exporting data, creating reports and developing forms thus decreasing development time. More under the cut…

Categories
business zealus.com

Administering web store databases – the inside out look

Database administration - www.istudioweb.comThe long delay in posting was caused, as some of you might have guessed, by the fact that we got ourselves a busy client (at least for now). We’ll see how it all go, but so far I was faced with an interesting dilemma. Or, rather, was sort of presented with the task to solve.

Our newly signed up client owns couple of web sites that are being fed from the same database. Administering these two sites is a breeze, since any product that has been entered in one immediately shows up on another. The administrator’s interface combines both web sites, so there are no surprises so far.

On his next step this businessman decides to create another web site. This one is fed from a different database, since it was a new team of developers who created this store for him. Additionally, the admin interface is not as friendly as the first one, although the feature set is the same. It’s worth to say that all three web sites are developed on PHP/mySQL platform. The story unfolds under the cut…