insert into multicart_rating values (1, 'poor');
insert into multicart_rating values (2, 'good');
insert into multicart_rating values (3, 'very good');
insert into multicart_rating values (4, 'excellent');

insert into multicart_currency_master values (1, 'US Dollar', 'USD', '&#36;', 1, 'Y', 'N');
insert into multicart_currency_master values (2, 'Euro', 'EUR', '&#128;', 1.1036, 'N', 'N');
insert into multicart_currency_master values (3, 'GB Pound', 'GBP', '&pound;', 0.5289, 'N', 'N');

insert into multicart_custom_form values (1, 'user_registration');
insert into multicart_custom_form values (2, 'product_adding');

INSERT  INTO multicart_template_master (ntemplate_id, vtemplate_name, vtop_filename, vleft_filename, vbottom_filename,vimages_folder,vcss_name,vcss_original, vactive_status) VALUES (1, 'template1', 'template1_top.php', 'centermain.php', 'template1_footer.php', 'images', 'Life Style - Fashion/style.css', 'template1_original.css', 'Y');

INSERT INTO multicart_shipping_settings VALUES (1, 10, 'OTP', 'CP', 'RES');

insert into multicart_shipping_methods values (2, 'Ups', 'ups.gif', '2007-08-29', 'N');
UPDATE multicart_shipping_methods SET vdeleted = 'Y' WHERE shipping_method_id =1 LIMIT 1 ;

INSERT INTO multicart_usps_settings VALUES (1, '599ARMIA0450', 'test');
INSERT INTO multicart_fedexsettings VALUES (1, '510087925', '7001069', 'LBS', 'test', 'REGULARPICKUP', 'PRIORITYOVERNIGHT-FedEx Priority Overnight,STANDARDOVERNIGHT-FedEx Standard Overnight,FIRSTOVERNIGHT-FedEx First Overnight,FEDEX2DAY-FedEx 2 Day', 'YOURPACKAGING', 'USD');
INSERT INTO multicart_settings(banner_size,canada_merchantId,canada_server,default_flatrate,additional_flatrate) values ('400,60','CPC_DEMO_XML','test',10,5);

UPDATE multicart_products set vapproved='Y';
UPDATE multicart_artists set vapproved='Y';
UPDATE multicart_affiliates  set vapproved='Y';
INSERT INTO multicart_email_templates (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES (22, 'order_notification_buyer', 'Order Notification To Buyer', 'Dear [first_name]     [last_name], \r\n\r\nA new order has been placed for you through the [site_name] site. The details are as follows. [order_details] With regards, Administrator, [site_name]', '[site_name], [order_details]', 'A');

insert into multicart_email_templates (nemail_id ,vtemplate_name , vtemplate_title,vemail_body , vreplaceable_variables ,vtemplate_flag)
VALUES ('', 'new_product_approval', 'New Product Approval', 'Dear Administrator,\r\n\r\nA new Product has been added  under  the seller [seller_username].\r\n\r\nDate of Posting: [date]\r\n\r\nProduct Name : [product_name]\r\n\r\nProdct code: [product_code]\r\n\r\nProduct Category Name : [category_name]\r\n\r\nProduct Price: [product_price]\r\n\r\nStock Available : [stock_available]\r\n\r\nShipping Weight :[shipping_weight]\r\n\r\nProduct Image:\r\n\r\n[product_image]\r\n\r\nIf you want to view please click the below link\r\n\r\n[link] ( Listing is available only after aproval)\r\n\r\n Thank you,\r\n\r\n[seller_name].  \r\n', '[seller_username], [date], [product_name], [product_code],[link],[seller_name],[product_price],[product_image],[stock_available],[shipping_weight],[category_name]', 'A');
insert into multicart_email_templates ( nemail_id , vtemplate_name , vtemplate_title,vemail_body , vreplaceable_variables ,vtemplate_flag)
VALUES ('', 'refund_registration', 'Refund Request Registration', 'Dear [first_name] [last_name],\r\n\r\nYour Return Payment Request has been Registered with [site_name]\r\n\r\nYour Request Refund Details are as follows\r\n\r\nproduct name :[p_name]\r\n\r\nReturn Reason :[return_reason]\r\n\r\nQuantity  :[quantity]\r\n\r\nDate : [date]\r\n\r\nComments : [comments]\r\n\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[first_name], [last_name], [site_name]', 'A');
insert into multicart_email_templates ( nemail_id , vtemplate_name , vtemplate_title,vemail_body , vreplaceable_variables ,vtemplate_flag)
VALUES ('', 'refund_request', 'Refund Request for Sellers', 'Dear [seller_name] ,\r\n\r\n[first_name]  has been requested for return payment  with [site_name]\r\n\r\nRequest Refund Details are as follows\r\n\r\nproduct name :[p_name]\r\n\r\nReturn Reason :[return_reason]\r\n\r\nQuantity  :[quantity]\r\n\r\nDate : [date]\r\n\r\nComments : [comments]\r\n\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[first_name], [last_name], [site_name]', 'A');
insert into multicart_email_templates ( nemail_id , vtemplate_name , vtemplate_title,vemail_body , vreplaceable_variables ,vtemplate_flag)
VALUES ('', 'refund_request_statuschange', 'Refund Request Status Change', 'Dear [user_name] ,\r\n\r\n Your request for refund has been confirmed  with [site_name]\r\n\r\nRefund Status  Details are as follows\r\n\r\nproduct name :[p_name]\r\n\r\nReturn payment Action :[status]\r\n\r\nQuantity  :[quantity]\r\n\r\nDate : [date]\r\n\r\nReturn Mode : [rmode]\r\n\r\nReference Number : [rno]\r\n\r\nSeller Comments : [comments]\r\n\r\n\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[first_name], [last_name], [site_name]', 'A');
insert into multicart_email_templates ( nemail_id , vtemplate_name , vtemplate_title,vemail_body , vreplaceable_variables ,vtemplate_flag)
VALUES ('', 'refund_request_adminstatus', 'Refund Request Status Change confirmation for admin', 'Dear Administrator ,\r\n\r\n Customer refund request status has been changed  with [site_name]\r\n\r\n Refund Status  Details are as follows\r\n\r\n Customer Name : [user_name] \r\n\r\n Seller Name : [seller_name] \r\n\r\n  product name :[p_name]\r\n\r\nReturn payment Action :[status]\r\n\r\nQuantity  :[quantity]\r\n\r\nDate : [date]\r\n\r\nReturn Mode : [rmode]\r\n\r\nReference Number : [rno]\r\n\r\nSeller Comments : [comments]\r\n\r\n\r\n\r\n Thank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[first_name], [last_name], [site_name]', 'A');
insert into multicart_email_templates ( nemail_id , vtemplate_name , vtemplate_title,vemail_body , vreplaceable_variables ,vtemplate_flag)
VALUES ('', 'refund_request_reg_admin', 'Refund Request Registartion confirmation for admin', 'Dear Administrator ,\r\n\r\n Customer Return Request Refund  has been registered  with [site_name]\r\n\r\n Refund Registration Details are as follows\r\n\r\n Customer Name : [user_name] \r\n\r\n Seller Name : [seller_name] \r\n\r\n  product name :[p_name]\r\n\r\nReason for Return  :[reason]\r\n\r\nQuantity  :[quantity]\r\n\r\nDate : [date]\r\n\r\n\r\n Thank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[first_name], [last_name], [site_name]', 'A');

INSERT INTO multicart_email_templates (nemail_id, vtemplate_name, vtemplate_title, vemail_body, vreplaceable_variables, vtemplate_flag) VALUES ('', 'seller_registration_approval', 'Sellers Approval By Admin', 'Dear [first_name],\r\n\r\nThank you for registering with [site_name]\r\n\r\nYour seller account has been approved with [site_name] \r\n\r\nYou can use your account details  to login to [site_name].\r\n\r\n Thank you once again for your interest in [site_name]\r\n\r\nStart earning money.. it''s that easy..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[first_name], [last_name], [site_name]', 'A');


UPDATE multicart_artists SET  defaultflatrate =(select default_flatrate  from multicart_settings ) ;
UPDATE multicart_artists SET  additionalflatrate =(select additional_flatrate  from multicart_settings ) ;


insert into multicart_categories values ('','Gift Certificate', 0, NULL, 0, 'Y');
UPDATE multicart_settings SET banner_size = '400,60' WHERE nsettings_id = 1 LIMIT 1 ;
insert into multicart_affiliate_banner ( naff_banner_id , vaff_banner_name )values ('', 'affiliate_banner1.jpg'), ('', 'affiliate_banner2.jpg');
insert into multicart_affiliate_banner ( naff_banner_id , vaff_banner_name )values ('', 'affiliate_banner3.jpg'), ('', 'affiliate_banner4.jpg');
insert into multicart_affiliate_banner ( naff_banner_id , vaff_banner_name )values ('', 'affiliate_banner5.jpg'), ('', 'affiliate_banner6.jpg');
insert into multicart_affiliate_banner ( naff_banner_id , vaff_banner_name )values ('', 'affiliate_banner7.jpg'), ('', 'affiliate_banner8.jpg');
insert into multicart_affiliate_banner ( naff_banner_id , vaff_banner_name )values ('', 'affiliate_banner9.jpg');
insert into multicart_affiliate_banner ( naff_banner_id , vaff_banner_name )values ('', 'affiliate_banner10.jpg');
insert into multicart_content_management ( content_id , content_name , content_heading , content_text )
values ('1', 'home_page', '<font size="4"><span style="font-weight: bold;">Amazing Offers!</span></font>', '<span style="font-weight: bold;">Multicart is a one stop store for all your shopping needs. Multicart offers a large list  of products from which you can select your favorite items. Apart from that you can view and purchase best quality items from  different sellers around the world! So have a nice time at Multicart</span>');
insert into multicart_email_templates ( nemail_id , vtemplate_name , vemail_body , vreplaceable_variables )
values (
'', 'order_acknowledgement', 'Dear [first_name] [last_name], Please find the order details [product_details] Rgds, [seller_name]', ''
);
UPDATE multicart_email_templates SET vreplaceable_variables = '[first_name], [last_name], [product_details], [seller_name]' WHERE nemail_id =1 LIMIT 1 ;
UPDATE multicart_email_templates SET vemail_body = 'Dear [first_name] [last_name], We have received an order from you for the following. [product_details] We will be shipping you the same as early as possible. Rgds, [seller_name]' WHERE nemail_id =1 LIMIT 1 ;
insert into multicart_email_templates ( nemail_id , vtemplate_name , vemail_body , vreplaceable_variables )
values (
'', 'gift_coupon', 'Dear [first_name][last_name], Please find the details of the gift coupon you ordered Coupon code : [coupon_code] Coupon Amount : [coupon_amount] Regards, Administrator, [site_name] ', '[first_name], [last_name], [coupon_code], [coupon_amount], [site_name]'
);
insert into multicart_email_templates ( nemail_id , vtemplate_name , vemail_body , vreplaceable_variables )
values (
'', 'order_notification_seller', 'Dear [site_name] seller, A new order has been placed for you through the [site_name] site. The details are as follows. [order_details] With regards, Administrator, [site_name]', '[site_name], [order_details]'
);
insert into multicart_email_templates ( nemail_id , vtemplate_name , vemail_body , vreplaceable_variables )
values (
'', 'stock_reorder', 'Dear [site_name] Seller, The following product(s) has gone under the reorder level set by you.Please refill your stock [product_details] With regards, Administrator, [site_name]', '[site_name], [product_details]'
);
insert into multicart_email_templates ( nemail_id , vtemplate_name , vemail_body , vreplaceable_variables )
values (
'', 'digital_product', 'Dear [first_name][last_name], We have received a Digital Product Order from you,Please find the details of the order. [product_details] Regards, Administrator, [site_name]', '[first_name], [last_name], [product_details]'
);
UPDATE multicart_email_templates SET vtemplate_title = 'Order Acknowledgement Mail From Seller' WHERE nemail_id =1 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_title = 'Gift Coupon Order Mail' WHERE nemail_id =2 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_title = 'New Order Placed Mail To Seller' WHERE nemail_id =3 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_title = 'Stock Reorder Mail ' WHERE nemail_id =4 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_title = 'Digital Product Order Placed Mail' WHERE nemail_id =5 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_flag = 'S' WHERE nemail_id =1 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_flag = 'A' WHERE nemail_id =2 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_flag = 'A' WHERE nemail_id =3 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_flag = 'A' WHERE nemail_id =4 LIMIT 1 ;
UPDATE multicart_email_templates SET vtemplate_flag = 'A' WHERE nemail_id =5 LIMIT 1 ;
UPDATE multicart_email_templates SET vemail_body = 'Dear [first_name] [last_name],

Please find the details of the gift coupon you ordered

[coupon_details]

Regards,

Administrator, [site_name]
',
vreplaceable_variables = '[first_name], [last_name], [coupon_details], [site_name]' WHERE nemail_id =2 LIMIT 1 ;

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , vreplaceable_variables , vtemplate_flag ) 
values (
'', 'New Member Registration', 'member_registration', 'Dear [first_name] [last_name],

Thank you for registering with [site_name]

Your account details are as follows

User Name :- [user_name]
Password :- [password]

Thank you once again for your interest in [site_name]

Happy shopping..

With warm regards,

Administrator, [site_name]', '[first_name], [last_name], [site_name], [user_name], [password]', 'A'
);

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , vreplaceable_variables , vtemplate_flag ) 
values (
'', 'New Seller Registration', 'seller_registration', 'Dear [first_name] [last_name]

Thank you for registering with [site_name]

Your seller account details are as follows

User Name :- [user_name]
Password :- [password]

Thank you once again for your interest in [site_name]

Start earning money.. it''s that easy..

With warm regards,

Administrator, [site_name]', '', ''
);

UPDATE multicart_email_templates SET vreplaceable_variables = '[first_name], [last_name], [site_name]',
vtemplate_flag = 'A' WHERE nemail_id =7 LIMIT 1 ;

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , vreplaceable_variables , vtemplate_flag ) 
values (
'', 'New Affiliate Registration', 'affiliate_registration', 'Dear [first_name] [last_name],

Thank you for registering with [site_name]

Your affiliate account details are as follows

User Name :- [user_name]
Password :- [password]

Thank you once again for your interest in [site_name]

With warm regards,

Administrator, [site_name]
', '[first_name], [last_name], [user_name], [password], [site_name]', 'A'
);



insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , vreplaceable_variables , vtemplate_flag ) 
values (
'', 'user_forgotpassword', 'User Forgot Password', 'Your password with [site_name] is reset on request.

Your updated account details are as follows

User Name :- [user_name]
Password :- [password]

With Regards,

Administrator [site_name].', '[user_name], [password], [site_name]', 'A'
);

UPDATE multicart_email_templates SET vemail_body = 'Dear [name],

Your password with [site_name] is reset on request.

Your updated account details are as follows

User Name :- [user_name]
Password :- [password]

With Regards,

Administrator [site_name].' WHERE nemail_id =9 LIMIT 1 ;

UPDATE multicart_email_templates SET vtemplate_title = 'User Forgot Password',
vtemplate_name = 'user_forgotpassword' WHERE nemail_id =9 LIMIT 1 ;

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , 

vreplaceable_variables , vtemplate_flag ) 
values (
'', 'Seller Forgot Password', 'seller_forgotpassword', 'Dear [name],

You have requested a password reset for your Seller account with [site_name]

Your updated Seller account details are as follows

User Name :- [user_name]
Password :- [password]

With regards,

Administrator [site_name]', '[name], [user_name], [password], [site_name]', 'A'
);

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , 

vreplaceable_variables , vtemplate_flag ) 
values (
'', 'Affiliate Forgot Password', 'affiliate_forgotpassword', 'Dear [name],

You have requested a password reset for your affiliate account with [site_name]

User Name :- [user_name]
Password :- [password]

With regards,

Administrator [site_name]
', '[name], [user_name], [password], [site_name]', 'A'
);

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , 

vreplaceable_variables , vtemplate_flag ) 
values (
'', 'Change User Password', 'change_userpassword', 'Dear [name],

Your password with [site_name] has been reset by the site Administrator

The updated account details are as follows

User Name :- [user_name]
Password :- [password]

With regards,

Administrator [site_name]', '[name], [user_name], [password], [site_name]', 'A'
);

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , vreplaceable_variables , vtemplate_flag ) 
values (
'', 'Change Seller Password', 'change_sellerpassword', 'Dear [name],

Your Seller account information with [site_name] has been reset by the Administrator.

The updated account details are as follows

User Name :- [user_name]
Password :- [password]

With regards,

Administrator [site_name]', '[name], [user_name], [password], [site_name]', 'A'
);

insert into multicart_email_templates ( nemail_id , vtemplate_title , vtemplate_name , vemail_body , 

vreplaceable_variables , vtemplate_flag ) 
values (
'', 'Change Affiliate Password', 'change_affiliatepassword', 'Dear [name],

Your password with [site_name] has been reset by the site Administrator

The updated account details are as follows

User Name :- [user_name]
Password :- [password]

With regards,

Administrator [site_name]', '[name], [user_name], [password], [site_name] ', 'A'
);
insert into multicart_content_management (content_id, content_name, content_heading, content_text) VALUES (5, 'faq', 'FAQ', '<table cellspacing="1" cellpadding="5" width="100%">\r\n    <tbody>\r\n        <tr>\r\n            <td width="100%" class="headng"><a name="top"><strong><u>User Section</u></strong></a></td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="innertextCopy1">\r\n            <ul>\r\n                <li><a class="menu2" href="#1">Why do I see sub orders in my order history?</a> </li>\r\n                <li><a class="menu2" href="#2">Why do I receive my order in many parts?</a> </li>\r\n                <li><a class="menu2" href="#3">What if I get my order in a damaged/bad condition?</a> </li>\r\n                <li><a class="menu2" href="#4">How long will it take to ship my items?</a> </li>\r\n                <li><a class="menu2" href="#5">Can I purchase without registering?</a> </li>\r\n                <li><a class="menu2" href="#6">Do I need to do anything after I receive the items?</a> </li>\r\n            </ul>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="headng"><a name="sellers"><strong><u>Seller Section</u></strong></a></td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="innertextCopy1">\r\n            <ul>\r\n                <li><a class="menu2" href="#1s">I am a seller. How will I sell my products through your site?</a> </li>\r\n                <li><a class="menu2" href="#2s">Can I sell the products free of cost? Are there any charges?</a> </li>\r\n                <li><a class="menu2" href="#3s">How will I receive the payments for my delivered orders?</a> </li>\r\n                <li><a class="menu2" href="#4s">Can I ship items from the same order separately?</a> </li>\r\n                <li><a class="menu2" href="#5s">What if some of my items don''t fit in any of the categories listed?</a> </li>\r\n                <li><a class="menu2" href="#6s">How will I display my portfolio to the users?</a> </li>\r\n                <li><a class="menu2" href="#7s">Do I need to pay to register with the site as a seller?</a> </li>\r\n            </ul>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="headng"><a name="affiliate"><strong><u>Affiliate Section</u></strong></a></td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="innertextCopy1">\r\n            <ul>\r\n                <li><a class="menu2" href="#1a">How can I become an affiliate of your site?</a> </li>\r\n                <li><a class="menu2" href="#2a">Are affiliates paid after registration?</a> </li>\r\n                <li><a class="menu2" href="#3a">Will I receive payments for the lifetime purchases from my referrals?</a> </li>\r\n                <li><a class="menu2" href="#4a">When will I receive the payments?</a> </li>\r\n                <li><a class="menu2" href="#5a">Do I need a website to become your affiliate?</a> </li>\r\n                <li><a class="menu2" href="#6a">Where can I get the urls for publishing?</a> </li>\r\n            </ul>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="headng"><strong><u>User Section</u></strong></td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="innertextCopy1">\r\n            <li><a class="menu2" name="1">Why do I see sub orders in my order history?</a> <br /><span class="innertextCopy2"><br />Any order you place on the site may contain items from different vendors. This implies that your order may have more than one suborder; these are shipped by the vendors separately. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="2">Why do I receive my order in many parts? </a> <br /><span class="innertextCopy2"><br />Any order you make can contain items from many vendors, these suborders are handled by each vendor individually. That is why your items are delivered in parts. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="3">What if I get my order in a damaged/bad condition?</a> <br /><span class="innertextCopy2"><br />The sellers are careful not to damage your orders after packaging and shipping them for you. If your order happens to be damaged, you can inform the seller and us to get return merchandize authorization from the seller to return the items.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="4">How long will it take to ship my items?</a> <br /><span class="innertextCopy2"><br />Your items should reach you in 3 weeks. If you haven&rsquo;t received your items in this span of time, please contact the seller immediately. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="5">Can I purchase without registering?</a> <br /><span class="innertextCopy2"><br />No. You need to first register with the site and login to be able to shop with the site. However, you can browse and compare items even without logging in.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="6">Do I need to do anything after I receive the items?</a> <br /><span class="innertextCopy2"><br />You can login to the system, go to ''Orders'' section and update the status of each sub-orders (if any) to ''delivered'' after you get your items in good condition.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span></li>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td class="headng">&nbsp;</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="headng"><strong><u>Seller Section</u></strong></td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="innertextCopy1">\r\n            <li><a class="menu2" name="1s">I am a seller. How will I sell my products through your site?</a> <br /><span class="innertextCopy2"><br />To be able to sell your products through <!--p echo SITE_NAME;-->you need to first <a href="artists/register.php">register</a> with the site as a Seller. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="2s">Can I sell the products free of cost? Are there any charges?</a> <br /><span class="innertextCopy2"><br />There is no listing fee or monthly fee. A commission for sale is deducted before sending you the proceeds. The current seller commission is 10%. The commission is applied only when a sale is complete.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="3s">How will I receive the payments for my delivered orders?</a> <br /><span class="innertextCopy2"><br />We pay vendors on a net 30 basis, so you can expect payments after 30 days of delivery. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="4s">Can I ship items from the same order separately?</a> <br /><span class="innertextCopy2"><br />No. You can&rsquo;t ship items separately. You need to ship all the items in one order or cancel it. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="5s">What if some of my items don''t fit in any of the categories listed?</a> <br />                   <span class="innertextCopy2"><br />If your items don&rsquo;t fit into any of the categories on the site, you can request that the administrator create the categories you need using the &lsquo;Mail Admin&rsquo; section. If the categories are relevant, the administrator will add them for you.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="6s">How will I display my portfolio to the users?</a> <br /><span class="innertextCopy2"><br />You need to have a html portfolio page designed for publishing on the site. If you have any images on the page, please make sure the image urls are complete otherwise they will not load properly.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="7s">Do I need to pay to register with the site as a seller?</a> <br /><span class="innertextCopy2"><br />No. Sellers can register for free. The sales commission is per order after you receive them through the site.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span></li>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td class="headng">&nbsp;</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="headng"><strong><u>Affiliate Section</u></strong></td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100%" class="innertextCopy1">\r\n            <li><a class="menu2" name="1a">How can I become an affiliate of your site?</a> <br /><span class="innertextCopy2"><br />You can become an affiliate by registering under the <a href="affiliates/index.php">Affiliate Section</a><br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="2a">Are affiliates paid after registration?</a> <br /><span class="innertextCopy2"><br />You will be paid for the purchase you refer to us. We pay 5%of the purchase amount, as affiliate commission. <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="3a">Will I receive payments for the lifetime purchases from my referrals?</a> <br /><span class="innertextCopy2"><br />No. You will be eligible for payments from the first purchase.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="4a">When will I receive the payments?</a> <br /><span class="innertextCopy2"><br />We pay our affiliates monthly after 30 days of the month&rsquo;s end. A minimum of $100 is required for payout and the unpaid balance will be rolled over to the next month.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="5a">Do I need a website to become your affiliate?</a> <br /><span class="innertextCopy2"><br /> No. You don&rsquo;t need a website to become our affiliate. All you have to do is get an advertising url from the <a href="affiliates/geturls.php.php">Get Url</a> page of the affiliate section. When you are finished, ask your friends to register using your url.<br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span><br /></li>\r\n            <li><a class="menu2" name="6a">Where can I get the urls for publishing?</a> <br /><span class="innertextCopy2"><br /><a href="affiliates/login.php">Login</a> to the Affiliate Section of the page and go to the &lsquo;Get URL&rsquo; page. You can email or select the banners and/or urls from this section to advertise on your site.   <br /></span><span class="innertextCopy2" align="right" width="100%"><a class="menu2" href="#top">Top</a><br /></span></li>\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>');
ALTER TABLE multicart_settings ADD vReview CHAR( 9 ) NOT NULL DEFAULT 'automatic' AFTER site_logo;

INSERT INTO `multicart_email_templates`
VALUES (
'', 'order_notification_admin', 'Order Notification To Admin', 'Dear Administrator, \r\n\r\nA new order has been placed by [first_name] [last_name] through the [site_name] site. The details are as follows. [order_details] With regards, [site_name]', '[site_name], [order_details]', 'A'
);


UPDATE `multicart_template_master` SET `vtemplate_name` = 'Feelings-Green',vcss_name = 'Feelings-Green/style.css' WHERE `ntemplate_id` =1 LIMIT 1 ;




INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'member_registration_admin', 'New Member Registration Mail To Administrator', 'Dear Administrator ,\r\n\r\n A new member 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\n\r\nLast Name :- [last_name]\r\n\r\n Happy shopping..\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ', '[first_name], [last_name], [site_name], [user_name], [password]', 'A');



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\n A 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 :  [firstname]\r\n \r\nLast Name :  [lastname]\r\n\r\n Happy shopping..\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ', '[firstname], [lastname], [site_name], [user_name], [password]', 'A');



INSERT INTO `multicart_email_templates` VALUES ('', 'order_notification_admin', 'Order Notification To Admin', 'Dear Administrator, \r\n\r\nA new order has been placed by  [first_name]     [last_name] through the [site_name] site. The details are as follows. [order_details] With regards,  [site_name]', '[site_name], [order_details]', 'A');


INSERT INTO `multicart_email_templates` VALUES ('', 'stock_reorder', 'Stock Reorder Mail to Seller', ' The following product(s) has gone under the reorder level set by you.Please refill your stock \r\n\r\n[product_details] \r\n\r\nWith regards, Administrator, [site_name]', '[site_name], [product_details]', 'A');

INSERT INTO `multicart_email_templates` VALUES ('', 'order_notification_buyer', 'Order Notification To Buyer', 'Dear [first_name]     [last_name], \r\n\r\nA new order has been placed for you through the [site_name] site. The details are as follows. [order_details] With regards, Administrator, [site_name]', '[site_name], [order_details]', 'A');

INSERT INTO `multicart_email_templates` VALUES ('', 'order_notification_mail_seller', 'Order Notification Mail to Seller', ' [order_details] \r\n\r\nWith regards, Administrator, [site_name]', '[site_name], [order_details]', 'A');

UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator, A new order has been placed by 

[buyer_first_name] [buyer_last_name] through the [site_name] site. The details are as follows. 

[order_details] With regards, [site_name]' WHERE  vtemplate_name='order_notification_admin' LIMIT 1; 




UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear [buyer_first_name] [buyer_last_name], A new 

order has been placed for you through the [site_name] site. The details are as follows. [order_details] With 

regards, Administrator, [site_name]' WHERE  vtemplate_name='order_notification_buyer' LIMIT 1; 


ALTER TABLE `multicart_affiliate_registrations` CHANGE `user_totalpurchasedamount` `user_totalpurchasedamount` DOUBLE NULL;


CREATE TABLE IF NOT EXISTS `multicart_giftcertificates` (
  `gift_id` int(11) NOT NULL AUTO_INCREMENT,
  `vgift_coupon_code` varchar(255) NOT NULL,
  `ngift_order_id` int(11) NOT NULL,
  `ngift_coupon_amount` double NOT NULL,
  `ngift_product_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `nused_gift_amount` double NOT NULL DEFAULT '0',
  `seller_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`gift_id`)
) ENGINE=MyISAM  ;


ALTER TABLE `multicart_orders` ADD `nused_gift_amount` DOUBLE NOT NULL DEFAULT '0',
ADD `namount_paid` DOUBLE NOT NULL DEFAULT '0';


CREATE TABLE IF NOT EXISTS `multicart_admin_menu` (
  `menu_id` bigint(20) NOT NULL auto_increment,
  `page_name` varchar(200) NOT NULL default '',
  `link` varchar(200) NOT NULL default '',
  `parent_id` smallint(4) NOT NULL default '0',
  `display_order` tinyint(4) NOT NULL default '0',
  `divname` varchar(200) NOT NULL default '',
  `status` enum('ACTIVE','INACTIVE') NOT NULL default 'ACTIVE',
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM   ;


ALTER TABLE `multicart_orders` ADD `vgiftcertificate_code` VARCHAR( 255 ) NOT NULL ;


ALTER TABLE `multicart_settings` ADD `admin_currency` VARCHAR( 255 ) NOT NULL DEFAULT 'USD';


ALTER TABLE `multicart_currency_master` ADD `usdollar_rate` FLOAT NOT NULL DEFAULT '1';


ALTER TABLE `multicart_products` CHANGE `discount` `discount` DOUBLE NULL DEFAULT '0';
ALTER TABLE `multicart_couponcode` CHANGE `ccDiscount` `ccDiscount` DOUBLE NOT NULL DEFAULT '0';

ALTER TABLE `multicart_affiliate_registrations` ADD `order_id` INT NOT NULL AFTER `user_id`; 
ALTER TABLE `multicart_affiliate_payments` ADD `order_id` INT NOT NULL AFTER `affiliate_id` ;



DELETE *  FROM multicart_currency_master ;

insert into multicart_currency_master values (1, 'US Dollar', 'USD', '&#36;', 1, 'Y', 'N',1);
insert into multicart_currency_master values (2, 'Euro', 'EUR', '&#128;', 1.1036, 'N', 'N',0.688136526);
insert into multicart_currency_master values (3, 'GB Pound', 'GBP', '&pound;', 0.607607243, 'N', 'N',0.607607243);


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'bulkproduct_uploadnotification_seller', 'Bulk Product Upload Notification Mail to Seller', 'Dear [seller_first_name] [seller_last_name],\r\n\r\n Your Following Products has been Uploaded to  [site_name]\r\n\r\n  [product_details] \r\n\r\n  Thank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[seller_first_name], [seller_last_name], [site_name]', 'A');




INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'bulkproduct_uploadnotification_admin', 'Bulk Product Upload Notification Mail to Admin', 'Dear Administrator , \r\n\r\n  Following Products has been Uploaded to  [site_name]  by  [seller_first_name] [seller_last_name] \r\n\r\n  [product_details] \r\n\r\n Happy shopping..\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ', '[seller_first_name], [seller_last_name], [site_name]', 'A');



INSERT INTO `multicart_email_templates` ( `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ( 'affiliate_registration_admin', 'New Affiliate Registration Mail To Administrator', 'Dear Administrator ,

 A new affiliate has been registered with [site_name]

 Account details are as  follows

User Name :- [user_name]

Password :- [password]

 First Name :- [first_name]
 
Last Name :- [last_name]


With warm regards,

[site_name]  Team ', '[first_name], [last_name], [site_name], [user_name], [password]', 'A'); 



UPDATE `multicart_email_templates` SET `vtemplate_title` = 'New Gift Order Placed Mail To Buyer',
`vemail_body` = '[coupon_details]',
`vreplaceable_variables` = '''[coupon_details], [site_name]''' WHERE  vtemplate_name='gift_coupon' LIMIT 1 ;


UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator, A new Product has been added under the seller [seller_username]. Date of Posting: [date] Product Name : [product_name] Prodct code: [product_code] Product Category Name : [category_name] Product Price: [product_price] Discount(%) : [product_discount] Stock Available : [stock_available] Shipping Weight :[shipping_weight] Product Image: [product_image] If you want to view please click the below link [link] ( Listing is available only after approval) Thank you, [seller_name]. ' WHERE vtemplate_name ="new_product_approval";


INSERT INTO multicart_email_templates (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ('product_review', 'New Product Review Mail To Administrator', 'Dear Administrator ,

A new product review has been posted with [site_name] By the User [first_name] [last_name]

Product Name :- [product_name].

[link] to view product details.


With warm regards,

[site_name]  Team ', '[site_name][first_name][last_name][product_name][link]', 'A');



INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'gift_couponmail_seller', 'New Gift Order Placed Mail To Seller', ' [coupon_details] \r\n\r\nWith regards, Administrator, [site_name]', '[site_name], [coupon_details]', 'A');


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'gift_couponmail_admin', 'New Gift Order Placed Mail To Admin', 'Dear Administrator, \r\n\r\nA new Gift order has been placed by  [buyer_first_name]     [buyer_last_name] through the [site_name] site. The details are as follows. [coupon_details] With regards,  [site_name]', '[site_name], [coupon_details]', 'A');


UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator ,

 Customer Return Request Refund  has been registered  with [site_name]

 Refund Registration Details are as follows

 Customer Name : [user_name] 

 Seller Name : [seller_name] 

  product name :[p_name]

Reason for Return  :[reason]

Quantity  :[quantity]

Date : [date]


With warm regards,

[site_name] Team' WHERE vtemplate_name  = "refund_request_reg_admin";


INSERT INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ('affiliate_registration_status', 'New Affiliate Registration status', 'Dear [first_name] [last_name],

Thank you for registering with [site_name]

Your affiliate account is approved by the administrator. You can login now using your username and password.

Thank you once again for your interest in [site_name]

With warm regards,

Administrator, [site_name]
', '[first_name],[last_name],[site_name]', 'A');



UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator ,

 Customer refund request status has been changed  with [site_name]

 Refund Status  Details are as follows

 Order Id   : [order_id]

 Refund Id : [refund_id]
 
 Customer Name : [user_name] 

 Seller Name : [seller_name] 

  product name :[p_name]

Return payment Action :[status]

Quantity  :[quantity]

Date : [date]

Return Mode : [rmode]

Reference Number : [rno]

Seller Comments : [comments]



 Thank you once again for your interest in [site_name]

Happy shopping..

With warm regards,

Administrator, [site_name]' WHERE vtemplate_name  ='refund_request_adminstatus';



UPDATE multicart_email_templates SET `vemail_body` = 'Dear [user_name] ,

 Your request for refund has been confirmed  with [site_name]

Refund Status  Details are as follows

Order Id : [order_id]

Refund Id : [refund_id]

product name :[p_name]

Return payment Action :[status]

Quantity  :[quantity]

Date : [date]

Return Mode : [rmode]

Reference Number : [rno]

Seller Comments : [comments]



Thank you once again for your interest in [site_name]

Happy shopping..

With warm regards,

Administrator, [site_name]' WHERE vtemplate_name  ='refund_request_statuschange';


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'refund_registration_seller', 'Refund Request Registration Mail for Seller', 'Dear [seller_first_name] [seller_last_name],\r\n\r\n Customer [first_name][last_name]  has been \r\n Requested Refund for following product with [site_name]\r\n\r\nRefund Details are as follows\r\n\r\nOrder Id : [order_id]\r\n\r\nRefund Id : [refund_id]\r\n\r\nproduct name :[p_name]\r\n\r\nReturn Reason :[return_reason]\r\n\r\nQuantity  :[quantity]\r\n\r\nDate : [date]\r\n\r\nComments : [comments]\r\n\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\nHappy shopping..\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]', '[seller_first_name],[''seller_last_name],[first_name], [last_name], [site_name]', 'A');


UPDATE multicart_email_templates SET `vemail_body` = 'Dear [first_name]  [last_name] ,

 Your Refund Request  has been registered  with [site_name]

Refund Details are as follows

Order Id : [order_id]

Refund Id : [refund_id]

product name :[p_name]

Return Reason :[return_reason]

Quantity  :[quantity]

Date : [date]

Comments : [comments]


Thank you once again for your interest in [site_name]

Happy shopping..

With warm regards,

Administrator, [site_name]',
`vreplaceable_variables` = '[seller_first_name],[''seller_last_name],[first_name], [last_name], [site_name]' WHERE  vtemplate_name  ='refund_registration';

UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator ,

 Customer [first_name] [last_name] has  been requested refund with [site_name]

 Refund Registration Details are as follows

 Order Id     : [order_id] 
 
 Refund Id    : [refund_id]

 Customer Name : [user_name] 

 Seller Name : [seller_name] 

  product name :[p_name]

Reason for Return  :[reason]

Quantity  :[quantity]

Date : [date]


Thank you once again for your interest in [site_name]

Happy shopping..

With warm regards,

Administrator, [site_name]' WHERE vtemplate_name  ='refund_request_reg_admin';



UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator, 

A new Product has been added under the seller [seller_username].
Date of Posting: [date]
Product Name : [product_name]
Prodct code: [product_code]
Product Category Name : [category_name]
Product Price: [product_price] Discount(%) : [product_discount]
Stock Available : [stock_available]
Shipping Weight :[shipping_weight]
Product Image: [product_image]

If you want to view please click the below link 
[link] 
(Listing will be available only after approval) 

Thank you,
[seller_name]. ', `vreplaceable_variables` = '[seller_username],[date],[product_name],[product_code],[category_name],[product_price],[product_discount],[stock_available],[shipping_weight],[product_image],[link],[seller_name]' WHERE vtemplate_name  = "new_product_approval";

INSERT INTO `multicart_email_templates` ( `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ('new_gift_certificate_seller', 'New gift certificate notification to admin from seller', 'Dear Administrator, 

A new gift certificate has been added under the seller [seller_username].
Date of Posting: [date]
Gift Certificate Name : [certificate_name]
Gift Certificate Code: [certificate_code]
Certificate Details : [imglink]
Certificate Amount : [certificate_amount] USD
Stock Available : [stock_available]
Stock Reorder Level : [stock_reorder]


Thank you,
[seller_name].', '[seller_username],[date],[certificate_name],[certificate_code],[imglink],[certificate_amount],[stock_available],[stock_reorder]', 'A');


INSERT INTO `multicart_email_templates` ( `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ( 'request_payment_seller', 'Request payment from seller to administrator', 'Dear administrator,

The seller [seller_name] has been made a request for payment in [site_name] site. 

The details are as follows. 
[order_details] 

With regards, 
[site_name] Team', '[seller_name],[site_name],[order_details]', 'A');


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES (NULL, 'settle_artist_payment', 'Mail to seller during settle payment', 'Dear [seller_name], Your payment is settled by the administrator in the [site_name] site. Amount paid is : [amount] With regards, [site_name]', '[seller_name][site_name][amount] ', 'A');


UPDATE multicart_email_templates SET `vtemplate_title` = 'Digital Product Order Mail to Buyer',
`vemail_body` = 'Dear [first_name]     [last_name], \r\n\r\n A new order has been placed for you through the [site_name] site. The details are as follows. [order_details] With regards, Administrator, [site_name]' ,
`vtemplate_flag` = 'Y' WHERE vtemplate_name  ='digital_product' LIMIT 1 ;


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'digital_product_seller', 'Digital Product Order Mail to Seller', ' A new Digital Product Order has been placed by [first_name] [last_name]  through the \r\n\r\n[site_name] site. The details are as follows. [order_details] With regards, Administrator, [site_name]', '[first_name], [last_name], [product_details]', 'Y');


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'digital_product_admin', 'Digital Product Order Mail to Admin', ' Dear Administrator ,  \r\n\r\n A new Digital Product Order has been placed by [first_name] [last_name]  through the \r\n\r\n[site_name] site. The details are as follows. [order_details] With regards, [site_name] Team ', '[first_name], [last_name], [product_details]', 'Y');


INSERT INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ('product_review_approved', 'Product review status change mail to user', 'Dear [user_name] ,

Your product review on [site_name] is [status] by the [approved_by]

Product Name :- [product_name].

[link] to view product details.


With warm regards,

[site_name]  Team ', '[user_name],[site_name],[approved_by],[product_name],[link]', 'A');


UPDATE `multicart_content_management` SET `content_heading` = '<font size="7"><span style="font-weight: bold;">Amazing Offers!</span></font>',
`content_text` = '<span style="font-weight: bold;">Multicart is a one stop store for all your shopping needs. Multicart offers a large list of products from which you can select your favorite items. Apart from that you can view and purchase best quality items from different sellers around the world! So have a nice time at Multicart . <br /><br /></span>' WHERE content_name ='home_page' LIMIT 1 ;


UPDATE multicart_template_master  SET vtemplate_name ='Occasion-Birthday' ,vcss_name='Occasion-Birthday/style.css' where vtemplate_name ='Occassion-Birthday' ;


UPDATE multicart_template_master  SET vtemplate_name ='Occasion-Wedding' ,vcss_name='Occasion-Wedding/style.css' where vtemplate_name ='Occassion-Wedding' ;


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'seller_plan_expirenotification', 'Seller Plan Expiry Notification Mail', 'Dear [seller_fname] [seller_lname], \r\n\r\n Thank you for using  [site_name]. \r\n\r\nThis is to   notify that your seller account with [site_name]  will expire on [date_expiry].\r\n\r\n Please renew your account to continue using [site_name] .\r\n\r\n  You can renew your account using following link \r\n\r\n  [LINK] . \r\n\r\n\r\n With regards, Administrator, \r\n\r\n[site_name]', '[seller_fname], [seller_lname], [date_expiry],[LINK]', 'Y');


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'seller_plan_expiry', 'Seller Plan Expiry  Mail', 'Dear [seller_fname] \r\n\r\n[seller_lname],   \r\n\r\n Thank you for using  [site_name]. \r\n\r\nThis is to   notify that your \r\n\r\nseller account expired on [date_expiry].\r\n\r\n\r\n Please renew your account to continue \r\nusing [site_name] .\r\n\r\n\r\n  You can renew your account using following link \r\n\r\n  [LINK] . \r\n\r\n\r\n\r\n \r\nWith regards, Administrator, \r\n\r\n[site_name]', '[seller_fname], [seller_lname], \r\n\r\n[date_expiry],[LINK]', 'Y');




UPDATE `multicart_email_templates` SET `vemail_body` = 'Dear Administrator , Customer [first_name] [last_name] has been requested refund with [site_name] Refund Registration Details are as follows Order Id : [order_id] Refund Id : [refund_id] Customer Name : [user_name] Seller Name : [seller_name] product name :[p_name] Reason for Return :[reason] Comments :[comments] Quantity :[quantity] Date : [date] Thank you once again for your interest in [site_name] Happy shopping.. With warm regards, Administrator, [site_name]' WHERE `vtemplate_name` = 'refund_request_reg_admin' LIMIT 1 ;

UPDATE `multicart_email_templates` SET `vtemplate_title` = 'Seller Account Approval',
`vemail_body` = 'Dear [first_name] [last_name],

Your seller account has been approved. <a href="[link]">Click here</a> or copy the url below and paste in your browser to login

[link]

Regards,

Administrator, 
[site_name]
',
`vreplaceable_variables` = '[first_name], [last_name], [site_name],[link]' WHERE `vtemplate_name` ='seller_registration_approval' LIMIT 1 ;

INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'order_statuschange_buyer', 'Order Status Change Mail To Buyer', 'Dear [first_name] [last_name], \r\n\
 Administrator has been changed your order status placed in [site_name] site. \r\n
The details are as follows. \r\n\ Order ID : [order_id] \r\n  Order status : [order_status] \r\n  Product Name : [product_name] \r\n Product Code: [product_code] \r\n Product Price : [product_price]  \r\n\r\n Product Quantity : [product_qty]  \r\n With regards, \r\n  Administrator, \r\n [site_name]', '[site_name], [order_details],[seller_first_name],[seller_last_name]', 'A');


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES (NULL, 'order_statuschange_buyer_seller', 'Order Status Change Mail To Buyer From Admin', 'Dear [first_name] [last_name], \r\n  The seller [seller_name] has changed order status of the following order placed in [site_name]. \r\n The details are as follows. \r\n Order ID : [order_id] \r\n Product Name : [product_name] \r\n Product Code: [product_code] \r\n Product Price : [product_price] \r\n Product Quantity : [product_qty] \r\n With regards,\r\n  Administrator, [site_name]', '[site_name], [order_details],[seller_first_name],[seller_last_name]', 'A');



INSERT INTO `multicart_metatags` (`nId`, `vTitle`, `vKeywords`, `vDescription`, `vPageName`) VALUES
(1, 'Multicart2.4', 'Multicart2.4', 'Multicart2.4', 'index.php'),
(2, 'Category Listing', 'Category Listing', 'Category Listing', 'categorydetail.php'),
(3, 'View Cart ', 'View Cart', 'View Cart', 'viewcart.php'),
(4, 'About Us', 'About Us', 'About Us', 'about_us.php'),
(5, 'FAQ', 'FAQ', 'FAQ', 'faq.php'),
(6, 'Site Feedback', 'Site Feedback', 'Site Feedback', 'site-feedback.php'),
(7, 'Terms and Coditions', 'Terms and Coditions', 'Terms and Coditions', 'terms_conditions.php'),
(8, 'Contact US', 'Contact US', 'Contact US', 'contact_us.php'),
(9, 'Register Now', 'Register Now', 'Register Now', 'register.php'),
(10, 'Forgot Password', 'Forgot Password', 'Forgot Password', 'forgotpassword.php');

 INSERT INTO `multicart_admin_menu` (`menu_id`, `page_name`, `link`, `parent_id`, `display_order`, `divname`, `status`) VALUES
(1, 'Home', 'index.php', 0, 1, 'Home', 'ACTIVE'),
(2, 'Settings', '', 0, 2, 'Settings', 'ACTIVE'),
(3, 'Members', '', 0, 3, 'Members', 'ACTIVE'),
(4, 'Contents', '', 0, 4, 'Contents', 'ACTIVE'),
(5, 'Approvals', '', 0, 5, 'Approvals', 'ACTIVE'),
(6, 'Categories', 'catalog.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 1, 'Product Categories', 'ACTIVE'),
(7, 'Products', 'listProducts.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 2, 'Products', 'ACTIVE'),
(8, 'Gift Certificates', 'gift_coupon.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 4, 'Gift Certificates', 'ACTIVE'),
(9, 'Orders', 'orders.php?rghtMenu=rghtMenu6&displayDiv=Finance', 67, 1, 'Orders', 'ACTIVE'),
(10, 'Payments', 'payments.php?rghtMenu=rghtMenu6&displayDiv=Finance', 67, 4, 'Payments', 'ACTIVE'),
(11, 'Refund Requests', 'refunds_requests.php?rghtMenu=rghtMenu6&displayDiv=Finance', 67, 2, 'Refund Requests', 'ACTIVE'),
(12, 'User Registration Fields', 'custom_fields.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 7, 'Custom Fields', 'ACTIVE'),
(13, 'Bulk Upload', 'bulkupload.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 5, 'Bulk Upload', 'ACTIVE'),
(14, 'Settlements', 'settleartistpayment.php?rghtMenu=rghtMenu6&displayDiv=Finance', 67, 3, 'Settlements', 'ACTIVE'),
(15, 'Bottom Banners', 'banners.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 5, 'Banners', 'ACTIVE'),
(16, 'Send Mail', '', 0, 16, 'Mail', 'ACTIVE'),
(17, 'Affiliates', '', 0, 17, 'Affiliates', 'ACTIVE'),
(18, 'Feedback', '', 0, 18, 'Feedback', 'ACTIVE'),
(19, 'Reports', 'reports.php', 0, 19, 'Reports', 'ACTIVE'),
(20, 'Product Reviews', 'product_reviews.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 6, 'Product Reviews', 'ACTIVE'),
(21, 'Newsletters', '', 0, 21, 'Newsletters', 'ACTIVE'),
(22, 'Coupon Codes', 'couponCodes.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 7, 'Coupon Codes', 'ACTIVE'),
(23, 'Seller Plans', 'sellerPlanes.php?rghtMenu=rghtMenu6&displayDiv=Finance', 67, 5, 'Seller Plans', 'ACTIVE'),
(24, 'General Settings', 'settings.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 0, 'General Settings', 'ACTIVE'),
(25, 'Shipping Settings', 'general_shipping_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 0, 'Shipping Settings', 'ACTIVE'),
(26, 'Tax Settings', 'tax_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 0, 'Tax Settings', 'ACTIVE'),
(27, 'Currency Settings', 'currency.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 0, 'Currency Settings', 'ACTIVE'),
(28, 'Users', 'users.php?rghtMenu=rghtMenu4&displayDiv=Members', 3, 0, 'Users', 'ACTIVE'),
(29, 'Sellers', 'artists.php?rghtMenu=rghtMenu4&displayDiv=Members', 3, 0, 'Sellers', 'ACTIVE'),
(30, 'Affiliates', 'affiliates.php?rghtMenu=rghtMenu4&displayDiv=Members', 3, 0, 'Affiliates', 'ACTIVE'),
(31, 'Current Style Sheet', 'templates.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 6, 'Current Style Sheet', 'ACTIVE'),
(32, 'Email Templates', 'email_templates.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 3, 'Email Templates', 'ACTIVE'),
(33, 'Page Contents', 'list_content_management.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 2, 'Page Contents', 'ACTIVE'),
(34, 'Approve Sellers', 'sellers.php?rghtMenu=rghtMenu6&displayDiv=Approvals', 5, 0, 'Approve Sellers', 'ACTIVE'),
(35, 'Approve Products', 'product_approve.php?rghtMenu=rghtMenu6&displayDiv=Approvals', 5, 0, 'Approve Products', 'ACTIVE'),
(36, 'Approve Affiliates', 'affiliates_approval.php?rghtMenu=rghtMenu6&displayDiv=Approvals', 5, 0, 'Approve Affiliates', 'ACTIVE'),
(37, 'Sellers', 'mailartists.php?rghtMenu=rghtMenu8&displayDiv=Mail', 16, 0, 'Sellers', 'ACTIVE'),
(38, 'Users', 'mailusers.php?rghtMenu=rghtMenu8&displayDiv=Mail', 16, 0, 'Users', 'ACTIVE'),
(39, 'Affiliates', 'mailaffiliates.php?rghtMenu=rghtMenu8&displayDiv=Mail', 16, 0, 'Affiliates', 'ACTIVE'),
(40, 'Affiliate Members', 'affiliates.php?rghtMenu=rghtMenu9&displayDiv=Affiliates', 17, 0, 'Affiliate Members', 'ACTIVE'),
(41, 'Affiliate Banners', 'affiliate_banner.php?rghtMenu=rghtMenu9&displayDiv=Affiliates', 17, 0, 'Affiliate Banners', 'ACTIVE'),
(42, 'Site Feedback', 'feedbacks.php?rghtMenu=rghtMenu10&displayDiv=Feedback', 18, 0, 'Site Feedback', 'ACTIVE'),
(43, 'Seller Feedback', 'artistfeedbacks.php?rghtMenu=rghtMenu10&displayDiv=Feedback', 18, 0, 'Seller Feedback', 'ACTIVE'),
(44, 'Create Newsletter', 'sendNewsletter.php?rghtMenu=rghtMenu11&displayDiv=Newsletters', 21, 0, 'Create Newsletter', 'ACTIVE'),
(45, 'Newsletter Archives', 'newsletterArchives.php?rghtMenu=rghtMenu11&displayDiv=Newsletters', 21, 0, 'Newsletter Archives', 'ACTIVE'),
(46, 'Multiple Image Upload', 'list_productview_images.php?rghtMenu=rghtMenu7', 13, 0, 'Bulk Image Upload', 'INACTIVE'),
(47, 'Bulk Product Upload', 'bulkupload.php?rghtMenu=rghtMenu7', 13, 0, 'Bulk Product Upload', 'INACTIVE'),
(48, 'Payment Settings', 'payment_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 0, 'Payment Settings', 'ACTIVE'),
(49, 'Products Viewed', 'products_viewed_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 0, 'Products Viewed', 'ACTIVE'),
(50, 'Products Purchased', 'products_purchased_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 0, 'Products Purchased', 'ACTIVE'),
(51, 'Financial Report', 'total_sales_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 0, 'Financial Report', 'ACTIVE'),
(52, 'Total Sales', 'total_sales_report.php?rghtMenu=rghtMenu4', 51, 0, 'Total Sales', 'ACTIVE'),
(53, 'Commissions', 'commission_report.php?rghtMenu=rghtMenu4', 51, 2, 'Commissions', 'ACTIVE'),
(54, 'Total Sales', 'total_sales_report.php?rghtMenu=rghtMenu4', 51, 1, 'Total Sales', 'ACTIVE'),
(56, 'Total Sales', 'total_sales_report.php?rghtMenu=rghtMenu4', 51, 0, 'Total Sales', 'ACTIVE'),
(57, 'Commissions', 'commission_report.php?rghtMenu=rghtMenu4', 51, 0, 'Commissions', 'ACTIVE'),
(58, 'Total Sales', 'total_sales_report.php?rghtMenu=rghtMenu4', 51, 1, 'Total Sales', 'ACTIVE'),
(60, 'Meta Tags Management', 'meta_tags.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 3, 'Meta Tags Management', 'ACTIVE'),
(62, 'Product Variations', 'options.php?rghtMenu=rghtMenu5&displayDiv=Product Management', 66, 3, '', 'ACTIVE'),
(63, 'Help', 'help_list.php', 0, 24, '', 'ACTIVE'),
(64, 'Home Page Banners', 'homepagebanners.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 4, 'Home Page Banners', 'ACTIVE'),
(65, 'Social Media Settings', 'social_media_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings', 2, 6, 'SocialMediaSettings', 'ACTIVE'),
(68, 'Site Logo', 'site_logo_management.php?rghtMenu=rghtMenu4&displayDiv=Contents', 4, 1, 'Page Contents', 'ACTIVE'),
(66, 'Product Management', '', 0, 5, 'Product Management', 'ACTIVE'),
(67, 'Finance', '', 0, 6, 'Finance', 'ACTIVE');



INSERT INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('admin_forgotpassword', 'Admin Forgot Password', 'Dear [name],\r\n\r\nYou have requested a password reset for your admin account with [site_name]\r\n\r\nYour updated admin account details are as follows\r\n\r\nUser Name :- [user_name]\r\nPassword :- [password]\r\n\r\nWith regards,\r\n\r\nAdministrator [site_name]', '[name], [user_name], [password], [site_name]', 'A');


INSERT INTO `multicart_help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`) VALUES
(1, 2, 'What is Multicart  Shopping Cart?', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" valign="top">\r\n				<h2 style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding:5px 0; font-weight:bold; ">\r\n					Welcome to Multicart - the low-cost, high-power web based multi access shopping cart system you can find on the web!</h2>\r\n				<p style="font-family:Arial, Helvetica, sans-serif;	font-size:12px; padding:5px 0 0 0; 	font-weight:normal; line-height:20px; ">\r\n					<strong>Multicart&nbsp; </strong>is a feature rich shopping cart system that handles multiple sellers thereby generating multiple store fronts. Multicart is compatible with any web server/operating system combo with PHP 4.x or higher installed and is built on a language and templating system that allows for complete customization into your existing site.</p>\r\n				<p style="font-family:Arial, Helvetica, sans-serif;	font-size:12px; padding:5px 0 0 0; 	font-weight:normal; line-height:20px; ">\r\n					<strong>Multicart&nbsp; </strong>is feature packed, supports an unlimited number of sellers,categories and products. Start your totally automated, trouble free, money minting ,multi store e- commerce site today using <strong>Multicart </strong>instant ecommerce kit.</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 1, '1', 'whatis_mc.png'),
(3, 2, 'Features', '<p class="heading_style1">\r\n	The {SITE_NAME} is feature packed . Check out the following features.</p>\r\n<ul class="list_style1">\r\n	<li>\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;No plug-ins / programming</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Web based administration </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Complete storefront system </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Sell virtually unlimited products </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Free manual </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;HTML knowledge not required </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Graphic design skills not required </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Related products and cross selling </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;One click featured products </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Set quantity discounts </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;On screen shopping list </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Accept real-time credit cards </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Authorize.net, PayPal or both </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Browser based email </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Sales reports </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;All orders stored in your database </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Live order tracking </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Customers can view order history </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Automated confirmation emails </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Repeat customer recognition </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Discounts and loyalty programs </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Express checkout </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Affiliate programs </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Password restricted seller entry </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Fully customizable design </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Customizable template provided </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Add shopping carts to existing sites </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;UPS Shipping</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Google Adsense</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;User Registration Custom Fields</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Multi Currency</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Digital Product Support</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Seller Rating</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Product Bulk Images Uploading</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Rss Feed</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Gift Coupon</span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Virtually unlimited main / sub categories </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Integrated store search </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Thumbnails and large image views </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;All customer&#39;s data is stored in database </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Greet repeat visitors </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Customer profiles and order history </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Real-time order tracking for customers </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Product/Bulk Discounts </span></font></li>\r\n	<li style="margin: 1.76mm 0mm; text-indent: 0mm;">\r\n		<font face="Arial"><span style="font-size: 10pt;">&nbsp;Password-protected admin access</span></font></li>\r\n</ul>\r\n<div align="left">\r\n	&nbsp;&nbsp;</div>\r\n', 2, '1', 'features.png'),
(5, 3, ' Purchase an item', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" valign="top">\r\n				<h2 style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding:5px 0; font-weight:bold;">\r\n					To Purchase an item with {SITE_NAME} do the following steps</h2>\r\n				<ul style="list-style:none; font-family:Arial, Helvetica, sans-serif; font-size:12px; line-height:25px; font-weight:bold; padding-left:10px">\r\n					<li>\r\n						1.&nbsp;<a href="help_details.php?id=6" style="text-decoration:underline; ">Select categories</a></li>\r\n					<li>\r\n						2.&nbsp;<a href="help_details.php?id=7" style="text-decoration:underline; ">Select product</a></li>\r\n					<li>\r\n						3.&nbsp;<a href="help_details.php?id=31" style="text-decoration:underline; ">View Cart</a></li>\r\n					<li>\r\n						4.&nbsp;<a href="help_details.php?id=51" style="text-decoration:underline; ">Confirm Order</a></li>\r\n					<li>\r\n						5.&nbsp;<a href="help_details.php?id=52" style="text-decoration:underline; ">Select Payment method</a></li>\r\n				</ul>\r\n				<p style="font-family:Arial, Helvetica, sans-serif;	font-size:12px; padding:5px 0 0 0; 	font-weight:normal; line-height:20px; ">\r\n					When you complete all the above steps your order will be placed in {SITE_NAME}.To view Your order go to <a href="help_details.php?id=12" style="text-decoration:underline;">Manage Orders.</a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 1, '1', 'purchase.png'),
(6, 3, 'Select Categories', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" valign="top">\r\n				<p class="text_style1">\r\n					You can select category from either on left side of the screen fig 2.1 or click &#39; Catalogue &#39; link on top menu section.Once you select category the selected category may contain either sub categories(ie Computers/Internet as main category and multimedia,softwares are sub categories) or products under the selected categories Fig 2.2Product will be displayed only in leaf level category</p>\r\n				<div class="text_style1">\r\n					&nbsp;</div>\r\n				<div align="left">\r\n					<img alt="graphic" border="0" src="../help/userhelp/selectcategoriesb1.png" /></div>\r\n				<div align="left">\r\n					&nbsp;</div>\r\n				<div align="left">\r\n					<font face="Arial"><span style="font-size: 10pt;">Fig 2.1</span></font></div>\r\n				<div align="left">\r\n					&nbsp;</div>\r\n				<div align="left">\r\n					<img alt="graphic" border="0" src="../help/userhelp/selectcategoriesb2.png" /></div>\r\n				<div align="left">\r\n					<font face="Arial"><span style="font-size: 10pt;">Fig 2.2</span></font></div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 2, '1', 'categories.png'),
(7, 3, 'Select Product', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n	</tbody>\r\n</table>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" valign="top">\r\n				<p class="text_style1">\r\n					Once You selected a leaf level category,You can select the product by click on &#39; product name &#39; link . The upcoming screen will give a brief description about the product.From this screen you can do the followings things</p>\r\n				<h2 class="heading_style1">\r\n					1.Add to cart</h2>\r\n				<p class="text_style1">\r\n					To add the selected product to your shopping cart click on &#39; Add to cart &#39; . In the ensuing screen you can change the quantity,remove selected product from your shopping cart.</p>\r\n				<p class="text_style3">\r\n					<a href="help_details.php?id=31">View shopping cart</a></p>\r\n				<h2 class="heading_style1">\r\n					2.Post feedback about seller</h2>\r\n				<p class="text_style1">\r\n					To post any feedback about the seller of your selected product click on &#39; Post feedback about seller &#39;. In the ensuing screen enter your feedback and click &#39; Post feedback &#39;.Only the logged in user can post feedback about a seller.</p>\r\n				<p class="text_style3">\r\n					<a href="help_details.php?id=8">How to register with {SITE_NAME}</a></p>\r\n				<h2 class="heading_style1">\r\n					3.Seller&#39;s portfolio</h2>\r\n				<p class="text_style1">\r\n					To view seller&#39;s portfolio click on &#39; View seller&#39;s portfolio &#39;. A new screen will open for you.There you can find brief description, such as sample products,users feedbacks,other products etc ,about the seller of your intended product.</p>\r\n				<p class="text_style1">\r\n					4.View feedbacks about seller</p>\r\n				<p class="text_style1">\r\n					To view feedbacks about the seller of your intended item click on &#39; View feedbacks about seller &#39; link. In the ensuing screen you can find all the users feedback about the seller.</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 3, '1', 'select_prdct.png'),
(143, 46, 'Log in', '<p>\r\n	To access the {SITE_NAME} Administration area, login in to the screen you view by accessing the following URL<br />\r\n	http://yoursite.com/admin (Assuming that you have installed the {SITE_NAME} at http://yoursite.com)<br />\r\n	Enter the administrator user name and password. On verifying your credentials correctly, you are logged on to the {SITE_NAME} Administration Panel</p>\r\n', 2, '1', ''),
(142, 46, 'Home', '<p>\r\n	Home Page has a dashboard which gives information to the administrator about all the activities in the {SITE_NAME} website.</p>\r\n<p>\r\n	1.Order status graph shows the percentage of orders Pending/Shipped/Delivered.</p>\r\n<p>\r\n	2.Total Sales Graph shows the total sales total every month.</p>\r\n<p>\r\n	3. Recent Orders section shows the recent orders in the website</p>\r\n<p>\r\n	4. Also there is a reminder section on approvals on the right hand side. Eg: Approve Sellers, Approve products etc..</p>\r\n<p>\r\n	5. Recent Site Feedbacks also viewable in dashboard</p>\r\n<p>\r\n	&nbsp;</p>\r\n', 1, '1', ''),
(8, 4, 'Register', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" colspan="2" valign="top">\r\n				<p class="text_style1">\r\n					Registering with {SITE_NAME} is easy and fast. Go to the registration page ( typically at http://yoursite.com/register.php ) assuming that the Shopping cart is installed at http://yoursite.com) and provide the very basic information. Registration is FREE and valid for life time.</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n<div class="fbChatMessage fsm direction_ltr" data-jsid="message" id="msg_1598645795_undefined">\r\n	&nbsp;</div>\r\n', 1, '1', 'register.png'),
(9, 4, 'Logging in ', '<table width="100%"  border="0" cellspacing="0" cellpadding="0">\r\n  <tr>\r\n    <td valign="top" align="left" colspan="2">\r\n	  <p class="text_style1">\r\n	  To access the {SITE_NAME} user area, click '' Login '' button.</br>\r\n	  Enter the user name and password. On verifying your credentials correctly, you are logged in to the {SITE_NAME} user area.\r\n	  </p>\r\n	</td>\r\n  </tr>\r\n</table>', 2, '1', 'login.png'),
(10, 4, 'Change Password ', '<table width="100%"  border="0" cellspacing="0" cellpadding="0">\r\n  <tr>\r\n    <td valign="top" align="left" colspan="2">\r\n	  <p class="text_style1">\r\n	  To change the Password, click '' My account '' link in the top menu section.In the ensuing screen click on '' change password ''\r\n	  </p>\r\n	  <p class="text_style1">\r\n	  Enter the old password in the '' Old password '' field.Enter the new password in the '' Password '' field and confirm it by retyping it in the '' Confirm Password '' field. \r\n	  Both the passwords should match and in the case the password is updated to the newly entered password. \r\n	  </p>\r\n	</td>\r\n  </tr>\r\n</table>', 3, '1', 'change_pwd.png'),
(11, 4, 'Edit Profile', '<table width="100%"  border="0" cellspacing="0" cellpadding="0">\r\n  <tr>\r\n    <td valign="top" align="left" colspan="2">\r\n	  <p class="text_style1">\r\n	  To edit profile, click on. '' My account '' link in the top menu section.In the ensuing screen click '' Edit profile '' link.Edit the details and click '' Save Changes ''\r\n	  </p>\r\n	</td>\r\n  </tr>\r\n</table>', 4, '1', 'edit_profile.png'),
(12, 4, 'Manage Orders', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" colspan="2" valign="top">\r\n				<p class="text_style1">\r\n					To manage user orders with {SITE_NAME}, click on &#39; My account &#39; button in the top header section. In the ensuing screen click on &#39; My orders &#39; link.</p>\r\n				<p class="text_style1">\r\n					The upcoming screen will display all the orders. Click on any field again the order row.You will be redirected to a new screen.Here you can view order in detail.Once the seller shipped your ordered item change the order status to delivered</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 5, '1', 'mange_ordr.png'),
(14, 5, 'Seller Rating', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" valign="top">\r\n				<p class="text_style1">\r\n					Seller rating is available under each product.Sellers can be rated as poor,good,very good and excellent.You can rate a seller only once.</p>\r\n				<div class="text_style1">\r\n					&nbsp;</div>\r\n				<div align="left">\r\n					<img alt="graphic" border="0" src="../help/userhelp/sellerratingb1.PNG" /></div>\r\n				<div align="left">\r\n					&nbsp;</div>\r\n				<div align="left">\r\n					<img alt="graphic" border="0" src="../help/userhelp/sellerratingb2.PNG" /></div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 1, '1', 'seller_rting.png'),
(15, 5, ' More Images', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" valign="top">\r\n				<p class="text_style1">\r\n					Additional images for each product is listed on the right side of the product thumb .</p>\r\n				<div class="text_style1">\r\n					&nbsp;</div>\r\n				<div align="left">\r\n					<img alt="graphic" border="0" src="../help/userhelp/moreimagesb1.PNG" /></div>\r\n				<div align="left">\r\n					&nbsp;</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 2, '1', 'mre_images.png'),
(31, 3, 'View Cart ', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" colspan="2" valign="top">\r\n				<div style="padding: 10px 0pt;">\r\n					<p class="text_style1">\r\n						You can view the cart on the left side of the screen. Select the &lsquo;View Cart&rsquo; link at the top of the menu</p>\r\n				</div>\r\n				<div>\r\n					<img alt="graphic" border="0" src="../help/userhelp/viewcart.png" /></div>\r\n				<div style="text-align: center;">\r\n					Fig 4.1</div>\r\n				<p class="text_style1">\r\n					You can delete an item from the shopping cart if you select the &lsquo;Delete Selected&rsquo; tab.<br />\r\n					You can update the quantity- just enter the desired quantity in the &lsquo;QTY&rsquo; box and select &lsquo;Update Quantities&rsquo;. If the requested quantity exceeds the available stock, your quantity will be adjusted accordingly.<br />\r\n					You can add more items to the shopping cart by selecting the &lsquo;Continue Shopping&rsquo; tab.</p>\r\n				<p class="text_style1">\r\n					Once you are ready to pay- select the &lsquo;Check out&rsquo; tab. If you are not logged in, you will then be redirected to the log in page.</p>\r\n				<p class="text_style3">\r\n					<a href="help_details.php?id=8">How to register with {SITE_NAME} Shopping Cart </a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 4, '1', 'view_cart.png'),
(50, 3, 'Shipping Options', '<table width="100%"  border="0" cellspacing="0" cellpadding="0">\r\n  <tr>\r\n    <td valign="top" align="left">\r\n	  <p class="heading_style1">\r\n	  UPS Shipping options screen\r\n	  </p>\r\n	  <div style="text-algn:left">\r\n	  <img alt="graphic" border="0" src="../help/userhelp/shippingoptionsb1.png" />\r\n	  </div>\r\n	  \r\n	</td>\r\n  </tr>\r\n</table>', 5, '1', 'shipping_option.png'),
(51, 3, 'Confirm Order', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n				<tr>\r\n			<td align="left" colspan="2" valign="top">\r\n				<p class="text_style1">\r\n					In this section you need to check your item,quantity and price.Once you are ready to pay ,enter your billing/shipping address and click on &#39; Confirm order &#39;</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', 6, '1', 'confirm_order.png'),
(52, 3, 'Payment method', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n	<tbody>\r\n		<tr>\r\n			<td align="left" colspan="2" valign="top">\r\n				<p class="text_style1">\r\n					Payment with {SITE_NAME} can be done with any of the following methods.</p>\r\n				<h2 class="heading_style1">\r\n					Authorize.net payment</h2>\r\n				<p class="text_style1">\r\n					Provide your credit card number,validation code,expiry date</p>\r\n				<h2 class="heading_style1">\r\n					Your Pay payment</h2>\r\n				<p class="text_style1">\r\n					Provide your credit card number,validation code,expiry date</p>\r\n				<h2 class="heading_style1">\r\n					Google Checkout Payment</h2>\r\n				<p class="text_style1">\r\n					Select this payment gateway you will be redirected to google checkout payment server.<br />\r\n					After you made the payment you have to contact the administrator to confirm your order</p>\r\n				<p class="text_style1">\r\n					Gift Coupon Payment</p>\r\n				<p class="text_style1">\r\n					Enter the gift coupon code received by selecting this payment method.</p>\r\n				<h2 class="heading_style1">\r\n					Paypal payment</h2>\r\n				<p class="text_style1">\r\n					When you select PayPal as your payment option, you will then be directed to the PayPal website. Here, provide your PayPal log in information. Once you confirm the payment in PayPal, don&#39;t forget to select &#39;Return to Merchant&#39; to finish your order.<br />\r\n					After you pay for the order, it will be placed in the {SITE_NAME}. To manage your order go to <a class="text_style3" href="help_details.php?id=12">Manage Orders</a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n', 7, '1', 'pymnt_mthd.png'),
(144, 47, 'General', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">The {SITE_NAME}&nbsp; has got many system level settings which can control the basic functionality of the site. You can control the following settings in this section:</span></font></p>\r\n<p>\r\n	&nbsp;</p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Change Password</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Admin can change the password fo the website here.</span></font></div>\r\n<p>\r\n	&nbsp;</p>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Licence Key</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; You need to have Multicart Licence Key here.</span></font></div>\r\n</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Site Name</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; The name of the website can be set in this section.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Site Email</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; The administrator email which will be used in many places can be set in this section.</span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Site URL</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; The site URL can be set by using this option.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Site Secure URL</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; The site secure URL can be set by using this option. If SSL is installed in server, you can use https url, else use http url. </span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Site Logo.</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; The Logo image of the website can be set in this section.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Affiliate Refferal Charge.</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Commission percentage for affiliates.</span></font></div>\r\n	<div align="left">\r\n		&nbsp;</div>\r\n	<div align="left">\r\n		<div align="left">\r\n			<div align="left">\r\n				<font face="Arial"><span style=" font-size:10pt"><b>Banner Size.</b></span></font></div>\r\n			<div align="left">\r\n				<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Commission percentage for affiliates.</span></font></div>\r\n		</div>\r\n	</div>\r\n</div>\r\n<p>\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Site Style.</b></span></font></p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; The appearance&nbsp; of the website can be set in this section.select themes from the selectbox for the site.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<p>\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Product Reviews approval.</b></span></font></p>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; This can be automatically approved or admin can approve it or vendor can approve it.</span></font></div>\r\n</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Number of Records.</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Number of records to display in pagination can be set in this section.</span></font></div>\r\n<p>\r\n	<br />\r\n	&nbsp;</p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Display More Product Images</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Check this option to display more product images.</span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Display Product Stock</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Check this option to display product stock .</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Display Banner</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Check this option to display banner on home page.</span></font></div>\r\n</div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Bulk Product Upload </b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Check this option to enable bulk product upload.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Enable Google Adsence</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Check this option to enable Google adsence.</span></font></div>\r\n	<div align="left">\r\n		&nbsp;</div>\r\n	<div align="left">\r\n		<div align="left">\r\n			<font face="Arial"><span style=" font-size:10pt"><b>Google Adsence code</b></span></font></div>\r\n		<div align="left">\r\n			<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Insert Google analytics code here.</span></font></div>\r\n		<div align="left">\r\n			&nbsp;</div>\r\n	</div>\r\n</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Enable Return Merchandize Authorization </b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style="font-size: 10pt;">&nbsp;&nbsp;&nbsp; </span></font>Check this option to enable the Return Merchandize Authorization. You can also set the Return Request Options like (Return, Refund, Repair, etc.) for the confirmation of mail messages as well.<br />\r\n	<font face="Arial"><span style=" font-size:10pt"> </span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Product Bulk Images Upload </b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Select number of image limit for bulk Upload.</span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Enable Gift Coupon Payment</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Select check box to enable gift coupon payment.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Enable Coupon code Payment</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Select check box to enable coupon payment.</span></font></div>\r\n</div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Approve Sellers</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Select an option for approve sellers. Default is Automatic.</span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Approve Affiliates</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Select an option for approve affiliates. Default is Automatic.</span></font></div>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Approve Products</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Select an option for approve products. Default is Automatic.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Enable Multiple currency</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Check this option if you want buyer to see product prices in different currencies. Administrator need to manage the multiple currency rates daily.</span></font></div>\r\n<p>\r\n	&nbsp;</p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Home page slide show delay</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Here admin can set the delay in seconds. The banner will change based on this delay.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Enable Affiliates</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Affiliates can be enabled using this feature.</span></font> Once enabled Affliates Link will appear in the top menu.</div>\r\n</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Product more image Limit</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Here we will have the maximum number of additional images needed for the product.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt"><b>Comments Box for ordering</b></span></font></div>\r\n	<div align="left">\r\n		<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; You can enable whether you need a comments box for the order.</span></font></div>\r\n	<div align="left">\r\n		&nbsp;</div>\r\n	<div align="left">\r\n		<div align="left">\r\n			<font face="Arial"><span style=" font-size:10pt"><b>Listing Fee for Products</b></span></font></div>\r\n		<div align="left">\r\n			<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; You can set listing fee for products.</span></font> If set products will be listed only if listing fee is paid.</div>\r\n	</div>\r\n	<div align="left">\r\n		&nbsp;</div>\r\n</div>\r\n', 1, '1', ''),
(145, 47, 'Shipping', '<p>\r\n	<b>Shipping Settings</b></p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">{SITE_NAME} support different shipping methods. It supports realtime shipping cost calculators and tracking for many carriers including UPS, FEDEX, US Postal Service, Canada Post, and Australian Post. It also supports a simple flat fee shipping rate method. If no other shipping is supported , flat free will be the default option. </span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<strong><font face="Arial"><span style="font-size: 10pt;">Flat rates</span></font></strong></div>\r\n<div align="left">\r\n	Admin can add different flat rate options and its rates which can be overriden by the sellers in seller section.</div>\r\n<br />\r\n<p>\r\n	<b>Fedex Shipping</b></p>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Fedex Requires Real Account from Fedex Shipment Service to provide realtime shipping info to your clients. You can get a free web tools account from https://www.fedex.com/us/OADR/index.html. once you have the account activated enter the Fedex Account Number below to activate Fedex Shipping realtime pricing and tracking. When your site goes live make sure to enable the product server by Selecting &quot;Production Server&quot; . </span></font></div>\r\n<br />\r\n<p>\r\n	<b>USPS Shipping</b></p>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">USPS Requires Web Tools account from US Postal Service to provide realtime shipping info to your clients. You can get a free web tools account from https://secure.shippingapis.com/registration/ . once you have the account activated enter the Web Tools User ID below to activate USPS realtime pricing and tracking. When your site goes live make sure to enable the product server by selecting &quot;Production Server &quot;. </span></font></div>\r\n<br />\r\n<p>\r\n	<b>Canada Post Shipping</b></p>\r\n<br />\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Canada Post Requires Account from Canada Post Shipment Service to provide realtime shipping info to your clients. You can get a free web tools account from http://sellonline.canadapost.ca/ . once you have the account activated enter the Merchant Id below to activate Canada Post Shipping realtime pricing and tracking. When your site goes live make sure to enable the product server by selecting &quot;Production Server &quot;. </span></font></div>\r\n', 2, '1', ''),
(146, 47, 'Tax ', '<div>\r\n	<font face="Arial"><span style=" font-size:10pt">General Settings </span></font></div>\r\n<p>\r\n	<font face="Arial"><span style=" font-size:10pt">There are 3 tax options</span></font></p>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">1) I don&#39;t want to apply tax to any products in my store. </span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">2) I want to apply tax for specific countries and/or states. </span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">3) I want to apply one tax rate to all products in my store .</span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">Select any option from the list above.</span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">If you select ‘I don’t want to apply tax to any products in my store’ no tax will be applied in your \r\n\r\nstore.</span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">If you select ‘I want to apply tax for specific states and/or countries’ then it will apply the tax for the states or \r\n\r\ncountries you choose. </span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">If you select ‘I want to apply one tax rate to all products in my store’ then it will apply a single tax rate for all \r\n\r\nproducts in the store. </span></font></div>\r\n<br />\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">Tax Options - </span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">Here we can view all the taxes. You can add sales tax or VAT using these options and make it applicable to selected \r\n\r\ncountries or states. </span></font></div>\r\n<br />\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">Add Tax Rate - </span></font></div>\r\n<div>\r\n	<font face="Arial"><span style=" font-size:10pt">Here we can add taxes </span></font></div>\r\n', 3, '1', ''),
(147, 47, 'Currency', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">{SITE_NAME} supports different currency types.The currencies can be defined in the admin side.To access the menu click on the tab &quot;currency&quot;.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">The screen display the defined currency types.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Click on &quot;Currency Add&quot; to display the currency adding screen.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><u>Currency Adding</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Enter the currency name,currency code,currency symbol and exchange price.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. Click on &quot;Add&quot; to finish.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. &quot;Currency Added Successfully&quot; message is received.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. <u>Currency Editing Section</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To edit the currency go through the steps from 1 to 5</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img alt="graphic" border="0" height="13" src="../help/adminhelp/currencytypesb1.PNG" width="18" /></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. You will get access to &quot;Currency Editing Screen&quot;.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. Enter the details in the corresponding boxes.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">4. Click on &quot;Update&quot; button once you entered all the details.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">5. You will receive a &quot;Currency Details Updated Successfully&quot; message </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; and you will be redirected to currency listing screen.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. <u>Currency Deleting Section</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To delete the currency follow the steps from 1 to 4</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img alt="graphic" border="0" height="13" src="../help/adminhelp/currencytypesb2.PNG" width="15" /></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. You will get a delete confirmation message.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. Deleting does not remove the record from the database permanently.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">4. You can undelete the same record by clicking on the same icon. </span></font></div>\r\n', 4, '1', ''),
(148, 47, 'Payment', '<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Payment gateway details</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style="font-size: 10pt;">The payment gateway for {SITE_NAME} is set in this section. You can utilize Authorize.net, Google Checkout, World Pay, Your Pay, and PayPal payment gateways for the cart. Select the Payment gateway to enable it for the shopping cart. Once it is enabled, apply the settings for the payment gateways explained below: </span></font></div>\r\n<br />\r\n	<br />\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Setting for Authorize.net.</b><br />\r\n	To utilize the Authorize.net gateway for payment processing you must create a merchant account first. To activate the Authorize.net gateway, just enter your Authorize.net Log In and Transaction key. You can create a transaction key at the Authorize.net account page. Please make sure to enable it as ‘Live’ when you are ready to make your site ‘Live’. <br />\r\n	<br />\r\n	<b>Settings For Worldpay</b><br />\r\n	When you enable Worldpay, you need to access your account from http://worldpay.com, then set the return page in your site. After the payment process is over, in the Worldpay Merchant Panel log in to your WorldPay Customer Management System- then select Configuration Options. \r\n1)Enter the callback URL as http://yoursitename/worldpay_callback.php\r\n2) Select the checkboxes for Callback Enabled and Use Callback Response\r\n3)Set your Callback Password to match exactly with the Callback Password you set in {SITE_NAME}- please note that you need to enter this in 2 boxes\r\n4) Select the Save Changes option\r\n5) Select Enable WorldPay option.\r\nThen, set the WorldPay Installation ID, Test Mode, Email Address, and Transaction Method\r\n<br />\r\n	<br />\r\n	<b>Settings for Paypal</b><br />\r\n	When you enable PayPal, you need to set the return page in your site after the PayPal payment process is finished. Here are the details to set up Auto Return:\r\n1) Select the Profile tab\r\n2) Select the Website Payment Preferences link under Setting Preferences\r\n3) Select the ‘On’ radio button to enable Auto Return\r\n4) Enter the return URL address\r\n5) If the return URL address is a success it should appear like this: http://yoursitename.com/success.php\r\n<br />	\r\n	<br />\r\n	<b>Settings for Google Checkout</b><br />\r\n	To set up a Google Checkout Account-\r\n1) Add the Google Merchant ID and Merchant Key- you will receive this from the “GoogleCheckout Merchant Panel’’. Here, you can navigate as follows:\r\n2) Select My Sales->Settings->Integration\r\n </span></font>\r\n ', 5, '1', ''),
(149, 47, 'Social Media', '<p>\r\n	Admin can add Twitter or facebook Links which will appear as icons on home page</p>\r\n', 6, '1', ''),
(217, 66, 'Affiliate Banners', '<p>\r\n	Banners are uploaded from the admin side. The uploaded banners are resized. The banner size is specified in the site settings. For each banner, the banner display count shows number of banner views.</p>\r\n<p>\r\n	This screen will display the number of banners which are added for affiliates. Browse the banners and select the &lsquo;Update Button&rsquo;. If the images are added a message will display that says &lsquo;Added Successfully&rsquo;.</p>\r\n', 2, '1', NULL),
(150, 48, 'Users ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">To manage users registered with {SITE_NAME} Shopping Cart, click on &#39;&nbsp; Users &#39;&nbsp; link under members menu section.The upcoming screen will display all the users registered with {SITE_NAME} Shopping Cart.</span></font></p>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To edit the user profile follow these simple steps:<br />\r\n	1. Select the log in name.<br />\r\n	2. In the next screen, edit the details and select ‘Save Changes’.<br />\r\n	3. To change the password- enter the new password and select ‘Reset Password’<br />\r\n	4. If you want to be notified when your password changes- select the ‘Notify by email’ option and a message with the password information will be sent to you directly.  </span></font></div>\r\n', 1, '1', '');
INSERT INTO `multicart_help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`) VALUES
(151, 48, 'Sellers', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">To manage sellers registered with {SITE_NAME}, click on &#39;&nbsp; Sellers &#39;&nbsp; link under Members menu section.The upcoming screen will display all the sellers registered with {SITE_NAME}.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Click on the login name&nbsp; against the seller. In the ensuing screen you can do the following things</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Update seller profile</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Edit the&nbsp; details about the seller and click &#39; Save changes &#39;</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Change password</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Type the new password in &#39; New Password &#39;&nbsp; field and click&nbsp; &#39; Reset Password &#39;.An email message will be send to the seller along with new password if &#39; Notify by email &#39; is checked.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Change seller commission</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">By default the seller commission will be the value given in site settings .You can change the commission for a selected seller in this section.This will override the default seller commission for the selected seller.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">View feedbacks</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">By clicking on this link you will be redirected to a new screen.The feedback about the seller can be viewed and managed&nbsp; from this screen.To publish the feedback about the&nbsp; seller click on &#39; feedback content &#39; against the feedback.In the ensuing screen check the &#39; Published &#39; field and click on &#39; save changes &#39;. click &#39; delete &#39; if you want to delete&nbsp; selected feedback.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">View/edit seller&#39;s portfolio</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">By clicking on this link you will be redirected to a new screen.The seller portfolio can be viewed and managed from this screen.Edit the details about seller&nbsp; and click &#39; Save Changes &#39;.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; </span></font></div>\r\n', 2, '1', ''),
(152, 48, 'Affiliates', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">To manage affiliates registered with the {SITE_NAME}, just select ‘Affiliates’ under the Members menu. The upcoming screen will display all of the affiliates registered with the site.  </span></font></p>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Click on the login name&nbsp; against the seller. In the ensuing screen you can do the following things</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Update affiliate profile</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Edit the&nbsp; affiliate details and click &#39; Save changes &#39;</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Change password</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Type the new password in &#39; New Password&nbsp; &#39; field and click&nbsp; &#39; Reset Password &#39;.An email message will be send to the seller along with new password if &#39; Notify by email &#39; is checked.</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; Settle affiliate registration</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">When you select this link you will then be directed to a new screen. All of the unsettled affiliated registration payments can be viewed and managed from this screen. To settle an affiliated registration payment, just select the row you want to settle and select ‘Settle Selected’. In the next screen, select ‘Settle Now’. </span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; View all affiliate registration</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">By clicking on this link you will be redirected to a new screen.To settle all the pending&nbsp; affiliated registration&nbsp;&nbsp; click on&nbsp; &#39; Settle pending registration &#39;</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; View/Edit Affiliate Payments</span></font></div>\r\n\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">By clicking on this link you will be redirected to a new screen.All the settled affiliate payments can be viewed and managed from this screen.To edit payment details such as payment method,date etc click on the &#39; Affiliate Name &#39; against the payment row.In ensuing screen edit the details and click &#39; save changes &#39;</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n\r\n', 3, '1', ''),
(153, 49, 'Current Style Sheet ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">To access the templates screen follow the steps</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on &quot;Current Style Under Contents &quot; link</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. Displays the currently activated template.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>Template Editing Section</b></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Accessible by clicking on </span></font>edit<font face="Arial"><span style=" font-size:10pt"> icon</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. The template name and css file content can be edited in this section</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. You can restore the original css content by clicking on </span></font>restore<font face="Arial"><span style=" font-size:10pt"> icon.</span></font></div>\r\n', 1, '1', ''),
(154, 49, 'Email Templates ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">The mail content in {SITE_NAME} can be formatted with the help of these Email Templates.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. To edit the templates click on the edit icon.&nbsp;</span></font><font face="Arial"><span style=" font-size:10pt"> </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. When finished, select the &#39;update&#39; button to save the changes to the database. </span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n', 2, '1', ''),
(155, 49, 'Page Contents ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">The home page,Contact US,Terms and Conditions,About US content can be customized with the help of a Content Management Editor integrated in this section.</span></font></p>\r\n', 3, '1', ''),
(156, 49, 'Meta Tags Management ', '<p>\r\n	This section can be used to assign Meta Tags to each page in the website.</p>\r\n', 4, '1', ''),
(157, 49, 'Home Page Banners', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">Banner Management consists of the following sections.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>1. Banner Adding Section.</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>2. Banner Editing Section.</b></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><b>3. Banner Deleting Section.</b></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To access banner management section click on the tab &quot;Banners&quot;.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. <u>Banner Adding Section</u></span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To add a new banner follow the instructions given below</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">a. Click on the tab &quot;Banners&quot;.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">b. A screen is displayed with all the banners added.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">c. Click on &quot;Add Banner&quot;</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">d. You will get the &quot;Banner Adding&quot; screen.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">e. Enter the banner name,banner location url and browse the banner image.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">f. Click on the button &quot;Add&quot;.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">g. If banner is added successfully you will get a message &quot;Banner Added Successfully Message&quot;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp; and you will be redirected to banner listing screen.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp; </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Banners are uploaded from the admin side. The uploaded banners are resized. The banner size is specified in the site settings. For each banner, the banner display count shows number of banner views.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. <u>Banner Editing Section</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To edit a banner go through the steps from 1 to 5</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on the edit icon </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. You will get access to &quot;Banner Editing Screen&quot;.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. Enter the details in the corresponding boxes.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">4. Click on &quot;Update&quot; button once you entered all the details.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">5. You will receive a &quot;Banner Details Updated Successfully&quot; message </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; and you will be redirected to banner listing screen.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. <u>Banner Deleting Section</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To delete a banner follow the steps from 1 to 4</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on the delete icon </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. You will get a delete confirmation message.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. Deleting does not remove the record from the database permanently.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">4. You can undelete the same record by clicking on the same icon. </span></font></div>\r\n', 5, '1', ''),
(158, 50, 'Sellers ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">This screen will list all of the sellers. The admin can approve sellers when they select the status link. An alert will appear asking the admin if they want to approve the sellers or not. When you select &#39;Yes&#39; it will approve the seller, obviously &#39;No&#39; will not. There is an option to automatically approve all new sellers, it is located in the main settings. </span> </font></p>\r\n', 1, '1', ''),
(159, 50, 'Affiliates', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">This screen will list all affiliates and admin can approve affiliates by clicking status link, it will ask an alert whether you want to approve affiliates or not. By clicking &#39;Yes&#39; will approve an affiliate and NO will take no action . </span> </font></p>\r\n', 3, '1', ''),
(160, 50, 'Products', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">This screen will list all of the products. The admin can decide either to approve or deny the selections. If the admin wants to approve a product they must select the &#39;Yes&#39; tab. The &#39;No&#39; tab obviously does not approve any product. The admin can also feature the products when they select the &#39;Featured&#39; link. </span> </font></p>\r\n', 2, '1', ''),
(161, 51, 'Product Variations', '<p>\r\n	Here you have define all the options which can be assigned to categories. Once options are assigned to the leaf category products assigned under the category can have multiple options.</p>\r\n<p>\r\n	Eg: Color, Size etc</p>\r\n', 3, '1', ''),
(162, 51, 'Categories', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">To manage category/product with {SITE_NAME}, click on &#39;&nbsp; Catalog &#39;&nbsp; link in the top menu section.The upcoming screen will display all the categories.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">The administrator can&nbsp; add&nbsp; products under different categories. These categories are created and maintained by the administrator of the site.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Managing Categories</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To add a new category,&nbsp; Enter a unique Category Name, category image and click on &#39; Add New Category &#39;. If the category name you entered was unique, the new category is added to the category list.</span></font> Also when adding a leaf level category you can assign any options.</div>\r\n<div align="left">\r\n	Eg: if the category is Shirt you can assign option Size to this category.</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To edit a category, click the &#39; Edit &#39; link against the category . A new screen opens where you can edit the details of the selected category. Click on &#39; Save Changes &#39; to update your changes.To delete&nbsp; a category, Click on &#39; Delete &#39;.Please make sure that you have deleted all the product under the category you wish to delete&nbsp; before deleting category.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n', 1, '1', ''),
(163, 51, 'Manage Products', '<p>\r\n	After you have created the appropriate categories, you can now start to add the products under each one. Just select the category you want to place the product under. Once you select a leaf level category, enter the fields in the bottom part of the screen. Then select &lsquo;Add Product&rsquo;. Please note that you can add product(s) only to the leaf level categories.</p>\r\n<p>\r\n	To edit a product, just select the category under it appears. The middle of the screen will display all of the products and their corresponding categories.</p>\r\n<p>\r\n	1. Select the &lsquo;Product Name&rsquo;</p>\r\n<p>\r\n	2. Edit the details and select &lsquo;Save Changes&rsquo;</p>\r\n<p>\r\n	3. To delete a product, select &lsquo;Delete&rsquo;</p>\r\n<p>\r\n	As a word of caution, please make sure that you delete only the products you want to. This option is irreversible.</p>\r\n', 2, '1', ''),
(164, 51, 'Gift Certificates', '<p>\r\n	<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></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Gift Certificate Management Screen can be accessed by following the instructions given below.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on &quot;Gift Coupon&quot; tab.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. Displays a screen which lists the created gift coupons.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. Click on &quot;Gift Coupon Add&quot; displays the gift coupon adding screen.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><u>Gift Certificate Adding Screen</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Enter the coupon name,code,description,image,amount and seller.</span></font></div>\r\n<div align="left">\r\n	<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></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. &quot;Gift Certificate&nbsp; Added Successfully&quot; message is received and the screen displays the newly created gift certificate.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt"><u>Gift Certificate Editing Screen</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img alt="graphic" border="0" height="13" src="../help/adminhelp/giftcouponb1.PNG" width="18" /></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. You will get access to &quot;Gift Certificate Editing Screen&quot;.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. Enter the details in the corresponding boxes.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">4. Click on &quot;Update&quot; button once you entered all the details.</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">5. You will receive a &quot;Gift Certificate Details Updated Successfully&quot; message </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; and you will be redirected to gift coupons listing screen.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">3. <u>Gift Certificate Deleting Screen</u></span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To delete the Gift Coupon follow the steps from 1 to 2</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">1. Click on the icon </span></font><img alt="graphic" border="0" height="13" src="../help/adminhelp/giftcouponb2.PNG" width="15" /></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">2. You will get a delete confirmation message.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n', 4, '1', ''),
(165, 52, 'Orders', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">To manage orders&nbsp; with {SITE_NAME}, click on &#39;&nbsp; Orders &#39;&nbsp; link in the top menu section.The upcoming screen will display all the orders.</span></font></p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To view/edit&nbsp; order detail click on &#39; User Name &#39; link&nbsp; against the order.In the ensuing screen you can view order in&nbsp; detail.Here you can change the order status to delivered,shipped [click to view order status] etc.</span></font></div>\r\n', 1, '1', ''),
(166, 52, 'Payments', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">The seller payments with Multicart can be viewed and managed from this section.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	Manage Seller Payments<br />\r\n	To settle the seller payments, select the &lsquo;Settle Seller Payments&rsquo; link in the Settlements menu. The next screen will show all of the pending seller payments (when the admin/user changes the status of the ordered item to delivered (click here to view the order status).<br />\r\n	To settle payments- select the payment row you want to settle and check &lsquo;Settle Payments&rsquo;. In the following screen the actual amount (amount after commission) is displayed. Then, select &lsquo;Make Payment&rsquo;.<br />\r\n	When the payment is successful, the intended row will be removed from the pending seller payments.</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	Manage Payments</div>\r\n<div align="left">\r\n	<p>\r\n		The seller payments with MultiCart Shopping Cart appear here. Now, it can be viewed and managed from this section.</p>\r\n	<p>\r\n		The settle seller payments, just select the &lsquo;Settle Payments&rsquo; tab in the Settlements menu section. ADD: The software will list payments due to sellers and you can make payments to sellers based on the agreement with the sellers using offline payment methods. Once it is finished, select the &lsquo;Make Payment&rsquo;.</p>\r\n</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">View Payments</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">Click &#39; View payments &#39; on the top menu section. All the settled seller payments can be&nbsp; viewed and managed from this section.To edit details such as payment method,date etc click &#39; Seller Name &#39; against the payment row.In the ensuing screen edit the details and click &#39; Save changes &#39;.</span></font></div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	&nbsp;</div>\r\n', 2, '1', ''),
(167, 52, 'Refund Requests', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">This section lists all of the Refund Requests from Customers</span></font></p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">The admin can view all refund requests from customers. You can also receive a refund request confirmation email from the customers. *make sure this is correct*.</span></font></div>\r\n', 3, '1', ''),
(168, 52, 'Settlements', '<p>\r\n	Admin can select multiple orders of a seller and click settle which will take you to a confirm page with the total amount to be settled and there will be a button called Make Payment. Clicking this will settle the order.</p>\r\n<p>\r\n	But the process is still not complete. You need to go to payments and can see those payments which are settled as pending. Here you need to update how u paid and payment date etc and complete the process.</p>\r\n', 4, '1', ''),
(169, 53, 'Sellers ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">Administrator with {SITE_NAME} can send email to all sellers registered with the site.To send email click &#39; Mail sellers &#39; under the Mail menu in the screen.In the upcoming screen ,select the seller from the list ,enter subject,enter email content and click&nbsp; &#39; Send mail &#39;.</span></font></p>\r\n', 1, '1', ''),
(0, 53, 'Affiliates ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">Administrator with {SITE_NAME} can send email to all affiliates registered with the site.To send email click &#39; Mail Affiliates &#39; under the Mail menu in the screen.In the upcoming screen ,select the seller from the list ,enter subject,enter email content and click&nbsp; &#39; Send mail &#39;.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n', 3, '1', ''),
(171, 52, 'Seller Plans', '<p>\r\n	Here admin can define the different seller plans. If seller plans is enabled in General settings then when the seller register they will be asked to choose one of the plans and pay the plan to register. Admin can also add Free plan.</p>\r\n', 5, '1', ''),
(172, 51, 'Product Reviews', '<p>\r\n	Reviews posted by buyers on products will be listed in this section.</p>\r\n', 6, '1', ''),
(174, 54, 'Site Feedback', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">The user feedback about the&nbsp; {SITE_NAME} Shopping Cart can be viewed and managed from this section.Click on &#39; View feedbacks &#39; link in the top menu section.To publish feedback click &#39; Feedback &#39; link&nbsp; against the feedback row .In the ensuing screen check &#39; Published? &#39; and click &#39; Save changes &#39;.To delete feedback click &#39; delete &#39;</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">To view user feedback about&nbsp; a seller go to&nbsp; Manage Seller</span></font></div>\r\n', 1, '1', ''),
(175, 54, 'Seller Feedback', '<p>\r\n	Buyers can send feedbacks about the sellers which will appear in this section</p>\r\n', 2, '1', ''),
(176, 55, 'Products Viewed ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">This report shows the number of times each product is viewed from the admin </span></font></p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; side.</span></font></div>\r\n', 1, '1', ''),
(177, 55, 'Products Purchased ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">Report displays the number of times each product purchased.</span></font></p>\r\n<div align="left">\r\n	&nbsp;</div>\r\n', 2, '1', ''),
(178, 55, 'Financial Report ', '<p>\r\n	<font face="Arial"><span style=" font-size:10pt">a. Total Sales Report - This report displays the total product sales in the site.The report can be &nbsp;&nbsp;</span></font></p>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taken order wise and date wise.There is provision for this report to be &nbsp;&nbsp;</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; printing.&nbsp;&nbsp;&nbsp;&nbsp; </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp;&nbsp;</span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp; b. Commission Report - Displays the seller commission.The report can be taken seller wise as </span></font></div>\r\n<div align="left">\r\n	<font face="Arial"><span style=" font-size:10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; well as date wise&nbsp; </span></font></div>\r\n', 3, '1', ''),
(210, 53, 'Users', '<p>\r\n	Here admin can send mail to any users/Buyers of the website who have registered in our website.</p>\r\n', NULL, NULL, NULL),
(211, 51, 'Bulk Upload', '<p>\r\n	Admin can use this option to upload multiple products. Sample CSV is available in this section. Download it and fill your products and upload products. Small image, big image and more image options need to be urls. ie the images need to be uploaded to a server and the links need to be given in the csv. Ideally the images need to be uploaded in the same server.</p>\r\n', 5, NULL, NULL),
(179, 56, 'Registration', 'Registering as seller with {SITE_NAME} is easy and fast. Go to the seller registration page (typically at http://yoursite.com/sellers/register.php assuming that the Shopping Cart is installed at http://yoursite.com) and provide the very basic information. Registration is FREE and valid for life time.\r\n', 1, '1', ''),
(180, 56, 'Login', 'To access the {SITE_NAME} seller area, login in the address given below: \r\nhttp://yoursite.com/seller/login.php(Assuming that you have installed the {SITE_NAME} in http://yoursite.com \r\nEnter the user name and password. On verifying your credentials correctly, you are logged in to the {SITE_NAME} Seller Panel.', 1, '1', ''),
(181, 57, 'My Profile', 'To edit the profile select- ''My Profile'' at the top of the seller menu. Edit the details and select ''Save Changes''. \r\n\r\nTo change the password- select ''Change Pass'' at the top of the seller menu. 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.\r\n\r\nBoth of the passwords should match. Then, the old password will update itself to then new one. \r\n\r\nThe 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.\r\n', 1, '1', ''),
(182, 58, 'My Plans', '<p>\r\n	This will show sellers current plan. This will show only if admin enable seller plans.</p>\r\n', 1, '1', ''),
(183, 58, 'Gift Certificates', '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 "Coupon" and typing the gift code received in the checkout page.\r\n\r\n\r\nGift Coupon Management Screen can be accessed by following the instructions given below. \r\n1. Click on "Gift Coupon" tab. \r\n2. Displays a screen which lists the created gift coupons. \r\n3. Click on "Gift Coupon Add" displays the gift coupon adding screen. \r\n\r\n\r\nGift Coupon Adding Screen \r\n1. Enter the coupon name,code,description,image,amount and seller. \r\n2. Once all the required details are filled click on "Add" to create a new gift coupon. \r\n3. "Gift Coupon Added Successfully" message is received and the screen displays the newly created gift coupon. \r\n\r\n\r\nGift Coupon Editing Screen \r\n1. Click on the icon \r\n2. You will get access to "Gift Coupon Editing Screen". \r\n3. Enter the details in the corresponding boxes. \r\n4. Click on "Update" button once you entered all the details. \r\n5. You will receive a "Gift Coupon Details Updated Successfully" message \r\nand you will be redirected to gift coupons listing screen.\r\n\r\n3. Gift Coupon Deleting Screen \r\nTo delete the Gift Coupon follow the steps from 1 to 4 \r\n1. Click on the icon \r\n2. You will get a delete confirmation message. \r\n3. Deleting does not remove the record from the database permanently. \r\n4. You can undelete the same record by clicking on the same icon. ', 1, '1', ''),
(184, 57, 'Portfolio', '<p>\r\n	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 &#39;My Portfolio&#39; link on top of the seller menu. Then, select &#39;Save Changes&#39; in the following screen.</p>\r\n', 1, '1', ''),
(199, 56, 'Reset My Password', '<p>\r\n	If seller forgot the password then he can reset his/her password with this option. The seller need to enter his/her email when registered to reset. If the email is correct password will be reset and send to the email of the seller.</p>\r\n', 1, '1', ''),
(200, 63, 'Home', 'The Affiliate program is a partnership program with {SITE_NAME}. Members get to earn a percentage of the order rate purchased by the referred user at {SITE_NAME}.\r\n\r\nAnyone can become an affiliate of {SITE_NAME}.You don''t even need to have a website to join.You can refer your friends to {SITE_NAME} through email or other means.', 1, '1', ''),
(201, 63, 'Login', '<p>\r\n	<img alt="" src="../help/affiliatehelp/login.png" style="height: 300px; width: 600px; " /></p>\r\n', 1, '1', ''),
(202, 63, 'Registration', '<p>\r\n	Registering with {SITE_NAME} as an affiliate is easy and fast. Go to the registration page (typically at http://yoursite.com/affiliates/register.php assuming that the Mulicart is installed at http://yoursite.com) and provide the very basic information. Registration is FREE and valid for life time.</p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/reg.png" style="cursor: default; width: 700px; height: 544px; " /></p>\r\n', 1, '1', ''),
(185, 57, 'Change Password', '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.\r\n\r\nBoth of the passwords should match. Then, the old password will update itself to then new one. ', 1, '1', ''),
(186, 59, 'Manage Products', '<p>\r\n	You 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 &lsquo;Add Product&rsquo;. Note, you can add products only to the leaf level categories.<br />\r\n	To edit a product- select the category-&gt;&rsquo;Product Name&rsquo;-&gt;then in the following screen you can edit the details. When you are finished, select &lsquo;Save Changes&rsquo;.<br />\r\n	To delete a product- select &lsquo;Delete&rsquo;. Keep in mind, please make sure that you are deleting the correct product because this action is irreversible.</p>\r\n', 1, '1', ''),
(187, 59, 'My Products', 'You 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''. Note, you can add products only to the leaf level categories. \r\n\r\nTo 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''.\r\n\r\nTo delete a product- select ''Delete''. Keep in mind, please make sure that you are deleting the correct product because this action is irreversible. \r\n  ', 1, '1', ''),
(188, 59, 'Bulk Product Upload', 'You can add bulk product using this facility (If Admin is activated bulk uploading feature in admin settings only).This menu is accessible by clicking on the tab "Bulk Product Upload ".\r\n\r\nUpload Product CSV File .\r\n\r\n 1. Click on "Bulk Product Upload. "\r\n 2. Product bulk upload screen is displayed.\r\n 3. Browse a CSV file . (You can upload CSV files only.).\r\n 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) Click Here to view Categories in Cart.\r\n 5. After Browsing a CSV file Click on "Next" button.\r\n 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.\r\n 7. After Mapping with corresponding filelds click on "Next" Button.\r\n 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.\r\n 9. If Products are saved successfully click on button "Continue with Bulk Image Upload".\r\n ', 1, '1', ''),
(189, 60, 'Shipping Settings', '<p>\r\n	Here seller can define his/her own shipping flat rate options. Buyers can choose these options and buy items.</p>\r\n', 1, '1', ''),
(212, 49, 'User Registration Fields', '<p>\r\n	Admin can add more fields to user registration form to gather more information.</p>\r\n', NULL, NULL, NULL),
(213, 51, 'Coupon Codes', '<p>\r\n	Admin can create coupon codes with discounts and send to selected users. Users can use this coupon code to buy items with discount.</p>\r\n', 8, '1', NULL),
(214, 65, 'Create Newsletter', '<p>\r\n	Admin can create newsletter and send to all the users who have suscribed to newsletters while registering.</p>\r\n', 1, '1', NULL),
(215, 65, 'Newsletter Archive', '<p>\r\n	All the newsletters send so far will be listed in this section</p>\r\n', 2, '1', NULL),
(216, 66, 'Affiliate Members', '<p>\r\n	All members who are registered as affiliates will be listed here.</p>\r\n', 1, '1', NULL),
(190, 58, 'Orders', '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. \r\n\r\nTo 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. ', 1, '1', ''),
(191, 58, 'Refund Requests', '<p>\r\n	Sellers can see all the refund requests from buyers and make appropriate action by clicking on change status link against each refund request. Seller can choose whether to refund,repair or replace..</p>\r\n', 1, '1', ''),
(192, 61, 'Email Templates', 'The mail content sent to customers can be customized in this section. ', 1, '1', ''),
(193, 58, 'Manage Payment', '<p>\r\n	After the delivery is completed you can request a form for payment. Select the &lsquo;Request for Payment&rsquo; 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 &lsquo;Request for Payment&rsquo;.</p>\r\n', 1, '1', ''),
(194, 58, 'Request for Payment Approved', '<p>\r\n	Once the payment has been settled it will come in approved payments area.</p>\r\n', 1, '1', ''),
(195, 58, 'Payment History', '<p>\r\n	In order to view the payment details of your orders, select the &lsquo;Payment History&rsquo; 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.<br />\r\n	To view an order in detail select the &lsquo;Order&rsquo; link next to the settled payment row.<br />\r\n	To view payments in detail such as the payment date, select the &lsquo;Seller name&rsquo; next to the settled payment row.<br />\r\n	&nbsp;</p>\r\n', 1, '1', ''),
(196, 59, 'Product Reviews', '<p>\r\n	Here all the reviews made by buyers will be listed. Sellers can approve these reviews and those will be listed.</p>\r\n', 1, '1', ''),
(197, 62, 'Email to Administrator', '<p>\r\n	The&nbsp; sellers can send&nbsp; an email to the administrator of the marketplace. To send an email, select the &lsquo;Mail Admin&rsquo; at the top of the menu. In the following screen, enter the email subject, email content, and then select &lsquo;Send Mail&rsquo;.</p>\r\n', 1, '1', ''),
(198, 62, 'My Messages', '<p>\r\n	This page will show the messages from the users</p>\r\n', 1, '1', ''),
(203, 64, 'My Profile', '<p>\r\n	After you have logged in {SITE_NAME} as an affiliate, if you want to change your profile or password you can find the details of doing it in the next few sections. Edit Profile Click on &#39; My profile &#39; in the top menu section.In the ensuing screen edit the profile and click &#39; Save changes &#39;.</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/editprofile.png" style="width: 700px; height: 532px; " /></p>\r\n', 1, '1', ''),
(204, 64, 'Change Password', '<p>\r\n	Click on &#39; Change pass &#39; in top menu section.In ensuring screen Enter the old password in the &#39; Old password &#39; field.Enter the new password in the &#39; Password &#39; field and confirm it by retyping it in the &#39; Confirm Password &#39; field. Both the passwords should match and in the case the your password is updated to the newly entered password.</p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/changepassword.png" style="width: 700px; height: 261px; " /></p>\r\n', 1, '1', ''),
(205, 64, 'Payment History', '<p>\r\n	The details of settled payment so far can be viewed by going to &#39;Payment History&#39; in top affiliate menu section. In the ensuing screen you can view payment deatils such as amount paid,date.To view payment in detail click on &#39; Seller Name&#39; against the settled payment row. in the upcoming screen you can view payment date,mode,date of payment etc.</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/payments.png" style="width: 700px; height: 200px; " /></p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/paymentdetail.png" style="width: 700px; height: 251px; " /></p>\r\n', 1, '1', ''),
(206, 64, 'Registration', '<p>\r\n	To view all the users referred by you click &#39; Registrations &#39; on top affiliate menu section.In the ensuing screen you can view the referred users along with their purchase amount,referral charge etc.The users will be listed only when they purchase with {SITE_NAME}.</p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/user_regs.png" style="width: 700px; height: 169px; " /></p>\r\n', 1, '1', ''),
(207, 64, 'Mail Administrator', '<p>\r\n	Affiliate registered with {SITE_NAME} can send email to administrator with the site.To send email click &#39; Mail admin &#39; on the top part of the screen.In the upcoming screen ,enter subject,enter email content and click &#39; Send mail &#39;</p>\r\n<p>\r\n	<img alt="" src="../help/affiliatehelp/mailadmin.png" style="width: 700px; height: 321px; " /></p>\r\n', 1, '1', ''),
(208, 64, 'Get Urls To Publish', '<p>\r\n	<img alt="" src="../help/affiliatehelp/urltopublish.png" style="width: 700px; height: 562px; " /></p>\r\n', 1, '1', ''),
(209, 63, 'Forgot Password', '<p>\r\n	<img alt="" src="../help/affiliatehelp/forgotpwd.png" style="width: 700px; height: 235px; " /></p>\r\n', 1, '1', '');


INSERT INTO `multicart_helpcategory` (`hcid`, `htype`, `hctitle`, `hcposition`, `active`) VALUES
(2, 'client', 'Introduction', 1, '1'),
(3, 'client', 'Purchase Product ', 2, '1'),
(4, 'client', 'User Area', 3, '1'),
(5, 'client', 'Products', 4, '1'),
(46, 'admin', 'Introduction', 1, '1'),
(47, 'admin', 'Settings', 2, '1'),
(48, 'admin', 'Members', 3, '1'),
(49, 'admin', 'Contents', 4, '1'),
(50, 'admin', 'Approvals', 5, '1'),
(51, 'admin', 'Product management', 6, '1'),
(52, 'admin', 'Finance', 7, '1'),
(53, 'admin', 'Send Mail', 8, '1'),
(54, 'admin', 'Feedback', 10, '1'),
(55, 'admin', 'Reports', 11, '1'),
(56, 'seller', 'Introduction', 1, '1'),
(57, 'seller', 'Profile', 2, '1'),
(58, 'seller', 'Finance', 3, '1'),
(59, 'seller', 'Product management', 4, '1'),
(60, 'seller', 'Settings', 5, '1'),
(61, 'seller', 'Contents', 6, '1'),
(62, 'seller', 'Contacts', 7, '1'),
(63, 'affiliate', 'Introduction', 1, '1'),
(64, 'affiliate', 'Affiliate area', 1, '1'),
(65, 'admin', 'Newsletters', 12, '1'),
(66, 'admin', 'Affiliate', 9, '1');

INSERT INTO `multicart_metatags` (`nId`, `vTitle`, `vKeywords`, `vDescription`, `vPageName`) VALUES
(1, 'Multicart2.4', 'Multicart2.4', 'Multicart2.4', 'index.php'),
(2, 'Category Listing', 'Category Listing', 'Category Listing', 'categorydetail.php'),
(3, 'View Cart ', 'View Cart', 'View Cart', 'viewcart.php'),
(4, 'About Us', 'About Us', 'About Us', 'about_us.php'),
(5, 'FAQ', 'FAQ', 'FAQ', 'faq.php'),
(6, 'Site Feedback', 'Site Feedback', 'Site Feedback', 'site-feedback.php'),
(7, 'Terms and Coditions', 'Terms and Coditions', 'Terms and Coditions', 'terms_conditions.php'),
(8, 'Contact Us - Shopping Mall', 'Contact Us - Shopping Mall', 'Contact Us - Shopping Mall', 'contact_us.php'),
(9, 'Register Now', 'Register Now', 'Register Now', 'register.php'),
(10, 'Forgot Password', 'Forgot Password', 'Forgot Password', 'forgotpassword.php');


INSERT INTO `multicart_social_media` (`social_media_id`, `name`, `title`, `link`, `logo`, `active`) VALUES
(1, 'twitter', 'Twitter', 'http://www.twitter.com/multicart', 'twitter.jpg', 'N'),
(2, 'facebook', 'Facebook', 'http://www.facebook.com/multicart', 'facebook.jpg', 'N');



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');

