ref dbo.Orders_ShoppingCart field: OrderedProductManufacturerPartNumber
we noticed that the MFG pn is duplicated in this field
ex 0612006120 s/b 06120
our products are loaded from an excel spread sheet and are not duplicated
there
if you look at dbo.product it is not duplicated there or in the
dbo.productvaiant table just in the dbo.Orders_ShoppingCart
apparently when a order is placed in the cart this field is stringed together 2 times
it does not show up on the customer reciept
we noticed this since this we export this field from an external program
If you are not directly accessing these tables thru SQL you would not see this
issue.
This is just FYI not sure who to send this to