We have built these systems in the past and are currently working on a
rather elaborate multi-warehouse system, and it comes down to how deep into
the supply chain you want to place your orders. It's okay to take more
orders for depleted items if you can replenish, reshelve, pack, and ship
within stated customer service limits.
We handle this entirely through business logic implemented as triggers in
the database. They automatically reorder an item-specific quantity of items
that fall below an item-specific reorder level, and also automatically
manage live inventory counts for Internet customers. No ColdFusion code
involved, which is the only way it should be.
If you want control over how deep into your supply chain you place customer
orders (how many replenishment cycles or days it takes to get enough product
to fulfill pending orders), you'll need additional attributes that specify
the expected timeline for cycle replenishment of your inventory items. I
don't like to automate that part too much, because it usually comes down to
a human decision to either find additional suppliers, expedite shipping at
his own expense, call the customer, or some combination of the above. If
you give your warehouse manager an auto-refreshing list of potentially
problematic reorder items, where he can click an item to get details so he
can make a decision and call the parties involved, then that should do.
If memory serves me correctly, Toy's 'R Us took it to the other extreme some
years ago and had virtually no limit on how far back in the supply chain
they allowed customer orders to be placed; the result was children without
presents on Christmas, and the following year they integrated with Amazon
instead. Their own website was great stuff -- make no mistake; I believe it
was a well-meaning management decision that caused the resupply problem.
If you want some personalized help on this then please feel free to call me
at 770-446-8866 and I'll do what I can to help guide you.
Respectfully,
Adam Phillip Churvis
Member of Team Macromedia
Advanced Intensive ColdFusion MX Training
ColdFusion MX Master Class:
January 12 - 16, 2004
http://www.ColdFusionTraining.com
Download CommerceBlocks V2.1 and LoRCAT from
http://www.ProductivityEnhancement.com
The ColdFusion MX Bible is in bookstores now!
----- Original Message -----
From: "Tony Gruen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 13, 2004 6:51 PM
Subject: ecommerce store and real store inventory
> ok group. Here is one I can't seem to find information on.
>
> I have been asked if a real world store that has a Cold Fusion based
> webstore could tie their inventory to the website. If an item sells out in
> the store, it would not be available on the website until restocked. They
> have a CF Based website now and are willing to change their in-house
> inventory system. Anyone else run into this idea?
>
> Tony
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
