Recommended Daily System Checks
Topic: Recommended Daily System Checks
OLX Version(s): 5.1
OLX Editions: All
Recommended Daily System Checks
OrderLogix is a robust platform with a lot of
moving pieces. We understand it can become daunting at times and offer Managed Service. With Managed Service a member of the Customer
Support team will login every morning to check on the core components of the
system to make sure jobs are running without errors and communicating to your
external vendors.
We have also put together an outline of
recommended daily system checks if you would like to keep this task internal to
your team. Reports
Data Warehouse Export
Reports > Processing Reports > Data Warehouse
Export
Filter
Columns (at minimum we
recommend the following, but you can add or remove as needed)
status
datecreated
DateProc
Iscredit
PayProcAcct
DateShip
ShipState
shipTransID
custnum
ordered
CampaignName
dnis
productoffer
prodgroup
total
Item Status
Item Pending Review
These are orders that must be manually handled by agents in order to move the order forward. Check the CS Event on the customer record to help determine resolution.
Invalid
These are orders that must be manually handled by agents in order to move the order forward. If the customer has an autoship associated to them an order in Item Invalid status will prohibit the autoship from creating and moving forward. These orders will hold inventory counts if your system is setup with inventory. Will be either due to high $ filter being met OR credit card has expired.
Not Yet Available
Orders creating in the system will go to Not Yet Available. If payment processing has already run for the day this would require a review of prepayment processing. Prepayment processing should pick these orders up and move them to Item Pay Ready or Item Ship Ready (dependent on base item settings).
If prepayment processing is run hourly, it could be the order is brand new and the next schedule run has not been reached. If you hover over the status, you will see the date and time the order was created, and this will help determine if there is an issue.
Item Pay Ready
If payment processing has already run for the day this would require a review of payment processing. Confirm the product group is selected on the payment schedule (you will need to check each product offer on the order). Confirm the Payment Processing Account (PPA) is set correctly on the campaign, script and/or product group. A quick way to check is to grab the DNIS from the order "stuck" in item pay ready, navigate to Campaigns > Source > filter DNIS = [insert DNIS from order]. Confirm if you need to schedule a payment batch.
If payment processing is run hourly, it could be the order is brand new and the next schedule run has not been reached. If you hover over the status, you will see the date and time the order was created, and this will help determine if there is an issue.
Item Awaiting Authorization
This tells you the item is in a payment batch. If payment processing has already run for the day this would require a review of payment batches to confirm batches are all in a status of complete.
Item Ship Ready
Sort by date created. Anything in the current date can be ignored as it’s most likely just waiting to get into a batch. Prior days should be checked to see if there’s an issue such as product groups not selected on the scheduled job or if the prior job log is reporting an error (even if the job has a status of Succeeded there may still be errors listed in the job log). Another potential issue is the base item on the offer may not be set to allow shipping.
If processing is run hourly, it could be the order is brand new and the next schedule run has not been reached. If you hover over the status, you will see the date and time the order was created, and this will help determine if there is an issue.
Item Awaiting Ship Confirm
Determine reasonable turn around for warehouse to ship orders, in days. You are only interested in seeing anything that’s older than this time frame, anything newer can be ignored. Keep an eye on order/ship date to make sure orders are being confirmed in a timely manner. This will let you know if the fulfillment center is having issues or if you need to review your ship confirm schedule.
SAS (Shipped Awaiting Settlement)
These are all orders that have been confirmed but they are waiting to get into settle batch or are in a batch that’s waiting to process. These should all be current. If they aren’t then there’s a possibility that product groups aren’t selected, or something is amiss with the processing account for auth vs settle.
If payment processing is run hourly, it could be the next schedule run has not been reached. If you hover over the status, you will see the date and time the order was confirmed, and this will help determine if there is an issue.
Purpose
To keep the system cleaned
up and orders moving into a closed/final status.
Real Time Auth Report
Reports > Processing Reports > Real Time Auth
Report
Filter
Date Range – set for time
period to review. Recommended to do 2-4 weeks
Report Layout =
Date/Campaign/Client
Trans Type = Approved with
no order
Purpose
To make sure all orders are
created.
There are on occasion
technical glitches when submitting an order (double clicking submit
button, internet/electric outages, system restarts) and the system does
not capture all of the information it needs to create the order. There
is a system job that runs every 15 minutes to find these orders and
check a couple of tables to collect the missing data and create the
order. However, if there's not enough data collected during the Call this report will inform you and display as much data as we have.
Payment Batch Report
Reports>Processing Reports>Payment Batch Report
- Payment Batch Report Definitions (orderlogix.com)
Choose the start date of the day you last checked and leave the end date as is. For instance, on Monday you would have a start date of the last Friday. On Tuesday you would have the start date of Monday, so on and so forth. Under the batch name drop down go to the bottom and select all. You want all the information for all batches pulled into one report. Run the report.
Unknown result - Once complied scroll all the way to the end to see if there are any orders that are in “unknown result”. This means something occurred with these orders during processing where the result from the processor did not get brought into the system. These orders will need to be looked up in your merchant account. If there was no capture you can manually mark the item as declined and resubmit it. If you show payment was captured, you can manually mark the item as paid. If you are unable to do this, you will need to enter a ticket. These are rare occurrences.
Debit Other – Look for the first credit and the last debit (debits are blue, credits are red). Between these if there were any issues you will see anything in the status of Debit Other. This means that something occurred in the processing that’s outside of the normal processing constraints. You will need to go to the order and click on the status to see the result and enter a ticket so we can investigate.
No Result – These will be at the very beginning of the batch and are most likely the check credits that have not yet been created, mailed, and the transaction marked as paid.
Continuity Mailing List Report
- Reports>Continuity/Installment Reports> Continuity Customer List
- Continuity Customer List Report Definitions (orderlogix.com)
- Keeping Current
- Date Range - prior week
- Report Layout - Next Ship Date/Sequence/Customer
- check - Do Not Show Declined Autoshipments
- check - Do Not Show Held Autoshipments
- Date Type - Immediate Next Ship Date
- Status - Active Only
- View Report and check each customer listed to see if continuity can be saved.
- If last order was created but did not reach a favorable item status
- click on alert icon to allow system to ignore the last order and create the next.
- click OK
- edit sequence and update the Next Ship Date
- Confirm customer sequence has a profile associated to it
- System Cleanup
- On Hold Subscriptions that need to be stopped:
- Date Range - determine how far back you want to stop continuities without calling customer to save the sale
- Report Layout - Next Ship Date/Sequence/Customer
- Date Type - Immediate Next Ship Date
- Status - On Hold Only
- If continuity is too old to save/make active go ahead and stop.
- Edit sequence
- Click Stop (top right corner)
- Save sequence
- On Hold Subscriptions that need to be restarted:
- Date Range - determine how far back you want to restart continuities without calling customer
- Report Layout - Next Ship Date/Sequence/Customer
- Date Type - Immediate Next Ship Date
- Status - On Hold Only
- Edit sequence
- Click Active (top right corner)
- Save sequence
- Active Subscriptions where previous order did not reach a favorable status:
- Date Range - determine how far back you want to stop continuities without calling customer to save the sale
- Report Layout - Next Ship Date/Sequence/Customer
- Date Type - Immediate Next Ship Date
- Status - Active Only
- If continuity is too old to save/make active go ahead and stop.
- Edit sequence
- Click Stop (top right corner)
- Save sequence
Manage Order Exceptions
Processing > Import/Export > Manage Order
Exceptions
Using the magnifying glass open the order and make the necessary correction.
Once you have made the necessary corrections scroll over to the preview and process buttons.
Preview first as a test to see if you have cleared the error.
If you see a successful result:
Review the last grid Item List As it was Imported
If data is correct, you can then process the order.
When you return to the exceptions screen the exception will no longer exist.
If you see a new error, continue troubleshooting.
- Purpose
- To make sure all orders are importing successfully.
- On occasion an imported order will run into an issue
and needs to be handled manually to be brought into the system.
Import Logs
Processing > Import/Export > Import Logs
Filter
Process Stamp >=
(yesterdays date OR beginning date range to check)
Process Stamp <= (todays
date OR ending date range to check)
Import File Name contains
(you will need to know the different files importing into your system
to enter a few characters of each to search individually - you can skip
this filter if you want to see all falls in date range regardless of
specific file name)
Purpose
For counts - to make sure
counts match in OLX and vendor side
Payment Processing
Processing > Payment Processing
Filter
status does not contain Complete
This allows you to see
quickly batches that are in status of:
In
Process
Using the second icon, click into the Process Batch screen and then click on Process Batch button at the bottom of the screen. The batch will continue to process, and orders will move into Approved, Declined, or Other. If there are errors review the payment batch report by clicking on the first icon. Look for special characters in the customer's name/address or mal formatted payment profile.
Created
Using the second icon, click into the Process Batch screen and then click on Process Batch button at the bottom of the screen. The batch will process, and orders will move into Approved, Declined, or Other. If there are errors review the payment batch report by clicking on the first icon. Look for special characters in the customer's name/address or mal formatted payment profile.
You may see the EXT batch name; these are check refunds that are in process. The batch was created but they have not been sent so nothing in the batch is marked as paid. If you are still seeing an EXT batch after 2 weeks you should check with finance to see if maybe a check was missed.
Purpose
to make sure all created batches are processing and
money is being captured.
Process History
Processing > Processing > Process History
Show System Jobs checked
Job Status
Filter
job status contains
running
you
want to make sure jobs are not running longer than two hours and appear stuck. > open support ticket with OLX
failed
did
the job run successfully after a fail?
are
there issues in the job that need to be handled to successfully
run?
Export failed. The
following error has occurred:~~ Transaction (Process ID 60) was deadlocked on
lock resources with another process and has been chosen as the deadlock victim.
Rerun the transaction. DBCC execution completed. If DBCC printed error messages,
contact your system administrator. ~~ Error occurred after
completing export:Export failed Error in onStart():Export
failed
Orders will be sent to Pending Review (if any
picked up in batch)
Confirm order is not showing in warehouse before
releasing from pending review.
If order is at warehouse DO NOT release.
Put in a ticket for item status change to
Awaiting Ship Confirm
If order is not at warehouse,
Release from pending review. Order
will pickup in next export.
cancelled
did
the job run successfully after being cancelled?
are
there issues in the job that need to be handled to successfully
run?
If export to warehouse/fulfillment center that all orders were successfully exported
Updated to awaiting ship confirm
If orders are not showing at warehouse > open support ticket with OLX for Shipment Rollback
Give JobID of SysCancelled job
Send signed rollback form
Purpose
to make sure there are no
jobs "hung up" in the system that need to be cancelled
to make sure there are no
issues with jobs that may have stopped during run time
imports (looking for errors
within job)
- Inventory Sync
- Filter
- Adjust
Job type contains import
- Adjust
Job Name contains sync
(or a portion of your inventory sync job name)
- Purpose
- to
ensure inventory is being updated correctly
- Ship Confirm
- Filter
- Adjust
Job type contains import
- Adjust
Job name contains confirm (or a portion of your ship confirm
job name)
- Purpose
- to
confirm shipments are being confirmed and item statuses are being
set to Ship Delivered and orders are able to go to a closed
status
exports (looking for
errors within job)
- Filter
- Adjust job type contains
export
- Adjust job name contains
(a portion of your export job name)
- Order
Export look for following types of issues:
- orders
where at least 1 item has no inventory associated.
- once all files are open ctrl+f for
'RESPONSE << HTTP_STATUS(4' to get total count and orderID's to
review
- once all files are open ctrl+f for
'RESPONSE << HTTP_STATUS(-' to get total count and orderID's to
review
- other
export jobs
- make
sure to review any other export jobs you have in your system and
open the most recent to see if there are any errors that need to be
addressed.
- Job status of Succeeded does not mean there are no errors within the data of the job that need to be handled. Only that the job ran from start to finish with no technical errors.
Notifications (looking
for errors within job)
- Filter
- Adjust Job type
= Notification Delivery
- Remove Job Name
- Purpose
- make sure credentials are
good
- make sure all
notifications sent - if they did not send you can try to force a send
via Processing > Notifications > Notification Management >
Send Email/API
- Notification Management (orderlogix.com)
Daily Continuity
Processing (looking for errors within job)
- Continuity Processing (orderlogix.com)
- Filter
- Adjust Job type
= Continuity Processing
- Purpose
- to make sure
continuities/subscriptions are creating without error
Notification Management
Send Email/API
Processing > Notifications > Notification Management >Send Email/API
you'll want to set the end date to 24-48 hrs prior
This allows you to send notification batches they may have gotten "stuck" due to an address that was formatted incorrectly.
You will not be able to send the batch that has the incorrect email but you will be able to send other batches that got stuck as well
Purge Notifications
Processing > Notifications > Notification
Management > Purge Notifications
you'll want to set the end date to 24-48 hrs prior
if there are still notification showing that need
purged this is a good indication you may need to review how you have
your schedule setup
the first time you start looking at this you may need
to decide how far back you are wanting to review and go ahead and purge
anything showing up to that date.
Related Articles
System Preference: Expand Sales Agent Commission by Default
When agents are viewing their Sales Commissions for a date range, it can become cumbersome for them to expand each order line to review the product specific details. If you wish to have all of the commission lines expanded automatically upon loading ...
WARNING: Order is using a TOKEN, however the default token VISA/MASTERCARD/DISCOVER/AMERICAN EXPRESS number in system preferences is not populated.
Message: WARNING: Order is using a TOKEN, however the default token VISA/MASTERCARD/DISCOVER/AMERICAN EXPRESS number in system preferences is not populated. Explanation: There are no placeholder credit card numbers for tokenized accounts defined in ...
Notifications Step By Step
Module: Notification Topic: Notifications Step By Step Version(s): 5.1 and up Editions: Commerce / Call Center Below you will find step by step instructions on how to setup notifications within your instance. The links will give you more detailed ...
Migrating to a New Processing Accounts
Module: Payment Proc Accounts Path: Campaign > Payment Proc Accounts Topic: Payment Processing Accounts Version(s): 5.1 & up Editions: All Migrating to a New Payment Proc Account Points to Note Credit Card (not tokenization) payment profiles can be ...
Media Step By Step
Module: Media Topic: Media Step By Step Version(s): 5.0 / 5.1 Editions: Call Center Below you will find step by step instructions on the recommended order media related components are setup. The links will give you more detailed instructions on HOW ...