Forum OpenACS Q&A: OpenACS Shoppe

Collapse
1: OpenACS Shoppe
Posted by Tim The Evil on 02/27/01 02:48 AM
Hey, is there an equivalent to the ArsDigita Shoppe in the OpenACS
toolkit?  We're thinking about using it at work but would like
similar out-of-the-box functionality.  I've only used the bboard and
classified modules so far.

thanks!

Collapse
2: Response to OpenACS Shoppe (response to 1)
Posted by Ryan Campbell on 02/27/01 05:20 AM
Well, Shoppe is essentially a light weight version of the Ecommerce module, which included in the OpenACS.  You could theoretically use Shoppe instead of the included Ecommerce module, but it would be more work (porting any Oracle specific stuff) for less functionality (like customer reviews, templating, product catalog, reporting, etc).

You probably would only want to use Shoppe if you didn't want to install the OpenACS.  I recommend that you check out the OpenACS ecommerce module instead.

Collapse
3: Response to OpenACS Shoppe (response to 1)
Posted by Janine Ohmer on 02/27/01 04:53 PM
Shoppe has it's place;  if you want to sell soft goods, like an
online job listing or an event signup, it gives you what you need
without a lot of overhead.

I've only used it with Oracle, though;  we don't have a Postgres
version.

Collapse
4: Response to OpenACS Shoppe (response to 1)
Posted by Todd Gillespie on 02/28/01 08:55 PM
Last year I ported aD Shoppe to Postgres to demo an ecommerce site with OpenACS. The tarball is here. It worked for me, but be warned - I haven't touched those sources since last June. Moreover, there *have* to be at least some queries that are still incorrect; I didn't need all the pages.

Shoot me an email when you hit a bug...

Collapse
5: Response to OpenACS Shoppe (response to 1)
Posted by Budi Wiyono on 06/13/01 08:51 AM
Dear Tim,

My postqres shoppe could not work.
How to fix the problem ?

[Wed Jun 13 13:45:08 2001] [error] [client 127.0.0.1] [uri: /shoppe/]
  no such pool: clickpool
[Wed Jun 13 13:45:08 2001] [error] [client 127.0.0.1] [uri: /shoppe/]
  registered_proc blew up --- backtrace follows:
could not allocate 1 handle from pool "clickpool"
    while executing
"ns_db gethandle clickpool $howmany"
    (procedure "sh_gethandle" line 2)
    invoked from within
"sh_gethandle"
    invoked from within
"set db [sh_gethandle]"
    (file "/var/opt/www/my_openacs/www/shoppe/index.tcl" line 12)
    invoked from within
"source $ad_conn(file)"
    (procedure "ad_handle_abstract_url" line 67)
    invoked from within
"ad_handle_abstract_url conn {}"
[Wed Jun 13 13:45:08 2001] [notice] [client 127.0.0.1] [uri: /shoppe/]
  Querying '
                update sec_sessions
                set last_hit = 992414708
                where session_id = 15;'
[Wed Jun 13 13:45:08 2001] [notice] [client 127.0.0.1] [uri: /shoppe/]
  sql(localhost:5432:my_openacs):
                update sec_sessions
                set last_hit = 992414708
                where session_id = 15

Collapse
6: Response to OpenACS Shoppe (response to 1)
Posted by John Lowry on 06/13/01 11:36 PM
Budi, It looks like this code requires a database pool called "clickpool". Have you defined one with this name in your AOLserver initialization file? By default, only "main", "log" and "subquery" are configured.
Collapse
7: Response to OpenACS Shoppe (response to 1)
Posted by Todd Gillespie on 06/14/01 04:58 AM
Budi, setting up Shoppe correctly is covered in the docs.  In the OpenACS tree, it's found at /www/download/doc/shoppe.html.  It's also in the tarball found at the link I posted above.