To check Sales orders have got to WMS:
Check sales order has been interfaced and exists on Traxs
select * from websites.sites -- has we.pets order been interface to Traxs? (by date select * from [petscorner].[wepets_order_import_hdr] where date_time > '2021-04-21' select * from vw_salesorders where site_no = 8 and datetime_transaction > '2021-04-21' select * from [petscorner].[wepets_order_import_line] where date_time > '2021-04-20' and _is_valid = 0 select * from [petscorner].[wepets_order_import_sale] where date_time > '2021-04-21' -- has it been processed and sent to WMS? Status = 4 indicates that it has SELECT * FROM vw_SalesOrder_Hdr WHERE site_no = 8 AND order_ref = '?' SELECT status,* FROM petscorner.wms_interface_sales WHERE sales_order_id = ?