HomeHome Product Discus... Product Discus...Enhancement Req...Enhancement Req...SmithOrderDetails table should have VariantIDSmithOrderDetails table should have VariantID
Previous
 
Next
New Post
5/7/2013 12:48 PM
 
Scot Sunnergren
No Ranking


Joined: 3/28/2012
Posts: 41
The Smith_OrderDetails table needs to have the VariantID field. When a variant is purchased, the only way to tie it back to the variant is through its description. The variantId should be added to the table and filled whenever the product purchased is a variant.
 
New Post
5/9/2013 6:05 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
Hi Scot,
We could either add a new field in the Smith_OrderDetails table that holds a comma separated list of variantid's or we could add a new child table of Smith_OrderDetails called "Smith_OrderDetailVariants". Either way that's a good idea to add that so you dont have to parse the variants from the description when reporting or migrating to your ERP system. I will add this to the cart dev roadmap.

Thanks for your feedback!
At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...Enhancement Req...Enhancement Req...SmithOrderDetails table should have VariantIDSmithOrderDetails table should have VariantID




Questions? Contact us for answers!

Contact Us!