{"id":46987,"date":"2024-03-04T05:12:39","date_gmt":"2024-03-04T05:12:39","guid":{"rendered":"https:\/\/www.process.st\/templates\/google-sheets-order-tracking-template\/"},"modified":"2024-03-04T05:12:39","modified_gmt":"2024-03-04T05:12:39","slug":"google-sheets-order-tracking-template","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/google-sheets-order-tracking-template\/","title":{"rendered":"Google Sheets Order Tracking Template"},"content":{"rendered":"\n<section id=\"open-the-google-sheets-order-tracking-template\">\n <h2>Open the Google Sheets Order Tracking Template<\/h2>\n <div class=\"text-content\">\n  Open the Google Sheets Order Tracking Template to access the latest order information. This is where all the order details will be recorded and tracked throughout the process.\n <\/div>\n<\/section>\n<section id=\"enter-new-order-details-into-the-template\">\n <h2>Enter new order details into the template<\/h2>\n <div class=\"text-content\">\n  Enter the new order details into the Google Sheets Order Tracking Template. Include information such as customer name, product name, quantity, and any special instructions or notes related to the order.\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Customer Name <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Product Name <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"number-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Quantity <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"textarea-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Special Instructions <\/label> <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled class=\"form-control\"><\/textarea>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"update-the-status-of-the-order\">\n <h2>Update the status of the order<\/h2>\n <div class=\"text-content\">\n  Update the status of the order in the Google Sheets Order Tracking Template. This helps in keeping track of the progress of each order and ensures timely updates for the team and the customer.\n <\/div>\n <div class=\"select-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Order Status <\/label> <select disabled class=\"form-control\"> <option value=\"An option will be selected here\">An option will be selected here<\/option> <\/select>\n  <\/div>\n  <ul class=\"items\">\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      1\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Pending\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      2\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Processing\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      3\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Shipped\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      4\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Delivered\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      5\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Cancelled\n    <\/div><\/li>\n  <\/ul>\n <\/div>\n<\/section>\n<section id=\"review-the-shipping-information-provided\">\n <h2>Review the shipping information provided<\/h2>\n <div class=\"text-content\">\n  Review the shipping information provided by the customer. Ensure that all necessary details such as shipping address, contact information, and preferred shipping method are accurate and complete.\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Shipping Address <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Contact Information <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"select-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Shipping Method <\/label> <select disabled class=\"form-control\"> <option value=\"An option will be selected here\">An option will be selected here<\/option> <\/select>\n  <\/div>\n  <ul class=\"items\">\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      1\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Standard\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      2\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Expedited\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      3\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Express\n    <\/div><\/li>\n  <\/ul>\n <\/div>\n<\/section>\n<section id=\"check-the-payment-details-and-order-total\">\n <h2>Check the payment details and order total<\/h2>\n <div class=\"text-content\">\n  Check the payment details provided by the customer and verify the order total. Ensure that the payment information is accurate and the order total is correctly calculated.\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Payment Method <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"select-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Currency <\/label> <select disabled class=\"form-control\"> <option value=\"An option will be selected here\">An option will be selected here<\/option> <\/select>\n  <\/div>\n  <ul class=\"items\">\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      1\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     USD\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      2\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     EUR\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      3\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     GBP\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      4\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     AUD\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      5\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     CAD\n    <\/div><\/li>\n  <\/ul>\n <\/div>\n <div class=\"number-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Order Total <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"update-inventory-to-reflect-the-new-order\">\n <h2>Update inventory to reflect the new order<\/h2>\n <div class=\"text-content\">\n  Update the inventory records to reflect the new order. Deduct the quantity of the ordered product from the available stock in the inventory.\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Product Name <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"number-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Quantity Ordered <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"input-expected-delivery-date-based-on-shipping-method-and-location\">\n <h2>Input expected delivery date based on shipping method and location<\/h2>\n <div class=\"text-content\">\n  Input the expected delivery date based on the shipping method and location. Take into account the estimated shipping time for the selected shipping method and the destination of the order.\n <\/div>\n <div class=\"select-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Shipping Method <\/label> <select disabled class=\"form-control\"> <option value=\"An option will be selected here\">An option will be selected here<\/option> <\/select>\n  <\/div>\n  <ul class=\"items\">\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      1\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Standard\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      2\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Expedited\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      3\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Express\n    <\/div><\/li>\n  <\/ul>\n <\/div>\n <div class=\"select-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Destination Location <\/label> <select disabled class=\"form-control\"> <option value=\"An option will be selected here\">An option will be selected here<\/option> <\/select>\n  <\/div>\n  <ul class=\"items\">\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      1\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     North America\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      2\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Europe\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      3\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Asia\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      4\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     Australia\n    <\/div><\/li>\n   <li class=\"item\">\n    <div class=\"step-number-container\">\n     <div class=\"step-number\">\n      5\n     <\/div>\n    <\/div>\n    <div class=\"step-checkbox-container\">\n     <div class=\"step-checkbox\"><\/div>\n    <\/div>\n    <div class=\"item-name-static\">\n     South America\n    <\/div><\/li>\n  <\/ul>\n <\/div>\n <div class=\"date-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Expected Delivery Date <\/label>\n   <div class=\"date-container\">\n    <button type=\"button\" disabled class=\"btn btn-default\"> <i class=\"fa fa-calendar btn-icon\"><\/i> Date will be set here <\/button>\n   <\/div>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"check-customer-contact-information-for-delivery-updates\">\n <h2>Check customer contact information for delivery updates<\/h2>\n <div class=\"text-content\">\n  Check the customer's contact information for delivery updates. Ensure that the contact details such as phone number and email address are correct and up to date to facilitate smooth communication regarding the delivery.\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Phone Number <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"email-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Email Address <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"approval-order-details\">\n <h2>Approval: Order Details<\/h2>\n <div class=\"approval-content\">\n  <div class=\"header\">\n   <div class=\"list-title\">\n    Will be submitted for approval:\n   <\/div>\n  <\/div>\n  <div class=\"approval-rule-subject-tasks-list\">\n   <ul class=\"list\">\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Enter new order details into the template<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Update the status of the order<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Review the shipping information provided<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Check the payment details and order total<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Update inventory to reflect the new order<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Input expected delivery date based on shipping method and location<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Check customer contact information for delivery updates<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n   <\/ul>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"send-order-confirmation-to-the-customer\">\n <h2>Send order confirmation to the customer<\/h2>\n <div class=\"text-content\">\n  Send an order confirmation email to the customer to provide them with a summary of their order details. Use the customer's email address provided earlier and include the order information in the email body.\n <\/div>\n <div class=\"send-rich-email-content form-field-content\">\n  <!-- No Recipients --> <!-- No Recipients --> <!-- No Recipients -->\n  <div class=\"form-group subject\">\n   <label>Subject<\/label>\n   <p class=\"form-control-static\">Order Confirmation - {{form.Customer_Name}}<\/p>\n  <\/div>\n  <div class=\"form-group body\">\n   <label>Body<\/label> <iframe srcdoc=\"<p>Dear customer,<\/p><p>Thank you for placing your order with us. We would like to confirm that we have received your order with the following details:<\/p><p>Product: {{form.Product_Name}}<\/p><p>Quantity: {{form.Quantity}}<\/p><p>Payment Method: {{form.Payment_Method}}<\/p><p>Total: {{form.Order_Total}}<\/p><p>Please feel free to contact us if you have any questions or require further assistance. We will keep you updated on the status of your order.<\/p><p>Best regards,<\/p><p>Your Company<\/p>\n<style>*{font-family:Inter,&quot;Segoe UI&quot;,&quot;Roboto&quot;,&quot;Oxygen&quot;,&quot;Ubuntu&quot;,&quot;Cantarell&quot;,&quot;Fira Sans&quot;,&quot;Droid Sans&quot;,&quot;Helvetica Neue&quot;,system-ui,sans-serif}<\/style>\n\" sandbox=\"\"><\/iframe>\n  <\/div>\n  <div class=\"form-group\">\n   <button type=\"button\" disabled class=\"btn btn-default\"> <i class=\"fa fa-envelope btn-icon\"><\/i> Send <\/button>\n  <\/div>\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Customer Name <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Product Name <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"number-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Quantity <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Payment Method <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"number-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Order Total <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"track-the-shipment-using-the-provided-tracking-number\">\n <h2>Track the shipment using the provided tracking number<\/h2>\n <div class=\"text-content\">\n  Track the shipment using the provided tracking number to monitor its progress. Follow the shipping carrier's online tracking system or contact their customer service for updates on the current location and estimated delivery time of the package.\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Tracking Number <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"url-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Shipping Carrier Website <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"update-the-status-of-the-order-once-the-item-is-shipped\">\n <h2>Update the status of the order once the item is shipped<\/h2>\n <div class=\"text-content\">\n  Update the status of the order in the Google Sheets Order Tracking Template once the item is shipped. Mark it as 'Shipped' to indicate that the package has been sent out for delivery.\n <\/div>\n <div class=\"date-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Shipping Date <\/label>\n   <div class=\"date-container\">\n    <button type=\"button\" disabled class=\"btn btn-default\"> <i class=\"fa fa-calendar btn-icon\"><\/i> Date will be set here <\/button>\n   <\/div>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"send-shipping-update-to-the-customer\">\n <h2>Send shipping update to the customer<\/h2>\n <div class=\"text-content\">\n  Send a shipping update email to the customer to inform them that their package has been shipped. Include the tracking number and a link to track the shipment for their convenience.\n <\/div>\n <div class=\"send-rich-email-content form-field-content\">\n  <!-- No Recipients --> <!-- No Recipients --> <!-- No Recipients -->\n  <div class=\"form-group subject\">\n   <label>Subject<\/label>\n   <p class=\"form-control-static\">Shipping Update - Order {{form.Tracking_Number}}<\/p>\n  <\/div>\n  <div class=\"form-group body\">\n   <label>Body<\/label> <iframe srcdoc=\"<p>Dear customer,<\/p><p>We are pleased to inform you that your order with tracking number {{form.Tracking_Number}} has been shipped. You can track the progress of your shipment using the following link: <a href='{{form.Shipping_Carrier_Website}}'>Track Your Order<\/a>.<\/p><p>If you have any questions or need further assistance, please don't hesitate to reach out to us.<\/p><p>Best regards,<\/p><p>Your Company<\/p>\n<style>*{font-family:Inter,&quot;Segoe UI&quot;,&quot;Roboto&quot;,&quot;Oxygen&quot;,&quot;Ubuntu&quot;,&quot;Cantarell&quot;,&quot;Fira Sans&quot;,&quot;Droid Sans&quot;,&quot;Helvetica Neue&quot;,system-ui,sans-serif}<\/style>\n\" sandbox=\"\"><\/iframe>\n  <\/div>\n  <div class=\"form-group\">\n   <button type=\"button\" disabled class=\"btn btn-default\"> <i class=\"fa fa-envelope btn-icon\"><\/i> Send <\/button>\n  <\/div>\n <\/div>\n <div class=\"text-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Tracking Number <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n <div class=\"url-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Shipping Carrier Website <\/label> <input type=\"text\" placeholder=\"Something will be typed here...\" disabled class=\"form-control\">\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"monitor-delivery-and-update-status-accordingly\">\n <h2>Monitor delivery and update status accordingly<\/h2>\n <div class=\"text-content\">\n  Monitor the delivery of the package and update the status accordingly in the Google Sheets Order Tracking Template. If any delays or issues occur during the delivery process, make appropriate notes and communicate with the customer as necessary.\n <\/div>\n<\/section>\n<section id=\"confirmation-of-order-receipt-by-customer\">\n <h2>Confirmation of order receipt by customer<\/h2>\n <div class=\"text-content\">\n  Confirm the receipt of the order with the customer. Follow up with an email or call to verify if the customer has received the package and if they are satisfied with their order.\n <\/div>\n <div class=\"members-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Customer Contact <\/label> <select disabled class=\"form-control\"> <option value=\"A member or group will be selected here\">A member or group will be selected here<\/option> <\/select>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"approval-delivery-confirmation\">\n <h2>Approval: Delivery Confirmation<\/h2>\n <div class=\"approval-content\">\n  <div class=\"header\">\n   <div class=\"list-title\">\n    Will be submitted for approval:\n   <\/div>\n  <\/div>\n  <div class=\"approval-rule-subject-tasks-list\">\n   <ul class=\"list\">\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Track the shipment using the provided tracking number<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Update the status of the order once the item is shipped<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Send shipping update to the customer<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Monitor delivery and update status accordingly<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n    <li>\n     <div class=\"approval-rule-subject-tasks-list-item\">\n      <div class=\"item\">\n       <div class=\"container\">\n        <span class=\"title\">Confirmation of order receipt by customer<\/span>\n        <div class=\"body\">\n         Will be submitted\n        <\/div>\n       <\/div>\n      <\/div>\n     <\/div><\/li>\n   <\/ul>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"update-the-order-status-to-complete\">\n <h2>Update the order status to complete<\/h2>\n <div class=\"text-content\">\n  Update the order status in the Google Sheets Order Tracking Template to 'Complete' once the customer has confirmed the order receipt. This indicates that the order process has been successfully completed.\n <\/div>\n<\/section>\n<section id=\"archive-the-completed-order-data\">\n <h2>Archive the completed order data<\/h2>\n <div class=\"text-content\">\n  Archive the completed order data for future reference and record keeping. This ensures that the order information is stored securely and can be accessed if needed for any future inquiries or audits.\n <\/div>\n <div class=\"file-field-content form-field-content\">\n  <div class=\"form-group\">\n   <label> Order Receipt <\/label>\n   <div class=\"file-container\">\n    <button type=\"button\" disabled class=\"btn btn-default\"> <i class=\"fa fa-upload btn-icon\"><\/i> File will be uploaded here <\/button>\n   <\/div>\n  <\/div>\n <\/div>\n<\/section>\n<section id=\"prepare-for-the-next-order-entry\">\n <h2>Prepare for the next order entry<\/h2>\n <div class=\"text-content\">\n  Prepare for the next order entry by organizing the workspace, restocking inventory if necessary, and ensuring all necessary tools and resources are readily available for the next order processing.\n <\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Open the Google Sheets Order Tracking Template Open the Google Sheets Order Tracking Template to access the latest order information. This is where all the order details will be recorded and tracked throughout the process. Enter new order details into the template Enter the new order details into the Google Sheets Order Tracking Template. Include [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"19","template_description":"Manage your orders effortlessly with our Google Sheets Order Tracking Template, efficiently overseeing inventory, payments, order status, and customer communication.","template_id":"iyjw6eDuh3sV9iijlsdAtA","task_0":"Open the Google Sheets Order Tracking Template","task_slug_0":"open-the-google-sheets-order-tracking-template","task_1":"Enter new order details into the template","task_slug_1":"enter-new-order-details-into-the-template","task_2":"Update the status of the order","task_slug_2":"update-the-status-of-the-order","task_3":"Review the shipping information provided","task_slug_3":"review-the-shipping-information-provided","task_4":"Check the payment details and order total","task_slug_4":"check-the-payment-details-and-order-total","task_5":"Update inventory to reflect the new order","task_slug_5":"update-inventory-to-reflect-the-new-order","task_6":"Input expected delivery date based on shipping method and location","task_slug_6":"input-expected-delivery-date-based-on-shipping-method-and-location","task_7":"Check customer contact information for delivery updates","task_slug_7":"check-customer-contact-information-for-delivery-updates","task_8":"Approval: Order Details","task_slug_8":"approval-order-details","task_9":"Send order confirmation to the customer","task_slug_9":"send-order-confirmation-to-the-customer","task_10":"Track the shipment using the provided tracking number","task_slug_10":"track-the-shipment-using-the-provided-tracking-number","task_11":"Update the status of the order once the item is shipped","task_slug_11":"update-the-status-of-the-order-once-the-item-is-shipped","task_12":"Send shipping update to the customer","task_slug_12":"send-shipping-update-to-the-customer","task_13":"Monitor delivery and update status accordingly","task_slug_13":"monitor-delivery-and-update-status-accordingly","task_14":"Confirmation of order receipt by customer","task_slug_14":"confirmation-of-order-receipt-by-customer","task_15":"Approval: Delivery Confirmation","task_slug_15":"approval-delivery-confirmation","task_16":"Update the order status to complete","task_slug_16":"update-the-order-status-to-complete","task_17":"Archive the completed order data","task_slug_17":"archive-the-completed-order-data","task_18":"Prepare for the next order entry","task_slug_18":"prepare-for-the-next-order-entry","task_19":"","task_slug_19":"","task_20":"","task_slug_20":"","task_21":"","task_slug_21":"","task_22":"","task_slug_22":"","task_23":"","task_slug_23":"","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[115,35],"tags":[],"class_list":["post-46987","post","type-post","status-publish","format-standard","hentry","category-inventory-management","category-supply-chain"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/46987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=46987"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/46987\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=46987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=46987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=46987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}