The eCommerce Solution Guide – Easy UK eCommerce on a Budget

Unless you’re an experience-hardened entrepreneur, fear of the unknown is always going to be one of the most stressful things about starting up any new business. And with the wealth of up-to-date information readily available over the internet these days you’d be pretty daft to look anywhere else. So when I set out on the road to eCommerce fame and fortune for the first time I thought it would be plain sailing, followed by canapés and caviar, alas not quite. However, this account of my own journey to accepting online credit card payments should allow you to avoid the many pitfalls and quickly point you in the right direction.

My initial searches proved to be quite fruitful. If you’re based in the UK and want to set up your own eCommerce website the general theory behind this is (sort of) straight forward. Here’s the list of the essential processes broken down, in simple terms, to explain what’s happening at each stage…

Shopping Cart eCommerce Software/3rd Party Service

This handles the various ‘Buy’ buttons on a site, and places items into the customer’s shopping cart. When at the ‘checkout’ area of an online store, this is also used to gather the customer’s name, billing address and credit card details etc, along with any items they’ve placed in the cart. The card details are then securely passed on to a payment services provider (see below). This can also be used to set up and automatically send out your company receipt to the customer, upon payment approval.

Payment Service Provider (also known as a ‘Payment Gateway’)

These people act as a middleman between the shopping cart software (see above) the customer’s credit card issuer and the store owners Merchant Account (see below). Card details are checked for validity, encrypted and sent back and forth. If the transaction is approved the customer’s shipping details and ‘bought item’ details are then decrypted and sent to the store owner for shipping to take place, and the customer will receive an automated receipt from the payment service provider.

Internet Merchant Account from an ‘Acquiring Bank’

This is the service (offered by most high street banks) that actually carries out the customer’s credit card processing and puts the money in your pocket. Simple in theory, but the longest and most expensive part to set up.

If you already have a ‘Merchant Account’ with an Acquiring Bank this will need to be changed over to an ‘Internet Merchant Account’ for any online transactions to take place, regardless of who the service provider is.

Okay that’s all the theory out of the way. Of course you could avoid all this nonsense and save a lot of time and money by simply setting up a Paypal merchant accoun. Afterall, they now accept credit and debit cards without making your customers set up any sort of account with them. Unfortunately, Paypal still has a bit of an image problem (mainly due to it’s eBay roots). If you’re selling home made mittens I’m sure this won’t be a problem. But if like me, your potential customers are from other businesses, and you want to convey as professional an image as possible, it can send out the wrong sort of message. Also, in my experience, many businesses are notorious for regarding any ‘new’ payment methods with great suspicion, and many still find it hard to stop using chequebooks. However, I’m sure Paypal will be viewed differently in time, so to cover all eventualities, I chose to implement it on my own site in addition to the more traditional ‘merchant account’ method for accepting cards.

Finding a Shopping Cart

Beyond this first bit of research I was hoping to find forums full of real life accounts and experiences of the above mentioned services which would quickly point me in the direction of the best software available. On the subject of ‘shopping carts’ the problem seems to be one of volume. There are a lot of people recommending a lot of different products, so you end up not seeing the wood for the trees, and they range wildly in price. All the big names in this area are PC based, so if you own a mac you may need to also consider the extra cost of either buying a cheap PC for the job or, if you’re pushed for space, Virtual PC emulation software.

I read a few times that ecommerce is in it’s infancy, but after 2 weeks of studying these “easy” software solutions I was frankly shocked at how dismal these offerings are for normal people like me. Most of them expect you to know some sort of programming language, PHP scripting and spreadsheet inputting. Now I regard myself as being above average when it comes to most things technical, but in this particular area I was quickly left feeling like the school dunce. My personal feeling is that if I’ve just spent £300 on a piece of eCommerce software why on earth do I need to know anything about any of these areas, surely that’s what the shopping cart software is for? In addition to this my personal experience showed that many are firmly aimed at the US market and are often incompatible with UK payment service providers. Not surprisingly, I had to grudgingly give up on this area of research and spent a week worrying about the future of my site.

All was not lost however. There is an alternative to becoming one of the heavy-metal t-shirt wearing brigade and emerging yourself in the joys of Perl scripting. Third party providers offer ‘Remotely Hosted Shopping Cart Software’ which again varies enormously in price and also in how the costs are structured. To cut a long story short I found recommended enough times to catch my eye which has an easy to use ‘admin page’ system. After you sign up you get issued with a small personalised line of code which you add to the HTML of all your ‘buy’ buttons (which can be either text hyperlinks or images of your choosing). Log in, and start customising the comprehensive list of admin settings (accepted currencies, taxes, postage etc, etc) that’s about it really. It’s simply priced too at £13.60 ($24) for 3 months or £49 ($86.40) for 12 months service. Apart from the reasonable price, the ability to also use the service for free if you only want to implement Paypal on your site is a great way of testing the service first before you pay for the credit card accepting ‘Premium’ service. And so far I have to say I’ve been very happy with the way it works.

Finding a Payment Service Provider

If I want to find the cheapest electricity supplier, the cheapest mobile phone contract, or buy the cheapest pair of tartan slippers for Father Day there are loads of websites that will compare these things at the touch of a button. And it’s pretty simple business sense that in order to remain competitive your overheads should be kept as low as possible without quality of service suffering. With this in mind my first port of call was the Business Link’s ‘product and cost comparison service’ at (click on the ‘Use The Tool’ button) which aims to compare the services and costs of various Payment Service Providers.

Initially you’re put through the annoying and totally unnecessary hassle of registering with the site. After this dodgy start you are presented with a simple form asking you to put in 3 figures, ‘annual turnover’ (actual or estimated), ‘average online transaction value’, and your ‘business borrowing/overdraft rate’. All sensible stuff. From there another 4 pages of forms come up ‘Transaction Bands’, ‘Acquiring Costs’, ‘Payment Method Split’ and ‘Compatibility’ where you can enter more detailed information as you feel necessary before finally being presented with your personalised results. Overall the experience is a bit clunky in places but if you bear with it you find it’s a fairly invaluable service.

The cheapest/best ‘Payment Service Provider’ I found at the time was They deal with 10 of the 13 available Acquiring Banks in the UK and (most importantly) their system is compatible with mentioned above. Charges are as follows: an initial £50 set-up fee (£58.75 with VAT) and £10 per month thereafter (£11.75 with VAT). Each transaction is charged at either 1.9% or 39p of the sale price (the choice is yours), and the money from the customer will generally take 2-3 days to appear in your business bank account (which is a lot quicker than some). Apparently they also offer an online ‘virtual’ swipe card facility for telephone orders at no extra charge, but I have yet to test this out myself.

I should also point out that there are a small number of operators such as Netbanx who don’t require you to have a merchant account so set-up costs are kept to a minimum, but their individual transaction costs are higher, so for me at least, this was a false economy. I also chose not to accept American Express and Diners Club cards yet, as they need a separate merchant account to handle each of them.

Finding an Internet Merchant Account

This is no easy task, currently there’s a serious lack of any specific hard facts and figures on the internet on this subject. There are also no up-to-date comparison tools or lists that I could find, this may well be because a bank’s charges can often depend upon how much they’re already making from you for other services. For instance, if you already have a loan from the same bank they may charge you less for each online transaction cost. Ecommerce forums were equally disappointing, I found scant accounts from individuals with any personal experience there. Even on the individual banks’ websites finding costs and set-up fees is often impossible. In fact I resorted to phoning various departments of HSBC Bank over the course of a whole afternoon where none of the staff could tell me anything about their own merchant banking fees! Merchant banking it would seem is deeply stuck in the dark ages, so they’re all more than keen to waste time and paper by sending you their glossy 200-page merchant account ‘joining pack’ in the post. On the last page in small type you will invariably find these illusively secret figures finally revealed. However, even this was a partial waste of time, as by the time the last ‘pack’ (of six) arrived two of the banks had already restructured their fees. I was still none the wiser.

So I took a step back, and started again from a slightly different angle. I phoned Secpay asking if they recommended any particular acquiring banks, and they helpfully suggested using either EuroConex (which is the Bank of Ireland/Alliance & Leicester) or Lloydstsbcardnet (Lloyds/TSB) if I want to keep cost to a minimum. From there I called EuroConex (based in Ireland) and had to tell them my predicted annual turnover, and average transaction amount. Based on this, they would charge me a one-off set-up fee and a percentage cost per transaction on credit cards (they had a sliding scale from 1.9% to 2.5% at the time), and 24p per transaction on debit cards. They also have to see your website in order to check that what you’re selling is ‘ethical’.

A month later, after further research, I finally decided to go with EuroConex, so phoned them up before filling in the forms. Their prices had soared, now there was a £150 set-up fee (instead of £100) and 3.46% per transaction on personal credit cards (instead of 2.4%). This basically meant that their prices were roughly the same as all the other merchant bankers, and was beginning to see how they’d earned their entry in the dictionary of Cockney rhyming slang. There were two more blows to follow though, this hike in costs meant that I would have to wait for them to send me a new ‘joining pack’ with the new figures, and (and this was my oversight) that I would need to already have my own ‘Business Account’ set up before being considered for an internet merchant account, grrr! Being entirely new to this, I had naively assumed that because a ‘Merchant Account’ is just a different type of ‘Business Account’ that alone would be fine, and hadn’t allowed for this level of banking pedantry.

After further research, and much gnashing of teeth I finally chose to set up my very first business account with the Alliance & Leicester Commercial Bank, due to their offer of a permanently free business current account with internet banking, and also because of their connection with EuroConex (which I thought might help to speed things up a bit). There was a fairly straight forward form to fill in and two types of photographic identification along with verified signatures were required (authorised by two separate officials, e.g. police, teachers, postmasters etc), before finally being accepted 2 weeks later.

Once the business account was sorted, the merchant account joining pack could finally be filled in. Even though this account was essentially with the same bank as my newly granted business account (Alliance & Leicester), yet more identification and verified signatures were required by them. Two weeks passed before Euroconex emailed me saying that their underwriters additionally needed 3 consecutive months of statements from Paypal. Never having used my Paypal account for anything other than buying stuff from eBay I was very concerned that, at this last hurdle, I was going to be refused an account.

Three long weeks passed before I could take no more. I phoned up Euroconex to find that my fears were unfounded. After 3 months of research and form-filling I was now officially ready to accept credit cards over the internet. Who would have thought that such a prospect could be such a relief!

Conclusion Well it’s no easy ride and the caviar is still on ice, but if I’d found an article like this in the first place it would certainly have saved me a great deal of time and stress. Essentially I ended up with the following services which work well together and represent great value for money:

Having read this article it’s my hope that you’ll have a better understanding of the process, even if some of the information may become out-dated over time you’ll still have a good starting point to base your own research upon. Best of luck in creating your own eCommerce site, and consider sending me some canapés in the post when you’ve made your fortune.

Microsoft Great Plains Integration Scenarios – EDI, eCommerce

Microsoft Dynamics GP, successor of Great Plains Software Dynamics and eEnterprise is very popular ERP platform, deployed as accounting back office and integrated with various business management system. Among the most typical scenarios of GP MRP integration are Electronic Document Interface EDI and eCommerce. Let’s consider and compare the methodologies, integration and software development tools, programming techniques and customization option

1. EDI. Electronic Document Interchange is relatively matured technology and typically it is realized in the form of fixed length text formatted files or text streams. Newer approach may consider new generation of similar to EDI in concept XML streams. When we are talking about GP, we should expect two types of EDI integrations – when you are vendor (in this case you receive EDI formatted either Sales Order Processing orders or invoices or Accounts Receivables invoices); and when you are customer (in this case you place EDI purchase orders to your vendors). From the technology standpoint, EDI is not really difficult in standard and even custom realization and programming. Microsoft Dynamics GP, starting with version 8.0, is supported on the only DB platform – Microsoft SQL Server. Current version of Microsoft Great Plains is 10.0, available on MS SQL Server 2005 or 2000. You program EDI streams with SQL select command, and you format text fields with cast or convert constructions. When you import external EDI streams you, it is when you create SOP Invoices, you should consider utilizing eConnect

2. eCommerce. If you are e-commerce programmer, please invest your time in eConnect technology learning. You probably heard about eConnect and about the fact that it was dedicated initially to e-commerce software developers. We would like to sort of popularize eConnect and say this – if you do eCommerce integration from scratch, you have to feed eCommerce orders and invoices into GP tables: SOP10100, SOP10200. However, you should know that eConnect already has this job done for you in eConnect business objects – encrypted stored procedures. There are several situations when you should break through eConnect restrictions. First one is the fact that eConnect replicates Dexterity business logic (DYNAMICS.DIC is Microsoft Dexterity dictionary, where all the core modules business logic is stored) and even trusting astonishing SQL Server performance, you can still have concerns that eConnect might be a bit slow, if you transactions volume crosses thousand records per session. If eConnect performance is in question, you may consider doing simplified integration in SQL stored procedures using insert into logic. The second eConnect limitation is absence of posting logic – in order to post SOP batches you will need to deploy Albaspectrum posting server.

Using Forums To Network Successfully

According to one of the entries found at the definition of the word network is as follows: Something resembling an openwork fabric or structure in form or concept, especially: An extended group of people with similar interests or concerns who interact and remain in informal contact for mutual assistance or support.

The Merriam Webster Online Dictionary at gives the following definition for networking: the exchange of information or services among individuals, groups, or institutions.

Successful networking occurs when the exchange of information or services is amongst people with similar interests or concerns. Maintaining the network of connections provides a networking opportunity when one has new information to exchange with others in this group of individuals.

Recently I decided to put a theory to the test that one of the best ways to develop networking relationships was through the use of online forums. My target audience of response was forums aimed at people involved in affiliate programs, network marketing, or internet marketing of some type. I mostly wanted to see who would respond if anyone and see how much of a response I would get.

I used a piece of software that has both a browser and a way to watch one’s forum posts for responses. In addition to seeing how many people would answer my questions another goal is to get my self-known among forum communities. No one wants to do business with a stranger.

Here is something that I discovered. The small forums that are part of groups such as Delphi Forums and Ezboards have very few posts and when someone does post, the posts are mainly advertising in nature. I would suggest that you are wasting your time if you post to these forums. Is all forum posting a waste of time? Definitely not, as there is much value in it, as you will see by what I write next.

I decided to go to some of the forums of well-known websites or well-known internet marketers and posting there. In creating an account I set up a signature file so that in every post that I made my URL would be shown. I was very careful for the most part to ask questions or give answers. Never once did I post what could be seen as an ad. And guess what the result was.

In the settings of the forums where it was allowed I set the choice so that I would be emailed when I had a response. I was very happy to get emails announcing that people had responded to my various posts in not one but several of these professional forums.

The forums I posted to all had to do with a subject that I am interested in namely affiliate and network marketing on the Internet. The people who responded were very knowledgeable and helpful and I hope that in situations where I answered someone’s question(s) that my answer(s) were of help to them.

What did my experience in the forums prove? By the fact that I shared information with people interested in the same topics as myself and that they shared their information with me it proved that forums are a very important part of networking on the Internet.

In researching to write this article I have also discovered an incredible online tool, basically a website that keeps track of posts to e-commerce websites. It is found at Mike also has a page for watching posts to marketing forums discussing internet marketing and search engines. The link for this is at Although this tool doesn’t watch for replies to your post it can keep you aware of what discussions are going on in these forums. Then if you have questions about the particular subject or answers to someone’s question you can jump into that forum and network with the people in that forum.