Advanced Retail (UK) Ltd
Company Wiki

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 = ?