Re: [mv] Don't Know How To Title This Question

["Bill Randle" <billr@exgate.tek.com>]

On Feb 4,  2:47am, OTR Comm wrote:
} Subject: [mv] Don't Know How To Title This Question
} Hello,
}
} I want to put up a gallery with one-of-a-kind pieces.
}
} What I want to be able to do is setup a system where when a customer
} selects to buy an item, everyone else who goes into the gallery sees a
} 'Sale Pending' notice for that particular item.  In other words, I do
} not want multiple customers trying to purchase the same piece.
}
} Then, if the customer who has the piece under 'Sale Pending' does
} purchase the piece, the notice will change to 'Sold' when the page is
} re-displayed.
}
} The only way that I can figure out how to do this is by having code at
} the start of the page where this item lives that checks a switch in a
} database.  If the switch is not set, then the item is available for
} purchase.  If someone puts the item in their cart, the switch is then
} set and anyone else who comes to the page will not have the item
} available (i.e., Sale Pending).  These customers will be told to
} periodically check back at the page to see if the sale went through.  If
} the sale does go through, then the notice will say 'Sold', if not then
} the item will be available.
}
} Does this make sense?  Has anyone ever done this? Am I off base with the
} database switch approach?  Would the inventory database work for this?
} I have never worked with the inventory database, so I do not know.
}
} Any ideas/solutions would be appreciated.
}
} Thanks,
} Murrah Boswell

It's possible you could use the inventory database for this - I haven't
really used the inventory db, so I don't know for sure.

The way I implemented this in the past was to add a "status" field to
the product database. This field would show the product status, e.g.:
SALE-PENDING, SOLD, SALE-FAILED, AVAILABLE. Each item that is displayed
simply checks the status field and displays the appropriate message.
It should be pretty straight forward to add some mv tags or [perl]
block to the checkout page to set the status field.

The scenario I was doing this for was actually an auction, so it went
one step further and automatically sent email to the next highest
bidder when the status changed from SALE-PENDING to SALE-FAILED. After
processing any product records with the SALE-FAILED status, the status
field was changed to AVAILABLE. This was all done via a cron script that
ran every 5-10 minutes.

	-Bill


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