INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('BUYERAPP_STATUS', 1, 'Status', 3)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('buyerapp_message_b', 1, 'Message', 3)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('buyerapp_reason', 1, 'Reason', 3)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('buyerapp_request_system', 1, 'Request System Owner To Get Your Account Information', 3)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_configurations` (`conf_name`, `conf_val`, `conf_common`) VALUES
('CONF_COOKIES_TEXT_1', 'Growcer uses cookies to monitor the performance of this website and improve user experience. To find out more about cookies, please see our privacy policy.', 0)
ON DUPLICATE KEY UPDATE conf_val = VALUES(conf_val), conf_common = VALUES(conf_common);
ALTER TABLE `tbl_products` ADD INDEX( `product_seller_id`);
ALTER TABLE `tbl_products` ADD INDEX( `product_brand_id`);

INSERT INTO `tbl_extra_pages_lang` (`epagelang_epage_id`, `epagelang_lang_id`, `epage_label`, `epage_content`) VALUES
(31, 1, 'Explore the Grocery Marketplace Apps built with Growcer', '\n<div class=\"col-md-5 col-xl-6 d-none d-lg-block\">                    \n	<div class=\"app-screenshot\">                      <img src=\"/images/app-screen.png\" />                    </div>                </div>                \n<div class=\"col-lg-7 col-xl-6\">                    \n	<div class=\"download-app\">                        \n		<h2>Explore the Grocery Marketplace Apps built with Growcer</h2>                        \n		<p>It`s all at your fingertips -- the restaurants you love. Find the right food to suit your mood, and make the first bite last. Go ahead, download us.</p>                        \n		<div class=\"download-app__links\">                            \n			<h5>Or Download from here</h5>                            \n			<div class=\"app-links\">                              <a href=\"\"><img src=\"/images/google-play-store.png\" /></a>                              <a href=\"\"><img src=\"/images/app-store.png\" /></a>                            </div>                        </div>                    </div>                </div>')
ON DUPLICATE KEY UPDATE epage_label = VALUES(epage_label), epage_content = VALUES(epage_content);


UPDATE `tbl_extra_pages` 
SET `epage_identifier` = 'Download the Growcer app' Where `epage_type` = 31;

UPDATE `tbl_extra_pages_lang` 
SET `epage_label` = 'Download the Growcer app',
`epage_content` = '<section class="section" data-collection="section" >
	<div class="container">
		<div class="get-app">
			<div class="app-screen">
				<img src="/images/app-screen.png" alt="">
			</div>
			<div class="app-data">
				<h3>Download the Growcer app</h3>
				<p>Access video consultation with India’s top doctors on the Practo app. Connect with doctors online, available 24/7, from the comfort of your home.</p>
				<h4>Or Download from here</h4>
				<div class="app-actions">
					<a class="link-add" href="">
						<img src="/images/google-play.png" alt="">
					</a>
					<a class="link-add" href="">
						<img src="/images/app-store.png" alt="">
					</a>
				</div>
			</div>
		</div>
	</div>
</section>'
Where `epagelang_epage_id` = (SELECT epage_id FROM `tbl_extra_pages` WHERE `epage_type` = 31);

UPDATE `tbl_extra_pages_lang` 
SET `epage_content` = '<section class="section" data-collection="section" >
    <div class="container">
        <div class="incentives-layout-1">
            <div class="incentives">
                <div class="incentives-icon">
                    <img src="/images/agile-delivery.svg" width="109" height="109" alt="">
                </div>
                <h3 class="incentives-title">Agile Delivery</h3>
                <p class="incentives-text">Our proficient experts ensure quality delivery within the required timeframe.</p>
            </div>
            <div class="incentives">
                <div class="incentives-icon">
                    <img src="/images/impeccable.svg" width="109" height="109" alt="">
                </div>
                <h3 class="incentives-title">Impeccable UI/UX</h3>
                <p class="incentives-text">From the ordering phase till delivery, our seamless UI/UX provides an effortless shopping experience</p>
            </div>
            <div class="incentives">
                <div class="incentives-icon">
                    <img src="/images/unmatchable.svg" width="109" height="109" alt="">
                </div>
                <h3 class="incentives-title">Unmatchable Pricing</h3>
                <p class="incentives-text">We offer exceptional grocery with best-in-class services at competitive prices.</p>
            </div>
        </div>
    </div>
</section>'
Where `epagelang_epage_id` = (SELECT epage_id FROM `tbl_extra_pages` WHERE `epage_type` = 28);

UPDATE `tbl_collections` SET `collection_primary_records` = 2 WHERE `collection_type` = 4 AND `collection_layout_type` = 7;
UPDATE `tbl_collections` SET `collection_primary_records` = 7 WHERE `collection_type` = 2 AND `collection_layout_type` = 4;

UPDATE `tbl_plugins` SET `plugin_identifier` = 'Sign In With Apple' WHERE plugin_code = 'AppleLogin';

INSERT INTO `tbl_plugins` (`plugin_identifier`, `plugin_type`, `plugin_code`, `plugin_active`, `plugin_display_order`) VALUES
('Sign In With Google', 3, 'GoogleLogin', 0, 1),
('Sign In With Facebook', 3, 'FacebookLogin', 0, 1)
ON DUPLICATE KEY UPDATE plugin_identifier = VALUES(plugin_identifier);

INSERT INTO `tbl_plugins_lang`(`pluginlang_plugin_id`, `pluginlang_lang_id`, `plugin_name`) VALUES 
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'GoogleLogin'), 1, 'Sign In With Google'),
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'AppleLogin'), 1, 'Sign In With Apple'),
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'FacebookLogin'), 1, 'Sign In With Facebook')
ON DUPLICATE KEY UPDATE plugin_name = VALUES(plugin_name);

INSERT INTO `tbl_plugin_settings`(`pluginsetting_plugin_id`, `pluginsetting_key`, `pluginsetting_value`) VALUES 
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'GoogleLogin'),'developer_key', (SELECT conf_val FROM tbl_configurations WHERE conf_name = 'CONF_GOOGLE_DEVELOPER_KEY')),
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'GoogleLogin'),'client_id', (SELECT conf_val FROM tbl_configurations WHERE conf_name = 'CONF_GOOGLE_CLIENT_ID')),
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'GoogleLogin'),'client_secret', (SELECT conf_val FROM tbl_configurations WHERE conf_name = 'CONF_GOOGLE_CLIENT_SECRET')),
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'FacebookLogin'),'app_id', (SELECT conf_val FROM tbl_configurations WHERE conf_name = 'CONF_FACEBOOK_APP_ID')),
((SELECT plugin_id FROM tbl_plugins WHERE plugin_code = 'FacebookLogin'),'app_secret', (SELECT conf_val FROM tbl_configurations WHERE conf_name = 'CONF_FACEBOOK_APP_SECRET'))
ON DUPLICATE KEY UPDATE pluginsetting_key = VALUES(pluginsetting_key), pluginsetting_value = VALUES(pluginsetting_value);

DELETE FROM tbl_configurations WHERE `conf_name` = 'CONF_DEFAULT_PLUGIN_3';
UPDATE `tbl_banner_locations` SET `blocation_banner_count` = '3' WHERE `blocation_identifier` like 'Banner Layout 1';

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '640', `blocation_banner_height` = '360'  WHERE `bldimension_device_type` = 3 and `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Banner Layout 2');

DELETE FROM tbl_language_labels WHERE `label_key` = 'ERR_PLEASE_CONTACT_YOUR_ADMINISTRATOR';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_NO_PAYMENT_METHOD_FOUND';
ALTER TABLE `tbl_blog_post` ADD `post_featured` TINYINT(1) NOT NULL AFTER `post_comment_opened`;

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '1502', `blocation_banner_height` = '481'  WHERE `bldimension_device_type` = 1 and `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Banner Layout 2');

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '1024', `blocation_banner_height` = '341'  WHERE `bldimension_device_type` = 2 and `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Banner Layout 2');

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '1502', `blocation_banner_height` = '481'  WHERE `bldimension_device_type` = 1 and `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Bottom Banner');

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '1024', `blocation_banner_height` = '341'  WHERE `bldimension_device_type` = 2 and `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Bottom Banner');

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '660', `blocation_banner_height` = '330'  WHERE `bldimension_device_type` = 3 and `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Bottom Banner');

UPDATE `tbl_banner_location_dimensions` SET `blocation_banner_width` = '500', `blocation_banner_height` = '375'  WHERE `bldimension_blocation_id` = (select `blocation_id` from `tbl_banner_locations` where `blocation_identifier` like 'Banner Layout 1');
UPDATE `tbl_banner_locations` SET `blocation_banner_count` = '3' WHERE `blocation_id` = 1;
ALTER TABLE `tbl_user_transactions` ADD INDEX( `utxn_user_id`);
ALTER TABLE `tbl_user_wish_list_products` ADD INDEX( `uwlp_selprod_id`);
ALTER TABLE `tbl_user_wish_lists` ADD INDEX( `uwlist_user_id`);

ALTER TABLE `tbl_brands` ADD `brand_banner_updated_on` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `brand_logo_updated_on`;

-- -------------------TV-2.1.0.20230213----------------------

UPDATE `tbl_collections` SET `collection_primary_records` = '8' WHERE `collection_type` = 3 AND `collection_layout_type` = 6 AND `collection_data_type` = 3;
UPDATE `tbl_collections` SET `collection_primary_records` = '8' WHERE `collection_type` = 3 AND `collection_layout_type` = 6 AND `collection_data_type` = 4;
UPDATE `tbl_collections` SET `collection_primary_records` = '12' WHERE `collection_type` = 1 AND `collection_layout_type` = 2 AND `collection_data_type` = 6;
UPDATE `tbl_collections` SET `collection_primary_records` = '8' WHERE `collection_type` = 1 AND `collection_layout_type` = 1 AND `collection_data_type` = 6;


--
-- Table structure for table `tbl_content_pages_block_lang`
--

CREATE TABLE `tbl_content_pages_block_lang` (
    `cpblocklang_cpage_id` int NOT NULL,
    `cpblocklang_lang_id` int NOT NULL,
    `cpblocklang_block_id` int NOT NULL,
    `cpblocklang_text` mediumtext COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY `cpblocklang_cpage_id` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`,`cpblocklang_block_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



INSERT INTO `tbl_content_pages_block_lang` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`, `cpblocklang_block_id`, `cpblocklang_text`) VALUES ('1', '1', '1', '<div class="content-block-img"> <img src="../images/about-left-pic.png" alt="" /> </div>
<div class="content-block-cms">    
	<div class="cms cms-about-us">        
		<h2>Who We Are</h2>        
		<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text.</p>        
		<ul>            
			<li>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li>            
			<li>Proin dictum tortor et ex mollis dignissim.</li>            
			<li>Nullam commodo lorem vitae tortor consectetur, in suscipit nisi dignissim.</li>            
			<li>Etiam at nunc vel ipsum vestibulum vehicula.</li>            
			<li>Vestibulum condimentum metus ut feugiat euismod.</li>        
		</ul>    </div></div>');


INSERT INTO `tbl_content_pages_block_lang` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`, `cpblocklang_block_id`, `cpblocklang_text`) VALUES ('1', '1', '2', '
<div class="section-head section-head-center">    
	<div class="section-heading">        
		<h2>We have impactful results</h2>    </div></div>
<div class="stats">    
	<div class="stats-block">        
		<h4>99%</h4>        
		<p>Customer satisfaction</p>    </div>    
	<div class="stats-block">        
		<h4>32M</h4>        
		<p>Original Artworks</p>    </div>    
	<div class="stats-block">        
		<h4>94K</h4>        
		<p>Emerging Artists</p>    </div>    
	<div class="stats-block">        
		<h4>110+</h4>        
		<p>Countries Represented</p>    </div></div>');

INSERT INTO `tbl_content_pages_block_lang` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`, `cpblocklang_block_id`, `cpblocklang_text`) VALUES ('1', '1', '3', '
<div class="section-head section-head-center">                                    
	<div class="section-heading">                                        
		<h2>Why should I use GoodMarket? </h2>                                    </div>                                </div>                                
<div class="row justify-content-center">                                    
	<div class="col-lg-10">                                        
		<div class="row justify-content-center">                                            
			<div class="col-lg-4">                                                
				<div class="card-how">                                                    
					<div class="card-how-head">                                                        
						<div class="icon">                                                            <img src="../images/step-1.png" alt="" />                                                        </div>                                                    </div>                                                    
					<div class="card-how-body">                                                        
						<h3>Step 1</h3>                                                        
						<h4>Searching is Easy For Products </h4>                                                    </div>                                                    
					<div class="card-how-foot">                                                        
						<p>Discover new products and shop for all your food and grocery needs from the comfort of your home or office.

                                                        </p>                                                    </div>                                                </div>                                            </div>                                            
			<div class="col-lg-4">                                                
				<div class="card-how">                                                    
					<div class="card-how-head">                                                        
						<div class="icon" style="background-color: rgb(255, 245, 246);">                                                            <img src="../images/step-2.png" alt="" />                                                        </div>                                                    </div>                                                    
					<div class="card-how-body">                                                        
						<h3>Step 2</h3>                                                        
						<h4>Shop Online Smartly
                                                        </h4>                                                    </div>                                                    
					<div class="card-how-foot">                                                        
						<p>Food shopping online is now easy as every product on your monthly shopping list, is now available online.

                                                        </p>                                                    </div>                                                </div>                                            </div>                                            
			<div class="col-lg-4">                                                
				<div class="card-how">                                                    
					<div class="card-how-head">                                                        
						<div class="icon" style="background-color: rgb(255, 249, 241);">                                                            <img src="../images/step-3.png" alt="" />                                                        </div>                                                    </div>                                                    
					<div class="card-how-body">                                                        
						<h3>Step 3</h3>                                                        
						<h4>Get Everything You Need
                                                        </h4>                                                    </div>                                                    
					<div class="card-how-foot">                                                        
						<p>No more getting stuck in traffic jams, paying for parking, standing in long queues and carrying heavy bags.

                                                        </p>                                                    </div>                                                </div>                                            </div>                                        </div>                                    </div>                                </div>');


INSERT INTO `tbl_content_pages_block_lang` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`, `cpblocklang_block_id`, `cpblocklang_text`) VALUES ('1', '1', '4', '<div class="content-block">    
	<div class="content-block-img"> <img src="../images/about-left-pic.png" alt="" /> </div>    
	<div class="content-block-cms">        
		<div class="cms cms-about-us">            
			<h2> About Growcer platform</h2>            
			<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.
                <br />
				                <br />
				                It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
            </p>        </div>    </div></div>
<div class="content-block">    
	<div class="content-block-img"> <img src="../images/about-left-pic-2.png" alt="" /> </div>    
	<div class="content-block-cms">        
		<div class="cms cms-about-us">            
			<h2>We believe in talent</h2>            
			<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. </p>        </div>    </div></div>
<div class="content-block">    
	<div class="content-block-img"> <img src="../images/about-left-pic-3.png" alt="" /> </div>    
	<div class="content-block-cms">        
		<div class="cms cms-about-us">            
			<h2>We support our local makers</h2>            
			<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy.</p>        </div>    </div></div>    ');


INSERT INTO `tbl_content_pages_block_lang` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`, `cpblocklang_block_id`, `cpblocklang_text`) VALUES ('1', '1', '5', '
<div class="col-lg-6 mb-4 mb-md-0">    
	<div class="cms cms-about-us">        
		<h3>What We Do</h3>        
		<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium,
            totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo.Eenim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia
            consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi
            tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. </p> <img class="mt-2" src="/images/what-we.jpg" alt="" />    </div></div>
<div class="col-lg-6">    
	<div class="cms cms-about-us">        
		<h3>What We Do</h3>        
		<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium,
            totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo.Eenim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia
            consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi
            tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. </p> <img class="mt-2" src="/images/what-we-do.jpg" alt="" />    </div></div>   ');

INSERT INTO `tbl_content_pages_block_lang` (`cpblocklang_cpage_id`, `cpblocklang_lang_id`, `cpblocklang_block_id`, `cpblocklang_text`) VALUES ('1', '1', '6', '
<div class="section-heading">    
	<h2>Or Start your business with Growcer Multivendor Platform </h2><a href="https://demo.yogrowcer.com/supplier" class="btn btn-brand">Start Selling Now</a></div>');

DELETE FROM tbl_extra_pages WHERE epage_type = 37;
INSERT INTO `tbl_extra_pages` (`epage_identifier`, `epage_type`, `epage_active`, `epage_default`, `epage_default_content`, `epage_content_for`) VALUES
('Seller Import General Settings', 37, 1, 0, "<h5>Multilingual</h5>
<p> Since {website-name} inherently is a multilingual platform all export-import functionality wherever available in the system will only work for the particular language exported or imported in. This means that a file that is exported in English will only update English values when imported back into the system. Same items in other languages will not be updated until the user exports the same CSV in other languages makes changes and imports it back to the system.</p>
  
<h5>Import/Export process</h5>
<p>As a practice, it is always recommended to export the CSV first make changes to it and then import it back into the system. This practice will ensure the accuracy of the CSV file and minimize any errors during import.</p>
 
<h5>Images/Media Files</h5><p>Any type of images/media can only be imported into the system if the file is located at a public URL. For example, the file should be hosted either on a server that is accessible publically or on online tools such as Dropbox/Google Drive etc. Please note that images saved on devices and desktops cannot be imported through the CSV.</p><p>
 Once the media CSV is imported into the system, a cron job is executed by the system to import and save the images on the server. This cron job is an automated script that the system runs after a set interval on its own and no intervention is required from the user's end. The media/images imported into the system will not display immediately.</p>


<h5>Deleting Items</h5><p>Within {website-name} when an item is deleted, the system does not delete the item from the database rather it just hides the item from the display. With the import functionality, a user can restore a previously deleted item by changing the value of the deleted column from 'Yes' to 'No'.</p>
   
<h5>Import Log File</h5><p>{website-name} will generate a CSV log file for every import action where it will log the column and row for the errors encountered during the import. If the import was successful then no log file will be generated. The system will only allow importing the CSV if no errors are encountered.</p>
  
<h5>CSV</h5><p>To avoid errors it is recommended to not alter columns or their names/headers in the CSV. Also to import bulk entries it is recommended to keep maximum entries to a count of 20,000 per sheet. It is recommended to make multiple sheets for data above 20,000.</p>
  
<h5>Import Export {website-name} Settings</h5><p>Only turn on/off settings from the settings console if you are familiar with boolean concepts and understand how ids will work in a CSV. Also turning on settings from the import-export settings tab may alter or add columns to the CSV. These columns are not defined in the instructions tab.</p>", 1)
ON DUPLICATE KEY UPDATE epage_default_content = VALUES(epage_default_content);

	ALTER TABLE `tbl_orders` ADD INDEX( `order_is_paid`);
	ALTER TABLE `tbl_payment_methods` ADD INDEX( `pmethod_code`);
	ALTER TABLE `tbl_order_products` ADD INDEX( `op_selprod_id`);
	ALTER TABLE `tbl_banners` ADD INDEX( `banner_blocation_id`);
	ALTER TABLE `tbl_promotions` ADD INDEX( `promotion_duration`);
	ALTER TABLE `tbl_promotions` ADD INDEX( `promotion_budget`);

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<p>Allthe information you need regarding this page</p>             \r\n             	\r\n	<ul class=\"\">                    \r\n		<li>                        This page lists all the marketplace products added by admin and seller.\r\n                        Marketplace products are of two types:-\r\n                        \r\n			<ul>                            \r\n				<li><strong>System Products</strong>: Available to all sellers and any seller can add to their own store.</li>                            \r\n				<li><strong>My Products</strong>: Available only for you. No other seller can add to their own store.</li>                        \r\n			</ul>                    </li>                    \r\n		<li>On clicking \"<strong>Add Product</strong>\" button, seller can add new product to marketplace products.</li>                    \r\n		<li>On click of \"<strong>Add to Store</strong>\" the seller can pick the product and add the products to his store inventory.</li>                \r\n	</ul> ' WHERE `tbl_extra_pages`.`epage_type` = 53;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<p>All the information you need regarding this page</p>              \r\n	<ul>                    \r\n		<li>This tab lists all the products requested by seller to the admin which are not available in the marketplace products.</li>\r\n		<li>On admin approval, the product will be added to the marketplace products and to the seller inventory.</li>                \r\n	</ul>' WHERE `tbl_extra_pages`.`epage_type` = 55;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<p>All the information you need regarding this page</p>\r\n	<ul class=\"\">                    \r\n		<li>This tab lists all the products available to your front end store.</li>\r\n		<li>For each product variant, separate copy need to be created by seller either from Marketplace product tab or clone product icon.</li>                    \r\n		<li>To add new product to your store inventory, seller will have to pick the products from the marketplace products tabs from \"Add to Store\" button</li>                \r\n	</ul>' WHERE `tbl_extra_pages`.`epage_type` = 54;
-- --------------TV-2.1.0.20230301-----------------------

UPDATE `tbl_configurations` SET `conf_val` = '<div class=\"modal-header\">\r\n    <h5 class=\"modal-title\">Growcer</h5>\r\n </div> \r\n <div class=\"modal-body demo-data-inner\">\r\n <p>To enhance your demo experience, we periodically restore our database every 4 hour(s).</p>\r\n <br> \r\n <p>For technical issues :-</p> \r\n <ul> \r\n <li><strong>Call us at: </strong>+1 469 844 3346, +91 85919 19191, +91 95555 96666, +91 73075 70707, +91 93565 35757</li> \r\n <li><strong>Mail us at : </strong> <a href=\"mailto:sales@fatbit.com\">Click here</a></li>\r\n </ul> \r\n <p>Create Your Dream Multi-vendor Ecommerce Store With Growcer <a href=\"https://www.yogrowcer.com/request-growcer-free-personalized-demo.php\" target=\"_blank\">Click here</a></p>\r\n </div>' WHERE `tbl_configurations`.`conf_name` = 'DEMO_MARKETING_POPUP_CONTENT';

DELETE FROM `tbl_language_labels` WHERE `tbl_language_labels`.`label_key` = 'LBL_View_WireFrame';


DELETE FROM `tbl_configurations` WHERE `conf_name` LIKE 'CONF_FRONT_THEME';
DROP TABLE `tbl_theme_colors`;
DROP TABLE `tbl_theme_colors_lang`;
-- --------------TV-2.1.0.20230310-----------------------

DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Canceled';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Plan_Canceled';


UPDATE `tbl_language_labels` SET `label_caption` = 'Add New Product' WHERE `tbl_language_labels`.`label_key` = 'LBL_Add_New_Product';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ADD_NEW_PRODUCT_CATALOG';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Custom_Catalog_Product_Setup';


INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('LBL_start_typing_to_get_the_exact_city_name', 1, 'Note: Start typing to get the exact required city name from the Map.<br/><br/> Sometimes, there can be multiple cities with the same name and the map is added to uniquely find the exact city that is required. <br/>this will be used to get only exact Longitude & Lattitude. Use the found city name for the below city identifier field.', 1)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);
CREATE TABLE `tbl_pages_language_data` (`plang_key` VARCHAR(100) NOT NULL ,  `plang_lang_id` INT NOT NULL ,  `plang_title` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ,  `plang_summary` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ,  `plang_warring_msg` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ,  `plang_recommendations` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL) DEFAULT CHARSET=utf8mb4;
ALTER TABLE `tbl_pages_language_data` ADD UNIQUE KEY( `plang_key`, `plang_lang_id`);
ALTER TABLE `tbl_pages_language_data` ADD `plang_id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`plang_id`);
ALTER TABLE `tbl_pages_language_data` ADD `plang_replacements` MEDIUMTEXT NOT NULL AFTER `plang_recommendations`;
ALTER TABLE `tbl_pages_language_data` ADD `plang_helping_text` LONGTEXT NOT NULL AFTER `plang_replacements`;

INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'NAV_DASHBOARD', '-1', 'DASHBOARD', 'Overview of the Sales stats, Analytics, Recent orders, Customers\' activities, Top-selling products, and many more.', '', '', '', '');

INSERT IGNORE INTO `tbl_pages_language_data` VALUES (1,'DASHBOARD',-1,'Dashboard','Overview of the Sales stats, Analytics, Recent orders, Customers\' activities, Top-selling products, and many more.','','','','\r\n'),(2,'BLOG_CATEGORIES',-1,'Blog Categories','Manage blog categories to sort and organise content into different sections.','','','','Deleting a category does not delete the posts in that category. Instead posts that were only assigned to the deleted category are set to the category.\r\n '),(3,'BLOG_POSTS',-1,'Blog Posts','Create and manage the blog content of your Website.','Post status of a Blog Post needs to be marked "Published" to get it displayed at Front end.','You can link a particular Blog Post to multiple Categories.','','\r\n<ul>  \r\n	<li>Blog Posts marked as \"Featured\" will get reflected under the \"Featured Blogs\" section at the Front End</li>  \r\n  \r\n	<li>Admin can enable or disable the feature of adding comments on these Blog Posts.</li>\r\n</ul>'),(4,'BLOG_CONTRIBUTION',-1,'Blog Contribution Requests','Manage the Blog requests placed by Users in case they want to share their thoughts and opinion.','Admin needs to create and publish such Blogs taking reference to the User\'s content.','','','\r\n<ul>  \r\n	<li>The Status of the \"Contribution Request\" by default will be \"Pending\".</li>  \r\n	<li>Admin can take the following actions on such Contribution Requests:    \r\n		<ul>\r\n			<li>Approved: If He approves the content and considers it appropriate to be published.</li>    \r\n			<li>Posted: If He Posts/Publishes the content in order to get it published at the Front end.</li>    \r\n      \r\n			<li>Rejected: If He finds the submitted content inappropriate and doesn\'t want to get it published at the Front end.</li>\r\n		</ul></li>\r\n</ul>'),(5,'BLOG_COMMENTS',-1,'Blog Comments','Manage the comments posted by users on the Blog Posts.','','Admin has the rights to edit the comments posted.','','\r\n<ul>  \r\n	<li>By default Status of the \"Comments\" posted will be marked \"Pending\".</li>  \r\n	<li>Admin can take the following actions on such posted comments:\r\n    \r\n		<ul>\r\n			<li>Approved: If Admin approves the comment and considers it appropriate to be published.</li>    \r\n      \r\n			<li>Rejected: If Admin finds the submitted comment inappropriate and doesn\'t want it to get published at the Front end.</li>\r\n		</ul></li>\r\n</ul>'),(6,'MANAGE_PRODUCTS',-1,'Manage Products Catalog','Manage Products listing (Catalog) for the Products added by Admin and Seller.','','','','\r\n<ul>  \r\n	<li>\"Master Products\" i.e. Products created by the Admin will be available to all the Sellers to add to their respective Inventories.</li>  \r\n	<li>Seller\'s Products (listed under \'My Products\' section on the Seller\'s Dashboard), created/added by a specific Seller will be available only to him to add to his Inventory. No other Sellers can add that product to their Inventories.</li>  \r\n	<li>A Product will be displayed at the StoreFront (Front End) only when a Seller has added stock of that Product in his/her Inventory.</li>  \r\n	<li>Sellers can add Products to their Inventories only when Admin chooses \'Allow Sellers To Add Products\' enabled from Settings > System Configuration > Product.</li>\r\n</ul>'),(7,'MANAGE_SELLER_INVENTORIES',-1,'Manage Sellers\' Products\' Inventories','View and Edit Sellers\' Products\' Inventories and Pricing.','','','','\r\n<div>Product Inventory refers to the collection of Items/Products representing the stock level (units) for each Product\'s variant added by Sellers in their e-store to sell.</div>\r\n<div>&nbsp;</div>\r\n<div>If any specific Product listed here is not found at the Storefront? This might be because:</div>\r\n<ul>    \r\n	<li>The Product doesn\'t fulfill the required conditions to get displayed at the Storefront.</li>\r\n</ul>'),(8,'MANAGE_SHOPS',-1,'Manage Shops','View and Manage Sellers’ registered Shops (Stores).','Inactive Shops will not be visible at Storefront (Front End)','','','\r\n<ul>  \r\n	<li>Buyers\' will view Shop information on the \'Shop Detail Page\' at the Storefront (Front End).</li>\r\n</ul>  '),(9,'MANAGE_CATEGORIES',-1,'Manage Product Categories ','Configure Product Categories to group similar items together at the Storefront. ','','Categories will be visible at the Storefront only if Product(s) is/are linked with them.','','\r\n<ul>  \r\n	<li>A number displayed corresponding to each category is the number of products linked with the category and its associated sub-categories.</li>  \r\n	<li>Editing the details of an existing \'Category\' will automatically get reflected in the entire System. \r\nIf any specific Category listed here is not found at the Storefront? This might be because:\r\n		<ul>  \r\n			<li>No Product(s) is linked to that particular \'Category\'.</li>    \r\n			<li>Products linked to a particular Category don\'t fulfill the required conditions to get displayed at the Storefront.</li>  \r\n  \r\n			<li>Parent Category or a specific Category within any of the Parent Categories has been deleted or marked Inactive.</li> \r\n		</ul>  </li>\r\n</ul>'),(10,'MANAGE_BRANDS',-1,'Manage Brands','Manage the Product\'s Brand related info (ex. Name, Logo, and Banner).','The Brand name should always be unique in order to avoid duplicity.','Add a Brand but do not repeat it. ','','\r\n<ul>  \r\n	<li>You can make \'Brand\' optional/mandatory for the Products under System Settings >> Configuration>> Product.</li>  \r\n	<li>You can allow/inhibit Sellers from placing a \'Brand Request\' under System Settings >> configuration >> Product.</li>  \r\n	<li>Brands will be visible at the Storefront only if they are linked with Product(s).</li>  \r\n	<li>Brand not found at Storefront? This might be because you have: Marked its status Inactive or not linked any Products with that particular Brand.&nbsp;</li>\r\n</ul>   ');

INSERT IGNORE INTO `tbl_pages_language_data` VALUES (11,'MANAGE_OPTIONS',-1,'Manage Product Options','Set up different \'Options\' such as Color, Size, Dimensions etc. along with their respective \'Option Types\' like red, small, 4” x 8\" for the Product(s). ','','This module allows Admin/Admin\'s Sub Users to create and manage Options. To link an Option with a Product, Go to Products > Edit Product > Variant and Options Tab.','','What is an Option ?\r\n<ul>  \r\n	<li>Any entity (ex. Color, Size, etc) if changed, which creates an impact on Products\' variants\' pricing will be considered as an Option.</li>\r\n</ul>     '),(12,'MANAGE_TAGS',-1,'Product Tags','Add or Remove keywords (Tags) corresponding to each Product.','','Associated \'Tags\' help to manage and display the suitable Product Recommendation.','','\r\n'),(13,'MANAGE_PRODUCT_REVIEWS',-1,'Manage Product Reviews','Manage the reviews posted by Buyers for the delivered items.','','Buyers can post reviews if the review module is enabled from Settings  >> System Configuration >> Reviews','','\r\n<ul>\r\n	<li>Rating types can be managed under Settings >> Rating Types.</li>\r\n	<li>Once any new \'Review\' is received, you can \'Approve\', \'Cancel\' and leave the status of that Review as \'Pending\'</li>  \r\n	<li>System will prompt an error message when a user tries to submit a review by adding abusive words which are defined under Settings >> Abusive Keywords </li>\r\n</ul> '),(14,'THRESHOLD_PRODUCTS',-1,'Product Inventories Threshold ','View the sellers\' products\' inventories (units) whose stock is equal to or less than the defined threshold limit.','','Admin can send a reminder (email notification) to the selected seller from the below list.','','\r\n<ul>\r\n	<li>Sellers have the rights to setup threshold limits under their products inventory setup.</li>\r\n	<li>Admin can manage threshold limits under Product Catalog >> Sellers Inventory.</li>\r\n	<li>Alerts are sent automatically through email notification only when the above setting is enabled.</li>\r\n	<li>Alert email notification template is managed under the Settings >> Email template management.</li>\r\n</ul>'),(15,'SELLER_APPROVAL_REQUESTS',-1,'Sellers\' Approval Requests','Manage the status of new Sellers registered with the Platform.','','','','\r\n<ul>  \r\n	<li>Admin can enable/disable Sellers approval feature from the Settings >> System Configuration >> Account Tab. </li>\r\n</ul>     '),(16,'ORDER_CANCELLATION_REQUESTS',-1,'Order Cancellation Requests','Manage the status of \"Cancellation Requests\". ','','','','\r\n<ul>  \r\n	<li>Admin has the privilege to Add and View comments for those Requests whose Status is marked \"Approved\".</li>\r\n</ul>    '),(17,'MANAGE_ORDER_RETURN_REQUESTS',-1,'Order Return Requests','Manage the status of \"Orders Return Requests\".','','','','\r\n<ul>  \r\n	<li>Admin has the privilege to Add and View comments for those Requests whose Status is marked \"Refunded\".</li>  \r\n	<li>Admin can also reply to the message communication thread on the Return Request detail page.</li>\r\n</ul>       '),(18,'MANAGE_WITHDRAWAL_REQUESTS',-1,'Withdrawal Requests','Manage the status of payment Withdrawal Requests initiated by Buyers, Sellers, Advertisers, and Affiliates.','','','','\r\n<ul>  \r\n	<li>The Admin can set the minimum and maximum \'Withdrawal\' amount limits for the users from Settings >> Configuration Settings >> User Account tab.</li>  \r\n	<li>Admin has the privilege to Add comments while updating the Withdrawal Status. </li>\r\n</ul>      '),(18,'MANAGE_SELLER_PRODUCTS_REQUEST',-1,'Sellers Product Requests','Manage the status of new Products requested by Sellers to make them available under \"Sellers Catalog\". ','Approved Products (under Sellers Catalog) will not be available to other Sellers.','','','\r\n<ul>\r\n	<li>\'Seller Product Requests\' are initiated by Sellers for those Products that are a part of his/her own Catalog.</li>  \r\n	<li>Admin can enable/disable the approval on products added by Sellers under Settings > System Configuration > Product Tab</li>\r\n</ul>  '),(19,'MANAGE_BRAND_REQUEST',-1,'Brand Requests','Manage the status of the new \'Brands\' requested by the Sellers.','','Admin and Sellers will be able to link only the Approved Brands with their Products.\r\n','','\r\n<ul>  \r\n  \r\n	<li>Once the Brand Request has been approved by Admin, Sellers will be able to link the Approved Brands with their products.</li>\r\n	<li>Admin can manage Product Brands under Product Catalog >> Brands</li>\r\n</ul>       '),(20,'MANAGE_USER_GDPR_REQUEST',-1,'GDPR Requests','Review and respond to data deletion requests initiated by users. ','','','','');

INSERT IGNORE INTO `tbl_pages_language_data` VALUES (21,'MANAGE_ORDERS',-1,'Manage Orders ','View and Manage the Orders.','Orders with \"PAID\" Payment status cannot be deleted.','Newly placed orders always get listed at the top.','','\r\n<ul>   \r\n	<li>Admin can manage the order\'s status and view their status history.</li>  \r\n   \r\n	<li>Admin has an option to notify Buyers of the orders status update.</li>\r\n	<li>Admin can add the transaction status for the orders.</li>   \r\n	<li>Admin can print invoices for the orders.</li>\r\n	<li>Action buttons on this page facilitate you to view order details/delete that particular order.&nbsp;</li>  \r\n	<li>Order Status can be managed under left navigation >> Orders >> Order Statuses</li>  \r\n	<li>Orders configuration related settings can be managed under Settings >> System Configuration >> Checkout.</li>\r\n</ul> '),(22,'MANAGE_SELLER_ORDERS',-1,'Manage Seller\'s Orders ','View and Manage the Orders.','Orders with \"PAID\" Payment status cannot be deleted.','Newly placed orders always get listed at the top.','','\r\n<ul>   \r\n	<li>Admin can manage the order\'s status and view their status history.</li>  \r\n   \r\n	<li>Admin has an option to notify Buyers of the orders status update.</li>\r\n	<li>Admin can add the transaction status for the orders.</li>   \r\n	<li>Admin can print invoices for the orders.</li>\r\n	<li>Action buttons on this page facilitate you to view order details/delete that particular order.&nbsp;</li>  \r\n	<li>Order Status can be managed under left navigation >> Orders >> Order Statuses</li>  \r\n	<li>Orders configuration related settings can be managed under Settings >> System Configuration >> Checkout.</li>\r\n</ul> '),(23,'MANAGE_SUBSCRIPTION_ORDERS',-1,'Subscription Orders','Manage Sellers\' Subscription Orders and Update their payment status.','Subscription Orders with \"PAID\" Payment status cannot be deleted.','Newly placed subscription orders always get listed at the top.','','\r\n<ul>\r\n	<li style=\"text-align: left;\">Sellers subscription module can be enabled/disabled from Settings >> System Settings >> Subscription.</li>\r\n	<li style=\"text-align: left;\">Sellers packages can be managed under Settings => Sellers Packages.</li>\r\n	<li style=\"text-align: left;\">You can perform easy search by using different filter options provided on this page.</li>\r\n	<li style=\"text-align: left;\"> Action buttons on this page facilitate you to view order details/delete that particular order.&nbsp;</li>\r\n</ul>\r\n<div>\r\n	<div style=\"text-align: left;\"><br />\r\n		</div>&nbsp;</div>      '),(24,'MANAGE_ADMIN_USERS',-1,'Admin Users','Manage the Sub-Admin Users along with the Modules-Specific Permissions.','','','','\r\n<div>Depending upon the permission granted, a User can View, Add, Edit and Access a particular module.&nbsp;</div>\r\n<ul>\r\n	<li>‘None’ means no permission has been granted.</li>\r\n	<li> ‘Read Only’ means&nbsp;permission to \'only view\' that particular module has been granted.</li>  \r\n	<li>‘Read &amp; Write’ means Sub-admin users can View/Add/Edit information.</li>\r\n</ul>    '),(25,'MANAGE_USERS',-1,'Manage Users','View and Manage registered Users\' details.','','Admin can manage Buyers and Sellers registration-related configuration under Settings >> System Configuration >> Users Account.','','\r\n<ul>\r\n	<li>Affiliate registration-related configuration can be managed under Settings >> System Configuration >> Affiliate.</li>  \r\n	<li>Admin can send an email.</li>   \r\n	<li>Admin can manage Users\' cookies preferences.</li>  \r\n	<li>Admin can manage Users\' bank info.</li>  \r\n	<li>Admin can directly login to the Users\' account .</li>  \r\n</ul>  '),(26,'MANAGE_SELLER_APPROVAL_FORM',-1,'Manage Seller Information Form','Insert custom fields in a Seller Sign Up form as per your requirement.\r\n\r\n','','Change label, mandatory field, field type, field order with easy add, edit, drag and drop options. ','','\r\n<ul>\r\n	<li>The added form fields will show up under the Activation Tab of the Seller Sign Up form.</li>\r\n</ul>'),(27,'MANAGE_MESSAGES',-1,'Users Messages','View the message threads between buyers and seller.','','','','\r\n'),(28,'MANAGE_DISCOUNT_COUPONS',-1,'Discount Coupons','Manage discount coupons on Products (for Buyers) and Subscription packages (for Sellers).\r\n','','','','\r\n<ul>  \r\n	<li>Whenever a user applies a discount coupon during checkout, the coupon gets locked in the System for a period of 15 minutes so that user can proceed with payment and after that coupons are deemed used.</li>  \r\n	<li>All the active coupons are listed at the Front end discount coupon list.</li>\r\n</ul>   '),(29,'PROMOTIONS',-1,'PPC Promotions','Manage the list of PPC (pay-per-click) promotions (ads) configured by Sellers and Advertisers. ','','Admin can configure PPC promotions under Settings >> Configurations >> PPC Management','','\r\n<ul>  \r\n	<li>Sellers can promote their shops, products, banners, and slides by defining their budget on Daily/Monthly/Yearly basis.</li>  \r\n	<li>Advertiser can promote banners, and slides by defining their budget on Daily/Monthly/Yearly basis.</li>  \r\n	<li>A minimum wallet balance must be maintained by Sellers/Advertisers in order to run their promotions.</li>  \r\n	<li>Admin can define minimum wallet balance limit under Settings >> Configurations >>PPC Management.</li>\r\n</ul>  '),(30,'REWARDS_ON_PURCHASE',-1,'Reward on Purchase','Configure the Reward points for a definite Purchase amount/limit.','','Reward points will be credited to the Buyers\' account when their Order amount will match the defined Purchase amount.','','\r\n<ul>  \r\n	<li>Amount equivalent to the Rewards points (like: 10 Reward points = 1 USD) can be managed under Settings >> System Settings >> Rewards Points.</li>  \r\n	<li>Buyers can utilize these Rewards points during checkout.</li>\r\n</ul>  ');

INSERT IGNORE INTO `tbl_pages_language_data` VALUES (31,'MANAGE_COLLECTIONS',-1,'Manage Collections','Personalize and rearrange sections on your home page.','','Collections can be repeated as per your choice. You can choose different layouts for the same collection. ','','\r\n<ul>\r\n	<li>By default, the system will come with a few main collections already added to the list. You can edit these collections or delete them accordingly.</li>\r\n	<li>To add a new collection, click on New. Select the collection type and its layout. Fill in the related form and select the items that you want to display in the collection. </li>\r\n	<li>To unpublish a collection from the front end, simply turn OFF the toggle switch beside the collection. You can also delete it.</li>\r\n	<li>Collections can only be created once you have added products, brands, and categories to the platform. </li>\r\n</ul>'),(32,'MANAGE_SLIDES',-1,'Slides Management','Add and manage the slides that will be displayed in a slider at the top of the website\'s home page.','Multiple slides can be added here, but only four at a time will be displayed on the frontend.','Promotional slides added by advertisers and sellers will also be displayed along with these home page slides.','','\r\n<ul>\r\n	<li>The slides that you add under this module will all be displayed at the top of the home page.</li> \r\n  \r\n	<li>Admin can attach a link with each slide.</li>  \r\n	<li>Users of the Storefront will be directed to the attached link once they click these slides.</li>\r\n	<li>You can add multiple home page sliders by clicking on the New button.</li> \r\n	<li>The system will randomly choose 4 slides to display every time.</li> \r\n	<li>If there are many promotional slides in the queue, they will be given a higher priority and will be displayed most of the time instead of these home slides.</li> \r\n	<li>Hyperlink the slide to a specific URL when adding the slide details. With this, when a buyer clicks on the slide, they will be directed to the hyperlinked page.</li>\r\n</ul>'),(33,'MANAGE_NAVIGATIONS',-1,'Manage Navigations','Configure which items appear in the navigation menu for both the header and footer, and manage the order.','','','','\r\n<ul>\r\n	<li>You can change the sequence of the page listed under the navigation panel, or add new links to them.</li> \r\n	<li>To change the sequence, click on the grey area and drag and drop the page link. </li>\r\n	<li>To add a new link, click on the Add icon. Enter the caption name, which is the text that will be displayed on the front end. </li> \r\n	<li>You can add both onsite and offsite page links to the navigation panels. </li>\r\n</ul>'),(34,'MANAGE_CONTENT_PAGES',-1,'Content Pages','Create, manage, and modify content displayed on the website without the need for specialized technical knowledge.','','Try both webpage layouts before finalizing.','','\r\n<ul>\r\n	<li>You can add more content pages to the platform by clicking on New </li>\r\n	<li>The system offers two types of layouts. To view the layout designs available, click on Layouts/</li>\r\n	<li>The process to create a new content page for the platform includes, giving it a name, choosing a layout, and uploading the content and media that will be displayed on the page under the language data tab</li>\r\n</ul>'),(35,'MANAGE_CONTENT_BLOCK',-1,'Content Block','Use a predefined list of content blocks to edit text, images, and more from the given listing.\r\n','Once a content block is updated, the updated content will be displayed everywhere the content block is used.','','','\r\n<ul>\r\n	<li>The platform allows you to personalize multiple sections of the website by editing its content and images through these content blocks</li> \r\n	<li>The system comes with 16 pre-defined content blocks that you can personalize</li>\r\n	<li>You can\'t add nor delete a content block. If you do not want to publish a listed content block, deactivate it by turning OFF the toggle switch beside it</li>\r\n	<li>Edit the content block details by clicking on the edit icon beside it. Almost every content block has a different layout. Update them accordingly</li>\r\n</ul>'),(36,'MANAGE_LABELS',-1,'Manage Labels','Labels represent arbitrary text used with various input fields, buttons, messages (success or error), and more.','The platform offers multiple languages. Use language-specific labels appropriately.','','','\r\n<ul>\r\n	<li>A label is a component that places the text in a container. It defines the object beside it. For instance, on a form, for the \"Description\" text field, \"description\" is the label. </li>\r\n	<li>Edit any label on the platform from this preconfigured list of labels that comes with the system.</li>\r\n	<li>Search for a label using the search bar at the top of the list.</li>\r\n	<li>There are two kinds of labels - web and app. </li>\r\n	<li>Update both the web application platform and mobile application platform labels by clicking on the edit icon beside them. </li>\r\n	<li>No label can be deleted from the system.</li>\r\n</ul>'),(37,'MANAGE_FAQ_CATEGORIES',-1,'FAQs Categories','Use this screen to organize FAQ\'s content into their associated categories.','','','','\r\n<ul>\r\n	<li>If you do not want to publish an FAQ category, deactivate it by turning OFF the toggle switch beside it.</li> \r\n	<li>Click on the FAQ Listing icon to view the list of all the FAQs added under a category. Add more FAQs under this category by clicking on New. </li>\r\n	<li>When adding a new FAQ data, enter the question as the FAQ title and the answer to this question in the description field. </li>\r\n	<li>When you delete an FAQ category, all the FAQs under it will also get deleted from the system. </li>\r\n</ul>'),(38,'MANAGE_COUNTRIES',-1,'Manage Countries','Manage the list of countries that will be visible under any country field all over the platform.','','To remove a country from the serviceable list, deactivate that country\'s entry.','','\r\n<ul>\r\n	<li>Manage the list of countries that will be visible under any country field all over the platform.</li> \r\n	<li>Activate the countries where you want to do business in. Only the active countries will be visible in the country list all over the platform. </li>\r\n	<li>Edit a country by clicking on the edit icon beside it.</li>\r\n	<li>Add a new country to the list using the New button.</li>\r\n	<li>You cannot delete a country from the list, although you can deactivate it if you do not want it to be visible in any of the country dropdown lists on the platform. </li>\r\n</ul>'),(39,'MANAGE_EMAIL_TEMPLATES',-1,'Manage Email Templates','Manage system email templates','You cannot add a new email template. ','Admin can only modify the default email templates by adjusting body text, font size, color, logo, footer content etc.  ','','\r\n<ul>  \r\n	<li>Each template has a replacement variable kept inside curly brackets{}. </li>  \r\n	<li>When you send the email, text inside the brackets is replaced with information setup prior such as recipient\'s email address, website name, etc. </li>\r\n</ul>'),(40,'MANAGE_STATES',-1,'Manage States','Manage the list of states that will be visible under any state field all over the platform','','To remove a state from the serviceable list, deactivate that state\'s entry.','','\r\n<ul>\r\n	<li>Manage the list of states that will be visible under any state field all over the platform. </li>\r\n	<li> Activate or deactivate as many states as you want. Just ensure that the active states have their countries activated as well, because: If you activate the states - California and Arizona, but have deactivated the USA under Countries, these two states will not be serviceable by the platform. </li>\r\n	<li>Edit a state by clicking on the edit icon beside it.</li>\r\n	<li>You cannot delete a state from the list, although you can deactivate it if you do not want it to be visible in any of the state dropdown lists.</li>\r\n</ul>');

INSERT IGNORE INTO `tbl_pages_language_data` VALUES (41,'MANAGE_TESTIMONIAL',-1,'Testimonials','View, edit or delete the existing testimonials left by users.','','','','\r\n<ul>\r\n	<li>Let the audience know more about your service by sharing all the testimonials you received from your users. </li>\r\n	<li>The testimonials added here will be reflected on the home page at the front end when the testimonial collection is active. </li>\r\n	<li>Only you can add and edit a testimonial. No user is allowed to directly post a testimonial.</li>\r\n	<li>If a user wants to leave a review about the platform, they can share their review with you via email or so. To display this testimonial on the platform, you will have to add it under this module by clicking on the New button. </li>\r\n	<li>Unpublish a testimonial by turning OFF the toggle switch beside it. </li>\r\n</ul>'),(42,'MANAGE_ORDER_CANCEL_REASONS',-1,'Order Cancellation Reasons','Manage the reasons selected by Buyers while placing a cancellations request.','','','','\r\n<ul>\r\n	<li>Buyers can request cancellation until the product Payment Is Confirmed, In Process and also in case of Cash On Delivery.</li>\r\n	<li>The system even allows Sellers to cancel orders before they are arranged for shipment by the seller.</li>\r\n	<li>There is a Sorting icon provided beside each column’s header. Click on this icon to sort the list in either the ascending or descending order.</li>\r\n	<li>Reasons not listed at Storefront?\r\nThis might be because the reasons listing is empty or not prepared.</li>\r\n</ul>  '),(43,'MANAGE_ORDER_RETURN_REASONS',-1,'Order Return Reasons','Manage the reasons selected by Buyers while placing a return request.','','','','\r\n'),(44,'SHOP_REPORT_REASONS',-1,'Shop sales','Detailed shop sales report that includes information on total sales, sold quantity, refunded orders, and total earnings made by the shop. ','Filters and selected columns will impact the exported data.','Apply filters from the advance search and select relevant columns to view data and export the same.','','\r\n<ul>\r\n	<li>The report has a few default columns. To include additional columns in the report, click on Columns and select the respective checkboxes. </li>\r\n	<li>Drag the headers under the Columns list to change the order of the columns.</li>\r\n	<li>Sort the report by clicking on a header. The highlighted header indicates that the column is sorted. And the direction of the arrow will indicate the sorting type.</li> \r\n	<li>Click on Export to download the adjusted report after sorting a header, adding columns, and changing the sequence of the columns, on a spreadsheet. </li>\r\n</ul> '),(45, 'SOCIAL_PLATFORM', '-1', 'Social Platform', 'Add links, icons of your preferred social media profiles including Facebook, LinkedIn, Instagram, and more', '', '', '', ''),(45, 'EMPTY_CART_ITEMS', '-1', 'Empty Cart Items', 'Manage the title message and link that will be displayed on the message notifying a buyer about their empty cart. ', '', '', '', ''),(46,'MANAGE_IMPORT_INSTRUCTIONS',-1,'Manage Inport Instructions','Manage the import instructions for all the sections of the platform. These instructions are reflected under the import/export module.','','If you have made many changes you can press the \"Reset to Default\" option. ','','\r\n<ul>\r\n	<li>All the import instructions listed here can be reflected under the Import tab >> Import/Export.</li> \r\n	<li>These instructions guide you through the process of how you can import the data.</li>\r\n</ul>'),(47, 'MANAGE_PAGES_LANGUAGE_DATA_BLOCK', '-1', 'Manage Help Text Labels', 'Manage and update the description, warnings, recommendations, and help text content of various modules on the platform. ', '', '', '', ''),(48,'METATAG_MANAGEMENT',-1,'Meta Tags Management','Define meta information for all the pages.','','','','\r\n<ul>\r\n	<li>Update all the metadata, including the meta title, meta description, meta keywords and other meta content for each web page.</li> \r\n	<li>The pages are categorized into different sections allowing you to update and manage the metadata for each page easily.</li>\r\n	<li>Click on the edit icon beside the web page. A form will appear allowing you to update the metadata for that page.</li>\r\n	<li>The metadata added should be - findable, accessible, interoperable and reusable.</li>\r\n</ul>'),(49,'MANAGE_URL_REWRITING',-1,'Url Rewriting','Create SEO-friendly URLs for web pages to make it easier for users to remember and search engines to crawl.','Each web page URL should be unique. No two URLs can be the same. ','An SEO-friendly URL should be short, clear and should include the main keyword that describes the page.','','\r\n<ul>\r\n	<li>Only last part of the URL, called the slug, can be edited. </li>\r\n	<li>Most of the URL entries in this list were created when the respective page was created. For instance, when you create a brand and create an SEO-friendly URL for it on the same form, it is added to this list.</li>\r\n	<li>Click on the delete icon to delete a URL. It will delete the SEO-friendly URL that you created for the respective page. You can still visit the page, but the URL of this page will be a system-generated one. </li>\r\n</ul>'),(50,'MANAGE_IMAGE_ATTRIBUTES',-1,'Image Attributes','Create image attributes for all the images uploaded to the platform for the search engines to crawl.','','','','\r\n<ul>\r\n	<li>There are two attributes for each image - image title and image alt tag. Both of these image attributes can be the same. </li>\r\n	<li>You can use the same keyword or name for multiple image attributes.</li>\r\n	<li>Notes about ALT Tag and how they help in SEO:\r\n		<ul>\r\n			<li>Image ALT tags are helpful for accessibility reasons. </li>\r\n			<li>It helps participants with physical or vision impairments. </li>\r\n			<li>The image attributes help the image show up in the search image results.</li>\r\n		</ul></li>\r\n</ul>');

INSERT IGNORE INTO `tbl_pages_language_data` VALUES (51,'IMPORT_EXPORT',-1,'Import & Export','Perform bulk import or export for relevant data via CSV file.','Double-check interdependent data while importing CSV files.','Tweak import/export settings beforehand.','','\r\n<ul>\r\n	<li>Export: Download the categories, users, products, etc., data in a separate CSV file from this platform as a backup, or to use it elsewhere.</li>\r\n	<li>Import: Add your data via exported CSV files. The instructions to import each type of data are explained on the first tab of each form. </li>\r\n	<li>Add Media to Server: Upload all media files on the platform\'s server under this section. This makes the image uploading process much simpler.</li>\r\n	<li>Settings: There are multiple settings that govern the import and export process. Configure these settings before you import or export any data so as to avoid any errors.</li>  \r\n	<li>Import instructions can be managed under CMS >> Import instructions.</li>\r\n</ul>'),(52,'MANAGE_EMAIL_TEMPLATES',-1,'Manage Email Templates','Manage system email templates','You cannot add a new email template. ','Admin can only modify the default email templates by adjusting body text, font size, color, logo, footer content etc.  ','','\r\n<ul>  \r\n	<li>Each template has a replacement variable kept inside curly brackets{}. </li>  \r\n	<li>When you send the email, text inside the brackets is replaced with information setup prior such as recipient\'s email address, website name, etc. </li>\r\n</ul>'),(53,'MANAGE_SMS_TEMPLATES',-1,'SMS Templates','Manage system-defined SMS templates.','You cannot add a new SMS template. ','Admin can only modify the default SMS templates by adjusting body text. ','','\r\n<ul>  \r\n	<li>Each template has a replacement variable kept inside curly brackets{}. </li>  \r\n	<li>When you send the SMS, text inside the brackets are replaced with the information setup prior such as user name, website name etc. </li>\r\n</ul>'),(54, 'APP_NOTIFICATIONS', '-1', 'App Push Notification', 'Manage the push notifications for the APP users. ', '', '', '', ''),(55, 'DELIVERY_SETTINGS', '-1', 'Delivery Settings', 'Manage self pickup or delivery settings (by seller or admin) ', '', '', '', ''),(56, 'DELIVERY_SLOTS', '-1', 'Manage admin delivery slots', 'Manage the delivery slots for admin shipping.', '', '', '', ''),(57, 'DELIVERY_SLOTS', '-1', 'Admin Delivery Charges', 'Manage order delivery charges.', '', '', '', ''),(57, 'DELIVERY_STAFF', '-1', 'Delivery Staff', 'View and Manage registered Delivery staff details.', '', '', '', ''),(58, 'DELIVERY_STAFF_FEE', '-1', 'Delivery Staff Fee', 'View and Manage registered Delivery staff fee.', '', '', '', '');

-- ---------------------------TV-2.1.0.20230327------------------------

INSERT INTO `tbl_configurations` (`conf_name`, `conf_val`, `conf_common`) VALUES
('conf_page_size', 12, 0)
ON DUPLICATE KEY UPDATE conf_val = VALUES(conf_val), conf_common = VALUES(conf_common);

UPDATE `tbl_language_labels` SET `label_caption` = 'Sign Me up for Exclusive Newsletter Deals.' WHERE `tbl_language_labels`.`label_key` = 'LBL_Newsletter_Signup';

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('LBL_Newsletter_Signup_Help_Text', 1, 'Sweepstakes and 24 hour sales only available to subscribers.', 1)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

ALTER TABLE `tbl_blog_contributions` ADD `bcontributions_author_phone_dcode` VARCHAR(50) NOT NULL AFTER `bcontributions_author_email`;
ALTER TABLE `tbl_users` CHANGE `user_dial_code` `user_phone_dcode` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `tbl_user_address` CHANGE `ua_dial_code` `ua_phone_dcode` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `tbl_user_phone_verification` CHANGE `upv_dial_code` `upv_phone_dcode` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `tbl_shops` CHANGE `shop_dial_code` `shop_phone_dcode` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
UPDATE
    tbl_users tu
    INNER JOIN tbl_countries tc ON tc.country_dial_code = tu.user_phone_dcode AND tu.user_phone_dcode != ''
SET
    tu.user_phone_dcode = CONCAT(tu.user_phone_dcode, '-', LOWER(tc.country_code));
UPDATE `tbl_configurations` SET `conf_common` = '1' WHERE `tbl_configurations`.`conf_name` in ('CONF_TIMEZONE','CONF_USE_SSL','CONF_DEFAULT_SERVING_LOCATION','CONF_COUNTRY','CONF_CURRENCY','CONF_DEFAULT_SITE_LANG','CONF_THEME_COLOR_RGB','CONF_AUTO_CLOSE_SYSTEM_MESSAGES','CONF_TIME_AUTO_CLOSE_SYSTEM_MESSAGES','CONF_GOOGLE_TAG_MANAGER_HEAD_SCRIPT');
ALTER TABLE `tbl_shops` ADD `shop_avg_rating` DOUBLE(10,2) NOT NULL AFTER `shop_background_updated_on`, ADD `shop_total_reviews` INT(11) NOT NULL AFTER `shop_avg_rating`;
ALTER TABLE `tbl_shops` ADD INDEX( `shop_latitude`, `shop_longitude`);

UPDATE `tbl_configurations` SET `conf_val` = '<div class=\"modal-body market-popup-body\" style=\"background-image: url(images/bg/marketing-popup.png);\"><h1 class=\"market-popup-title\">Launch your <br>eGrocery Marketplace <br> with Growcer</h1><ul class=\"market-popup-list\"><li>Fully Customizable</li><li>No Recurring Charges</li><li>Readymade Mobile Apps</li><li>Lifetime Ownership</li></ul><a href=\"https://www.yogrowcer.com/request-growcer-free-personalized-demo.html\" target=\"_blank\" class=\"btn btn-brand\"> Book a Personalized Demo</a></div>' WHERE `tbl_configurations`.`conf_name` = 'conf_demo_popup_html';
ALTER TABLE `tbl_product_categories` ADD `prodcat_ordercode` VARCHAR(255) NOT NULL AFTER `prodcat_code`;
ALTER TABLE `tbl_product_categories` ADD INDEX( `prodcat_code`);
ALTER TABLE `tbl_orders_status` ADD `orderstatus_color_class` TINYINT(4) NULL DEFAULT NULL COMMENT 'Defined in applicationConstant' AFTER `orderstatus_identifier`;

DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 13;
DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 14;
DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 19;
DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 27;
DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 29;
DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 30;
DELETE FROM `tbl_extra_pages` WHERE `tbl_extra_pages`.`epage_type` = 1;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"heading1\">Simple steps to start selling online</div>        \n        \n<div class=\"seller-steps\">  \n	<ul>      \n		<li><i class=\"icn\"><img src=\"/images/easyto-use.png\" alt=\"\" width=\"84\" height=\"105\" /></i>  \n			<h3></h3>\n			<h3>Easy to Use</h3>  \n			<p>Set up simulation exercises for large group of students in a few steps.</p></li>      \n		<li><i class=\"icn\"><img src=\"/images/real-market.png\" alt=\"\" /></i>  \n			<h3>Real Market Data</h3>  \n			<p>Use real financial markets data in simulation activities.</p></li>      \n		<li><i class=\"icn\"><img src=\"/images/simulated.png\" alt=\"\" /></i>  \n			<h3>Simulated Market Data</h3>  \n			<p>Simulate past market events and data over a specific historical time period.</p></li>      \n		<li><i class=\"icn\"><img src=\"/images/customization.png\" alt=\"\" /></i>  \n			<h3>Fully Customizable</h3>  \n			<p>Fully customize activities to meet various learning outcomes, disciplines and levels of difficulty.</p></li>  \n	</ul></div>' WHERE `tbl_extra_pages`.`epage_type` = 16;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"container\"> \n	<div class=\"container\">            \n		<div class=\"row justify-content-center\">                \n			<div class=\"col-lg-9\">                    \n				<div class=\"content-wrap\">                        \n					<div class=\"content-block\">                            \n						<div class=\"content-block-img\">                                <img src=\"./images/sell-onajeebshop.png\" alt=\"\" />                            </div>                            \n						<div class=\"content-block-cms\">                                \n							<div class=\"cms cms-about-us\">                                    \n								<h2>Sell on YoGrowcer!</h2>                                    \n								<p>Reach millions of buyers globally.</p>                                </div>                                \n							<ul class=\"bullet-circle\">                                    \n								<li><i class=\"icn fa fa-check\" aria-hidden=\"true\"></i>                                        \n									<p> <strong>Grow your Business</strong> <br />\n										                                            Sell to buyers anytime, anywhere\n                                        </p>                                    </li>                                    \n								<li><i class=\"icn fa fa-check\" aria-hidden=\"true\"></i>                                        \n									<p> <strong>Zero Cost</strong> <br />\n										 No commission or transaction fee</p>                                    </li>                                    \n								<li><i class=\"icn fa fa-check\" aria-hidden=\"true\"></i>                                        \n									<p> <strong>Manage your Business Better</strong> <br />\n										 Lead Management System &amp; other features</p>                                    </li>                                \n							</ul>                            </div>                        </div>                    </div>                </div>            </div>        </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 17;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<h3>Selling on YoGrowcer is easy! <span class=\"\">All you need is:</span> </h3> <ul> <li><i class=\"fa fa-check\" aria-hidden=\"true\"></i> VAT Number </li> <li><i class=\"fa fa-check\" aria-hidden=\"true\"></i> PAN Card </li> <li><i class=\"fa fa-check\" aria-hidden=\"true\"></i> Current Account Number </li> </ul>' WHERE `tbl_extra_pages`.`epage_type` = 18;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<h3>Simple Pricing With No Surprises</h3> <p>Subscription plans and At vero eos et accusamus et iusto odio dignissimos<br /> ducimus qui blanditiis quas molestias excepturi sint occaecati cupiditate non provident. </p>' WHERE `tbl_extra_pages`.`epage_type` = 20;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<h3>Advertise With us</h3> <p>Yo-Growcer advertising offers a great value to brands with the ability to target their commertial messaging using different categories and search keywords. Our Advertising Platform provides an in-depth knowledge of e-commerce audience. This will help you to connect with our exclusive user base through various Advertising models like Standard Banners.</p>' WHERE `tbl_extra_pages`.`epage_type` = 21;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<h3>Make Money <span class=\"\">by becoming an Affiliate!</span></h3> <p>Our affiliate program is easy &amp; free to join! It enables you to earn revenue by referring potential customers to our website. Whether you are a large content network, social media butterfly or a seasoned blogger, you can earn our standard 5.00% commission on referred purchases.&nbsp;</p>' WHERE `tbl_extra_pages`.`epage_type` = 22;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div>Need Help In Getting Pan/vat?</div> <div>To Contact Our Partners Near Your Location</div>' WHERE `tbl_extra_pages`.`epage_type` = 24;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"container\">  	<div class=\"container\">             		<div class=\"section-head section-head-center\">                 			<div class=\"section-heading\">                     				<h2>Simple Pricing Structure</h2>                </div>            </div>             		<div class=\"pricing-structure\">                 			<ul>                     				<li class=\"box\">                         					<h4>10%</h4>                         					<p>Commission Fee</p>                    </li>                     				<li class=\"sign\">+</li>                     				<li class=\"box\">                         					<h4>$1 </h4>                         					<p>Shipping Fee</p>                    </li>                     				<li class=\"sign\">+</li>                     				<li class=\"box\">                         					<h4>$4 </h4>                         					<p>Marketplace Fee</p>                    </li>                     				<li class=\"sign lg-hide\">+</li>                     				<li class=\"box\">                         					<h4>15%</h4>                         					<p>Service Tax</p>                    </li>                     				<li class=\"sign\">+</li>                     				<li class=\"box\">                         					<h4>Amt.</h4>                         					<p>Amount You Earned</p>                    </li>                     				<li class=\"sign\">=</li>                     				<li class=\"box\">                         					<h4>Price </h4>                         					<p>Price You Decide</p>                    </li>                 			</ul>            </div>             		<div class=\"row justify-content-center\">                 			<div class=\"col-lg-6\">                     				<div class=\"cms text-center mt-5\">                         					<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum voluptatem.</p>                        <a class=\"link\" href=\"\">Learn More About Pricing</a>                    </div>                </div>            </div>        </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 25;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<section class=\"section\">     	<div class=\"container\">         		<div class=\"incentives-layout-1\">             			<div class=\"incentives\">                 				<div class=\"incentives-icon\">                    <img src=\"/images/agile-delivery.svg\" width=\"109\" height=\"109\" alt=\"\" />                </div>                 				<h3 class=\"incentives-title\">Agile Delivery</h3>                 				<p class=\"incentives-text\">Our proficient experts ensure quality delivery within the required timeframe.</p>            </div>             			<div class=\"incentives\">                 				<div class=\"incentives-icon\">                    <img src=\"/images/impeccable.svg\" width=\"109\" height=\"109\" alt=\"\" />                </div>                 				<h3 class=\"incentives-title\">Impeccable UI/UX</h3>                 				<p class=\"incentives-text\">From the ordering phase till delivery, our seamless UI/UX provides an effortless shopping experience</p>            </div>             			<div class=\"incentives\">                 				<div class=\"incentives-icon\">                    <img src=\"/images/unmatchable.svg\" width=\"109\" height=\"109\" alt=\"\" />                </div>                 				<h3 class=\"incentives-title\">Unmatchable Pricing</h3>                 				<p class=\"incentives-text\">We offer exceptional grocery with best-in-class services at competitive prices.</p>            </div>        </div>    </div></section>' WHERE `tbl_extra_pages`.`epage_type` = 28;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<section class=\"section\"> <div class=\"container\"> <div class=\"get-app\"> <div class=\"app-screen\"><img src=\"/images/app-screen.png\" alt=\"\" /></div> <div class=\"app-data\"> <h3>Download the Growcer app</h3> <p>Access video consultation with India’s top doctors on the Practo app. Connect with doctors online, available 24/7, from the comfort of your home.</p> <h4>Or Download from here</h4> <div class=\"app-actions\"><a class=\"link-add\" href=\"\"><img src=\"/images/google-play.png\" alt=\"\" /></a><a class=\"link-add\" href=\"\"><img src=\"/images/app-store.png\" alt=\"\" /></a></div></div></div></div></section>' WHERE `tbl_extra_pages`.`epage_type` = 31;
-- ------------------------TV-2.1.0.20230515---------------------

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<section class=\"section\"> \n <div class=\"container\"> \n <div class=\"get-app\"> \n <div class=\"app-screen\"><img src=\"/images/app-screen.png\" alt=\"\" /></div> \n <div class=\"app-data\"> \n <h3>Download the Growcer app</h3> \n <p>Access video consultation with India’s top doctors on the Practo app. Connect with doctors online, available 24/7, from the comfort of your home.</p> \n <h4>Or Download from here</h4> \n <div class=\"app-actions\">\n <button class=\"link-add\" aria-label=\"Google play\"><img src=\"/images/google-play.png\" alt=\"\" /></button>\n <button class=\"link-add\" aria-label=\"App store\"><img src=\"/images/app-store.png\" alt=\"\" /></button></div></div></div></div></section>' WHERE `tbl_extra_pages`.`epage_type` = 31;

UPDATE `tbl_configurations` SET `conf_common` = '1' WHERE `tbl_configurations`.`conf_name` in ('CONF_MAINTENANCE','CONF_ENABLE_301','CONF_ADDRESS_','CONF_THEME_COLOR_INVERSE_RGB','CONF_SECONDARY_THEME_COLOR_RGB','CONF_SECONDARY_THEME_COLOR_INVERSE_RGB','CONF_CURRENCY','CONF_ADMIN_DEFAULT_LANG');

ALTER TABLE `tbl_cron_schedules` ADD UNIQUE(`cron_command`);

INSERT INTO `tbl_cron_schedules` (`cron_name`, `cron_command`, `cron_duration`, `cron_active`) VALUES
('Update Sitemap', 'Cronjob/generateSitemap', 4320, 1)
ON DUPLICATE KEY UPDATE cron_command = VALUES(cron_command);

INSERT INTO `tbl_extra_pages` (`epage_identifier`, `epage_type`, `epage_active`, `epage_default`, `epage_default_content`, `epage_content_for`) VALUES
('Google Service Account JSON Key', 84, 1, 0, "<h6 class=\"mt-2\">Please Follow Below Steps To Get Service Account Detail :</h6>\r\n<ul class=\"listing--bullet\">      \r\n	<li>Visit <a class=\"link\" href=\"https://console.developers.google.com\" target=\"_blank\">Google Console</a></li>            \r\n    <li>Click on <span style=\"font-weight: bold;\">Navigation Menu</span> (Breadcrumb Icon).</li>            \r\n	<li>Open the <span style=\"font-weight: bold;\">IAM &amp; Admin</span> page in the Cloud Console.</li>            \r\n	<li>Click <span style=\"font-weight: bold;\">Select a project</span>, choose a project, and click <span style=\"font-weight: bold;\">Open.</span></li>            \r\n	<li>In the left nav, click <span style=\"font-weight: bold;\">Service accounts.</span></li>            \r\n	<li>Find the row of the service account that you want to create a key for. Follow below steps.</li>\r\n    <li>Steps > In that row, click the <span style=\"font-weight: bold;\">Actions <i class=\"fa fa-ellipsis-v\"></i></span> button, and then click <span style=\"font-weight: bold;\">Create key/Manage Keys.</span></li>\r\n    <li>If service account row not listing on this page. Then click on <span style=\"font-weight: bold;\">Create service account</span> and fill the required information and follow above mentioned steps.</li>           \r\n	<li>Select a <span style=\"font-weight: bold;\">Key type</span> and click <span style=\"font-weight: bold;\">Create.</span> - OR - Select <span style=\"font-weight: bold;\">Add Key</span> and click <span style=\"font-weight: bold;\">Create new key</span> and select <span style=\"font-weight: bold;\">JSON</span> hit Create.</li>\r\n    <li>A JSON file will be downloaded. Open that JSON file copy whole data inside that file and paste it in above <span style=\"font-weight: bold;\">Service account detail</span> input box.</li>\r\n    <li>Hit Save Button</li>\r\n</ul>", 0)
ON DUPLICATE KEY UPDATE epage_default_content = VALUES(epage_default_content);

INSERT INTO `tbl_extra_pages` (`epage_identifier`, `epage_type`, `epage_active`, `epage_default`, `epage_default_content`, `epage_content_for`) VALUES
('Google Analytics Property Id', 85, 1, 0, '<h6 class="mt-2">Please Follow Below Steps To Get GA4 property ID:</h6>
<ul class="listing--bullet">
    <li>To find your <span style="font-weight: bold;">property ID</span>, go to <a class="link-underline" href="https://analytics.google.com/analytics/web/" target="_blank">Google Analytics</a> website, admin page.</li>
    <li>Select the desired <span style="font-weight: bold;">GA4 property from the list.</span></li>
    <li>From the middle column, click <span style="font-weight: bold;">Property Settings.</span></li>
    <li>From the right column, you will see your <span style="font-weight: bold;">Property ID</span> (eg: 123456789). Use the icon next right to it to copy the value.</li>
</ul>', 0)
ON DUPLICATE KEY UPDATE epage_default_content = VALUES(epage_default_content);

-- -------------------------TV-2.1.0.20230616---------------------------

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('app_file_size_error', 1, 'Your file size must be less than %s MB', 2),
('app_write_your_message', 1, 'Write your Message', 3),
('app_max_file_error', 1, 'Choose Max 5 Files', 2),
('app_new_email', 1, 'New Email', 2),
('app_new_email', 1, 'New Email', 3)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_app_notifications` (`appnotification_code`, `appnotification_type`, `appnotification_lang_id`, `appnotification_name`, `appnotification_body`, `appnotification_replacements`, `appnotification_status`) VALUES
('app_notification_your_account_credited_debited_reward_points', 1, 1, 'Your Account Has Been Credited/Debited With Reward Points', 'Your Account Has Been {debit_credit_type} with {reward_points} Reward Points.', '{debit_credit_type} Transaction type.<br/>\r\n{reward_points} Amount.', 1)
ON DUPLICATE KEY UPDATE appnotification_name = VALUES(appnotification_name), appnotification_body = VALUES(appnotification_body);

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<section class=\"section\"> \n <div class=\"container\"> \n <div class=\"get-app\"> \n <div class=\"app-screen\"><img src=\"/images/app-screen.png\" alt=\"\" /></div> \n <div class=\"app-data\"> \n <h3>Download the Growcer app</h3> \n <p>Access video consultation with India’s top doctors on the Practo app. Connect with doctors online, available 24/7, from the comfort of your home.</p> \n <h4>Or Download from here</h4> \n <div class=\"app-actions\">\n <a href="https://play.google.com/store/apps/details?id=com.fatbit.growcer.buyer&hl=en&gl=US&pli=1" class=\"link-add\" aria-label=\"Google play\"><img src=\"/images/google-play.png\" alt=\"\" /></a>\n <a href="https://apps.apple.com/in/app/growcer/id1529562195" class=\"link-add\" aria-label=\"App store\"><img src=\"/images/app-store.png\" alt=\"\" /></a></div></div></div></div></section>' WHERE `tbl_extra_pages`.`epage_type` = 31;

UPDATE `tbl_extra_pages_lang` SET `epage_content` = '<section class=\"section\"> \n <div class=\"container\"> \n <div class=\"get-app\"> \n <div class=\"app-screen\"><img src=\"/images/app-screen.png\" alt=\"\" /></div> \n <div class=\"app-data\"> \n <h3>Download the Growcer app</h3> \n <p>Access video consultation with India’s top doctors on the Practo app. Connect with doctors online, available 24/7, from the comfort of your home.</p> \n <h4>Or Download from here</h4> \n <div class=\"app-actions\">\n <a href="https://play.google.com/store/apps/details?id=com.fatbit.growcer.buyer&hl=en&gl=US&pli=1" class=\"link-add\" aria-label=\"Google play\"><img src=\"/images/google-play.png\" alt=\"\" /></a>\n <a href="https://apps.apple.com/in/app/growcer/id1529562195" class=\"link-add\" aria-label=\"App store\"><img src=\"/images/app-store.png\" alt=\"\" /></a></div></div></div></div></section>' WHERE `epagelang_epage_id` = (SELECT epage_id FROM `tbl_extra_pages` WHERE `epage_type` = 31) AND `epagelang_lang_id` = 1;

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('MSG_Zone_details_updated_Successfully', 1, 'Packaging time updated successfully', 1)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_language_labels` (`label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES
('LBL_COPYRIGHT_TEXT', 1, 'Copyright {YEAR} {PRODUCT}', 1)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);
-- ------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO `tbl_payment_methods` (`pmethod_id`, `pmethod_identifier`, `pmethod_code`, `pmethod_active`, `pmethod_display_order`) VALUES (NULL, 'Paystack', 'Paystack', '1', '4');

ALTER TABLE `tbl_shops` ADD UNIQUE(`shop_identifier`);
ALTER TABLE `tbl_shops` ADD INDEX(`shop_country_id`);
ALTER TABLE `tbl_shops` ADD INDEX(`shop_state_id`);
ALTER TABLE `tbl_upc_codes` ADD INDEX(`upc_product_id`);
ALTER TABLE `tbl_upc_codes` ADD INDEX(`upc_code`);

INSERT INTO `tbl_payment_methods` (`pmethod_id`, `pmethod_identifier`, `pmethod_code`, `pmethod_active`, `pmethod_display_order`) VALUES (20, 'Transfer Bank', 'TransferBank', '1', '5');
INSERT INTO `tbl_payment_methods_lang` (`pmethodlang_pmethod_id`, `pmethodlang_lang_id`, `pmethod_name`, `pmethod_description`) VALUES ('20', '1', 'Transfer Bank', 'Transfer Bank');

ALTER TABLE `tbl_order_payments` ADD `opayment_txn_status` TINYINT NOT NULL AFTER `opayment_gateway_response`;

INSERT INTO `tbl_email_templates` (`etpl_code`, `etpl_lang_id`, `etpl_name`, `etpl_subject`, `etpl_body`, `etpl_replacements`, `etpl_status`) VALUES ('ADMIN_ORDER_PAYMENT_TRANSFERRED_TO_BANK', '1', 'Admin Order Payment Transferred To Bank', 'Order #{ORDER_ID} Payment Transferred To Bank', '<div style=\"margin:0; padding:0;\">\r\n	<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Arial; color:#333; line-height:26px;\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<!--\r\n					page title start here\r\n					-->\r\n					\r\n					<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n						<tbody>\r\n							<tr>\r\n								<td style=\"background:#fff;padding:20px 0 10px; text-align:center;\">									\r\n									<h2 style=\"margin:0; font-size:34px; padding:0;\">Bank Transfer</h2></td>\r\n							</tr>\r\n						</tbody>\r\n					</table>				\r\n					</td>\r\n			</tr>\r\n			<tr>\r\n				<td>		   \r\n					<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n						<tbody>\r\n							<tr>\r\n								<td style=\"background:#fff;padding:0 30px; text-align:center; color:#999;vertical-align:top;\">\r\n									<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">                                \r\n										<tbody>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:20px 0 30px;\" colspan=\"2\"><strong style=\"font-size:18px;color:#333;\">Dear Admin </strong><br />\r\n													Order Payment Detail Submitted BY {USER_NAME} For #{ORDER_ID}. <br />\r\n													Please find the transfer information below.</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Payment Method</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{PAYMENT_METHOD}</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Transaction Id</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{TRANSACTION_ID}</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Amount</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{AMOUNT}</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Comments</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{COMMENTS}</td>                                    \r\n											</tr>                                    \r\n										</tbody>                            \r\n									</table>\r\n								</td>\r\n							</tr>\r\n						</tbody>\r\n					</table>				\r\n					</td>\r\n			</tr>\r\n		</tbody>\r\n	</table></div>', '{USER_NAME} - Name of the User.<br>\r\n{ORDER_ID} - Order Id.<br>\r\n{PAYMENT_METHOD} - Payment Method Used By Buyer.<br>\r\n{TRANSACTION_ID} - Transaction Id<br>\r\n{AMOUNT} - Amount<br>\r\n{COMMENTS} - Comments.<br>', '1');

INSERT INTO `tbl_sms_templates` (`smstpl_code`, `smstpl_type`, `smstpl_lang_id`, `smstpl_name`, `smstpl_body`, `smstpl_replacements`, `smstpl_active`) VALUES ('ADMIN_ORDER_PAYMENT_TRANSFERRED_TO_BANK', '1', '1', 'Order Payment Transferred To Bank', 'Hello Admin,\r\n\r\nOrder Payment Detail Submitted BY {USER_NAME}\r\nFor #{ORDER_ID}.\r\n\r\n{SITE_NAME} Team', '[{\"title\":\"User Name\", \"variable\":\"{USER_NAME}\"},{\"title\":\"Order Id\", \"variable\":\"{ORDER_ID}\"}, {\"title\":\"Website Name\", \"variable\":\"{SITE_NAME}\"}]', '1');


ALTER TABLE `tbl_order_payments` ADD `opayment_opd_id` INT NOT NULL AFTER `opayment_txn_status`;

INSERT INTO `tbl_email_templates` (`etpl_code`, `etpl_lang_id`, `etpl_name`, `etpl_subject`, `etpl_body`, `etpl_replacements`, `etpl_status`) VALUES ('order_payment_decline_by_admin', '1', 'Order payment decline by admin', 'Order #{ORDER_ID} Payment decline by admin', '<div style=\"margin:0; padding:0;\">\r\n	<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Arial; color:#333; line-height:26px;\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<!--\r\n					page title start here\r\n					-->\r\n					\r\n					<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n						<tbody>\r\n							<tr>\r\n								<td style=\"background:#fff;padding:20px 0 10px; text-align:center;\">									\r\n									<h2 style=\"margin:0; font-size:34px; padding:0;\">Bank Transfer</h2></td>\r\n							</tr>\r\n						</tbody>\r\n					</table>				\r\n					</td>\r\n			</tr>\r\n			<tr>\r\n				<td>		   \r\n					<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n						<tbody>\r\n							<tr>\r\n								<td style=\"background:#fff;padding:0 30px; text-align:center; color:#999;vertical-align:top;\">\r\n									<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">                                \r\n										<tbody>										                                 \r\n											<tr>                                        \r\n												<td style=\"padding:20px 0 30px;\" colspan=\"2\"><strong style=\"font-size:18px;color:#333;\">Dear {buyer_name} </strong><br />\r\n													Bank transfer decline by admin for #{ORDER_ID}. <br />\r\n													Please find the information below.</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Payment Method</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{PAYMENT_METHOD}</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Transaction Id</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{TRANSACTION_ID}</td>                                    \r\n											</tr>                                    \r\n											<tr>                                        \r\n												<td style=\"padding:0 0 30px;\">Amount</td>                                        \r\n												<td style=\"padding:0 0 30px;\">{AMOUNT}</td>                                    \r\n											</tr>                              \r\n										</tbody>                            \r\n									</table>\r\n								</td>\r\n							</tr>\r\n						</tbody>\r\n					</table>				\r\n					</td>\r\n			</tr>\r\n		</tbody>\r\n	</table></div>', '{buyer_name} - Name of the Buyer.<br>\r\n{ORDER_ID} - Order Id.<br>\r\n{PAYMENT_METHOD} - Payment Method Used By Buyer.<br>\r\n{TRANSACTION_ID} - Transaction Id<br>\r\n{AMOUNT} - Amount<br>\r\n', '1');

DELETE FROM `tbl_language_labels` WHERE `label_key`='LBL_DELIVERY_NOT_ASSIGNED';

UPDATE `tbl_language_labels` SET `label_caption` = 'Unassigned delivery- ' WHERE `tbl_language_labels`.`label_key` = 'LBL_Unassigned_Delivery';

UPDATE `tbl_language_labels` SET `label_caption` = 'Unassigned delivery' WHERE `tbl_language_labels`.`label_key` = 'LBL_Unassigned_Delivery_Filter';

INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'ADMIN_PROFILE_SECTION', '-1', 'Admin Profile', 'Manage the admin profile', '', '', '', '');

INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'ADMIN_CHANGE_PASSWORD', '-1', 'Change Admin Password', 'Manage the admin password', '', '', '', '');

UPDATE `tbl_orders_status` SET `orderstatus_identifier` = 'Canceled' WHERE `tbl_orders_status`.`orderstatus_id` = 8;

DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_RESET_PAGE_RIGHT_BLOCK';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_-_Seller_Approval_Requests_';
DELETE FROM tbl_language_labels WHERE `label_key` = 'M_INVALID_ORDER_PAID_CANCELLED';
DELETE FROM tbl_language_labels WHERE `label_key` = 'TXT_DELETE_DELIVERY_CHARGES';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Delete_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Delete_Product';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Delete_User';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Social_Platform_deleted!';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Status_by_seller';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ORDER CANCELLATION REQUESTS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Order_Cancellation_Requests';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Order_Cancellation_Requests_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Search_Order_Cancellation_Requests';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_ORDER_RETURN/REFUND_REQUESTS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Product_Brand_Requests';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Seller_Orders_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Seller_Orders';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Admin_Users';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_DISCOUNT_COUPONS_LIST';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_DISCOUNT_COUPONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Discount_Coupons_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Seller_Discount_Coupons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Seller_Discount_Coupons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_PPC_PROMOTIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_PPC_PROMOTIONS_LIST';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_More_Customers';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_On_enabling_return_shipping_charges_to_customer';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Search_In_Customer_Details_For_Orders';
DELETE FROM tbl_language_labels WHERE `label_key` = "LBL_Set_the_order_status_the_customer's_order_must_reach_before_they_are_allowed_to_access_their_downloadable_Products.";
DELETE FROM tbl_language_labels WHERE `label_key` = "LBL_Set_the_order_status_the_customer's_order_must_reach_before_they_are_allowed_to_place_return/exchange_request_on_orders_of_Digital_Products.";
DELETE FROM tbl_language_labels WHERE `label_key` = "LBL_Set_the_order_status_the_customer's_order_must_reach_before_they_are_are_considered_in_buyer's_purchase.";
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_What_our_customer';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_With_other_customers';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_TAG_NOT_FOUND?_CLICK_HERE_TO_ADD_NEW_TAG';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Brand_Not_Found?_Click_here_to_';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Tag_Not_Found?_Click_here_to_';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Be_the_first_to_review_this_product';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Checkout_Review_Order_Self_Pickup';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_Displaying_Reviews';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Product_Reviews';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Number_of_reviews_have_1_stars';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Number_of_reviews_have_2_stars';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Number_of_reviews_have_3_stars';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Number_of_reviews_have_4_stars';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Number_of_reviews_have_5_stars';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Orders_Reviewed';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Product_Reviews_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Rate_and_Review_Product';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Rating_and_Reviews';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Ratings_&_Reviews';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBl_Ratings_&_Reviews1';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_Review_of';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_Reviews_by';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_SHOP_REVIEW';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_Showing_All_Reviews';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_users_found_this_review_helpful';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_View_All_Reviews';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Msg_Review_can_be_posted_on_bought_product';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Shop_Report_Reasons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_SHOP_REPORT_REASONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Shop_Reports';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Back_to_Shop_Reports';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_%S_DATE_TIME_IS_INVALID_FOR_SHOP';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_%s_date_is_invalid_for_shop_%s';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Back_to_Shop';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Collection_Shop_Setup';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Preferred_Dimensions_width_*_height';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Preferred_Dimensions_width*height';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Preferred_Dimesions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Preferred_Dimensions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Backgroud_Image(If_Any)';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Collection_Background_Image_Management(If_any)';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Select_Brand_Background_Image';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Select_Categories_Background_Image';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Upload_Background_Image';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Upload_shop_background_image_text';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_FOOTER_TRUST_BANNERS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_BANNERS_LOCATIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_BANNER_LOCATIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_BANNER_LOCATION_SETUP';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_UPLOAD_SHOP_BANNER_TEXT';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Product_Detail_Page_Banner';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Advertiser_Banner_Slogan';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Affiliate_Banner_Slogan';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_File';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_identifier';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_Banner_Layouts_Instructions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_Location_Identifier';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_Location_Title';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_Locations_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_Name';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_Target';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banner_URL';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Banners_Layout_Instructions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Category_Banner_Seller';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Category_Banners';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Cost_Per_Click_(banner)';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Banner';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Banner_Locations';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Promote_Banner';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Shop_Banner_Management';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Upload_Banner';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Banners';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_PPC_cost_per_click_for_banner';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Please_Add_Delivery_Slot_Info_In_Shop_Settings_First!';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Please_Add_Shop_Availability_Info_In_Shop_Settings_First!';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Please_Add_Zone_Information_In_Shop_Settings_First!';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Preferred_Start_Time';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Start_time_and_end_time_can_not_be_same';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Start_time_can_not_be_equal_to_End_time';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Start_time_should_be_less_than_End_time';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Preferred_End_Time';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Start_time_and_end_time_can_not_be_same';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Start_time_can_not_be_equal_to_End_time';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Start_time_should_be_less_than_End_time';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Add_New_Tax';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_{paymentMethodName}_is_not_available_as_Shipping_Company_is_not_added_by_admin_as_yet.';
DELETE FROM tbl_language_labels WHERE `label_key` = 'TXT_DELETE_DELIVERY_CHARGES';
DELETE FROM tbl_language_labels WHERE `label_key` = 'TXT_EDIT_DELIVERY_CHARGES';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Excluding_Delivery_Charges';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_FREE_DELIVERY_UP_TO_{AMOUNT}_PURCHASE';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Enter_N.A._if_value_not_required.';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_CUSTOM CATALOG PRODUCTS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Add_Custom_Catalog';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Custom_Catalog_Request';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Clear_Search';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_PLEASE_ADD_SHOP_DESTIALS_FIRST';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Search_In_Shop_Details_For_Orders';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_VIEW_SHOP_ORDER';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Short_Decsription';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Return_Request_Type';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Request_Type_Does_Not_Matter';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Received_Payment';
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'MANAGE_ORDER_RETURN_REQUEST_DETAILS', '-1', 'Order Return/Refund Request Details', 'View the Order Return Request Details.', '', '', '', '');
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'MANAGE_ORDER_DETAILS', '-1', 'Order details', 'Get the order details.', '', '', '', '');
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'MANAGE_SELLER_ORDER_DETAILS', '-1', 'Seller\'s Order Details', 'View the Seller Order Details.', '', '', '', ' ');
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'MANAGE_SUBSCRIPTION_ORDER_DETAILS', '-1', 'Subscription Order Details', 'View Seller\'s Subscription Order Details.', '', '', '', ' ');
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ORDER_TOTAL123';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_ADMIN_DELIVERY_COMMISSION_CHARGED_FOR_ORDER_{ORDERID}';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Commission_charged_including_shipping';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Commission_charged_including_shipping_charges';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_REWARD POINTS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_PAYMENT RECEIVED BY';

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Categories Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Category Identifier</h5>\n					<p>User defined free text field for unique identifier of the category. This works as a unique key for the system to identify a particular category.</p>   </li>\n				<li>\n					<h5>Parent Identifier</h5>\n					<p>Parent Identifier is used for categories that belong to a root/master category, essentially they are subcategories to root categories. For a category that is root/master category the parent identifier needs to be left blank.</p>   </li>\n				<li>\n					<h5>Name</h5>\n					<p>User defined name for the category.</p>   </li>\n				<li>\n					<h5>Description</h5>\n					<p>User defined description for the category.</p>   </li>\n				<li>\n					<h5>SEO Friendly URL</h5>\n					<p>User defined URL for the category for SEO purposes. Spaces cannot be used in the URL.</p>   </li>\n				<li>\n					<h5>Featured</h5>\n					<p>User defined field to mark a particular category as featured or not. Possible inputs for this field are \'Yes\' &amp; \'No\'.</p>   </li>\n				<li>\n					<h5>Active</h5>\n					<p> User defined field to mark a particular category as active in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'Yes\'.</p>   </li>\n				<li>\n					<h5>Display Order</h5>\n					<p>User defined field to set priority on display order of root categories or sub-categories within a root category. If more than one category has display order set to the same value then the system will display category that was added first. If you are unsure about this field add display order as \'1\' to all the categories.</p>   </li>\n				<li>\n					<h5>Deleted</h5>\n					<p>User defined field to mark a particular category as deleted in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'No\' to display categories in the system.</p>   </li>\n			</ul>  </div> </div>\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Categories Media File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Category Identifier</h5>\n					<p>User defined unique identifier for the category. This field needs to be the same as Category Identifier defined in Categories Content sheet.</p>   </li>\n				<li>\n					<h5>Lang Code</h5>\n					<p>User defined field to link the category image for a particular language. \'Universal\' is to be used as an option to link the media in all languages. Language codes can be looked up by clicking the language option in the top header. Language codes need to be used if the Category has different images for each language.</p>   </li>\n				<li>\n					<h5>Image Type</h5>\n					<p>User defined field with input options of \'Category Icon\' &amp; \'Category Banner\'. Category icon option is to be used when uploading icon image for the category. Category banner option is to be used when uploading banner image for the category page.</p>   </li>\n                <li>\n                    <h5>File Path</h5>\n                    <p>File path needs to be a publically accessible URL for example URL\'s from Google Drive, Dropbox etc. Images stored locally on your personal device/machine cannot be uploaded. Preferred image dimensions for Category Icon are 60*60 pixels. Preferred image dimensions for Category banner are  1320*320 pixels.</p>   </li>\n                <li>\n                    <h5>File Name</h5>\n                    <p>Name of the image file.</p>   </li>\n			</ul>  </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 45;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n <div class=\"groups group-js\">\n <div class=\"group__head group__head-js\">\n <h5> Tags Content File</h5></div>\n <div class=\"group__body group__body-js\">\n <ul> \n <li>\n <h5>Tag Identifier</h5>\n <p>User defined unique identifier for the Tag. This works as a unique key for the system to identify a particular Tag.</p> </li>\n <li>\n <h5>Username</h5>\n <p>For admin this field needs to be left blank. In case a tag is added by a seller then seller username will be displayed/added in this field. </p> </li>\n <li>\n <h5>Tag name </h5>\n <p>User defined name for the Tag.</p> </li>\n </ul> </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 46;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Brands Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Brand Identifier</h5>\n					<p>User defined unique identifier for the Brand. This works as a unique key for the system to identify a particular Brand.</p>   </li>\n				<li>\n					<h5>Name</h5>\n					<p>User defined name for the Brand in the system.</p>   </li>\n				<li>\n					<h5>Description</h5>\n					<p>User defined description for the Brand.</p>   </li>\n				<li>\n					<h5>SEO Friendly URL</h5>\n					<p>User defined URL for the Brand for SEO purposes. Special characters/Spaces cannot be used in the URL. </p>   </li>\n				<li>\n					<h5>Featured</h5>\n					<p>User defined field to mark a particular Brand as featured or not. Possible inputs for this field are \'Yes\' &amp; \'No\'.</p>   </li>\n				<li>\n					<h5>Active</h5>\n					<p>User defined field to mark a particular category as active in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'Yes\'.</p>   </li>\n			</ul>  </div> </div>\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Brands Media File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Brand Identifier</h5>\n					<p>User defined unique identifier for the Brand. This field needs to be the same as Brand Identifier defined in Brands Content sheet.</p>   </li>\n				<li>\n					<h5>Lang Code</h5>\n					<p>User defined field to link the brand image for a particular language. \'Universal\' is to be used as an option to link the media in all languages. Language codes can be looked up by clicking the language option in the top header. Language codes need to be used if the Brand has different images for each language. </p>   </li>\n				<li>\n					<h5>File Path</h5>\n					<p>File path needs to be a publicly accessible URL for example URL\'s from Google Drive, Dropbox etc. Images stored locally on your personal device/machine cannot be uploaded. Preferred image dimensions are 150*90 pixels.</p>   </li>\n                <li>\n                    <h5>File Name</h5>\n                    <p>Name of the image file.</p>   </li>\n			</ul>  </div> </div></div>' WHERE `tbl_extra_pages`.`epage_type` = 47;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Options Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Option Identifier</h5>\n					<p>User defined unique identifier for the Option. This works as a unique key for the system to identify a particular Option.</p>   </li>\n				<li>\n					<h5>Option Name</h5>\n					<p>User defined name for the Option.  </p>   </li>\n				<li>\n					<h5>Username </h5>\n					<p>For admin this field needs to be left blank. In case an option is added by a seller then seller username will be displayed in this field.</p>   </li>\n				<li>\n					<h5>Is separate image</h5>\n					<p>User defined input field to denote if the option would have a separate image. Useful for color options of the product. Possible inputs for this field are \'Yes\' &amp; \'No\'.</p>   </li>\n				<li>\n					<h5>Deleted</h5>\n					<p>User defined field to mark a particular option as deleted in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'No\' to display Options in the system.</p>   </li>\n			</ul>  </div> </div>\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Options Values File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Option value identifier</h5>\n					<p>User defined unique identifier for the Option value. This works as a unique key for the system to identify a particular Option value.</p>   </li>\n				<li>\n					<h5>Option Identifier</h5>\n					<p>User defined unique identifier for the option. This field value needs to be the same as the Option Identifier defined in Options Content sheet.</p>   </li>\n				<li>\n					<h5>Option Value</h5>\n					<p>User defined value for the Option.</p>   </li>\n                <li>\n                    <h5>Display order</h5>\n                    <p>When an option has multiple option values then this field defines the order of display of the option value. If you are unsure about this field add display order as \'1\'.</p>   </li>\n			</ul>  </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 48;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Countries Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>CountryId/Country Code</h5>\n					<p>User defined field for unique country id or code.</p>   </li>\n				<li>\n					<h5>Alpha-2 Country Code</h5>\n					<p>User defined identifier for the Product. This field needs to be the same as Product Identifier defined in the Product Catalog sheet.  </p>   </li>\n				<li>\n					<h5>Country Name</h5>\n					<p>User defined field for unique country name.</p>   </li>\n				<li>\n					<h5>Country Phone Code</h5>\n					<p>Country phone dial code.</p>   </li>\n				<li>\n					<h5>Active</h5>\n					<p>User defined field to mark a particular country as active in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'Yes\'.</p>   </li>\n			</ul>  </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 42;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> States Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>State Identifier</h5>\n					<p>User defined unique identifier for the State. This works as a unique key for the system to identify a particular State.</p>   </li>\n				<li>\n					<h5>Country Code</h5>\n					<p>This field needs to be the same as country code defined in Countries Content sheet.  </p>   </li>\n				<li>\n					<h5>Sate Name </h5>\n					<p>User defined field for unique state name.</p>   </li>\n				<li>\n					<h5>State Code</h5>\n					<p>User defined field for unique state code. </p>   </li>\n				<li>\n					<h5>Active</h5>\n					<p>User defined field to mark a particular state as active in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'Yes\'.</p>   </li>\n			</ul>  </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 41;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5> Cities Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>City Identifier</h5>\n					<p>User defined unique identifier for a City. This works as a unique key for the system to identify a particular City.</p>   </li>\n				<li>\n					<h5>City Name</h5>\n					<p>User defined name for city</p>   </li>\n                <li>\n                    <h5>State Identifier</h5>\n                    <p>This works as a unique key for the system to identify a particular State Identifier. This field needs to be the same as State Identifier defined in States Content sheet.</p>   </li>\n				<li>\n					<h5>City Latitude </h5>\n					<p>Latitude of City</p>   </li>\n				<li>\n					<h5>City Longitude</h5>\n					<p>Longitude of City.</p>   </li>\n				<li>\n					<h5>City Active</h5>\n					<p>User defined field to mark a particular City as active in the system or not. Possible inputs for this field are \'Yes\' &amp; \'No\'. Default value should be set as \'Yes\'.</p>   </li>\n			</ul>  </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 51;

UPDATE `tbl_extra_pages` SET `epage_default_content` = '<div class=\"grouplisting\">\n	<div class=\"groups group-js\">\n		<div class=\"group__head group__head-js\">\n			<h5>Language Labels Content File</h5></div>\n		<div class=\"group__body group__body-js\">\n			<ul> \n				<li>\n					<h5>Type</h5>\n					<p>Integer Values based on the following:<br/>\n                        Web : 1<br/>\n                        Delivery App : 2<br/>\n                        Buyer App : 3<br/></p>   </li>\n				<li>\n					<h5>Key</h5>\n					<p>Pre defined underscored label Key which is already used in the code. Other keys will not get reflected on the frontend. </p>   </li>\n				<li>\n					<h5>Language Codes </h5>\n					<p>Language code for all the active languages in the system need to be listed as columns. New column for each language code.<br/>\n                    Code should be the same as it is in the languages list. Other than the system languages no labels will be imported.</p>   </li>\n			</ul>  </div> </div> </div>' WHERE `tbl_extra_pages`.`epage_type` = 52;

DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_GUEST_LOGIN_SUCCESSFULL';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_LOGIN_SUCCESSFULL';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Delivery_Exlusions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_OrderStatus_Setup';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Order_Satatus_Setup';
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'MANAGE_USERS_PERISSION', '-1', 'Configure user permissions', 'Configure user permissions.', '', '', '', '');
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Blog_Post_Categories';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Blog_Posts';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Blog_Contributions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Blog_Comments';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Home_Page_Slides';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Content_Pages';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Content_Blocks';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_LANGUAGE_LABELS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Labels';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Language_labels_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_States';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Order_Cancel_Reasons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Order_Cancel_Reasons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Order_Return_Reasons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Order_Return_Reasons';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Empty_Cart_Items_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Empty_Cart_Items';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Meta_Tags';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Url_Rewriting';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Bulk_Import_Export';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_IMPORT_EXPORT_MEDIA';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_General_Settings';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_APP_RELEASE_VERSIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Abusive_keywords_List';
DELETE FROM tbl_language_labels WHERE `label_key` = 'TXT_SECTION_Delivery_Management';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Bad_Products_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Most_Refunded_Products_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Products_Report_(Seller_Products)';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Top_Products_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Products_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Users_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_View_Users_Report';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MANAGE_SMS_NOTIFICATIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_APP_PUSH_NOTIFICATIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Email_Template_Lists';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Email_Template_Logo';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Email_Template_logo_size';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Email_Templates';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Question_Bank_Name';
DELETE FROM tbl_language_labels WHERE `label_key` = 'buyerapp_withdraw_bank_name';
DELETE FROM tbl_language_labels WHERE `label_key` = 'app_bank_name';
DELETE FROM tbl_language_labels WHERE `label_key` = 'L_Current_Account_Number';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_IFSC_or_swift_code';
DELETE FROM tbl_language_labels WHERE `label_key` = 'buyerapp_withdraw_bank_address';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_MY ADDRESSES';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBLUA_Pin_for_Delivery_Location';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBLCHKUA_Pin_for_Delivery_Location';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBLUA_Add_Delivery_Location';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Valid_Till_<br/>(Custom_Weightage)';
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'DELETED_USER', '-1', 'Deleted Users', 'Deleted user list', '', '', '', '');
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'MESSAGES_DETAIL_VIEW', '-1', 'Message Detail view', 'Message Detail view listings.', '', '', '', '');
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_REWARD_ON_PURCHASE';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Blog_Contributions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_Or_Maybe_you_are_like_our_collecctions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Collections';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_COLLECTIONS_LIST';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Lbl_Collection_Listing';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Layout2_(Collection_along_with_Products-Full-width)';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Layout3_(Collection_along_with_Products)';
DELETE FROM tbl_language_labels WHERE `label_key` = 'TXT_layout_Color';
DELETE FROM tbl_language_labels WHERE `label_key` = 'TXT_Shop_Layout';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Home_Page_After_First_Layout';
DELETE FROM tbl_language_labels WHERE `label_key` = 'Home_Page_After_Third_Layout';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Content_Pages_Layout_Instructions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Content_Pages_Layouts_Instructions';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_PPC_slides_count_home_page';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_how_many_PPC_slides_shown_on_home_page';
DELETE FROM tbl_language_labels WHERE `label_key` = 'MSG_PPC_cost_per_click_for_Slides';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Navigations';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_COPYRIGHT_AND_NAVIGATIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_SHOP_NAVIGATIONS';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_CMS_Page_To_Faq';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Content_Blocks';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Language_labels_List';
INSERT INTO `tbl_pages_language_data` (`plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES ( 'FAQ', '-1', 'FAQs Listing', 'Use this screen to Update FAQ\'s content.', '', '', '', '\r\n<ul>\r\n <li>If you do not want to publish an FAQ category, deactivate it by turning OFF the toggle switch beside it.</li> \r\n <li>Click on the FAQ Listing icon to view the list of all the FAQs added under a category. Add more FAQs under this category by clicking on New. </li>\r\n <li>When adding a new FAQ data, enter the question as the FAQ title and the answer to this question in the description field. </li>\r\n <li>When you delete an FAQ category, all the FAQs under it will also get deleted from the system. </li>\r\n</ul>')
ON DUPLICATE KEY UPDATE plang_summary = VALUES(plang_summary), plang_warring_msg = VALUES(plang_warring_msg), plang_recommendations = VALUES(plang_recommendations), plang_replacements = VALUES(plang_replacements), plang_helping_text = VALUES(plang_helping_text);

-- -------------- Task-118109 Distance matrix cr  -------------- --

ALTER TABLE `tbl_delivery_charges` ADD `deliverycharge_min_delivery_range` DECIMAL(10,2) NOT NULL COMMENT 'IN KM' AFTER `deliverycharge_amount`, ADD `deliverycharge_additional_delivery_charges` DECIMAL(10,2) NOT NULL COMMENT 'DELIVERY CHARGES PER KM AFTER MIN RANGE' AFTER `deliverycharge_min_delivery_range`;


INSERT INTO `tbl_language_labels` ( `label_key`, `label_lang_id`, `label_caption`, `label_type`) VALUES 
('LBL_PLEASE_FOLLOW_{STEPS}_TO_GET_FIREBASE_SERVICE_ACCOUNT_JSON_KEY',1,'Please follow {STEPS} to get firebase service account JSON Key',1)
ON DUPLICATE KEY UPDATE label_caption = VALUES(label_caption);

INSERT INTO `tbl_extra_pages` (`epage_identifier`, `epage_type`, `epage_content_for`, `epage_active`, `epage_default`, `epage_default_content`) VALUES 
('Firebase Service Account Private Key JSON File', 86, 0, 1, 0, '<h6 class=\"mt-2\"><strong>To generate a private key file for your service account:</strong></h6>\n<ul class=\"listing--bullet\">\n	<li>\n		<p>In the Firebase console, open <strong>Settings > <a href=\"https://console.firebase.google.com/project/\">Service Accounts</a></strong>.</p></li>\n	<li>\n		<p>Click <strong>Generate New Private Key</strong>, then confirm by clicking <strong>Generate Key</strong>.</p></li>\n	<li>\n		<p>Securely store the JSON file containing the key.</p></li>\n</ul>')
ON DUPLICATE KEY UPDATE epage_identifier = VALUES(epage_identifier), epage_default_content = VALUES(epage_default_content);

ALTER TABLE `tbl_extra_pages` ADD UNIQUE(`epage_type`);
INSERT INTO `tbl_pages_language_data` (`plang_id`, `plang_key`, `plang_lang_id`, `plang_title`, `plang_summary`, `plang_warring_msg`, `plang_recommendations`, `plang_replacements`, `plang_helping_text`) VALUES (NULL, 'CITIES', '-1', 'Cities', 'cities list', '', '', '', '\r\n')
ON DUPLICATE KEY UPDATE plang_summary = VALUES(plang_summary), plang_warring_msg = VALUES(plang_warring_msg), plang_recommendations = VALUES(plang_recommendations), plang_replacements = VALUES(plang_replacements), plang_helping_text = VALUES(plang_helping_text);

DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ADMIN_SELECTED_CITY_NAME';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Testimonials';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Social_Platforms';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Add_Social_Platform';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Manage_Meta_Tags';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_Meta_Tags_Setup';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ALL_CATEGORIES_>>';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ALL_CATEGORIES_WITH';
DELETE FROM tbl_language_labels WHERE `label_key` = 'LBL_ALL_CATEGORIES__>>';
DELETE FROM `tbl_pages_language_data` WHERE `plang_key` = 'DELIVERY_SLOTS';

-- --------------------------------
-- Update Payment Method Table
-- M Pesa Integration
-- -------------------------------
INSERT INTO `tbl_payment_methods`(`pmethod_id`, `pmethod_identifier`, `pmethod_code`, `pmethod_active`, `pmethod_display_order`) VALUES ('21','Mpesa','Mpesa','1','21');

INSERT INTO `tbl_payment_methods_lang`(`pmethodlang_pmethod_id`, `pmethodlang_lang_id`, `pmethod_name`, `pmethod_description`) VALUES ('21','1','M-pesa','M-pesa');
INSERT INTO `tbl_payment_methods_lang`(`pmethodlang_pmethod_id`, `pmethodlang_lang_id`, `pmethod_name`, `pmethod_description`) VALUES ('21','2','كرمة','كرمة');

INSERT INTO `tbl_payment_method_settings` (`paysetting_pmethod_id`, `paysetting_key`, `paysetting_value`) VALUES ('20', 'consumer_key', '');
INSERT INTO `tbl_payment_method_settings` (`paysetting_pmethod_id`, `paysetting_key`, `paysetting_value`) VALUES ('20', 'consumer_secret', '');
INSERT INTO `tbl_payment_method_settings` (`paysetting_pmethod_id`, `paysetting_key`, `paysetting_value`) VALUES ('20', 'lipa_na_mpesa_online_passkey', '');
INSERT INTO `tbl_payment_method_settings` (`paysetting_pmethod_id`, `paysetting_key`, `paysetting_value`) VALUES ('20', 'lipa_na_mpesa_online_shortcode', '');
INSERT INTO `tbl_payment_method_settings` (`paysetting_pmethod_id`, `paysetting_key`, `paysetting_value`) VALUES ('20', 'account_reference', '');

ALTER TABLE `tbl_orders` ADD COLUMN `order_round_off_amount` DECIMAL(10,2) NULL;
INSERT INTO `tbl_configurations`(`conf_name`, `conf_val`, `conf_common`) VALUES ('CONF_ROUND_OFF_REWARD_POINTS','1','0');
