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 ForumsStoreStoreHow to extend store for size and colorHow to extend store for size and color
Previous
 
Next
New Post
3/26/2008 10:03 AM
 

Hello, how can I extend the store to allow different product sizes and/or color choices. Perhaps even adding cost based on size or color?

There has been some posts that this feature may be coming in a future release. Unfortunatly, I must either modify the store in the next couple of days or spend $ on a store that already has this feature.

Surely someone has done this type of modification to the store.... Please share your methods. Thanks!

 
New Post
3/9/2009 5:12 AM
 

I have the same problem. I guess I'm going to get non core store module as this is feature is very important for my business.

 

 
New Post
3/9/2009 11:46 PM
 

Hi,

I know many users need options but it's not so simple to implement! Because the Store module is providers based, then if you change something in the products table you will have to apply numerous changes to the cart, the tax provider, the shipping provider, the chekout process and so on. The Store module is made of 21 projects and 53 controls. This is definitely not so simple. ;-) You can read this post to install the Store with sources.

Currently I work with Benoît (my co-lead) to define the best way to add this feature. But don't expect to have this version before months.

Gilles


We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
3/10/2009 4:07 AM
 

Yes, I have to agree with Gilles here. Enhancing current store module to be able working with product attributes is not a small task. I know it because I am working on this feature at this time. There is no need to change anything in Product table (at least in my implementation) but the integration of product attributes into store project(s) doesn’t let anything unchanged in it. Inclusive database stuff of course.

Well, regardless I am almost done with my work but I am definitely interested about “the best way to add this feature definition”. Can you Gilles and/or Benoit open public discussion about this topic?
 

 
New Post
3/10/2009 11:49 PM
 

Hi Jan,

We can talk about this feature here and now! :-) I already discused about that in some another posts, but we can resume.

Let me expose different cases from the more simple to the more complex one...

1) Most users need just color and size as product's options, we could think that it could be enougth to add two dropdownlist controls to the product form with some choices like (S, M, L, XL, ...). It's probably why so much users complains about this lack, because they "see" just the visible part of the iceberg. The first problem come with localization, there is different size systems all over the world! In France, it can be the same for T-shirt but we use numbers for shirts (the round of the neck in cm). We have the same problem with jean's and pants. Even if I never visited all the world, I'm sure we shall have the same problem in other countries. And what happens if you sell rings? They have a size but how is the measure in India or Denmark cm, inch, a letter, a word, hum? This is why we can't simply add two fields in the products table with two dropdownlist. If it was so simple, it would be already done! ;-)

2) Moreover in some case we need to adjust product's price and weight. An "XXL" T-shirt is more expensive than a "S" one and their weight is not the same. Now imagine that you sell furnitures, you can propose a model of table for 4, 8 or 12 people. In this case the size, the weight AND dimensions are not the same. Currently we have four fields concerning the measurement in the products table (ProductWeight, ProductHeight, ProductLength, ProductWidth). what is the best choice, move them to a product variants table or duplicate them to this table and add their values to the "final" product according the selected options? Furthermore, there are five new fields in the future 02.02.02 version to manage inventories (StockQuantity, LowThreshold, HighThreshold, DeliveryTime, PurchasePrice). Because we need to manage inventories for each product variant, we should move them too in the product variants table, no? Same problem for the UnitCost field, each variant can have a different price! An other great improvement in the next version is about SEO (Search Engine Optimization) and I added a new "Keywords" field. Now you can inject dynamicaly the product description field and keywords in the corresponding meta tags. Ideally, each selected variant should change the meta tags. There is also the IsDeleted, Archived and Featured fields, given that each variant can be deleted, archived or proposed as a featured product, we should also move them to the variants table. What if we want to boost sales for just one product's variant? Three more fields to move (SaleStartDate, SaleEndDate and SalePrice). One again, in a perfect world we should have a different picture for each variant (ProductImage field), one more field to move! Because each variant should be able to be identified in a warehouse, we also have to move the ModelNumber field and probably rename it SKU (a more widely accepted name) and add a "Name" field for the variant. STOOOOOPPPPP !!!! What the hell a product is finaly? A "Manufacturer", a "ModelName" and a "Summary", plus the ProductID, PortalID and CategoryID fields. All other fields have been moved to the variants table! :-(

Is that the right choice? Because if I apply these changes, it must change almost all classes in the module. You will understand, I hope, that we must ask ourselves the right questions because this really means A LOT of work! There is a much more simpler solution that would be to be able to duplicate a product. In this case no options at all, just a quick workaround. Don't tell me, I can hear you: "WE DON'T WANT THAT! IF YOU DO THIS, WE WILL FIND YOU AND CUT YOUR #@beep@#!" :-)

3) Now it's a little bit more clear in our brain concerning product's variants. But we have some other problems! How many options should be available to a product (size, color, material, ...)? Two, three, illimited? How can we manage this in the UI (dropdownlists, checkboxes, ...)? What if you sell computers and want to propose differents real options (not variants) like extra memory or larger hard drive?

As you can see, it's a big chalenge and we do not have the right to be wrong! If you have some good ideas, data model or whatever, YOU ARE WELCOME!

Gilles


We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreHow to extend store for size and colorHow to extend store for size and color


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