Re: [Zope] Another Zope E-Commerce Site Online
On 8 Dec 2000, at 8:14, Cees de Groot wrote: The nice thing about the checkout sequence is that you can move backwards at any time without losing the entered data. Also you can jump out to shop more, jump to the privacy, shipping and returns policy and your entered data isn't lost. As my ebusiness site has trouble with exactly that point, would you care to elaborate on how you accomplished that? It'd be nice to peek at someone else's solution before running off and reinventing wheels :-) When users proceed from Shopping Cart to Checkout, we create an SQL record for the order. This record holds their billing and shipping information, charge card result code (not the credit card number of course). If you examine the checkout sequence, you'll see that the only way you can leave it (other than by the nav bar, which will soon be fixed too) is by clicking on an image. All of these images are part of the form. Clicking on any image causes the contents of the form to populate the database record. If you clicked on 'next', we also validate your inputs. If your input passes validation, we increment a "nextPageAllowed" SQLSession integer. This controls which page you can move to.. So naturally you can move backwards to any page you've completed, we retrieve the data from the SQL record to populate the form. When you hit page 3, we populate a LINEITEMS table by dumping the contents of your shopping cart (which is an SQLSession dict). During the population of LINEITEMS, we calculate sales tax, shipping costs, etc and record all the costs in the ORDER record. We then display on step 3 the LINEITEMS records and the costs from the ORDER record, since this is what the actual cc charge will be based on. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
[EMAIL PROTECTED] said: [ an awful lot on the workings of his ecommerce site ] Thanks, Brad. A lot of very useful information, and it'll surely help me in building version 2 of our stuff (v1 was a quick 1.5wk hack because of deadlines, I can now take things "easy", like in 1.75wks :-)). -- Cees de Groot http://www.cdegroot.com [EMAIL PROTECTED] GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
Brad Clements wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com Hmm. I get: Zope has encountered an error while publishing this resource. Error Type: TransactionError Error Value: A serious error, which was probably a system error, occurred in a previous database transaction. This application may be in an invalid state and must be restarted before database updates can be allowed. Beware though that if the error was due to a serious system problem, such as a disk full condition, then the application may not come up until you deal with the system problem. See your application log for information on the error that lead to this problem. -- http://www.mk.w.pl / Marcin.Kasperski | Sztuczki i kruczki w C++: @softax.com.pl | http://www.mk.w.pl/porady/porady_cplusplus @bigfoot.com \ ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
Transaction Error too Are you trying to do session management and/or database querys in two different frames? On Qua 06 Dez 2000 16:16, you wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com Come buy something, but don't whack it too hard, this site is still a work in progress (aren't they all?) -- This site was "thrown together" in about 5 days for a disorganized customer, came online just 30 minutes before it's first sale. They had a big ad in the New York Times which pushed the deadline. - Zope 2.2.4 with Interbase, gvibDA and Wampum Generator running behind Apache with mod_proxy and mod_ssl, on RH Linux 7. I'm thinking of writing a white paper on this entire experience, from a consulting point of view and a programmer's viewpoint. Not sure how useful that would be to anyone. There were 2 graphics/layout designers and myself working directly with the customer to go from concept to completion in an extremely short timeframe. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design --- [EMAIL PROTECTED] www.magicwebdesign.com.br Curitiba - PR - Brasil ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Another Zope E-Commerce Site Online
On 6 Dec 2000, at 19:51, Lee Hunter wrote: Site looks beautiful but I would *never* have guessed that it was an ecom site unless you told me. Even then it was just by accident that I clicked an image and came to a price and description. Maybe that's the part you were refering to as being in progress. Otherwise the site works great. Thanks for your comments. I mentioned this to the site owner a few weeks ago.. It takes too many clicks to get to buy something. We're just now adding a "browse by products" page, which itself is still a weak concept in my mind. This is an object lesson.. leave plenty of time for usability testing. The result of rushing the project to meet an ad publication date really shows in many areas of the site, including transaction errors mentioned by others. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
On 6 Dec 2000, at 22:48, Jason C. Leach wrote: hi, How long did it take? And what level of Zope(xpertese) where you at whe you started? Did you have to do that shopping cart from scratch? This site was "thrown together" in about 5 days for a disorganized customer, came online just 30 minutes before it's first sale. Zope expertise? Based on the crass errors I've made putting this site together I'd say I'm a new-bee. See my other post about what makes "the cart". Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
On 6 Dec 2000, at 23:54, Bill Welch wrote: Maybe you just looked at the catalog and didn't notice what's in the checkout. Having spent the past month setting up a site with Etailer, I would have to completely disagree with you. If Brad started with Etailer (I suspect he did, the checkout sequence has an Etailer look), it would have taken a lot of hard core programming, not graphical work, to get to where he is in 5 days. I haven't looked at Etailer. I did download zCommerce for a look, but was concerned about using ZPatterns. I've used LoginManager and it works well, but the terminology used in ZPatterns always gives me a headache. Clearly a shortcoming on my part - if I could understand what it does I'd probably use it. In the end, I already had the product database and the "shopping cart", so all I needed was the checkout sequence and cybercash charging. The checkout sequence is based on pages that the web designer gave me, and she copied the design from someone else's site. The nice thing about the checkout sequence is that you can move backwards at any time without losing the entered data. Also you can jump out to shop more, jump to the privacy, shipping and returns policy and your entered data isn't lost. We of course don't keep the CC number info if you leave page 3 by any means other than "Purchase". But everything else is kept. 1) Etailer doesn't support separate billing and shipping addresses 2) ETailer doesn't support a shipping fee, much less shipping alternatives Oih, shipping is a total headache with this site. The current shipping charge is based on a table by total purchase price. We really need to support actual charging by carrier/service/destination. That's simple to do but I ran out of time. The big headache is that each product is likely shipped from a different "artisan", so the site owner encounters multiple shipping charges, but the customer really can only be charged once for shipping. 3) Etailer doesn't do taxes. We have to charge tax for ship-to Zips in New York State. We use a tax table by Zip to get the tax rate. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
On 6 Dec 2000, at 21:57, Bill Welch wrote: I found the shopping cart interesting. Did you start with an existing package or write it from scratch? Are you willing to share it? There are four major parts to this system. 1. product inventory and descriptions - kept in Interbase, images in Zope 2. Shopping cart - track qty of each item put in basket, this is just a dict stored in an SQLSession object 3. The checkout sequence - Interbase tables with Python code to populate them as each checkout step is completed 4. Charging the card - Wampum generator calling Cybercash. Item 1 is very specific to this site, so there's nothing really worth sharing there. Item 2 is trivial easy Item 3 A lot of this is from my "toolbox" built on SQLDict. I'm hoping someday I can give it away, but my current customers have paid for it and aren't willing to give it up. Maybe next quarter when the current contracts are complete. Item 4 Not mine, but I have some fixes to give back when I get my brain working again to do a decent job. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online - Transaction Errors
On 7 Dec 2000, at 9:41, Diego Rodrigo Neufert wrote: Transaction Error too Are you trying to do session management and/or database querys in two different frames? Thanks to everyone who emailed me about transaction errors, here's what was happening so you can avoid it too. First, we're using Interbase on Linux. Apparently there's a bug in the Linux Interbase client that causes the client connection to dropped if no DB requests are made within .. (5 minutes?) There's a fix in gvibDA that works around this by generating a dummy select before any query() is executed. If an exception is raised in the dummy select, the db-api connection is deleted and a new one opened. This fix seems to work pretty well. But I'm also using a gvib db-api connection from within Python code called through external methods. This second connection is used with SQLDict. I've wrapped it up with THUNK Zope code so SQLDict can participate in Zope's transaction machinery. Unfortunately I did not have the Linux-broken-pipe-fix in my SQLDict code, so that second connection could fail. The second connection is only activated when a person selects "Checkout". SQLDict registers itself with the transaction manager, then creates a cursor and executes an sql request. This causes an exception to be raised (broken pipe). The Zope transaction manager does a rollback, which causes this second interbase connection to try to call rollback(), which raises another broken pipe exception. This second exception within the transaction rollback causes a system- wide failure and Zope disables all further transactions, which then kills the entire site. -- The solution was to add the broken-pipe handling code to the external method before making calls into SQLDict. Unfortunately my first fix was wrong, so it didn't work, but I think I have it right now. This brings up a good issue. How do you work on a live Zope site without causing serious problems? Versions only go just so far. Fortunately, because I'm using SQLSession to hold the shopping cart contents, I can restart Zope at any time without killing off active shopping carts. -- Hopefully there will be a fix for this interbase client bug from the firebird group soon. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
Brad Clements [EMAIL PROTECTED] said: I haven't looked at Etailer. I did download zCommerce for a look, but was concerned about using ZPatterns. I've used LoginManager and it works well, but the terminology used in ZPatterns always gives me a headache. Clearly a shortcoming on my part - if I could understand what it does I'd probably use it. Nope, it's a shortcoming on the authors' part. At least that's my current opinion, because everytime I've come across a technology I had trouble understanding, it turned out to be a worthless technology or a good one where the authors had trouble explaining their stuff. For the time being, I've placed zPatterns in the latter category ;), and I dearly wish they'd taken more conventional terms. The nice thing about the checkout sequence is that you can move backwards at any time without losing the entered data. Also you can jump out to shop more, jump to the privacy, shipping and returns policy and your entered data isn't lost. As my ebusiness site has trouble with exactly that point, would you care to elaborate on how you accomplished that? It'd be nice to peek at someone else's solution before running off and reinventing wheels :-) -- Cees de Groot http://www.cdegroot.com [EMAIL PROTECTED] GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
I found the shopping cart interesting. Did you start with an existing package or write it from scratch? Are you willing to share it? Bill. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Another Zope E-Commerce Site Online
Nice site A small suggestion for the shopping basket. It is really great the way you describe the 4 steps involved in making a purchase. But it would be really nice if you added som information allready in step one in regard to payment methods. I would get rather crossed if I got to step 4 and found out that my prefered method of payment wasn't included. I would also be more inclined to buy if I could see upfront that I could use my Visa. Furthermore Icons with credit cards, verisign etc. on the payment page make customers trust the site several times more than sites without it. (It's been tested) Regards Max M Max M. W. Rasmussen,Denmark. New Media Director private: [EMAIL PROTECTED] work: [EMAIL PROTECTED] - Specialization is for insects. - Robert A. Heinlein -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brad Clements Sent: Wednesday, December 06, 2000 7:17 PM To: [EMAIL PROTECTED] Subject: [Zope] Another Zope E-Commerce Site Online Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com Come buy something, but don't whack it too hard, this site is still a work in progress (aren't they all?) -- This site was "thrown together" in about 5 days for a disorganized customer, came online just 30 minutes before it's first sale. They had a big ad in the New York Times which pushed the deadline. - Zope 2.2.4 with Interbase, gvibDA and Wampum Generator running behind Apache with mod_proxy and mod_ssl, on RH Linux 7. I'm thinking of writing a white paper on this entire experience, from a consulting point of view and a programmer's viewpoint. Not sure how useful that would be to anyone. There were 2 graphics/layout designers and myself working directly with the customer to go from concept to completion in an extremely short timeframe. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
Maybe you just looked at the catalog and didn't notice what's in the checkout. Having spent the past month setting up a site with Etailer, I would have to completely disagree with you. If Brad started with Etailer (I suspect he did, the checkout sequence has an Etailer look), it would have taken a lot of hard core programming, not graphical work, to get to where he is in 5 days. 1) Etailer doesn't support separate billing and shipping addresses 2) ETailer doesn't support a shipping fee, much less shipping alternatives 3) Etailer doesn't do taxes. Adding even one of the above features means touching a lot of python, management dtml, and user dtml. 4) Etailer sorts options alphabetically. 5) Etailer uses the variable name as the label on forms, i.e. Firstname in CheckOut. Makes for ugly shipping address vs billing address forms unless you extend the required_properties code to support labels. More python, management dtml, and user dtml. Nothing wrong with Etailer, but there's a lot to Brad's site that Etailer doesn't handle. Bill. On Thu, 7 Dec 2000, Terry Kerr wrote: Hi, Looks good. 5 days eh?. I think one graphics artist could have done it in less than two days using Etailer (e-tailer.adroit.net)...except for the Wampum bit...I am hoping someone will add this in soon. terry Brad Clements wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
Bill, No I didn't look at the checkout. It just seemed that the catalog was a perfect fit. terry Bill Welch wrote: Maybe you just looked at the catalog and didn't notice what's in the checkout. Having spent the past month setting up a site with Etailer, I would have to completely disagree with you. If Brad started with Etailer (I suspect he did, the checkout sequence has an Etailer look), it would have taken a lot of hard core programming, not graphical work, to get to where he is in 5 days. 1) Etailer doesn't support separate billing and shipping addresses 2) ETailer doesn't support a shipping fee, much less shipping alternatives 3) Etailer doesn't do taxes. Adding even one of the above features means touching a lot of python, management dtml, and user dtml. 4) Etailer sorts options alphabetically. 5) Etailer uses the variable name as the label on forms, i.e. Firstname in CheckOut. Makes for ugly shipping address vs billing address forms unless you extend the required_properties code to support labels. More python, management dtml, and user dtml. Nothing wrong with Etailer, but there's a lot to Brad's site that Etailer doesn't handle. Bill. On Thu, 7 Dec 2000, Terry Kerr wrote: Hi, Looks good. 5 days eh?. I think one graphics artist could have done it in less than two days using Etailer (e-tailer.adroit.net)...except for the Wampum bit...I am hoping someone will add this in soon. terry Brad Clements wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) -- Terry Kerr ([EMAIL PROTECTED]) Adroit Internet Solutions (www.adroit.net) Phone: +61 3 9563 4461 Fax: +61 3 9563 3856 ICQ: 79303381 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Another Zope E-Commerce Site Online
Site looks beautiful but I would *never* have guessed that it was an ecom site unless you told me. Even then it was just by accident that I clicked an image and came to a price and description. Maybe that's the part you were refering to as being in progress. Otherwise the site works great. Cheers Lee Hunter Hum Communications Ltd. Brad Clements wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com Come buy something, but don't whack it too hard, this site is still a work in progress (aren't they all?) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
hi, How long did it take? And what level of Zope(xpertese) where you at whe you started? Did you have to do that shopping cart from scratch? j. .. . Jason C. Leach ... University College of the Cariboo. .. On Wed, 6 Dec 2000, Brad Clements wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com Come buy something, but don't whack it too hard, this site is still a work in progress (aren't they all?) -- This site was "thrown together" in about 5 days for a disorganized customer, came online just 30 minutes before it's first sale. They had a big ad in the New York Times which pushed the deadline. - Zope 2.2.4 with Interbase, gvibDA and Wampum Generator running behind Apache with mod_proxy and mod_ssl, on RH Linux 7. I'm thinking of writing a white paper on this entire experience, from a consulting point of view and a programmer's viewpoint. Not sure how useful that would be to anyone. There were 2 graphics/layout designers and myself working directly with the customer to go from concept to completion in an extremely short timeframe. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Another Zope E-Commerce Site Online
hi, You shoud add it to the Zope site's list of Zope sites. j. .. . Jason C. Leach ... University College of the Cariboo. .. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Another Zope E-Commerce Site Online
Ooops I get a Zope transaction error when I go there Ian Cottee ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )