This may sound dumb but is there a specific location around line 283 that
this has to go into? I have tried it everyplace I can find around line 283
and it does absolutly nothing at all. Nothing updated and no change.
HELP.
Shawn
----- Original Message -----
From: "Christie Walker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 06, 2001 7:50 AM
Subject: [FreeTrade] Marking skus/items inactive if out of stock
> Here's some code you might find useful if you have skus that are
> not being reordered when they are out of stock. I am setting them
> Inactive so they do not show up on the website. THen, if all skus
> of an item are marked inactive, I'm setting the whole item inactive
> so it doesn't show up on the website either. This goes immediately
> after the inventory is decremented for the order, around line 283 in
> actions/SUBMIT_ORDER.
>
>
> /* CW - if sku count=0 then mark sku as inactive so it doesn't
> show up on the website, if not reordering */
> $Query = "SELECT Available, Item FROM inventory i JOIN sku s
> WHERE s.ID = i.SKU and SKU = $ReduceStock_sku[$index] and
> Backorder='N'";
> $DatabaseResult = mysql_query($Query, $DatabaseLink);
> if (mysql_numrows($DatabaseResult)>0) {
> $row = mysql_fetch_row($DatabaseResult);
> if ($row[0]<1) {
> $Query = "UPDATE sku SET Active='N' WHERE ID =
> $ReduceStock_sku[$index]";
> $DatabaseResult = mysql_query($Query, $DatabaseLink);
> /* CW - if all of an item's skus are inactive, mark the item
> inactive */
> $Query = "SELECT Active from sku WHERE Item =
> $row[1] GROUP BY Active";
> $DatabaseResult = mysql_query($Query, $DatabaseLink);
> if (mysql_numrows($DatabaseResult)==1) {
> $Query = "UPDATE item SET Active='N' WHERE
> ID=$row[1]";
> $DatabaseResult = mysql_query($Query,
> $DatabaseLink);
> }
> }
> }
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
