an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Development > General Programming > DSC_Product_Status_lkp flags
DSC_Product_Status_lkp flags
Last Post 1/21/2009 1:49:30 PM By Newmedia Design. 11 replies.
Page 1 of 2 (12 posts) << First < Prev 1 2 Next > Last >> 
1/12/2009 7:26:38 AM
macker999
Posts: 30
Joined: 10/11/2008
DSC_Product_Status_lkp flags
Hi Lukezy
 
I have downloaded version 3 (which is great, custom fields are excellent) but i didnt notice the functionality to set the status of a product to Inactive/discontinued etc.
We need this for our project as the client wants to set products to discontinued etc and also to show products that have zero stock.
 
I manually bulk add the stock (which is pulled from an accounting system) using the sp dsc_product_add and dsc_product_update so i can set the status id to one of these values
 
Active
Inactive
New
On Backorder
Featured
Discontinued (Special Order)
No Longer Available
Future Release
 
As the client wants to display products with zero in stock but also wants to hide certain products etc then i need to use the above values.
 
What I am not sure of is what views / stored procedures to modify to display products that have a value of Active only and what modifications do i need to use ie. seklect ... where statusid = 1?
 
 
Thanks for your help.
 
1/12/2009 11:04:16 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: DSC_Product_Status_lkp flags
Ah, it seems that we missed inactive/discontinued flag. We will work on the patch to fix that.
 
DotShoppingCart Staff
1/12/2009 12:36:29 PM
macker999
Posts: 30
Joined: 10/11/2008
Re: DSC_Product_Status_lkp flags
Thanks Lukezy
 
I sort of need to implement this in the next  2 weeks so do you know when it might be ready?
 
 
 
1/12/2009 11:15:42 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: DSC_Product_Status_lkp flags
We will try our best to get it out in 2 week but no guarantee.
DotShoppingCart Staff
1/13/2009 2:03:48 AM
macker999
Posts: 30
Joined: 10/11/2008
Re: DSC_Product_Status_lkp flags
Thanks Lukezy
 
Is it possible to add my own values to the DSC_Product_Status_lkp table like clearance, Sepcial Offers etc?
 
 
 
1/15/2009 11:12:39 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: DSC_Product_Status_lkp flags
Sure, I don't see the reason why you can't.
DotShoppingCart Staff
1/17/2009 11:04:15 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: DSC_Product_Status_lkp flags
We just released V3.01 which should address this issue.
DotShoppingCart Staff
1/19/2009 1:54:20 PM
Newmedia Design
Posts: 65
Joined: 9/25/2008
Re: DSC_Product_Status_lkp flags
Thanks Lukezy
 
Thats excellent
 
There is one last thing that  I need to do.
 
I need to be able to hide (dont display) categories if there are no products for that category or if the products are inactive, Can you tell me what stored procedure/view etc that I need to edit .
 
 
1/19/2009 2:21:15 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: DSC_Product_Status_lkp flags
Try DSC_Category_Get.
DotShoppingCart Staff
1/20/2009 8:38:30 AM
Newmedia Design
Posts: 65
Joined: 9/25/2008
Re: DSC_Product_Status_lkp flags
Hi Lukezy
 
I had a look at that sp and it displays the cargories and subcategories but I am not sure where the count value is pulled from 
EG. Notebooks(0). 
 
I noticed this line of code but i dont know where it gets its data from.
 
categoryListData.ShowProductCount.
 
Is the product count value stored in a table somewhere? If i can get access to this value then i Can modify the DSC_Category_Get sp to (rougnn example) select * from table where productcont > 0
 
Thanks
1/20/2009 2:06:48 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: DSC_Product_Status_lkp flags
There is a view vw_DSC_Category_Count that you can use. Check sproc DSC_Category_GetByTempTable how the view gets used.
DotShoppingCart Staff
Page 1 of 2 (12 posts) << First < Prev 1 2 Next > Last >> 
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.