-- failure template
INSERT INTO `tblapad_emailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`, `is_tenant_email_config_allowed`, `is_tenant`) VALUES (NULL, 'card_reader_shipping_failure', 'card-reader-shipping-label-creation-error', 'english', 'Card Reader Shipping Label Creation Error', 'Urgent: Shipping Label Creation Failed for Order #{order_number}', '<p style=\"font-size: 12pt\">Hello {admin_name},</p><br/><p style=\"font-size: 12pt\">We encountered an issue while attempting to generate a shipping label for <b>Order #{order_number}</b>.</p><br\><p style=\"font-size: 12pt\"><b>Order Details:</b></p>
<ul style="font-size: 12pt;">
        <li>
            <b>Customer Name: </b> {customer_name}             
        </li>
        <li>
            <b>Product: </b> {products}            
        </li>
        <li>
            <b>Reason for Failure: </b> {reason}            
        </li> 
</ul>
<p style=\"font-size: 12pt\">Since the shipping label could not be created automatically, please log in to the admin panel and manually create the shipping label as soon as possible. Once you have created the label, kindly update the order status in the system.</p><br\><p style=\"font-size: 12pt\">Your prompt action is greatly appreciated to ensure there are no shipping delays for our customer. If you have any questions or need assistance, please let us know.</p><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><span style="font-size: 12pt;">Contractor+ App</span><br/><span style="font-size: 12pt;">www.contractorplus.app</span>', '', NULL, '0', '1', '0', '0', '0');


-- success template
INSERT INTO `tblapad_emailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`, `is_tenant_email_config_allowed`, `is_tenant`) VALUES (NULL, 'card_reader_shipping_success', 'card-reader-shipping-label-creation-success', 'english', 'Card Reader Shipping Label Success', 'Shipping Label Successfully Created for Order #{order_number}', '<p style=\"font-size: 12pt\">Hello {admin_name},</p><br/><p style=\"font-size: 12pt\">We’re pleased to inform you that a shipping label has been successfully created for <b>Order #{order_number}</b>.</p><br/><p style=\"font-size: 12pt\"><b>Order Details:</b></p>
<ul style="font-size: 12pt;">
        <li>
            <b>Customer Name: </b> {customer_name}             
        </li>
        <li>
            <b>Product: </b> {products}            
        </li>
        <li>
            <b>Shipping Label ID: </b> {tracking_number}            
        </li>    
        <li>
            <b>Shipment Date: </b> {shipping_date}            
        </li>     
</ul>
<p style=\"font-size: 12pt\">Please proceed with printing the label and shipping the order at your earliest convenience. If you have any questions or concerns, feel free to reach out.<br\>Thank you for your prompt attention to this matter!</p><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><span style="font-size: 12pt;">Contractor+ App</span><br/><span style="font-size: 12pt;">www.contractorplus.app</span>', '', NULL, '0', '1', '0', '0', '0');