Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: duplicate MFG part number

  1. 05-18-2010, 04:55 PM #1
    rickkozz is offline Member
    Join Date
    Jul 2009
    Posts
    35

    Default duplicate MFG part number

    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
  2. 05-19-2010, 06:41 AM #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    The OrderedProductManufacturerPartNumber is created by putting together the parent product MFG# and the variant MFG#. Just take that out of one or the other and it will only be added there once.
    ECommerce Shopping Cart