Although this site has been produced for specific courses and groups of students it is designed as a public resource. If you find it useful then please let me know.

If you want to comment feel free to do so and if you find something wrong get in touch.

hide alert

Building e-commerce with OSCommerce

Written by: Jonathan Briggs

November 18, 2005 [7578 views]

My colleage Jarek Francik presented a step-by-step guide to setting up OScommerce using WAMP (windows+apache+mysql+php) on Friday. Here are some notes I wrote when I ran the similar session last year.

One of the challenges for this module is to find ways of building an online business without needed to create code. There is a considerable difference between a professionally developed highly integrated store and a bolt-on or experimental first-time online shop.

Advantages of lost cost ecommerce
  • Allows inexpensive experimentation
  • Allows development to be focussed on business and marketing
  • Allows initial income to fund future development
Disadvantages
  • Unsuitable for established brands (without considerable effort or white labelling)
  • Hard to integrate with off-line business processes
  • Hard to customise customer experience
  • Tends to look like it has been created from a standard template
  • May be harder to promote
Possible approaches
  • eBay
  • Amazon Marketplace
  • Actinic or other “shop in a box” software
  • OSCommerce
  • Outsource to a professional development company
Factors to take into account
  • Cost – what is the maximum budget that is available for construction and marketing?
  • Hosting – do you want to host your own store or let someone else host it for you?
  • Expected Return on Investment (ROI) – many “cookie cutter” stores generate very small amounts of revenue
  • Technical skills – running Actinic or OSCommerce will still require at least a minimum understanding of the technology beneath
Signing up for Amazon Marketplace
  1. Sell within the Amazon.co.uk environment
  2. Benefit from existing traffic, promotions and brand value
  3. Low cost starting point if you have only a few items to sell.
  4. Ideal for collectables and second hand goods (like eBay).
  5. Your products will appear alongside other Amazon sellers and regular Amazon items and will appear in search results
  6. Amazon takes the orders, you are responsible for the shipping.
  7. Take care to make sure that you fulfil orders promptly or Amazon will blacklist you.
  8. Amazon charges £0.86 an order plus 17.25% of the order value plus a percentage of the postage fee charged
Experimenting with OSCommerce
  1. Find a hosting agreement that allows installation and configuration of LAMP (Linux, Apache, MySQL and PHP) or WAMP (Windows+) components. To simply experiment install everything on your own PC.
  2. Register a domain and point it at the hosting space you have rented.
  3. Install Apache into the root of this hosting space and make sure that you can see it from outside.
  4. Install MySql into a directory. Make sure that you set the permissions correctly as OSCommerce needs to be able to be a user of this database.
  5. Install OSCommerce into its own directory following the instructions carefully.
  6. Alter the apache configuration file to make PHP active
  7. Run OSCommerce and launch the installer
  8. Once set up the store is fairly easy to manage and seems quite powerful. Stock is added manually with explicit stock allocated to the store. A variety of different browsing methods is provided and pricing, shipping calculation, payment and special offers are all supported.
  9. There are a variety of modules available to extend the software including PayPal and other payment partners.
  10. This would be a good place to start an e-commerce project if you are planning on learning PHP as all of the source code is accessible and you can make any changes you want.

Recent comments:

On November 20, 2005 at 5:34 PM, David Fretwell wrote:

Johnathon. I would like to try out the OS E-commerce site so if you could assign me a "play area" to experiment with that would greatly appreciated. I am assuming we should just give you the money to add a SQL Database to the hosting package next week.

Thanks

David Fretwell

www.youngcritics.com

On November 21, 2005 at 7:51 PM, Mitul wrote:

Hi,

I was wondering if it would be possible to have a brief lecture on 'XML' and how it can allow different systems to communicate i.e. supplier system and website.

Cheers,

Mitul

Jonathan replies: Its in the plan.

On November 23, 2005 at 11:03 AM, Nalini wrote:

A really good site with tutorials for installing PHP, MySQL and apache is below.

http://www.ricocheting.com/server

Jonathan replies: Thanks Nalini - very good link.

On November 24, 2005 at 5:51 PM, Onno wrote:

Would it be possible if you if you provided some addional information about UK laws regarding ecommerce?.

By looking around I found one article describing that there exists a return policy for non-food items that comes into play with distant selling.

I have also heard it is illegal to sell unless the product is in stock, meaning that an ecommerce solution needs a stock control system too.

Thanks

http://insight.zdnet.co.uk/internet/ecommerce/0,39020454,2137101,00.htm

Jonathan replies: Here are a few of the other laws involved.

On January 6, 2006 at 4:05 PM, akbar mahomed wrote:

any chance of putting jareks powerpoint lecture on here

Jonathan replies: Here is a zip file with his notes in them. Jarek's notes (9 KB)

On January 6, 2006 at 4:14 PM, Babz wrote:

I tried to setup OsCommerce on a home system using the WAMP setup, I had some difficuilties but eventually i took a short cut i went to www.easyphp.org
downloaded and installed the easyphp 1.8 package, this included PHP, APACHE & MYSQL. It was a pretty easy installation, and i installed OsCommerce, and everything seems to work perfect.

Rgds

Babz

www.easyphp.org

What do you think?







Add your comments