ProductCart Shopping Cart Software Forums : Customising Drop Shipping Previous Orders Screen

Customising Drop Shipping Previous Orders Screen : Thats great, works a treat thank...

Thu, 01 Apr 2010 14:20:05 +0000

Author: mattprice
Subject: 3579
Posted: 01-April-2010 at 2:20pm

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.

Customising Drop Shipping Previous Orders Screen : You need to add the "pcOrd_Archived"...

Thu, 01 Apr 2010 13:35:19 +0000

Author: ProductCart
Subject: 3579
Posted: 01-April-2010 at 1:35pm

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

Customising Drop Shipping Previous Orders Screen : We have drop shippers who are...

Thu, 01 Apr 2010 10:15:18 +0000

Author: mattprice
Subject: 3579
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