LOCKER SMS CHECK

Locker SMS System Check

Provider 1 • Checks queue, columns, latest SMS, and order status.

Factory Live Factory POS

1. SMS Queue Table

locker_sms_queue exists.
ColumnType
idint(11)
provider_idint(11)
order_refvarchar(40)
mobilevarchar(80)
messagetext
statusvarchar(40)
created_atdatetime
sent_atdatetime
sms_typevarchar(80)
actual_sent_tovarchar(80)
provider_responsetext
error_messagetext
attemptsint(11)

2. Queue Test SMS

This confirms the locker system writes to the SMS queue. If it does not physically send, the sender/cron script is not firing.

3. Latest SMS Queue Rows

IDOrderMobileStatusMessageCreated
9 0100015 0414628703 SENT Hi DEACON, your locker order 0100015 is ready for pickup. Please return to the locker location and scan the PICKUP QR code. Your secure locker number and pickup PIN will be shown o 2026-05-26 06:59:42
8 FS260524105641639 0414628703 SENT Fresh Stays: Hi Barry Test, your order FS260524105641639 is ready for payment. Total $18.00. Processing starts after payment: https://dcme.com.au/freshstays/payments/pay.php?provid 2026-05-24 12:09:33
7 FS260524070038790 0414628703 SENT Fresh Stays: Hi Barry Test, your order FS260524070038790 is ready for payment. Total $35.00. Processing starts after payment: https://dcme.com.au/freshstays/payments/pay.php?provid 2026-05-24 09:27:50
6 FS260524070038790 0414628703 SENT Fresh Stays: Hi Barry Test, your order FS260524070038790 is ready for payment. Total $35.00. Processing starts after payment: https://dcme.com.au/freshstays/payments/pay.php?provid 2026-05-24 08:43:45
5 0100015 0414628703 SENT Hi DEACON, your locker order 0100015 has been checked and priced at $32.00. Payment is required before processing commences. Pay here: https://dcme.com.au/locker/payments/pay.php?p 2026-05-24 08:35:47
4 0100014 0449933035 SENT Hi Ashley Deacon, your locker order 0100014 is ready for pickup. Please return to the locker location and scan the PICKUP QR code. Your secure locker number and pickup PIN will be 2026-05-22 13:00:49
3 0100014 0449933035 SENT Hi Ashley Deacon, your locker order 0100014 has been checked and priced at $32.50. Payment is required before processing commences. Pay here: https://dcme.com.au/locker/payments/pa 2026-05-22 13:00:07
2 0200004 0449933035 SENT Hi Ashley Deacon, your locker order 0200004 is ready for pickup. Please return to the locker location and scan the PICKUP QR code. Your secure locker number and pickup PIN will be 2026-05-22 12:57:31
1 0200004 0449933035 SENT Hi Ashley Deacon, your locker order 0200004 has been checked and priced at $14.00. Payment is required before processing commences. Pay here: https://dcme.com.au/locker/payments/pa 2026-05-22 12:56:36

4. Latest Locker Orders

IDOrderCustomerMobileStatusAmountCreated
3 0100015 DEACON 0414628703 LOADED_FOR_PICKUP 32.00 2026-05-24 08:34:33
2 0100014 Ashley Deacon 0449933035 COMPLETE 32.50 2026-05-22 12:58:57
1 0200004 Ashley Deacon 0449933035 COMPLETE 14.00 2026-05-22 12:53:47

What we are checking

  1. Did factory_pos.php write the payment SMS to locker_sms_queue?
  2. Is the row marked QUEUED, SENT, or failed?
  3. If queued only, the missing part is the SMS sender/cron worker, not the POS process.
  4. If no row exists, the POS SMS insert logic still needs adjustment to your actual table.