[ic] total adjustment upon item cancellation in admin

Mike Heins interchange-users@interchange.redhat.com
Sat Jan 5 16:44:00 2002


Quoting Steve Bourg (ml_interchange@integrity.bourg.net):
> Hey All,
> 
> I've built a few sites off of the construct & foundation demos pretty
> successfully (yay!).  One of the not-yet-complete features of the admin is
> that the order's product total, shipping total,
> tax total, and grand total are not adjusted when an item within the order
> has been
> cancelled.  This is confusing customers when the updated emails go out
> and also gives the burden or manual recalculation to the merchant.
> 
> I'm aware that the various areas of the demo and admin that reflect
> these
> calculations pull from a single transactions record vs. recalculating the
> line items from the orderline table.
> 
> I would like to be able to update the transactions record when a
> transactions line item is set to a cancelled status.  I've been told, and
> it appears that the calculation functions are dependent upon the use of
> carts.  I hope to approach this by simply sending the pertinent aggregate
> info needed to calcuate (weight, size, product total, etc for
> shipping) without recreating a cart within the admin.  Can anyone guide me
> on the approach and/or direct me to documentation for this?
> 

There is no documentation for a function that does not exist.

This is the type of thing an ERP or accounting system does, not
what an online ordering system does.

In particular, it would be very difficult to adjust the total cost
without re-calculating the shipping and tax, which depends on the user's
geography.

It would NOT be difficult to build a screen for recalculation of the
transaction record. If you want Interchange to be an accounting system,
you will have to do the programming yourself. 8-)

Simply do a query on the orderline database for that order number,
discard the item subtotal for each cancelled item, and total that.
Provide a user input to adjust the shipping cost or tax manually,
and total each of those to get the new total cost.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

Light travels faster than sound. This is why some people appear bright
until you hear them speak. -- unknown