UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_HOME' WHERE  `menu_id`=1 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SETTING' WHERE  `menu_id`=2 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_MEMBERS' WHERE  `menu_id`=3 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_CONTENTS' WHERE  `menu_id`=4 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_APPROVALS' WHERE  `menu_id`=5 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_CATEGORIES' WHERE  `menu_id`=6 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PRODUCTS' WHERE  `menu_id`=7 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_GIFT_CERTIFICATES' WHERE  `menu_id`=8 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_ORDERS' WHERE  `menu_id`=9 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PAYMENTS' WHERE  `menu_id`=10 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_REFUND_REQUESTS' WHERE  `menu_id`=11 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_USER_REGISTRATION_FIELDS' WHERE  `menu_id`=12 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_BULK_UPLOAD' WHERE  `menu_id`=13 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SETTLEMENTS' WHERE  `menu_id`=14 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_BOTTOM_BANNERS' WHERE  `menu_id`=15 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SEND_MAIL' WHERE  `menu_id`=16 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_AFFILIATES' WHERE  `menu_id`=17 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_FEEDBACK' WHERE  `menu_id`=18 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_REPORTS' WHERE  `menu_id`=19 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PRODUCT_REVIEWS' WHERE  `menu_id`=20 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_NEWSLETTERS' WHERE  `menu_id`=21 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_COUPON_CODES' WHERE  `menu_id`=22 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SELLER_PLANS' WHERE  `menu_id`=23 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_GENERAL_SETTINGS' WHERE  `menu_id`=24 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SHIPPING_SETTINGS' WHERE  `menu_id`=25 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_TAX_SETTINGS' WHERE  `menu_id`=26 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_CURRENCY_SETTINGS' WHERE  `menu_id`=27 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_USERS' WHERE  `menu_id`=28 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SELLERS' WHERE  `menu_id`=29 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_AFFILIATES' WHERE  `menu_id`=30 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_CURRENT_STYLE_SHEET' WHERE  `menu_id`=31 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_EMAIL_TEMPLATES' WHERE  `menu_id`=32 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PAGE_CONTENTS' WHERE  `menu_id`=33 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_APPROVE_SELLERS' WHERE  `menu_id`=34 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_APPROVE_PRODUCTS' WHERE  `menu_id`=35 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_APPROVE_AFFILIATES' WHERE  `menu_id`=36 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SELLERS' WHERE  `menu_id`=37 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_USERS' WHERE  `menu_id`=38 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_AFFILIATES' WHERE  `menu_id`=39 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_AFFILIATE_MEMBERS' WHERE  `menu_id`=40 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_AFFILIATE_BANNERS' WHERE  `menu_id`=41 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SITE_FEEDBACK' WHERE  `menu_id`=42 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SELLER_FEEDBACK' WHERE  `menu_id`=43 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_CREATE_NEWSLETTER' WHERE  `menu_id`=44 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_NEWSLETTER_ARCHIVES' WHERE  `menu_id`=45 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_MULTIPLE_IMAGE_UPLOAD' WHERE  `menu_id`=46 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_BULK_PRODUCT_UPLOAD' WHERE  `menu_id`=47 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PAYMENT_SETTINGS' WHERE  `menu_id`=48 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PRODUCTS_VIEWED' WHERE  `menu_id`=49 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PRODUCTS_PURCHASED' WHERE  `menu_id`=50 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_FINANCIAL_REPORT' WHERE  `menu_id`=51 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_TOTAL_SALES' WHERE  `menu_id`=52 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_COMMISIONS' WHERE  `menu_id`=53 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_COMMISIONS' WHERE  `menu_id`=57 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_TOTAL_SALES' WHERE  `menu_id`=54 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_TOTAL_SALES' WHERE  `menu_id`=56 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_TOTAL_SALES' WHERE  `menu_id`=58 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_METATAG_MANAGEMENT' WHERE  `menu_id`=60 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PRODUCT_VARIATIONS' WHERE  `menu_id`=62 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_HELP' WHERE  `menu_id`=63 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_HOME_PAGE_BANNERS' WHERE  `menu_id`=64 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SOCIAL_MEDIA_SETTINGS' WHERE  `menu_id`=65 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_SITE_LOGO' WHERE  `menu_id`=68 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_PRODUCT_MANAGEMENT' WHERE  `menu_id`=66 LIMIT 1;
UPDATE `multicart_admin_menu` SET `title`='LEFT_MENU_FINANCE' WHERE  `menu_id`=67 LIMIT 1;

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `display_order`, `divname`) VALUES ('Seller Registrar Help', 'LEFT_MENU_SELLER_HELP', 'help_list.php?q=seller', 25,'SellerHelp');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Registration', 1, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Logging in', 2, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'My Profile', 3, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'My Catalog', 4, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Orders', 5, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Manage Payments', 6, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Email to Administrator', 7, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Order Status', 8, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Gift Certificate', 9, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Bulk Image Upload', 10, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Bulk Product Upload', 11, '0');
INSERT INTO `multicart_helpcategory` (`htype`, `hctitle`, `hcposition`, `active`) VALUES ('seller_registrar', 'Email Templates', 12, '0');

INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`,`hposition`,`active`) VALUES (67, 'Registration', '<p><font face="Arial"><span style=" font-size:10pt">Registering as seller with Multicart Shopping Cart is easy and fast. Go to the seller registration </p>','1','0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (68, 'Logging in', '<font face="Arial"><span style=" font-size:10pt">To access the Multicart Shopping Cart seller area, login in the address given below:</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><font face="Arial"><span style=" font-size:10pt">http://yoursite.com/seller/login.php(Assuming that you have installed the Multicart in \r\nhttp://yoursite.com</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><font face="Arial"><span style=" font-size:10pt">Enter the user name and password. On verifying your credentials correctly, you are logged in to the \r\nMulticart Shopping Cart Seller Panel.</span></font><br><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><b>Seller Login Interface</b></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><b><br></b></span></font></div><div align="left"><img src="logging inb1.PNG"  width="643"  height="341"  border="0"  alt="graphic"></div>', 2, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (69, 'My profile', '<font face="Arial"><span style=" font-size:10pt">To edit the profile select- \'My Profile\' at the top of the seller menu. In the next screen, edit the details and select \'Save Changes\'.</span></font><font face="Times New Roman">\r\n        <span style=" font-size:10pt"> </span></font>\r\n    <br><br /><font face="Arial">\r\n<span style=" font-size:10pt">To change the password- select \'Change Pass\' at the top of the seller menu. In the following screen, enter the old password in the \'Old Password\' field. Then, enter the new password in the \'Password\' field and confirm it by retyping it in the \'Confirm Password\' field.<br />\r\n   <br /> Both of the passwords should match. Then, the old password will update itself to then new one. </span></font>\r\n    <font face="Times New Roman"><span style=" font-size:10pt"><br></span></font>\r\n    <font face="Times New Roman"><span style=" font-size:10pt"><br></span></font>\r\n    <font face="Arial"><span style=" font-size:10pt">The seller can create his/her portfolio. The portfolio will contain descriptions of the samples with photos included. To edit/create a portfolio select the \'My Portfolio\' link on top of the seller menu. Then, select \'Save Changes\' in the following screen.</span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><br><font face="Times New Roman"><span style=" font-size:10pt"><br></span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><br><div align="left">&nbsp;&nbsp;</div>', 3, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (70, 'My Catalog', '<font face="Arial"><span style=" font-size:10pt">The seller registered with Multicart Shopping cart can add product under different categories.These \r\ncategories are created and maintained by the administrator of the site.To add/edit product under \r\ndifferent categories , click on \' My catalog \' on top seller menu section. </span></font><font face="Times New Roman">\r\n<span style=" font-size:10pt"><br><br><br><br></span></font><font face="Arial">\r\n<span style=" font-size:10pt"><b>Manage Products</b></span></font><font face="Times New Roman">\r\n<span style=" font-size:10pt"><br><br></span></font><br><font face="Arial"><span style=" font-size:10pt">\r\nYou can start to add the products under each category here. Just select the leaf level category first, then, enter the fields in the bottom section of the screen and select \'Add Product\'. <strong>Note, you can add products only to the leaf level categories. </strong></span>\r\n<br />\r\n</font><br><font face="Arial"><span style=" font-size:10pt">To edit a product- select the category->\'Product Name\'->then in the following screen you can edit the details. When you are finished, select \'Save Changes\'.<br /><br />\r\n        To delete a product- select \'Delete\'. <strong> Keep in mind, please make sure that you are deleting the correct product because this action is irreversible.</strong> </span></font><br><div align="left">&nbsp;&nbsp;</div>', 4, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (71, 'Orders', '<font face="Arial">\r\n        <span style=" font-size:10pt">To manage orders for your product just select the \'Orders\' link on top of the seller menu. The next screen will display all of your orders.  </span></font><br /><br /><font face="Arial">\r\n         <span style=" font-size:10pt">To view/edit an order- select the \'User Name\' link. In the next screen, you can view the order in detail. Here, you can change the order status to delivered or shipped.\r\n         </span></font><a href="orderstatus.htm"><font face="Arial"  color="#0000ff">\r\n          <!--<span style=" font-size:10pt"><u>([click here to view order status])</u></span>--></font></a><!--<font face="Arial"  color="#0000ff"><span style=" font-size:10pt">etc.</span></font>--><br><div align="left">&nbsp;&nbsp;</div>', 5, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (72, 'Manage Payments', '<font face="Arial"><span style=" font-size:10pt"><b>Request Payment</b></span></font><font face="Times New Roman">\r\n        <span style=" font-size:10pt"><b> </b></span></font><br /><br />\r\n        <font face="Arial">\r\n            <span style=" font-size:10pt">After the delivery is completed you can request a form for payment. Select the \'Request for Payment\' link at the top of the seller menu. The following screen will display all delivered items. To request payment, select the row next to you \'Request for Payment\'.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><font face="Times New Roman">\r\n                <span style=" font-size:10pt"><br></span></font><br>\r\n                <p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;">\r\n                    <font face="Arial"><span style=" font-size:10pt"><b>Payment History</b></span></font>\r\n                    <font face="Times New Roman"><span style=" font-size:10pt"><b> </b></span></font><br>\r\n                <p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;">\r\n                    <font face="Arial">\r\n                        <span style=" font-size:10pt">In order to view the payment details of your orders, select the \'Payment History\' option at the top of the seller menu. All of the settled payments are displayed with their details here. For example you will see: order total, commission, and amount paid.\r\n                        <br /><br />\r\n                        To view an order in detail select the \'Order\' link next to the settled payment row.<br /><br />\r\n                        To view payments in detail such as the payment date, select the \'Seller name\' next to the settled payment row. </span></font>', 6, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (73, '	Email to Administrator', '<font face="Arial"><span style=" font-size:10pt">The  sellers can send  an email to the administrator of the marketplace. To send an email, select the \'Mail Admin\' at the top of the menu. In the following screen, enter the email subject, email content, and then select \'Send Mail\'. </span></font><br><div align="left">&nbsp;&nbsp;</div>', 7, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (74, 'Order Status', '<font face="Arial"><span style=" font-size:10pt">The following are the orders status supported by the MultiCart<br><br><br>\r\nPending - All orders that are pending to be delivered<br>\r\nShipped - All orders that are shipped to the buyer<br>\r\nDelivered - All orders that are delivered to the buyer<br>\r\nCancelled - All orders that are cancelled by the seller</span></font><font face="Times New Roman"><span style=" font-size:10pt"><br></span></font><font face="Times New Roman"><span style=" font-size:12pt"><br></span></font><br><div align="left">&nbsp;&nbsp;</div>', 8, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (75, 'Gift Certificate', '<font face="Arial"><span style=" font-size:10pt">Users can purchase gift coupons like other products. For each gift coupon there is a unique code, which is send by email. Persons receiving those codes can purchase items by selecting the payment option as &quot;Coupon&quot; and typing the gift code received in the checkout page.</span></font><br><font face="Arial"><span style=" font-size:10pt"><br></span></font><br><font face="Arial"><span style=" font-size:10pt">Gift Coupon Management Screen can be accessed by following the instructions given below. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">1. Click on &quot;Gift Coupon&quot; tab. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">2. Displays a screen which lists the created gift coupons. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. Click on &quot;Gift Coupon Add&quot; displays the gift coupon adding screen. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt"><br></span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt"><u>Gift Coupon Adding Screen</u> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">1. Enter the coupon name,code,description,image,amount and seller. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">2. Once all the required details are filled click on &quot;Add&quot; to create a new gift coupon. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. &quot;Gift Coupon Added Successfully&quot; message is received and the screen displays the newly
created gift coupon. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt"><br></span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt"><u>Gift Coupon Editing Screen</u> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img src="giftcouponb1.PNG"  width="18"  height="13"  border="0"  alt="graphic"><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">2. You will get access to &quot;Gift Coupon Editing Screen&quot;. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. Enter the details in the corresponding boxes. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">4. Click on &quot;Update&quot; button once you entered all the details. </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">5. You will receive a &quot;Gift Coupon Details Updated Successfully&quot; message </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">and you will be redirected to gift coupons listing screen.</span></font><br><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. <u>Gift Coupon Deleting Screen</u></span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">To delete the Gift Coupon follow the steps from 1 to 4</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img src="giftcouponb2.PNG"  width="15"  height="13"  border="0"  alt="graphic"><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">2. You will get a delete confirmation message.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. Deleting does not remove the record from the database permanently.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">4. You can undelete the same record by clicking on the same icon. </span></font><br><div align="left">&nbsp;&nbsp;</div>', 9, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (76, 'Bulk Image Upload', '<font face="Arial"><span style=" font-size:10pt">You can add additional product images using this facility.This menu is accessible by clicking on the
tab &quot;Product Images(bulk upload)&quot;.</span></font><br><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><u>Adding Product Images</u></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;1. Click on &quot;Add Images&quot;</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;2. Product Images bulk upload screen is displayed</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;3. Select the product name from the drop down.</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;4. Browse the image and enter the description of the corresponding image.</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;5. Click on &quot;Add&quot; button after all the details are entered.</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;6. You will receive a &quot;Images Added Successfully Message&quot;.</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><font face="Arial"><span style=" font-size:10pt">&#160;<u>Product Images Editing Section</u></span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><font face="Times New Roman"><span style=" font-size:10pt"><br></span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">To edit a product images go through the steps from 1 to 5</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img src="productimagesb1.PNG"  width="18"  height="13"  border="0"  alt="graphic"><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">2. You will get access to &quot;Product Images Editing Screen&quot;.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. Enter the details in the corresponding boxes.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">4. Click on &quot;Update&quot; button once you entered all the details.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">5. You will receive a &quot;Details Updated Successfully&quot; message </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">and you will be redirected to images listing screen.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Times New Roman"><span style=" font-size:10pt"><br></span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">&#160;<u>Product Images Deleting Section</u></span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Times New Roman"><span style=" font-size:10pt"><br></span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">To delete the product images follow the steps from 1 to 4</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img src="productimagesb2.PNG"  width="15"  height="13"  border="0"  alt="graphic"><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">2. You will get a delete confirmation message.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">3. Deleting does not remove the record from the database permanently.</span></font><font face="Times New Roman"><span style=" font-size:10pt"> </span></font><br><p style="margin-left:0mm; margin-right:0mm; text-indent:0mm; margin-top:1.76mm; margin-bottom:1.76mm;"><font face="Arial"><span style=" font-size:10pt">4. You can select the same record and undo deletion if you want to see the image again. </span></font><br><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left">&nbsp;&nbsp;</div>',10,'0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (77, 'Bulk Product Upload', '<font face="Arial"><span style=" font-size:10pt">You can add bulk product and images using this facility (If Admin is activated bulk uploading feature in admin settings only).This menu is accessible by clicking on the
tab &quot;Bulk Product Upload &quot;.</span></font><br><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><u>Upload Product CSV File .</u></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt"><br></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;1. Click on &quot;Bulk Product Upload. &quot;</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;2. Product bulk upload screen is displayed.</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;3. Browse a CSV file . (You can upload CSV files only.).</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;4. You can download  sample CSV files from the bulk product upload screen.(You can Either use same categories from the cart or can enter new categories) <a href="#" onClick="openWin();">Click Here</a> to view Categories in Cart.</a></span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;5. After Browsing a CSV file Click on &quot;Next&quot; button.</span></font></div><div align="left"><font face="Arial"><span style=" font-size:10pt">&#160;6. You will get a page with Link Import Fields. Use this page to define which import fields should map to which product fields in your uploaded CSV file. </span>
<div align="left"><span style=" font-size:10pt">&#160;7. After Mapping with corresponding filelds click on "Next" Button. </span></div>
<div align="left"><span style=" font-size:10pt">&#160;8. You will get a confirmation page showing the status of product upload like "Following Products Saved Successfully !." or  "Following Products Failed to save " etc.</span></div></font>
<div align="left"><span style=" font-size:10pt"><font face="Arial">&#160;9. If Products are saved successfully click on button "Continue with Bulk Image Upload".</font></span></div>
<div align="left"><span style=" font-size:10pt"><font face="Arial">&#160;10. Product Bulk Image upload screen will display. </font></span></div>
<div align="left"><span style=" font-size:10pt"><font face="Arial">&#160;11. Browse your zip file and select the ''Next'' button. The image name should be the same name as the product you uploaded in the Bulk Product Upload. </font></span></div>
<div align="left"><span style=" font-size:10pt"><font face="Arial">&#160;12. You will get a confirmation message like Following Products Images Saved Successfully or Following Products Images Failed to save etc..  </font></span></div>', 11, '0');
INSERT INTO `multicart_help` (`hcid`, `htitle`, `hdescription`, `hposition`, `active`) VALUES (78, '	Email Templates', '<font face="Arial"><span style=" font-size:10pt">The mail content sent to customers can be customized in this section. </span></font><br>', 12, '0');

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `parent_id`, `divname`) VALUES ('Language Settings', 'LEFT_MENU_LANGUAGE_SETTINGS', 'language.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 'Language Settings');

INSERT INTO `multicart_language_master` (`languageName`, `prevLanguage`, `backupFile`, `langActive`, `langDeleteStatus`) VALUES ('english', '0', '0', 2, 1);


DELETE FROM `multicart_email_templates` WHERE  `nemail_id`=50 LIMIT 1;

INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, 
`vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'order_statuschange_buyer_seller', 'Order Status Change Mail To Buyer From Seller', 
'[order_details] \r\n\r\nWith regards, \r\n[site_name] Team', '[site_name], [order_details]', 'S');

DELETE FROM `multicart_email_templates` WHERE  `nemail_id`=42 LIMIT 1;

INSERT  INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
	('', 'affiliate_registration_admin', 'New Affiliate Registration Mail To Administrator', 'Dear Administrator ,\r\n\r\n A new affiliate has been registered with [site_name]\r\n\r\n Account details are as  follows\r\n\r\nUser Name :- [user_name]\r\n\r\nPassword :- [password]\r\n\r\n First Name :- [first_name]\r\n\r\nLast Name :- [last_name]\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ', '[first_name], [last_name], [site_name], [user_name], [password]', 'A');


DELETE FROM `multicart_email_templates` WHERE  `nemail_id`=35 LIMIT 1;

INSERT  INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES('', 'seller_registration_admin', 'New Seller Registration Mail To Administrator', 'Dear Administrator ,\r\n\r\nA new seller has been registered with [site_name]\r\n\r\n Account details are as  follows\r\n\r\nUser Name :  [user_name]\r\n\r\nPassword :  [password]\r\n\r\n First Name :  [seller_first_name] \r\n\r\nLast Name :  [seller_last_name]\r\n\r\n Happy shopping..\r\n\r\n \r\nWith warm regards,\r\n\r\n [site_name]  Team ', '[seller_first_name], [seller_last_name], [site_name], [user_name], [password]', 'A');

UPDATE `multicart_metatags` SET `vTitle`='Multicart2.5', `vKeywords`='Multicart2.5', `vDescription`='Multicart2.5' WHERE `vPageName`='index.php';