[ic] Won't update inventory.

MITECH Trading interchange-users@lists.akopia.com
Thu Aug 2 09:15:00 2001


I did have the code in the log_transactions file and I added the variable to
my variable table and it still didn't work. However, I found a post from Guy
Soudant suggesting to add the following code to log_transaction:

[comment][perl] Log("Past transactions entry.");
[/perl][/comment][item-list]Added [item-code] to orderline: [import
table=orderline type=LINE continue=NOTES]
code: [value mv_order_number]-[item-increment]
store_id: __STORE_ID__
order_number: [value mv_order_number]
session__MVC_FIELDMUNGE__: [data session id]
username: [data session username]
shipmode: [item-modifier mv_shipmode]
sku: [item-code]
quantity: [item-quantity]
price: [item-price noformat]
subtotal: [item-subtotal noformat]
size__MVC_FIELDMUNGE__: [item-modifier size__MVC_FIELDMUNGE__]
color: [item-modifier color]
order_date: [value order_date]
affiliate: [data session source]
campaign: [value campaign]
status: pending
description: [filter mac][item-description][/filter]
[/import]
Inventory now: [data table=inventory col=quantity key="[item-code]"
increment=1 value="-[item-quantity]"]
[/item-list][/try]
[catch] There was an error adding to the transaction log. [/catch]
[if scratch auto_create]
 Logout auto-created user: [userdb logout]
 [value name=mv_username set=""]
[/if]
[comment][perl] Log("Past add data entry."); [/perl][/comment]

I have no clue about what it is doing but it helped.

Well I still have a problem with the out of stock notice:

SKU# 00007 comes in red and blue. I have made options for that and get
00007red and 00007blue with each their quantities on hand.
When one of the colors is out of stock, there is no out of stock notice
comming up.
The out of stock notice is controlled by 00007, and in this case the 00007
inventory never change. Only 00007red and 00007blue change when items is
purchased.

Are there any way to get a out of stock notice when one of the colors is out
of stock?

Regards
Mike








----- Original Message -----
From: "Brian Kosick" <briank@nacs.net>
To: <interchange-users@developer.akopia.com>
Sent: Wednesday, August 01, 2001 9:06 PM
Subject: Re: [ic] Won't update inventory.


> Well,
>          take a look at the etc/log_transactions file
>
> it has a little snippet of code:
> [if variable DECREMENT_INVENTORY]Inventory of [item-code] now:
>          [data
>                  table=inventory
>                  col=quantity
>                  key="[item-code]"
>                  increment=1
>                  value="-[item-quantity]"
>          ]
> [/if]
>
> If you DON'T have a variable called DECREMENT_INVENTORY set, it won't
> decrement it.
>
> try adding
> DECREMENT_INVENTORY  to vour variable database.  You don't need to give it
> a value, it just checks to see if it's set.
>
> Not positive though, as all the IC catalogues I've setup my clients don't
> care about that feature as they already have something to take care of it
> in-house.
>
>
> At 06:41 PM 8/1/01 -0400, you wrote:
> >IC 4.7.7  RH 6.2  PERL 5.6  MySQL
> >
> >When I purchase an item, the quantity don't change in the inventory.
> >I tried the online demo and it seems to be the same.
> >
> >Does anyone know what the problem can be?
> >
> >Regards
> >Mike
> >
> >_______________________________________________
> >interchange-users mailing list
> >interchange-users@lists.akopia.com
> >http://lists.akopia.com/mailman/listinfo/interchange-users
>
> Brian Kosick
> Web Programmer
> New Age Consulting Service, Inc.
> 216-619-2000
> briank@nacs.net
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>