an ASP.NET Open Source CMS & eCommerce platform
Search:
Last Post 12/15/2010 9:21:15 AM By lukezy. 3 replies.
10/21/2008 1:07:21 AM
rei
Posts: 1
Joined: 10/17/2008
2 questions
Hi, I'm reviewing different shopping cart solutions for a client's website, and I'd like to know if the 2 following things are possible easily with DotShoppingCart:
 
1. Having a "Product of the Week/Month" (a special sale price for this product this week or month), perpahs a bar to one side.
 
I read on the DotShoppingCart description:
"Showing featured products, sale products or new products on any page including the storefront"
 
However, i haven't seen this feature in the version comparison page, and it's not in the free version.
 
Basically it would be just a way to mark a product as "product of the week" so that all the products marked this way can be shown in a special pane... having a discount for a specific period of time for these products would be nice, but not imperative (the prices COULD be updated directly).
 
 
2. Using the user groups, is it possible to restrict access to certain products/categories to certain user groups?
 
Thank you
Roberto Eichin
10/21/2008 1:51:35 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: 2 questions
Currently there are serveral ways to mark the products special. 1) mark it a featured product 2) mark it sale product by setting the sale price 3) mark it new product by setting the start date within a certain time range say 1 month.
 
Once you have these marking you could use the pre-built blocks "Product List" to add it to any area of the page.
 
I think you could use "featured" product marking for "product of the week". These blocks are not part of the open source edition. They are only in the DotShoppingCart Suite.
 
I guess your second question is asking the discount user groups. The out of box software doesn't restrict cerain product/categories. But with customization it can be easily achieved.
 
 
DotShoppingCart Staff
12/15/2010 3:45:55 AM
malshini
Posts: 29
Joined: 11/9/2010
Re: 2 questions
please clarify this point more 3) mark it new product by setting the start date within a certain time range say 1 month.
 
how to define the date range ?
where?
 
Thanks
12/15/2010 9:21:15 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: 2 questions
You can update store procedure DSC_Product_GetProductListByListType.
 

 ELSE IF (1 = @listType) -- new less than 2 months
  BEGIN
   SELECT p.productId
   FROM DSC_Product p
   WHERE timeCreated > DATEADD(m, -2, GETDATE())
  END
 

DotShoppingCart Staff