HomeHome Product Discus... Product Discus...SmithCartSmithCartWhat is the point......What is the point......
Previous
 
Next
New Post
3/9/2011 1:10 PM
 

What is the point of having Variant SKUs, if the cart doesn't use THAT sku in the StoreOrderDetails? It's using the default SKU for the product, but not the variant SKU.

Since the product SKU is required, I can't leave it blank and just use the variant SKUs.... :(

 
New Post
3/9/2011 1:29 PM
 

I can't remember exactly what I did but I think you have to change [Smith_ListStoreOrderDetailsbyID] to:

SELECT
OD.[OrderDetailID], OD.[OrderID], OD.[ProductID], OD.[ProductName],p.modelnumber, ProductSKU,
OD.[Quantity], OD.[UnitCost], p.ModelName, convert(varchar,od.quantity * od.unitcost) as linetotal, WebServiceData
FROM Smith_StoreOrderDetails OD
inner join Smith_Products P
on OD.ProductID=P.ProductID

I am redoing my entire store from scratch so I will be figuring out what it is within the next 24 hours and will let you know.

 
New Post
3/9/2011 1:55 PM
 

But it's not saving the variant SKU in StoreOrderDetails at all. That was my point.

If you have a product with a SKU, that's fine. But if you have a product with a VARIANT, and those variants each have their own SKU, it should be the Variant SKU that goes into the ProductSKU Field of StoreOrderDetails, instead of the main product SKU.

 
New Post
3/9/2011 1:57 PM
 

Then you probably need to update variant inventory screen with the right info. When you originally put in the variants, those sku's and quantities mean nothing. You have to then go into the variant inventory screen and add them again.

 
New Post
3/9/2011 2:00 PM
 

So, the required skus and the required quantities mean nothing when adding variants?

 
New Post
3/9/2011 2:02 PM
 

Correct. SC likes to challenge their customers to weed out the weak.

 
New Post
3/10/2011 8:59 AM
 

Considering how much I've got invested in this cart already; but I digress.

I'd sure be interested in an explaination of why there are SKUs for the variants, if they're not used anywhere, and how to make that work properly.

 
New Post
3/10/2011 9:14 AM
Accepted Answer 

The variant sku's are entered in the variant inventory section. Right under Variants in the edit product menu.

 
New Post
6/10/2011 3:03 PM
 
Did anyone ever find an answer for this???

I've turned on inventory management but I still don't get the variant SKU in the orders.

Really effing annoying. I'm now having to hand sort the orders for variants cause one of my variants is a physical product that has to be shipped and the other variant isn't!

 
New Post
6/10/2011 6:03 PM
 
Did you enter your variant skus and inventory using the variant inventory screen? The variant inventory screen is a sub menu option under "Variants" on the product menu at the top of the add products page.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/10/2011 6:32 PM
 

Yup... All of it.  Whole 9yards all filled out.  SKU's are the primary SKU from the product screen in the *Smith_OrderDetails table.

I even deleted them and tried new ones.   No go.  

I'm about to have to use reporting services and just do some string searches to get my variants out of the DB.   

 
New Post
6/10/2011 7:48 PM
 

Hi Brady,

I have been able to purchase a product and have the SKU saved to the order details screen. Would you be able to test this on our http://www9.smith-consulting.com test portal as well?

Thanks, Kevin
 

 
New Post
6/10/2011 9:35 PM
 

Hi Kevin,

Yes I replicated this on your test site.  I placed a fake order with a variant of a new product I loaded into the test site and it does not save the variant SKU.  It is still showing the base product SKU.  No SKU in the manage orders and no SKU in the export orders.   

 

 

 

Thanks, Brady





Kevin wrote:

Hi Brady,

I have been able to purchase a product and have the SKU saved to the order details screen. Would you be able to test this on our http://www9.smith-consulting.com test portal as well?

Thanks, Kevin
 

 

 
New Post
6/10/2011 11:00 PM
 

Hi Brady,

I took a look at the product you set up on our test portal and I noticed that you did not enter your variant skus and inventory using the variant inventory screen. A screenshot of the inventory management screen is attached.

Thanks

 
 Login to download attachment
New Post
6/11/2011 10:45 AM
 
This is even more confusing?.? That's the exact same information on the variant page when you create the variant! Why twice? Also there is no Variant Inventory drop down menu on my production 4.32?

Kevin wrote:

Hi Brady,

I took a look at the product you set up on our test portal and I noticed that you did not enter your variant skus and inventory using the variant inventory screen. A screenshot of the inventory management screen is attached.

Thanks

 

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartWhat is the point......What is the point......