Creating a shopping cart?

Posted By: mt_liongirl ()
Posted On: 2003-Sep-17 03:32

I am trying to make a shopping cart for my site so I can start adding more products to my business. I am totally lost at what to do next. I have created a database with Microsoft Access, but cannot seem to reach it from my website builder ( which is frontpage 2000 ) I don't even know if I am even on the right track. I know NOTHING about this. All I know is very basic html. My site is hosted by a webhosting service and right now I have a secure order form through them and use my own merchant account to process the orders. I really want to be able to manage my own shopping cart and order form, since right now I have to go through the hosting service to have it edited,
Any help at all would be greatly appreciated. Even if it just a referral to someone that can work with me... or possibly some books??? I am on a very tight budget.
Thank you!


Posted By: jcokos (Staff)
Posted On: 2003-Sep-17 03:57

What you're using to develop your website (Frontpage and Access) has no relation, generally, to how it's going to work on the Internet.

Can you provide an answer to these questions, regarding your hosting company:

1. What operating system is your live web site running under (Unix/Linux or MS Windows) ?

2. What database, if any, do they provide you access to ?

3. What programming languages (perl, php, etc) are you allowed to use on the server?

Remember, your access database is only on your personal computer, not up on your website. You need to be thinking about how to make your website that you design in front page interface with the database that your hosting company provides, using the tools that they'll allow.

Welcome to the wonderful world (nightmare?) of dynamic, database driven websites wink


Posted By: mt_liongirl ()
Posted On: 2003-Sep-17 04:37

Thank you for your answer. I guess I'll start finding the answers to your questions from my hosting company. I know my site is running under MS Windows. I'll check into database access and programming languages. At least now I know where to start and can quit spending hours running around in circles and making myself CRAZY!! Yes, it is kind of a nightmare isn't it?
Thanks again


Posted By: RodB ()
Posted On: 2003-Sep-17 05:37

yup this is a cake walk in Perl.


Posted By: patrickh ()
Posted On: 2003-Sep-17 19:38

It may suck when you start, but it is very rewarding when you make your first database driven page that works properly wink


Posted By: excell (Staff)
Posted On: 2003-Sep-19 16:48

"yup this is a cake walk in Perl."

ok.. so can you expand on that a little please Rod & Patrick.

Can you point to some customisable starting points for building a store manager in perl?

Can you provide some examples URLs of sites you have built please. (pm me some URLs if you feel it inappropriate to post).

I'm currently on a Unix box and looking at perl or PHP programming as the best choice so far. mysql available, but what ever we build we want it to be fast and lean and not resource hungry.

If our current server is going to be inadequate for our needs we will be looking at finding an additional hosting service that does.

I think that there are many developers and webmasters looking for robust, but easy to manage customisable e-commerce and CMS solutions for clients. The need to be search engine friendly is obvious but things like reliability, security, speed and resources are some of the other issues.

I'm getting a little desperate timewise now as we have downloaded just about everything out there, spent so much time and I don't know that we cannot spend much more time.

Our biggest problem seems to be in making the thing scaleable, everything seems to have way too much functionality and bells & whistles that are not wanted.

Anyway if you think you can help, I am all ears at the moment.... I am not the one that would be working on this side of things but my techy partner just is taking too much time out of our productive workload time for me to allow him to continue much longer.. He would be perfectly happy to *tinker* forever to build the perfect thing. LOL

In the meantime there is work to be done and requirements to be met, so any help would be appreciated.


Posted By: patrickh ()
Posted On: 2003-Sep-19 19:26

I am working on a site and plan on using PHP and MySQL to build my shopping cart, this tutorial seems to cover all the bases:

link.

It does assume you have knowledge of PHP and MySQL, if you have experience with those it should be pretty easy to follow.


Posted By: RodB ()
Posted On: 2003-Sep-20 05:35

In its simplest form you need a database of the products and the prices and the shipping costs. So that is three columns in the DB. A .csv or pipe seperated database would be fine.

You need a secure order form in HTML and a perl script to write the order to your server where you retrieve it with a secure FTP program? The perl script would in its simplest form need to extract the items from the database and display the items. Even this need not happen as the items could be hard coded into your secure order pages depending on the number of items - one of the commercial database extraction programs would write say 250 items into HTML in about 10 seconds.

Script then needs to capture billing and delivery data plus credit card info and write it to your server. All told about 15 fields maybe 300 lines of code? A really sexy one might go up to 1500 lines of code.


Posted By: RodB ()
Posted On: 2003-Sep-20 05:45

Going back about 4 years before I started with my own scripts I bought "Shopmaster" at Jim Wilsons suggestion to solve exactly this problem. I am not sure if you can still get the actual software anymore. They even provide a secure gateway. I still use the gateway today. There must be a number of them. Before that I used a javascript one because I was on a real cheap host with no cgi access.


Posted By: rjzak ()
Posted On: 2003-Sep-20 11:26

It would also be nice to add columns for the following...

- on sale price
- how many items you have in inventory
- item status column to indicate instock, backordered, discontinued, etc.
- a date column of when you expect to get out of stock inventory to be back in stock
- a product id column (so you can feel free to change the product name later)
- dropshipper/wholesaler/manufacturer ID #
- dropshipper/wholesaler/manufacturer SKU

Then, in your DB design and cart design you may want to put in the hooks for offering quantity/volumn discounts, or free shipping for orders over $50.

Along those lines, it may also be a good idea to build in support for promotional codes that you can give out to your marketing partners to give them special deals.


Posted By: patrickh ()
Posted On: 2003-Sep-20 14:23

promotional codes should most definantly be in their own table, just three columsn (id, name, discount). I am currently working with a product database provided by a dropship disctributer, and the way that have it up leaves a bit to be desired (they have everything crammed in one table).


Posted By: Ron C ()
Posted On: 2003-Sep-20 16:35

Shopping carts, like any e-commerce application, are a software model of a real-life business situation. Ideally, of course, your specific business should be no more complex than absolutely necessary, so your shopping cart should be equally simple. That only holds, however, if every e-business writes their own custom application.

The moment a shopping cart tries to be all things to all businesses, the complexity escalates on a geometric scale. The more ambitious the cart tries to be, the more complicated becomes the database and the code. You get more power and flexibility, but not without a cost. It becomes much more difficult to configure, and much more expensive to maintain. And heaven help you should you ever want it do something outside its design parameters.

My advice has always been to sit down for an hour or two, and write down every single detail of a fictional, all-encompassing transaction in your particular business. What data is necessary to complete a transaction, where the does the data come from, where does the data go. You are charting the data flow, an absolute prerequisite to determining your needs.

I like to do this on big 4x6 index cards, numbering each card as I create it. Take a card, for example, and write a one- or two-line sentence about your inventory, then number the card 10. Does the inventory come from a database? Is it static or dynamic? Could it be both?

Take another card and write down a description of your "display" mechanism. Do you want static HTML pages or dynamic CGI pages? Label this card number 20. You want to leave gaps in your numbering system, so that later you can insert new cards if needed.

Will you display one product per page? Or multiple? Can the shopper select more than one item? Every time the shopper does something (or can do something), you need to insert at least one new card, possibly several. If the shopper has two choices, you need two cards. If he has three choices, you need three cards. Your numbering scheme should allow all of your cards to be laid out in a giant pyramid, though it need not (and probably won't) be balanced. Some data flow lines will end up being much longer and more complex than others.

At the end of a few hours, you should know EVERYTHING you want a shopping cart system to do for you. It's fine to look into the future, what do you want it to do six months from now, but realize that every such prognostication will carry a cost in complexity. Don't let your data flow become a wish list, else it will no longer be a true reflection of your business model.

Now, just go find the simplest available shopping cart that does everything you need, avoiding the bells and whistles you don't need. smile

p.s. No, it won't be quite that easy. As you read about shopping carts, as you install and test shopping carts, you are going to find a few holes in the data flow you so laboriously created. Things you plumb forgot. But that's okay, because you left gaps in your numbering and those new steps can still be added. Do so, then keep looking.

p.p.s. SAVE THOSE DATA FLOW CARDS! You'll find a few hundred other uses for them as you build your on-line business.

smile



Posted By: unreviewed ()
Posted On: 2003-Sep-20 16:58

Ron, I still drop in now and again and read the reviews you did on many of the carts available, I know you havin't worked on the content for sometime, but it's still a wonderful resource. http://rcarnell.com/


Posted By: Ron C ()
Posted On: 2003-Sep-21 00:37

Thanks, Bill. If you saw a recent post I made about keyword research for a soon-to-be resurrected project, you might have even guessed that the currently VERY decrepit condition of my flagship domain is about to change. The local college I originally did the work for has finally opened the doors for their A.A. in E-Commerce I helped design, so I'm dusting off the cobwebs, cleaning up the mismatched site designs, and hope to be adding new content by the end of the month.

smile



Posted By: RodB ()
Posted On: 2003-Sep-21 06:35

Excellent advice from RonC

"Now, just go find the simplest available shopping cart that does everything you need, avoiding the bells and whistles you don't need."

and

"Ideally, of course, your specific business should be no more complex than absolutely necessary, so your shopping cart should be equally simple. That only holds, however, if every e-business writes their own custom application"


Posted By: unreviewed ()
Posted On: 2003-Sep-21 12:35

That is great news Ron, it's unique, and I'm surprised that there isn't more of that type of information out there already, because it is vital info. Another big plus of the site is that you explain the subject material so well. If there is ever anything I could do to help out, you have my email. Regardless, I'll be a unofficial and frequent beta tester. wink


Posted By: patrickh ()
Posted On: 2003-Sep-24 22:17

I've got a hobby eCommerce (dropship) site I have been working on, and the last step I really have is making the shopping cart. Tonight I am going to officially sit down and try to tackle it head on with PHP and MySQL... wish me luck! If I can get past this hump, all I will need to do is cleanup the design a bit, then sit back and watch the site make no money at all :D.

[ Message was edited by: patrickh 09/24/2003 02:18 pm ]




Posted By: mattfe ()
Posted On: 2004-Nov-04 01:00

If you don't want to remove the hair on your head struggling with doing it yourself (nice if you can though!) I can suggest a good off the shelf solution that integrates with a popular SSL cart.

PM me for details


Posted By: mattfe ()
Posted On: 2004-Nov-05 07:56

hmmm that's not so cheap....