Okay, at first the SKU did not show on the cart page, checkout page, or success page, but I got them added and it shows all the way to the checkout_success.php. BUT it does not appear on the confirm order email that is sent out. I tried to add it to the confirm page, but it produces this error:
INSERT INTO orderdetails (`DetailOrderID`, `DetailProductID`, `DetailName`, `DetailPrice`, `DetailQuantity`, `DetailProductSKU`) VALUES (14, DEFAULT, '4" CORRUGATED 90 ELL 12/CT', 12.46, 1, '01-C304')
Unknown column 'DetailProductSKU' in 'field list'
this is the line i tried to add:
$ReplaceQuery->bindColumn("DetailProductSKU", "s", "".$eCart1->DisplayInfo("ProductSKU") ."", "WA_DEFAULT");