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: Mark Order As Ready To Ship

  1. #1
    Blush.no is offline Junior Member
    Join Date
    Nov 2009
    Posts
    7

    Default Mark Order As Ready To Ship

    Is it possible to mark all new orders as ready to ship automatic?

  2. #2
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    If you have a source that would require a little modification on the Order.cs, but if you do not have a source and you have access to your database serve, this query could do the trick:
    Code:
    UPDATE Orders SET ReadyToShip = 1 WHERE IsNew = 1

  3. #3
    Blush.no is offline Junior Member
    Join Date
    Nov 2009
    Posts
    7

    Default

    Thanks a lot.

    I have to write my own program to import tracking numbers to the StoreFront. Can you please tell me the SQL I need to update an order with tracking number?



    Regards,
    Anders

  4. #4
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Sure, you could try this one:
    Code:
    UPDATE Orders SET ShippingTrackingNumber = ### WHERE OrderNumber = ###