VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Orders Not Shipped
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

webyhost
Starting Member

USA
35 Posts

Posted - March 03 2011 :  22:37:02  Show Profile  Reply with Quote
Can anyone tell me how to do a search for orders that have not been shipped yet?

We do a lot of drop shipping and it's difficult to go through all the orders if the distributor missed an order.

It might be nice to have a future addon were a check mark is displayed next to the tracking button if the order has been shipped.

Thanks for the help.

Jorge

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - March 18 2011 :  21:17:30  Show Profile  Reply with Quote
how usually you mark an order as shipped ? is it via "oshippeddate" field by entering the date of the shipping ?

Diego.
Go to Top of Page

webyhost
Starting Member

USA
35 Posts

Posted - March 28 2011 :  19:12:01  Show Profile  Reply with Quote
I just click on the track button.
Fill in the the tracking message and click submit.
I know it uses the date I added the tracking message, but I want to search for some kind of status weather it was shipped true or false.

Thank you,

Jorge
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - April 01 2011 :  04:20:13  Show Profile  Reply with Quote
jorge, thought it should be simple since you already using track feature. When you track an order, did you update that order (if shipped), you update the tracking page so "Order Status" is "Shipped" ?

The order status at this page shopa_trackingorder.asp?oid=xx have a list of dropdowns to select whether shipped, waiting payment or back order.

to search any shipped orders, then just go Admin Home Misc Query & Export
Put in the textbox for sql :

select * from orders where ostatus = 'Shipped'

This should result for you all the shipped orders that you already marked in track page.

good luck for you!

Diego.
Go to Top of Page

webyhost
Starting Member

USA
35 Posts

Posted - April 01 2011 :  21:44:56  Show Profile  Reply with Quote
Thanks for the reply Diego.
I am mostly interested in the orders that have not been shipped.
What would I have to use instead of shipped?
Problem is sometimes our manufacturer forgets to process an order and by checking if it hasn't been shipped is an easy way of checking.

Thank you for your help.

Jorge
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - April 01 2011 :  23:38:37  Show Profile  Reply with Quote
jorge, you can to run this sql for orders that has not been shipped :

select * from orders where ostatus <> 'Shipped' or ostatus is null

hopefully that will help you solve your problem.

Diego.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000