Re: [mv] How To Extract Item Codes At Checkout Question: Followup

[cfm@maine.com]

On Sat, Jan 20, 2001 at 10:25:47AM -0700, OTR Comm wrote:
> Christopher,
> 
> 
> cfm@maine.com wrote:
> > 
> > On Sat, Jan 20, 2001 at 02:42:03AM -0700, OTR Comm wrote:
> > > Hello,
> > >
> > > Previously i asked if it is possible to extract the item codes for each
> > > line item in a given session at checkout?
> > >
> > > Is it possible for me to query $Vend::Session->{'carts'}->{'main'} in
> > > Order.pm?  If so, where should I do it before the cart gets dumped?
> > >
> > > What I want to do is write out each item code, description, price, etc.
> > > to a Mysql database for some report generation.
> > 
> > Can you clarify "some report generation"?
> 
> I am developing a 'mall' type shopping environment with minivend.  I
> will be working through a single merchant account for each separate
> store in the 'mall'.  Currently, the 'stores' share pages/ord/asket.html
> and pages/ord/checkout.html.

x items, y merchants in a single checkout, purchaser buys from
mall and merchants settle with the mall after transaction, right?
"Single merchant account for each separate" implies every store
has one and only one merchant account, but it doesn't really matter.
Merchant settlement and shipping is divorced from the purchasing
transaction, yes?  One cart, not multiple carts.

At a minimum, assign attribute for merchant id to each product 
systemwide.  In the report, trigger code to iterate the cart and 
write to database:

  for (@{$Vend::Items}) {
    stuff orders, order_items # whatever schema
    $MERCHANTS_IN_THIS_ORDER{$item->{merchant}}; # unique list
  }
  for (keys $MERCHANTS_IN_THIS_ORDER) {
    %o=SELECT * FROM orders WHERE order_number=$this_order_number;
    %v=SELECT * FROM order_items WHERE order_number=$this_order_number
      AND merchant_id=$this_merchant_id;
    &post_advice($this_merchant,\%o,%v); # might be email, db, whatever
  }


&do_my_behind_the_scene_stuff # can be entirely separate outside mv

cfm

> What I currently do is capture all the transactions after they have been
> 'authorized' by Cybercash and store them in a Mysql database.  Then I
> have an interface , that I wrote , to the Cybercash transaction
> gateway.  With this interface tool, I can control processing of the
> transactions. I have my Cybercash account setup to 'authorize only' and
> not 'settle' the transactions when they come from Minivend.  It is
> through my interface that the user can select transactions for
> processing (i.e.; build batches for marking, settle transactions, void
> transactions, etc.).
> 
> Now this works well for a single store, with its own merchant account,
> but it is not the same paradigm with a 'mall' situation.
> 
> What I need to do is have access to the item code for each line item in
> the checkout form, then be able to capture the information about each
> line item and associate each line item with the current session.  Then I
> need to store this information in Mysql records associated with the
> current transaction.
> 
> What I will do then is group these line items by item code and send an
> email to the 'store' owners to let them know that they some of their
> items have been ordered.
> 
> I am also developing a complete accounting system to control all this,
> but that is a different story.
> 
> Thanks,
> Murrah Boswell
> > 
> > Depending on what you want for report you'd dump it in
> > different way/page/place.
> > 
> > In the typical sequence the cart doesn't get dumped until the
> > report and receipt page are complete.
> > 
> > --
> > 
> > Christopher F. Miller, Publisher                             cfm@maine.com
> > MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
> > 1.207.657.5078                                       http://www.maine.com/
> > Content management, electronic commerce, internet integration, Debian linux
> > 
> > _______________________________________________
> > Minivend-users mailing list
> > Minivend-users@minivend.com
> > http://lists.akopia.com/mailman/listinfo/minivend-users
> 
> 
> _______________________________________________
> Minivend-users mailing list
> Minivend-users@minivend.com
> http://lists.akopia.com/mailman/listinfo/minivend-users

-- 

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Content management, electronic commerce, internet integration, Debian linux

_______________________________________________
Minivend-users mailing list
Minivend-users@minivend.com
http://lists.akopia.com/mailman/listinfo/minivend-users