Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreProduct InventoryProduct Inventory
Previous
 
Next
New Post
9/5/2006 9:44 AM
 

Has anyone added the concept of product inventory? I would like to sell small quantities of high demand products. I do not want someone to be able to add something to their cart if I've already sold out of the item.

Someone slap me if this feature is there and I just dont see it.

But if anyone has added this feature and is willing to share how they did it, I would appreciate it greatly.

 

 
New Post
9/8/2006 6:45 PM
 
I've considered this and may be adding the functionality over the weekend.

Firstly you need to add a stock level field to the products table, data providers, controller and then add relevant edit controls on the ProductEdit.ascx user control.

Now you have basic stock levels and need a way of altering them each time someone places an order.  This is simple enough to do in the update order query (you can't use the insert order query since this is used before the customer confirms their order).

Then you have to consider if a customer cancels an order.  Now you could just manually increase the stock level again if a customer cancels, but that could become high maintenance.  A code implementation would require the implementation of order statuses (a whole new topic) and conditional logic that increases the stock levels when you set an order to cancelled.  It's possible (I've added order statuses myself) but is added complexity.

Lastly, you have to modify the queries that perform product selects such that they only return products with a stock level > 0.  Be careful with this though as the GetProducts query is used in your product admin screen too, and you want to display all products here regardless of stock (again an additional parameter in the stored procedure is probably required).

Hope that gives you some ideas?
 
New Post
9/13/2006 11:15 PM
 

Adding an inventory or in stock feature is not too difficult to implement with the User Interface (UI), the real work is the maintenance of online counts including accuracy and related business procedures. The following questions should demonstrate how the simple feature becomes a little more complex...

Q1) How do you manage your inventory right now?
Q2) How many items/products do you have to manage?
Q3) How many items are on each order (daily average)?
Q4) How many orders do you process? (daily average)

For example, if you had 100's of items and processed a couple orders per day, you could spend a few minutes manually changing items from active to inactive when you run out of a product. If you handled 10 or more orders, you might use a daily summary to modify product counts in bulk. If you shipped hundreds of items per day, you would probably prefer an automated system that issues inventory as you accept an order (or ship an order) in real time.

The problem domain expands very quickly when you attempt to include related business processes...

Q5) Do you sell products online and via alternate channels?
(mail order, ebay, phone, fax, brick & mortar)
Q6) When does a product become available for sale?
(When it is received, work in progress begins, finished builds, etc.)
Q7) What increases available for sale counts?
(manual adjustment, received product, returns, order cancellations)
Q8) What process triggers inventory replenishment?
(out of stock, product demand, forecasting, SWAG (Scientific Wild Ass Guessing)

The easiest solution may be to mimic the process you already have in place. How to manage everbody's requirements may involve some more serious thinking.

Q) What do you get when you automate a bad system?
A) An automated bad system.


Dwayne J. Baldwin
 
New Post
9/14/2006 9:04 AM
 

Dwayne -- this is slightly off-topic but I can't find another way to reach you.

This post - http://www.dynamicvb.net/Home/tabid/36/EntryID/4/Default.aspx - mentions an invoice system/module you developed using Reporting Services. Is that something you would like to share w/ the DNN community?  I have 1 DNN site with many "child portals"; each child portal is for a seperate customer. I would to create a monthly invoice for each customer (i.e., users in certain Role(s) would see the invoice when they login to their respective portal).

I'm not sure what the best approach is (DNN Store ?, Catalook ?, custom module ?)... Any advice would be appreciated!

Thanks!

 
New Post
9/14/2006 2:16 PM
 

I am always happy to share code and/or advice, provided that it meets the terms of any agreements in effect.

In this case I would be a little uncomfortable asking my client if I could contribute their paid work to the open source community.  Second, the dependency on Reporting Services is not something that the DotNetNuke community would really want to support (we have enough trouble with IIS, ASP.NET, SQL Server. Visual Studio/Web Developer). 

I am a little confused about what you mean by best approach. Are you referring to the store that builds and accepts orders or the ability to display an invoice from these sources? What generates the monthly invoice? Why not email the invoice?

It would be a trivial task to use a template mechanism to display an invoice online. It would be fairly easy to add a pay now button inside the invoice/email using the code provided in the DotNetNuke Store project module.

Please start a new thread if you want to discuss these ideas further.


Dwayne J. Baldwin
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreProduct InventoryProduct Inventory


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out