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 4 of 4

Thread: Changing shipping status od drop shipped items from multiple locations

  1. 01-03-2010, 12:24 PM #1
    tabletennisstore is offline Junior Member
    Join Date
    Feb 2009
    Posts
    21

    Default Changing shipping status od drop shipped items from multiple locations

    We have items from the same order are shipped from various locations. Sometimes the items are shipped on different days. We don't find a way to update the status of individual items to say it is shipped. We can update only after all items are shipped.

    Is there a way to do this?
  2. 01-03-2010, 04:26 PM #2
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Well, you can execute an SQL script to manually change the ReadyToShip and ShippedOn columns' values...
  3. 01-03-2010, 05:02 PM #3
    tabletennisstore is offline Junior Member
    Join Date
    Feb 2009
    Posts
    21

    Default SQL script



    We hate running an sql script for this.
  4. 01-03-2010, 05:24 PM #4
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    By the way, considering that the Shipping status handler for Order is per order basis and not per item of an order, therefore, the only way for you to set the Shipping status would be to wait for the entire order to be shipped. However, you could add columns (Shipped and ShippedOn) on the Orders_ShoppingCart table that is a boolean type that could be manually set accordingly or automatically via Order Management but that would require modification work...