Customising Drop Shipping Previous Orders Screen |
Post Reply |
Author | |
mattprice
Senior Member Joined: 03-June-2007 Location: United Kingdom Status: Offline Points: 0 |
Post Options
Thanks(0)
Posted: 01-April-2010 at 10:15am |
We have drop shippers who are shipping a large number of low value products and I was looking for a way of filtering the sds_ViewPast.asp (Drop shippers previous orders screen) to exclude orders that we have archived in the backend.
I can see that sds_ViewPast.asp uses a query to find orders as follows :-
query="SELECT DISTINCT orders.idOrder, orders.orderDate, orders.ord_OrderName, orders.OrderStatus, orders.pcOrd_PaymentStatus FROM pcDropShippersSuppliers INNER JOIN (orders INNER JOIN ProductsOrdered ON orders.idorder = ProductsOrdered.idorder) ON (pcDropShippersSuppliers.idproduct=ProductsOrdered.idproduct AND pcDropShippersSuppliers.pcDS_IsDropShipper = " & session("pc_sdsIsDropShipper") & ") WHERE ProductsOrdered.pcDropShipper_ID=" & session("pc_idsds") & " AND ((orders.orderStatus>2 AND orders.orderStatus<5) OR (orders.orderStatus>6 AND orders.orderStatus<=9) OR (orders.orderStatus=10 OR orders.orderStatus=12)) ORDER BY orders.idOrder DESC;"
Can anyone give me any pointers as to how can modify this query so that it does not looks for archived orders ?
Many Thanks
Matt
|
|
ProductCart
Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
Post Options
Thanks(0)
|
You need to add the "pcOrd_Archived" field to the query:
pcOrd_Archived = 0 (not archived) pcOrd_Archived = 1 (archived) ... so: "[...] WHERE orders.pcOrd_Archived=0 AND ProductsOrdered.pcDropShipper_ID= [...]" Edited by earlyimp - 01-April-2010 at 1:36pm |
|
mattprice
Senior Member Joined: 03-June-2007 Location: United Kingdom Status: Offline Points: 0 |
Post Options
Thanks(0)
|
Thats great, works a treat thank you.
For anyone interested... there was another reason for hiding archived orders (other than trying to keep the drop shippers previous order screen tidy).
We have our drop shippers on manual notification because there are times when we want to ship the product ourselves instead of asking our supplier to drop ship it. When we ship ourselves we obviously do not notify the drop shipper. By archiving the order too after shipment it also does not confuse the drop shipper by showing the order on their previous orders log in screen.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |