First Step: Understanding the M3 order columns
A.) Customers Ord:
1. Orders processed in M3 by our CR Team: Field will reflect "customers first & last name"
- Example: Lisa Long Test
2. Orders place on TLC website's (Online Orders) : Field will reflect "Full Shopify Order Number"
- Example: 161508-OMG-WEB
- Example: 24235-CC-WEB
- Example: 29987-WB-WEB
B) WHS: Warehouse order is shipping from:
- All Countertop Parts & Units ship from PKY (Paris KY) for exception of West Bend Major Appliances & Microwaves.
- West Bend Major Appliances & Microwaves can also ship from : HNJ, SNV & WFL if stock is not available in PKY
C) CO no: This column reflects the M3 order number
- Older M3 order numbers began with: 10000 followed by 5 digits
- Currently M3 Order Numbers begin with 1000 followed by 6 digits
D) HI/LOW order status
1. Status 22: Order is in back order status
2. Status 33: Order has not been picked.
- Order can be cancelled
- Modifications that can be made: change carrier , change shipping address, re-process payment to order
3. Status 44: Order has been processed
- No changes can be made
- Order can no longer be cancelled
4. Status 66: Order shipped- (Tracking may reflect on order)
- No changes can be made to order
-Order can no longer be cancelled
5. Status 77: Order shipped and is invoiced
- No changes can be made
- Order can no longer be cancelled
6. Status 90: Order has been cancelled/deleted by our CR Team
7. Status 99: System has been cancelled/deleted order
E) S: Stop Code: Payment status
1. Stop Code 3 : There is a payment issue (Reach out to Lisa Long for Countertop & Compact for payment status update)
2. Stop Code 2,7, & 8": Payment is under review (Reach out to Lisa Long (Countertop) & Richard Moreno (Compact) for payment status update)
3. Stop Code 9: Payment captured successful
4. Status "Blank" : Orders with No Payment ( S&H Waived)
- If order has a payment associated , there may be a payment issue (Reach out to Lisa Long for payment status update)
F) Ship Via: The chosen Carrier
E) Ent dt : Order entry date
F) Req dt: Requested ship date
How To Steps
1. Log into M3
2. Click on OIS300
3. You can set the Sorting order & view on how you are looking the order up in M3 by using the dropdown arrows select your view.
Example1: View Below: Sorting order: 1-C Order No / View: TLC3 Customer/Cust Order No "OR" TLC2-Customer Or
A)- Search by M3 order number
Example 1- Original OIS300 View
Example 2: View below is : Sorting Order: 30-Customer PO# / View D83 PO#
B) - Search is by Consumers first & last name
C)-Search is by Shopify order number
4) Viewing order lines
- Locate order and click (Highlight line) -> Left Side Bar Click "Order lines"
Viewing Shipping Address
-Click Order line --> Right side of page click "Addresses" to view shipping and billing address.
