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
 
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
 
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
 
Previous
 
Next
HomeHome Product Discus... Product Discus...Enhancement Req...Enhancement Req...SmithOrderDetails table should have VariantIDSmithOrderDetails table should have VariantID