--
-- Host: localhost    Database: clients_subtraces
-- ------------------------------------------------------


--
-- Table structure for table `multicart_Review`
--

CREATE TABLE `multicart_Review` (
  `nRId` int(11) NOT NULL AUTO_INCREMENT,
  `nUserId` int(11) NOT NULL DEFAULT '0',
  `nProdId` int(11) NOT NULL DEFAULT '0',
  `vDes` text NOT NULL,
  `vActive` enum('0','1') NOT NULL DEFAULT '0',
  `seller_viewed_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nRId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_Review`
--


--
-- Table structure for table `multicart_admin_menu`
--

CREATE TABLE `multicart_admin_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(200) NOT NULL DEFAULT '',
  `title` text NOT NULL,
  `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 AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_admin_menu`
--

INSERT INTO `multicart_admin_menu` VALUES (1,'Home','LEFT_MENU_HOME','index.php',0,1,'Home','ACTIVE'),(2,'Settings','LEFT_MENU_SETTING','',0,2,'Settings','ACTIVE'),(3,'Members','LEFT_MENU_MEMBERS','',0,3,'Members','ACTIVE'),(4,'Contents','LEFT_MENU_CONTENTS','',0,4,'Contents','ACTIVE'),(5,'Approvals','LEFT_MENU_APPROVALS','',0,5,'Approvals','INACTIVE'),(6,'Categories','LEFT_MENU_CATEGORIES','catalog.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,1,'Product Categories','ACTIVE'),(7,'Products','LEFT_MENU_PRODUCTS','listProducts.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,2,'Products','ACTIVE'),(8,'Gift Certificates','LEFT_MENU_GIFT_CERTIFICATES','gift_coupon.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,4,'Gift Certificates','ACTIVE'),(9,'Orders','LEFT_MENU_ORDERS','orders.php?rghtMenu=rghtMenu6&displayDiv=Finance',67,1,'Orders','ACTIVE'),(10,'Payments','LEFT_MENU_PAYMENTS','payments.php?rghtMenu=rghtMenu6&displayDiv=Finance',67,4,'Payments','ACTIVE'),(11,'Refund Requests','LEFT_MENU_REFUND_REQUESTS','refunds_requests.php?rghtMenu=rghtMenu6&displayDiv=Finance',67,2,'Refund Requests','INACTIVE'),(12,'User Registration Fields','LEFT_MENU_USER_REGISTRATION_FIELDS','custom_fields.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,7,'Custom Fields','INACTIVE'),(13,'Bulk Upload','LEFT_MENU_BULK_UPLOAD','bulkupload.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,5,'Bulk Upload','INACTIVE'),(14,'Settlements','LEFT_MENU_SETTLEMENTS','settleartistpayment.php?rghtMenu=rghtMenu6&displayDiv=Finance',67,3,'Settlements','ACTIVE'),(15,'Bottom Banners','LEFT_MENU_BOTTOM_BANNERS','banners.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,5,'Banners','INACTIVE'),(16,'Send Mail','LEFT_MENU_SEND_MAIL','',0,16,'Mail','ACTIVE'),(17,'Affiliates','LEFT_MENU_AFFILIATES','',0,17,'Affiliates','INACTIVE'),(18,'Feedback','LEFT_MENU_FEEDBACK','',0,18,'Feedback','INACTIVE'),(19,'Reports','LEFT_MENU_REPORTS','reports.php',0,19,'Reports','ACTIVE'),(20,'Product Reviews','LEFT_MENU_PRODUCT_REVIEWS','product_reviews.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,6,'Product Reviews','INACTIVE'),(21,'Newsletters','LEFT_MENU_NEWSLETTERS','',0,21,'Newsletters','ACTIVE'),(22,'Coupon Codes','LEFT_MENU_COUPON_CODES','couponCodes.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,7,'Coupon Codes','ACTIVE'),(23,'Seller Plans','LEFT_MENU_SELLER_PLANS','sellerPlanes.php?rghtMenu=rghtMenu6&displayDiv=Finance',67,5,'Seller Plans','ACTIVE'),(24,'General Settings','LEFT_MENU_GENERAL_SETTINGS','settings.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,0,'General Settings','ACTIVE'),(25,'Shipping Settings','LEFT_MENU_SHIPPING_SETTINGS','general_shipping_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,0,'Shipping Settings','INACTIVE'),(26,'Tax Settings','LEFT_MENU_TAX_SETTINGS','tax_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,0,'Tax Settings','INACTIVE'),(27,'Currency Settings','LEFT_MENU_CURRENCY_SETTINGS','currency.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,0,'Currency Settings','INACTIVE'),(28,'Users','LEFT_MENU_USERS','users.php?rghtMenu=rghtMenu4&displayDiv=Members',3,0,'Users','ACTIVE'),(29,'Sellers','LEFT_MENU_SELLERS','artists.php?rghtMenu=rghtMenu4&displayDiv=Members',3,0,'Sellers','INACTIVE'),(30,'Affiliates','LEFT_MENU_AFFILIATES','affiliates.php?rghtMenu=rghtMenu4&displayDiv=Members',3,0,'Affiliates','INACTIVE'),(31,'Current Style Sheet','LEFT_MENU_CURRENT_STYLE_SHEET','templates.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,6,'Current Style Sheet','INACTIVE'),(32,'Email Templates','LEFT_MENU_EMAIL_TEMPLATES','email_templates.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,3,'Email Templates','ACTIVE'),(33,'Page Contents','LEFT_MENU_PAGE_CONTENTS','list_content_management.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,2,'Page Contents','ACTIVE'),(34,'Approve Sellers','LEFT_MENU_APPROVE_SELLERS','sellers.php?rghtMenu=rghtMenu6&displayDiv=Approvals',5,0,'Approve Sellers','ACTIVE'),(35,'Approve Products','LEFT_MENU_APPROVE_PRODUCTS','product_approve.php?rghtMenu=rghtMenu6&displayDiv=Approvals',5,0,'Approve Products','INACTIVE'),(36,'Approve Affiliates','LEFT_MENU_APPROVE_AFFILIATES','affiliates_approval.php?rghtMenu=rghtMenu6&displayDiv=Approvals',5,0,'Approve Affiliates','ACTIVE'),(37,'Sellers','LEFT_MENU_SELLERS','mailartists.php?rghtMenu=rghtMenu8&displayDiv=Mail',16,0,'Sellers','INACTIVE'),(38,'Users','LEFT_MENU_USERS','mailusers.php?rghtMenu=rghtMenu8&displayDiv=Mail',16,0,'Users','INACTIVE'),(39,'Affiliates','LEFT_MENU_AFFILIATES','mailaffiliates.php?rghtMenu=rghtMenu8&displayDiv=Mail',16,0,'Affiliates','INACTIVE'),(40,'Affiliate Members','LEFT_MENU_AFFILIATE_MEMBERS','affiliates.php?rghtMenu=rghtMenu9&displayDiv=Affiliates',17,0,'Affiliate Members','ACTIVE'),(41,'Affiliate Banners','LEFT_MENU_AFFILIATE_BANNERS','affiliate_banner.php?rghtMenu=rghtMenu9&displayDiv=Affiliates',17,0,'Affiliate Banners','ACTIVE'),(42,'Site Feedback','LEFT_MENU_SITE_FEEDBACK','feedbacks.php?rghtMenu=rghtMenu10&displayDiv=Feedback',18,0,'Site Feedback','ACTIVE'),(43,'Seller Feedback','LEFT_MENU_SELLER_FEEDBACK','artistfeedbacks.php?rghtMenu=rghtMenu10&displayDiv=Feedback',18,0,'Seller Feedback','ACTIVE'),(44,'Create Newsletter','LEFT_MENU_CREATE_NEWSLETTER','sendNewsletter.php?rghtMenu=rghtMenu11&displayDiv=Newsletters',21,0,'Create Newsletter','ACTIVE'),(45,'Newsletter Archives','LEFT_MENU_NEWSLETTER_ARCHIVES','newsletterArchives.php?rghtMenu=rghtMenu11&displayDiv=Newsletters',21,0,'Newsletter Archives','ACTIVE'),(46,'Multiple Image Upload','LEFT_MENU_MULTIPLE_IMAGE_UPLOAD','list_productview_images.php?rghtMenu=rghtMenu7',13,0,'Bulk Image Upload','INACTIVE'),(47,'Bulk Product Upload','LEFT_MENU_BULK_PRODUCT_UPLOAD','bulkupload.php?rghtMenu=rghtMenu7',13,0,'Bulk Product Upload','INACTIVE'),(48,'Payment Settings','LEFT_MENU_PAYMENT_SETTINGS','payment_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,0,'Payment Settings','ACTIVE'),(49,'Products Viewed','LEFT_MENU_PRODUCTS_VIEWED','products_viewed_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Products Viewed','INACTIVE'),(50,'Products Purchased','LEFT_MENU_PRODUCTS_PURCHASED','products_purchased_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Products Purchased','INACTIVE'),(51,'Financial Report','LEFT_MENU_FINANCIAL_REPORT','total_sales_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Financial Report','INACTIVE'),(52,'Total Sales','LEFT_MENU_TOTAL_SALES','total_sales_report.php?rghtMenu=rghtMenu4',51,0,'Total Sales','INACTIVE'),(53,'Commissions','LEFT_MENU_COMMISIONS','commission_report.php?rghtMenu=rghtMenu4',51,2,'Commissions','ACTIVE'),(54,'Total Sales','LEFT_MENU_TOTAL_SALES','total_sales_report.php?rghtMenu=rghtMenu4',51,1,'Total Sales','INACTIVE'),(56,'Total Sales','LEFT_MENU_TOTAL_SALES','total_sales_report.php?rghtMenu=rghtMenu4',51,0,'Total Sales','INACTIVE'),(57,'Commissions','LEFT_MENU_COMMISIONS','commission_report.php?rghtMenu=rghtMenu4',51,0,'Commissions','ACTIVE'),(58,'Total Sales','LEFT_MENU_TOTAL_SALES','total_sales_report.php?rghtMenu=rghtMenu4',51,1,'Total Sales','INACTIVE'),(60,'Meta Tags Management','LEFT_MENU_METATAG_MANAGEMENT','meta_tags.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,3,'Meta Tags Management','ACTIVE'),(62,'Product Variations','LEFT_MENU_PRODUCT_VARIATIONS','options.php?rghtMenu=rghtMenu5&displayDiv=Product Management',66,3,'','ACTIVE'),(63,'Help','LEFT_MENU_HELP','help_list.php',0,24,'','INACTIVE'),(64,'Home Page Banners','LEFT_MENU_HOME_PAGE_BANNERS','homepagebanners.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,4,'Home Page Banners','ACTIVE'),(65,'Social Media Settings','LEFT_MENU_SOCIAL_MEDIA_SETTINGS','social_media_settings.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,6,'SocialMediaSettings','ACTIVE'),(68,'Site Logo','LEFT_MENU_SITE_LOGO','site_logo_management.php?rghtMenu=rghtMenu4&displayDiv=Contents',4,1,'Page Contents','ACTIVE'),(66,'Product Management','LEFT_MENU_PRODUCT_MANAGEMENT','',0,5,'Product Management','INACTIVE'),(67,'Finance','LEFT_MENU_FINANCE','',0,6,'Finance','INACTIVE'),(69,'Seller Registrar Help','LEFT_MENU_SELLER_HELP','help_list.php?q=seller',0,25,'SellerHelp','INACTIVE'),(70,'Language Settings','LEFT_MENU_LANGUAGE_SETTINGS','language.php?rghtMenu=rghtMenu1&displayDiv=Settings',2,0,'Language Settings','INACTIVE'),(71,'User IP Address','LEFT_MENU_USER_IP_ADDRESS','user_ip_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'User Ip Address','ACTIVE'),(72,'Blocked IP Address','LEFT_MENU_BLOCKED_IP','blockedip.php?rightMenu=rghtMenu4',0,0,'','INACTIVE'),(73,'Seller IP Address','LEFT_MENU_SELLER_IP_ADDRESS','seller_ip_report.php?\r\n\r\nrghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Seller Ip Address','INACTIVE'),(74,'Referral Report ','LEFT_MENU_REFERRAL_REPORT','referral_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Referral Report','INACTIVE'),(75,'Category-wise Sales Report ','LEFT_MENU_CATEGORY_SALES_REPORT','category_sale_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Category-wise Sales Report','INACTIVE'),(76,'Seller Report ','LEFT_MENU_SELLER_REPORT','seller_report.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,0,'Seller Report','INACTIVE'),(77,'Track Management','LEFT_MENU_TRACK_MANAGEMENT','',0,5,'Track Management','ACTIVE'),(78,'Track Albums','LEFT_MENU_TRACK_CATEGORIES','trackcatalog.php?rghtMenu=rghtMenu6&displayDiv=Track Management',77,1,'Track Categories','ACTIVE'),(81,'Bulk Track Upload','LEFT_MENU_BULKTRACK_UPLOAD','bulkuploadtrack.php?rghtMenu=rghtMenu5&displayDiv=Track Management',77,5,'Bulk Track Upload','ACTIVE'),(79,'Tracks','LEFT_MENU_TRACKS','listTracks.php?rghtMenu=rghtMenu6&displayDiv=Track Management',77,2,'Tracks','ACTIVE'),(80,'Artist Plans','LEFT_MENU_ARTIST_PLANS','artistPlanes.php?rghtMenu=rghtMenu6&displayDiv=Finance',0,6,'Artist Plans','ACTIVE'),(82,'Genre','LEFT_MENU_GENRE','genre.php?rghtMenu=rghtMenu5&displayDiv=Track Management',77,6,'Genre','ACTIVE'),(83,'Artist Packages','LEFT_MENU_ARTIST_PACKAGES','artistPackages.php?rghtMenu=rghtMenu6&displayDiv=Finance',0,7,'Artist Packages','ACTIVE'),(84,'Mail Box','LEFT_MENU_MAIL_BOX','mymails.php?rghtMenu=rghtMenu8&displayDiv=Mail',16,0,'Mailbox','ACTIVE'),(85,'Subscription List','LEFT_MENU_SUBSCRIPTION_LIST','plan_subscription_list.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,1,'Subscription List','ACTIVE'),(86,'Track Download List','LEFT_MENU_DOWNLOAD_LIST','track_download_list.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,2,'Track Download List','ACTIVE'),(87,'Credit Buy List','LEFT_MENU_CREDIT_BUY_LIST','credit_buy_list.php?rghtMenu=rghtMenu4&displayDiv=Reports',19,3,'Credit Buy List','ACTIVE');

--
-- Table structure for table `multicart_affiliate_banner`
--

CREATE TABLE `multicart_affiliate_banner` (
  `naff_banner_id` int(11) NOT NULL AUTO_INCREMENT,
  `vaff_banner_name` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`naff_banner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_affiliate_banner`
--

INSERT INTO `multicart_affiliate_banner` VALUES (1,'affiliate_banner1.jpg'),(2,'affiliate_banner2.jpg'),(3,'affiliate_banner3.jpg'),(4,'affiliate_banner4.jpg'),(5,'affiliate_banner5.jpg'),(6,'affiliate_banner6.jpg'),(7,'affiliate_banner7.jpg'),(8,'affiliate_banner8.jpg'),(9,'affiliate_banner9.jpg'),(10,'affiliate_banner10.jpg');

--
-- Table structure for table `multicart_affiliate_payments`
--

CREATE TABLE `multicart_affiliate_payments` (
  `affiliate_payment_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `affiliate_id` bigint(20) DEFAULT NULL,
  `order_id` int(11) NOT NULL,
  `amount_paid` double DEFAULT NULL,
  `date_marked_for_payment` date DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `comments` text,
  PRIMARY KEY (`affiliate_payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_affiliate_payments`
--


--
-- Table structure for table `multicart_affiliate_registrations`
--

CREATE TABLE `multicart_affiliate_registrations` (
  `registration_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vaffiliate_currency` varchar(10) NOT NULL DEFAULT '',
  `affiliate_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `order_id` int(11) NOT NULL,
  `user_name` varchar(100) DEFAULT NULL,
  `user_first_name` varchar(100) DEFAULT NULL,
  `user_last_name` varchar(100) DEFAULT NULL,
  `user_email` varchar(100) DEFAULT NULL,
  `referral_charge` double DEFAULT NULL,
  `registration_date` date DEFAULT NULL COMMENT 'its Order date ',
  `affiliate_payment_id` bigint(20) DEFAULT NULL,
  `user_totalpurchasedamount` double DEFAULT NULL,
  PRIMARY KEY (`registration_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_affiliate_registrations`
--


--
-- Table structure for table `multicart_affiliates`
--

CREATE TABLE `multicart_affiliates` (
  `affiliate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `affiliate_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `address1` varchar(100) DEFAULT NULL,
  `address2` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `fax` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `taxid` varchar(100) DEFAULT NULL,
  `date_registered` date DEFAULT NULL,
  `deleted` char(1) DEFAULT 'N',
  `vapproved` char(2) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`affiliate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_affiliates`
--


--
-- Table structure for table `multicart_artist_devices`
--

CREATE TABLE `multicart_artist_devices` (
  `artist_device_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `artist_id` bigint(20) NOT NULL DEFAULT '0',
  `device_id` varchar(255) NOT NULL DEFAULT '0',
  `device_type` varchar(255) NOT NULL DEFAULT '0',
  `date_added` datetime DEFAULT NULL,
  `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`artist_device_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `multicart_artist_devices`
--


--
-- Table structure for table `multicart_artist_feedbacks`
--

CREATE TABLE `multicart_artist_feedbacks` (
  `artist_feedback_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `feedback_content` text,
  `rating` smallint(6) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `artist_id` bigint(20) DEFAULT NULL,
  `date_added` date DEFAULT NULL,
  `published` char(1) DEFAULT 'N',
  PRIMARY KEY (`artist_feedback_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_artist_feedbacks`
--


--
-- Table structure for table `multicart_artist_payments`
--

CREATE TABLE `multicart_artist_payments` (
  `artist_payment_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `artist_id` bigint(20) DEFAULT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `commission_percentage` double DEFAULT NULL,
  `seller_order_total_amount` double NOT NULL DEFAULT '0',
  `admin_commision_amount` double NOT NULL DEFAULT '0',
  `total_amount` double DEFAULT NULL,
  `amount_paid` double DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `comments` text,
  `date_marked_for_payment` date DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_status` enum('P','C') NOT NULL DEFAULT 'P',
  `seller_viewed_status` tinyint(1) NOT NULL DEFAULT '0',
  `discount_amount` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`artist_payment_id`),
  KEY `order_id` (`order_id`),
  KEY `payment_status` (`payment_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_artist_payments`
--


--
-- Table structure for table `multicart_artist_portfolios`
--

CREATE TABLE `multicart_artist_portfolios` (
  `artist_portfolio_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `artist_id` int(11) DEFAULT NULL,
  `artist_description` text,
  `artist_photo` varchar(200) DEFAULT NULL,
  `artist_sample_work_1` varchar(200) DEFAULT NULL,
  `artist_sample_work_2` varchar(200) DEFAULT NULL,
  `artist_sample_work_3` varchar(200) DEFAULT NULL,
  `artist_sample_work_4` varchar(200) DEFAULT NULL,
  `artist_sample_work_5` varchar(200) DEFAULT NULL,
  `artist_sample_work_6` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`artist_portfolio_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_artist_portfolios`
--


--
-- Table structure for table `multicart_artists`
--

CREATE TABLE `multicart_artists` (
  `artist_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `artist_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `address1` varchar(100) DEFAULT NULL,
  `address2` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `fax` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `storename` text,
  `portfolio` text,
  `commission` double DEFAULT NULL,
  `taxid` varchar(100) DEFAULT NULL,
  `vseller_currency` varchar(50) NOT NULL DEFAULT '',
  `date_registered` date DEFAULT NULL,
  `company` varchar(50) DEFAULT NULL,
  `website` varchar(30) DEFAULT NULL,
  `deleted` char(1) DEFAULT 'N',
  `vapproved` char(2) NOT NULL DEFAULT 'N',
  `defaultflatrate` float NOT NULL DEFAULT '0',
  `additionalflatrate` float NOT NULL DEFAULT '0',
  `sellerPlanID` int(11) NOT NULL DEFAULT '0',
  `enablepaypal` char(1) NOT NULL DEFAULT '',
  `enablepaypalsandbox` char(1) NOT NULL DEFAULT '',
  `paypalidentitytoken` varchar(200) NOT NULL DEFAULT '',
  `paypalemail` varchar(100) NOT NULL DEFAULT '',
  `plan_expired` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Whether \r\n\r\nplan expired or not',
  `theme_color` varchar(50) NOT NULL,
  `theme_banner` varchar(50) NOT NULL,
  `theme_numrows` varchar(255) NOT NULL,
  `theme_numcols` int(10) NOT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `is_vacation_mode` enum('Y','N') DEFAULT 'N' COMMENT 'check vacation mode is activated or not',
  `seller_time_zone` varchar(100) DEFAULT NULL COMMENT 'Seller time zone used for publish later feature',
  `ip_address` varchar(100) DEFAULT NULL COMMENT 'ip address of user',
  `ip_location` varchar(255) DEFAULT NULL COMMENT 'country , state,city',
  PRIMARY KEY (`artist_id`),
  KEY `seller_index` (`vapproved`,`deleted`),
  KEY `date_register` (`date_registered`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_artists`
--

INSERT INTO `multicart_artists` VALUES (1,'remya','e10adc3949ba59abbe56e057f20f883e','armia','a','cochin','','cochin','Kerala','IN','682023','8157806265','8157806265','remya.m@armiasystems.com','remya',NULL,0,NULL,'','2017-06-20','armia','','N','Y',10,5,0,'','','','remya.m@armiasystems.com','N','','','',0,NULL,'N','Africa/Casablanca',NULL,NULL);

--
-- Table structure for table `multicart_artists_membershipDetails`
--

CREATE TABLE `multicart_artists_membershipDetails` (
  `artist_memID` int(11) NOT NULL AUTO_INCREMENT,
  `artist_id` int(11) NOT NULL DEFAULT '0',
  `artist_memStartDate` date NOT NULL DEFAULT '0000-00-00',
  `artist_memEndDate` date NOT NULL DEFAULT '0000-00-00',
  `plan_Id` int(11) NOT NULL DEFAULT '0',
  `plan_SubscriptionCharge` double NOT NULL DEFAULT '0',
  `transaction_id` varchar(255) NOT NULL,
  PRIMARY KEY (`artist_memID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_artists_membershipDetails`
--


--
-- Table structure for table `multicart_banners`
--

CREATE TABLE `multicart_banners` (
  `nbanner_id` int(11) NOT NULL AUTO_INCREMENT,
  `vbanner_name` varchar(50) NOT NULL DEFAULT '',
  `vbanner_locurl` varchar(250) NOT NULL DEFAULT '',
  `vbanner_image` varchar(50) NOT NULL DEFAULT '',
  `dbanner_date` date NOT NULL DEFAULT '0000-00-00',
  `nbanner_display_count` int(11) NOT NULL DEFAULT '0',
  `vbannerdelete_status` char(1) NOT NULL DEFAULT '',
  `cdn_images_moved` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`nbanner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_banners`
--


--
-- Table structure for table `multicart_buycredit`
--

CREATE TABLE `multicart_buycredit` (
  `b_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(11) DEFAULT NULL,
  `charge_amount` bigint(20) DEFAULT NULL,
  `card_id` varchar(200) DEFAULT NULL,
  `charge_id` varchar(200) DEFAULT NULL,
  `credited_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`b_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `multicart_buycredit`
--

INSERT INTO `multicart_buycredit` VALUES (1,6,100,'card_1AhWsFFwqclwylo5hpY8MM40','ch_1AhWsGFwqclwylo5ZaekTecr','2017-07-20 05:01:10'),(2,6,500,'card_1AhWuSFwqclwylo5Av2NzQm8','ch_1AhWuVFwqclwylo505Q7Vc4o','2017-07-20 05:03:29'),(3,1,100,'card_1AhtGXFwqclwylo537QhXyTM','ch_1AhtGYFwqclwylo5p6fa47Z7','2017-07-21 04:55:42'),(4,9,100,'card_1AhuxNFwqclwylo5YhrQRx7j','ch_1AhuxOFwqclwylo5WHNlam1N','2017-07-21 06:44:02'),(5,9,20,'card_1Ahv1UFwqclwylo5lKjWurFf','ch_1Ahv1WFwqclwylo528V8AQoi','2017-07-21 06:48:18'),(6,2,500,'card_1AhzQvFwqclwylo5RiCivsTB','ch_1AhzQyFwqclwylo5UamDlEjO','2017-07-21 11:30:52'),(7,2,500,'card_1AhztjFwqclwylo5EYRMfuAZ','ch_1AhztlFwqclwylo5r6BsIEX7','2017-07-21 12:00:36'),(8,11,10,'card_1Aj3yjFwqclwylo5RU14oZJ2','ch_1Aj3ykFwqclwylo5EWlJ0frt','2017-07-24 10:34:05'),(9,11,100,'card_1Aj3zeFwqclwylo5ouW7OvkH','ch_1Aj3zgFwqclwylo5qg2XoBl4','2017-07-24 10:35:02'),(10,9,500,'card_1Ajkr8Fwqclwylo503YyZwqA','ch_1Ajkr9Fwqclwylo5zELWKh9v','2017-07-26 08:21:02'),(11,6,10,'card_1AtFJdFwqclwylo5IGWLXpVt','ch_1AtFJeFwqclwylo5WMrlPnBa','2017-08-21 12:40:57'),(12,22,20,'card_1B4l56Fwqclwylo5UyqBWkUO','ch_1B4l58Fwqclwylo5Zu8hVdoZ','2017-09-22 06:48:35'),(13,22,20,'card_1B4lKHFwqclwylo5EaOzUV6S','ch_1B4lKIFwqclwylo5tszTvXYl','2017-09-22 07:04:15'),(14,23,20,'card_1B4nlVFwqclwylo5BOu2o1Qu','ch_1B4nlaFwqclwylo53McIRyzj','2017-09-22 09:40:35'),(15,22,100,'card_1B5qraFwqclwylo5sbPB5oC9','ch_1B5qrcFwqclwylo5R1FLGPr8','2017-09-25 07:11:03'),(16,22,100,'card_1B5qsIFwqclwylo5wF0DYaEo','ch_1B5qsJFwqclwylo5RzT8IVZb','2017-09-25 07:11:46'),(17,28,100,'card_1B5tHEFwqclwylo5B8ChwiNm','ch_1B5tHFFwqclwylo5MAjUmZEb','2017-09-25 09:45:40'),(18,28,100,'card_1B5tHiFwqclwylo5CdAj41W4','ch_1B5tHjFwqclwylo5KF5Nkq23','2017-09-25 09:46:10'),(19,22,20,'card_1B60hhFwqclwylo5BcLoqsWh','ch_1B60hjFwqclwylo5nwLPFIiy','2017-09-25 17:41:29'),(20,1,20,'card_1B6F0GFwqclwylo5zY3yKyuR','ch_1B6F0IFwqclwylo5dc0l9rQR','2017-09-26 08:57:35'),(21,1,100,'card_1B6F9HFwqclwylo5vXTo6DRu','ch_1B6F9IFwqclwylo53IBWBC2X','2017-09-26 09:06:54'),(22,1,20,'card_1B6eGCFwqclwylo5Z5RXJnMF','ch_1B6eGEFwqclwylo5HIGs7wzA','2017-09-27 11:55:41'),(23,1,20,'card_1B6eKdFwqclwylo5f5hgtmPJ','ch_1B6eKeFwqclwylo537mhhX46','2017-09-27 12:00:15'),(24,1,100,'card_1B6eS3Fwqclwylo5MqXFkoW8','ch_1B6eS4Fwqclwylo55UVp9Dhu','2017-09-27 12:07:55'),(25,1,100,'card_1B6eUEFwqclwylo52jL9qL71','ch_1B6eUFFwqclwylo539tYMxQ1','2017-09-27 12:10:10'),(26,39,150,'card_1B9rxjFwqclwylo57yONoEWI','ch_1B9rxmFwqclwylo5Iqb9BXq2','2017-10-06 09:09:41'),(27,23,20,'card_1BAubuFwqclwylo5QenOtn8n','ch_1BAubwFwqclwylo56ZkckQt2','2017-10-09 06:11:22'),(28,23,100,'card_1BAv2gFwqclwylo57i7VL41i','ch_1BAv2hFwqclwylo56QRqV4QW','2017-10-09 06:39:01');

--
-- Table structure for table `multicart_cart`
--

CREATE TABLE `multicart_cart` (
  `cart_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(11) DEFAULT NULL,
  `visitor_cart_id` varchar(40) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `product_option_id` bigint(20) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `datetime_added` varchar(20) DEFAULT NULL,
  `digital_product_flag` enum('Y','N') DEFAULT 'N',
  `gift_product_flag` enum('Y','N') DEFAULT 'N',
  `seller_id` int(11) DEFAULT NULL,
  `subscription_flag` enum('Y','N') DEFAULT 'N' COMMENT 'store subscription status of a product',
  `subscription_duration` int(11) DEFAULT NULL,
  PRIMARY KEY (`cart_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_cart`
--


--
-- Table structure for table `multicart_cart_temp`
--

CREATE TABLE `multicart_cart_temp` (
  `ncart_temp_id` int(11) NOT NULL AUTO_INCREMENT,
  `ncart_id` int(11) NOT NULL DEFAULT '0',
  `ncart_quantity` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ncart_temp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_cart_temp`
--


--
-- Table structure for table `multicart_categories`
--

CREATE TABLE `multicart_categories` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(100) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `route` varchar(100) DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  `gift_certificate_flag` char(1) NOT NULL DEFAULT '',
  `avatar` varchar(250) NOT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `cdn_images_moved` enum('Y','N') DEFAULT 'N',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_categories`
--

INSERT INTO `multicart_categories` VALUES (1,'Old School cat2',0,NULL,16,'Y','','giftcertificate','N'),(2,'Old School cat1',0,'2',2,'','avatar_large1497956793_Old-School-Vibes.jpg','old-school-vibes','N');

--
-- Table structure for table `multicart_category_options`
--

CREATE TABLE `multicart_category_options` (
  `category_option_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) NOT NULL,
  `option_id` bigint(20) NOT NULL,
  PRIMARY KEY (`category_option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_category_options`
--


--
-- Table structure for table `multicart_content_management`
--

CREATE TABLE `multicart_content_management` (
  `content_id` int(11) NOT NULL AUTO_INCREMENT,
  `content_name` varchar(25) NOT NULL DEFAULT '',
  `content_heading` text NOT NULL,
  `content_text` text NOT NULL,
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_content_management`
--

INSERT INTO `multicart_content_management` VALUES (1,'home_page','<p>Non-exclusive rights</p>\r\n','<p><strong>Register Now and Get it </strong><br />\r\n<strong>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</strong></p>\r\n'),(2,'terms_conditions','Terms and Conditions','Welcome to our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use, which together with our privacy policy govern [business name]\'s relationship with you in relation to this website. The term \"[business name]\" or \"us\" or \"we\" refers to the owner of the website whose registered office is [address]. Our company registration number is [company registration number and place of registration]. The term \"you\" refers to the user or viewer of our website. The use of this website is subject to the following terms of use: * The content of the pages of this website is for your general information and use only. It is subject to change without notice. * Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law. * Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific requirements. * This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions. * All trademarks reproduced in this website which are not the property of, or licensed to, the operator are acknowledged on the website. * Unauthorised use of this website may give rise to a claim for damages and/or be a criminal offence. * From time to time this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s). * You may not create a link to this website from another website or document without [business name]\'s prior written consent.'),(3,'about_us','<p>About Us</p>\r\n\r\n<p>&nbsp;</p>\r\n','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla id arcu id orci luctus feugiat sed in dolor. Proin et aliquam enim. Quisque accumsan arcu at magna lobortis volutpat. Duis lobortis tincidunt cursus. Mauris fringilla laoreet metus non tincidunt. Nulla elementum, justo ac dapibus cursus, dui ligula ultricies lorem, vel blandit tortor ipsum ac nulla. Maecenas pulvinar pretium laoreet. Integer sed massa eget mauris vehicula porta. Nam tincidunt tortor sit amet orci imperdiet mollis. Sed eu leo lorem, et lacinia ipsum.<br />\r\nAt vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat<br />\r\n&quot;On the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain. These cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammelled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains.&quot;</p>\r\n\r\n<p>&quot;Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?&quot;</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>\r\n'),(4,'contact_us','<p>Contact Us</p>','<p>Here comes the contents of the contact us page<br />\r\n&nbsp;</p>\r\n'),(5,'faq','<p>\r\n	FAQ</p>\r\n','<table cellpadding=\"5\" cellspacing=\"1\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td class=\"headng\" width=\"100%\">\r\n				<a name=\"top\"><strong><u>User Section</u></strong></a></td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"innertextCopy1\" width=\"100%\">\r\n				<ul>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#1\">Why do I see sub orders in my order history?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#2\">Why do I receive my order in many parts?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#3\">What if I get my order in a damaged/bad condition?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#4\">How long will it take to ship my items?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#5\">Can I purchase without registering?</a></li>\r\n					<li>\r\n						<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 class=\"headng\" width=\"100%\">\r\n				<a name=\"sellers\"><strong><u>Seller Section</u></strong></a></td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"innertextCopy1\" width=\"100%\">\r\n				<ul>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#1s\">I am a seller. How will I sell my products through your site?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#2s\">Can I sell the products free of cost? Are there any charges?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#3s\">How will I receive the payments for my delivered orders?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#4s\">Can I ship items in an order partially?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#5s\">What if some of my items do not fit into any of the categories in the website?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#6s\">How will I display my portfolio to the users?</a></li>\r\n					<li>\r\n						<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 class=\"headng\" width=\"100%\">\r\n				<a name=\"affiliate\"><strong><u>Affiliate Section</u></strong></a></td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"innertextCopy1\" width=\"100%\">\r\n				<ul>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#1a\">How can I become an affiliate of your site?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#2a\">Are affiliates paid after registration?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#3a\">Will I receive payments for the lifetime purchases from my referrals?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#4a\">When will I receive the payments?</a></li>\r\n					<li>\r\n						<a class=\"menu2\" href=\"#5a\">Do I need a website in order to become your affiliate?</a></li>\r\n					<li>\r\n						<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 class=\"headng\" width=\"100%\">\r\n				<strong><u>User Section</u></strong></td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"innertextCopy1\" width=\"100%\">\r\n				<ul>\r\n					<li>\r\n						<a class=\"menu2\" name=\"1\">Why do I see sub orders in my order history?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">Any order you place on the site may contain items from different vendors. This implies that your \r\n\r\norder may have more than one suborder; these are shipped by the vendors separately. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"2\">Why do I receive my order in many parts? </a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">Any order you make can contain items from many vendors, these suborders are handled by each vendor \r\n\r\nindividually. That is why your items are delivered in parts.  </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"3\">What if I get my order in a damaged/bad condition?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">The sellers are careful not to damage your orders after packaging and shipping them for you. If your \r\n\r\norder happens to be damaged, you can inform the seller and us to get return merchandize authorization from the seller to return the items. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li><a class=\"menu2\" name=\"4\">How long will it take to ship my items?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">Your items should reach you in 3 weeks. If you haven’t received your items in this span of time, \r\n\r\nplease contact the seller immediately. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"5\">Can I purchase without registering?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">No. You need to first register with the site and login to be able to shop with the site. However, \r\n\r\nyou can browse and compare items even without logging in.</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"6\">Do I need to do anything after I receive the items?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">You can login to the system, go to &#39;Orders&#39; section and update the status of each sub-orders \r\n\r\n(if any) to &#39;delivered&#39; after you get your items in good condition.</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span></li>\r\n				</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"headng\">\r\n				&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"headng\" width=\"100%\">\r\n				<strong><u>Seller Section</u></strong></td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"innertextCopy1\" width=\"100%\">\r\n				<ul>\r\n					<li>\r\n						<a class=\"menu2\" name=\"1s\">I am a seller. How will I sell my products through your site?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">To be able to sell your products through <!--p echo SITE_NAME;-->you need to first <a \r\n\r\nhref=\"artists/register.php\">register</a> with the site as a Seller. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"2s\">Can I sell the products free of cost? Are there any charges?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">There is no listing fee or monthly fee. A commission for sale is deducted before sending you the \r\n\r\nproceeds. The current seller commission is 10%. The commission is applied only when a sale is complete.</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"3s\">How will I receive the payments for my delivered orders?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">We pay vendors on a net 30 basis, so you can expect payments after 30 days of delivery. </span><br \r\n\r\n/>\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"4s\">Can I ship items from the same order separately?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">No. You can’t ship items separately. You need to ship all the items in one order or cancel it. \r\n\r\n</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"5s\">What if some of my items don’t fit in any of the categories listed?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">If your items don’t fit into any of the categories on the site, you can request that the \r\n\r\nadministrator create the categories you need using the ‘Mail Admin’ section. If the categories are relevant, the administrator will add them for you. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"6s\">How will I display my portfolio to the users?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">You need to have a html portfolio page designed for publishing on the site. If you have any images \r\n\r\non the page, please make sure the image urls are complete otherwise they will not load properly. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"7s\">Do I need to pay to register with the site as a seller?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">No. Sellers can register for free. The sales commission is per order after you receive them through \r\n\r\nthe site.</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span></li>\r\n				</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"headng\">\r\n				&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"headng\" width=\"100%\">\r\n				<strong><u>Affiliate Section</u></strong></td>\r\n		</tr>\r\n		<tr>\r\n			<td class=\"innertextCopy1\" width=\"100%\">\r\n				<ul>\r\n					<li>\r\n						<a class=\"menu2\" name=\"1a\">How can I become an affiliate of your site?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">You can become an affiliate by registering under the <a href=\"affiliates/index.php\">Affiliate \r\n\r\nSection</a></span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"2a\">Are affiliates paid after registration? </a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">You will be paid for the purchase you refer to us. We pay 5% of the purchase amount, as affiliate \r\n\r\ncommission. </span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"3a\">Will I receive payments for the lifetime purchases from my referrals?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">No. You will be eligible for payments from the first purchase</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"4a\">When will I receive the payments?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\">We pay our affiliates monthly after 30 days of the month’s end. A minimum of $100 is required for \r\n\r\npayout and the unpaid balance will be rolled over to the next month. </span><br \r\n\r\n/>\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"5a\">Do I need a website to become your affiliate?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\"> No. You do not need a website to become our affiliate. All you have to do is get your advertising \r\n\r\nURL from the <a href=\"affiliates/geturls.php\">Get Url</a> page of the affiliate section and ask your friends to register with Multicart using the URL you received from the <a \r\n\r\nhref=\"affiliates/geturls.php.php\">Get Url</a> page.</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span><br />\r\n						&nbsp;</li>\r\n					<li>\r\n						<a class=\"menu2\" name=\"6a\">Where can I get the urls for publishing?</a><br />\r\n						<br />\r\n						<span class=\"innertextCopy2\"><a href=\"affiliates/login.php\">Login</a> to the Affiliate Section and go to the <a \r\n\r\nhref=\"affiliates/geturls.php\">Get Url</a> page. You can get the banners or URLs from this section to advertise your site by email or whatever means you deem necessary. \r\n\r\n</span><br />\r\n						<span align=\"right\" class=\"innertextCopy2\" width=\"100%\"><a class=\"menu2\" href=\"#top\">Top</a></span></li>\r\n				</ul>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n');

--
-- Table structure for table `multicart_countries`
--

CREATE TABLE `multicart_countries` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_name` varchar(64) NOT NULL DEFAULT '',
  `country_iso_code_2` char(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`country_id`),
  KEY `IDX_COUNTRY_NAME` (`country_name`)
) ENGINE=MyISAM AUTO_INCREMENT=241 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_countries`
--

INSERT INTO `multicart_countries` VALUES (1,'Afghanistan','AF'),(2,'Albania','AL'),(3,'Algeria','DZ'),(4,'American Samoa','AS'),(5,'Andorra','AD'),(6,'Angola','AO'),(7,'Anguilla','AI'),(8,'Antarctica','AQ'),(9,'Antigua and Barbuda','AG'),(10,'Argentina','AR'),(11,'Armenia','AM'),(12,'Aruba','AW'),(13,'Australia','AU'),(14,'Austria','AT'),(15,'Azerbaijan','AZ'),(16,'Bahamas','BS'),(17,'Bahrain','BH'),(18,'Bangladesh','BD'),(19,'Barbados','BB'),(20,'Belarus','BY'),(21,'Belgium','BE'),(22,'Belize','BZ'),(23,'Benin','BJ'),(24,'Bermuda','BM'),(25,'Bhutan','BT'),(26,'Bolivia','BO'),(27,'Bosnia and Herzegowina','BA'),(28,'Botswana','BW'),(29,'Bouvet Island','BV'),(30,'Brazil','BR'),(31,'British Indian Ocean Territory','IO'),(32,'Brunei Darussalam','BN'),(33,'Bulgaria','BG'),(34,'Burkina Faso','BF'),(35,'Burundi','BI'),(36,'Cambodia','KH'),(37,'Cameroon','CM'),(38,'Canada','CA'),(39,'Cape Verde','CV'),(40,'Cayman Islands','KY'),(41,'Central African Republic','CF'),(42,'Chad','TD'),(43,'Chile','CL'),(44,'China','CN'),(45,'Christmas Island','CX'),(46,'Cocos (Keeling) Islands','CC'),(47,'Colombia','CO'),(48,'Comoros','KM'),(49,'Congo','CG'),(50,'Cook Islands','CK'),(51,'Costa Rica','CR'),(52,'Cote D\'Ivoire','CI'),(53,'Croatia','HR'),(54,'Cuba','CU'),(55,'Cyprus','CY'),(56,'Czech Republic','CZ'),(57,'Denmark','DK'),(58,'Djibouti','DJ'),(59,'Dominica','DM'),(60,'Dominican Republic','DO'),(61,'East Timor','TP'),(62,'Ecuador','EC'),(63,'Egypt','EG'),(64,'El Salvador','SV'),(65,'Equatorial Guinea','GQ'),(66,'Eritrea','ER'),(67,'Estonia','EE'),(68,'Ethiopia','ET'),(69,'Falkland Islands (Malvinas)','FK'),(70,'Faroe Islands','FO'),(71,'Fiji','FJ'),(72,'Finland','FI'),(73,'France','FR'),(74,'France, Metropolitan','FX'),(75,'French Guiana','GF'),(76,'French Polynesia','PF'),(77,'French Southern Territories','TF'),(78,'Gabon','GA'),(79,'Gambia','GM'),(80,'Georgia','GE'),(81,'Germany','DE'),(82,'Ghana','GH'),(83,'Gibraltar','GI'),(84,'Greece','GR'),(85,'Greenland','GL'),(86,'Grenada','GD'),(87,'Guadeloupe','GP'),(88,'Guam','GU'),(89,'Guatemala','GT'),(90,'Guinea','GN'),(91,'Guinea-bissau','GW'),(92,'Guyana','GY'),(93,'Haiti','HT'),(94,'Heard and Mc Donald Islands','HM'),(95,'Honduras','HN'),(96,'Hong Kong','HK'),(97,'Hungary','HU'),(98,'Iceland','IS'),(99,'India','IN'),(100,'Indonesia','ID'),(101,'Iran (Islamic Republic of)','IR'),(102,'Iraq','IQ'),(103,'Ireland','IE'),(104,'Israel','IL'),(105,'Italy','IT'),(106,'Jamaica','JM'),(107,'Japan','JP'),(108,'Jordan','JO'),(109,'Kazakhstan','KZ'),(110,'Kenya','KE'),(111,'Kiribati','KI'),(112,'Korea, Democratic People\'s Republic of','KP'),(113,'Korea, Republic of','KR'),(114,'Kuwait','KW'),(115,'Kyrgyzstan','KG'),(116,'Lao People\'s Democratic Republic','LA'),(117,'Latvia','LV'),(118,'Lebanon','LB'),(119,'Lesotho','LS'),(120,'Liberia','LR'),(121,'Libyan Arab Jamahiriya','LY'),(122,'Liechtenstein','LI'),(123,'Lithuania','LT'),(124,'Luxembourg','LU'),(125,'Macau','MO'),(126,'Macedonia, The Former Yugoslav Republic of','MK'),(127,'Madagascar','MG'),(128,'Malawi','MW'),(129,'Malaysia','MY'),(130,'Maldives','MV'),(131,'Mali','ML'),(132,'Malta','MT'),(133,'Marshall Islands','MH'),(134,'Martinique','MQ'),(135,'Mauritania','MR'),(136,'Mauritius','MU'),(137,'Mayotte','YT'),(138,'Mexico','MX'),(139,'Micronesia, Federated States of','FM'),(140,'Moldova, Republic of','MD'),(141,'Monaco','MC'),(142,'Mongolia','MN'),(143,'Montserrat','MS'),(144,'Morocco','MA'),(145,'Mozambique','MZ'),(146,'Myanmar','MM'),(147,'Namibia','NA'),(148,'Nauru','NR'),(149,'Nepal','NP'),(150,'Netherlands','NL'),(151,'Netherlands Antilles','AN'),(152,'New Caledonia','NC'),(153,'New Zealand','NZ'),(154,'Nicaragua','NI'),(155,'Niger','NE'),(156,'Nigeria','NG'),(157,'Niue','NU'),(158,'Norfolk Island','NF'),(159,'Northern Mariana Islands','MP'),(160,'Norway','NO'),(161,'Oman','OM'),(162,'Pakistan','PK'),(163,'Palau','PW'),(164,'Panama','PA'),(165,'Papua New Guinea','PG'),(166,'Paraguay','PY'),(167,'Peru','PE'),(168,'Philippines','PH'),(169,'Pitcairn','PN'),(170,'Poland','PL'),(171,'Portugal','PT'),(172,'Puerto Rico','PR'),(173,'Qatar','QA'),(174,'Reunion','RE'),(175,'Romania','RO'),(176,'Russian Federation','RU'),(177,'Rwanda','RW'),(178,'Saint Kitts and Nevis','KN'),(179,'Saint Lucia','LC'),(180,'Saint Vincent and the Grenadines','VC'),(181,'Samoa','WS'),(182,'San Marino','SM'),(183,'Sao Tome and Principe','ST'),(184,'Saudi Arabia','SA'),(185,'Senegal','SN'),(186,'Seychelles','SC'),(187,'Sierra Leone','SL'),(188,'Singapore','SG'),(189,'Slovakia (Slovak Republic)','SK'),(190,'Slovenia','SI'),(191,'Solomon Islands','SB'),(192,'Somalia','SO'),(193,'South Africa','ZA'),(194,'South Georgia and the South Sandwich Islands','GS'),(195,'Spain','ES'),(196,'Sri Lanka','LK'),(197,'St. Helena','SH'),(198,'St. Pierre and Miquelon','PM'),(199,'Sudan','SD'),(200,'Suriname','SR'),(201,'Svalbard and Jan Mayen Islands','SJ'),(202,'Swaziland','SZ'),(203,'Sweden','SE'),(204,'Switzerland','CH'),(205,'Syrian Arab Republic','SY'),(206,'Taiwan','TW'),(207,'Tajikistan','TJ'),(208,'Tanzania, United Republic of','TZ'),(209,'Thailand','TH'),(210,'Togo','TG'),(211,'Tokelau','TK'),(212,'Tonga','TO'),(213,'Trinidad and Tobago','TT'),(214,'Tunisia','TN'),(215,'Turkey','TR'),(216,'Turkmenistan','TM'),(217,'Turks and Caicos Islands','TC'),(218,'Tuvalu','TV'),(219,'Uganda','UG'),(220,'Ukraine','UA'),(221,'United Arab Emirates','AE'),(222,'United Kingdom','GB'),(223,'United States','US'),(224,'United States Minor Outlying Islands','UM'),(225,'Uruguay','UY'),(226,'Uzbekistan','UZ'),(227,'Vanuatu','VU'),(228,'Vatican City State (Holy See)','VA'),(229,'Venezuela','VE'),(230,'Viet Nam','VN'),(231,'Virgin Islands (British)','VG'),(232,'Virgin Islands (U.S.)','VI'),(233,'Wallis and Futuna Islands','WF'),(234,'Western Sahara','EH'),(235,'Yemen','YE'),(236,'Yugoslavia','YU'),(237,'Zaire','ZR'),(238,'Zambia','ZM'),(239,'Zimbabwe','ZW'),(240,'United \r\nKingdom','UK');

--
-- Table structure for table `multicart_couponcode`
--

CREATE TABLE `multicart_couponcode` (
  `ccID` int(11) NOT NULL AUTO_INCREMENT,
  `ccStartDate` date NOT NULL DEFAULT '0000-00-00',
  `ccEndDate` date NOT NULL DEFAULT '0000-00-00',
  `ccCode` varchar(50) NOT NULL DEFAULT '',
  `sellerId` int(11) DEFAULT NULL COMMENT 'equivalent to artist_id(StoreId)',
  `categoryId` text,
  `productId` text,
  `ccDescription` text NOT NULL,
  `ccDiscount` float NOT NULL DEFAULT '0',
  `subscriptionStatus` char(1) NOT NULL DEFAULT '',
  `ccStatus` char(1) NOT NULL DEFAULT '',
  `coupon_type` varchar(50) NOT NULL DEFAULT '',
  `discount_type` enum('PERCENTAGE','FLAT') DEFAULT 'PERCENTAGE',
  PRIMARY KEY (`ccID`),
  UNIQUE KEY `ccCode` (`ccCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_couponcode`
--


--
-- Table structure for table `multicart_currency_master`
--

CREATE TABLE `multicart_currency_master` (
  `ncurrency_id` int(11) NOT NULL AUTO_INCREMENT,
  `vcurrency_name` varchar(50) NOT NULL DEFAULT '',
  `vcurrency_code` varchar(10) NOT NULL DEFAULT '',
  `vcurrency_symbol` varchar(10) NOT NULL DEFAULT '',
  `nexchange_price` float NOT NULL DEFAULT '0',
  `vactive` char(1) NOT NULL DEFAULT '',
  `vcurrency_delete_status` char(1) NOT NULL DEFAULT '',
  `usdollar_rate` float NOT NULL DEFAULT '1',
  PRIMARY KEY (`ncurrency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_currency_master`
--

INSERT INTO `multicart_currency_master` VALUES (1,'Australian dollar','AUD','&#36;',1,'Y','',1),(2,'Brazilian real','BRL','R$',1,'Y','',1),(3,'Malaysian ringgit','MYR','RM',1,'Y','',1),(4,'Indian rupee','INR','&#x20B9;',1,'Y','',1),(5,'Canadian dollar','CAD','&#36;',1,'Y','',1),(6,'British pound','GBP','&pound;',1,'Y','',1),(7,'Japanese yen','JPY','&yen;',1,'Y','',1),(8,'European euro','EUR','&euro;',1,'Y','',1),(9,'United States Dollar','USD','&#36;',1,'Y','',1),(10,'Russian ruble','RUB','Ã‘â‚¬Ã‘Æ’Ã',1,'Y','',1);

--
-- Table structure for table `multicart_custom_fields`
--

CREATE TABLE `multicart_custom_fields` (
  `ncustom_id` int(11) NOT NULL AUTO_INCREMENT,
  `vcustom_field_form_id` int(11) NOT NULL DEFAULT '0',
  `vcustom_field_name` varchar(50) NOT NULL DEFAULT '',
  `vcustom_field_type` varchar(50) NOT NULL DEFAULT '',
  `vrequired_custom_field` char(1) NOT NULL DEFAULT '',
  `vcustom_sort_order` int(11) NOT NULL DEFAULT '0',
  `vcustom_display_field` char(1) NOT NULL DEFAULT '',
  `vcustom_delete_status` char(1) NOT NULL DEFAULT '',
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`ncustom_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_custom_fields`
--


--
-- Table structure for table `multicart_custom_fields_value`
--

CREATE TABLE `multicart_custom_fields_value` (
  `nvalue_id` int(11) NOT NULL AUTO_INCREMENT,
  `ncustom_field_id` int(11) NOT NULL DEFAULT '0',
  `ncustom_table_id` int(11) NOT NULL DEFAULT '0',
  `vfield_name_value` text NOT NULL,
  `vcustom_field_name` text NOT NULL,
  `vcustom_field_type` text NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`nvalue_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_custom_fields_value`
--


--
-- Table structure for table `multicart_custom_form`
--

CREATE TABLE `multicart_custom_form` (
  `ncustom_form_id` int(11) NOT NULL AUTO_INCREMENT,
  `vcustom_form_name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ncustom_form_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_custom_form`
--

INSERT INTO `multicart_custom_form` VALUES (1,'user_registration'),(2,'product_adding');

--
-- Table structure for table `multicart_digital_product`
--

CREATE TABLE `multicart_digital_product` (
  `ndigital_id` int(11) NOT NULL AUTO_INCREMENT,
  `vdigital_product_name` varchar(250) NOT NULL DEFAULT '',
  `ndigital_productid` int(11) NOT NULL DEFAULT '0',
  `ndigital_orderid` int(11) NOT NULL DEFAULT '0',
  `vdigital_product_code` text NOT NULL,
  `ndownload_try` int(11) NOT NULL DEFAULT '0',
  `ndownload_count` int(11) NOT NULL DEFAULT '0',
  `ndownload_expiry` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ndownload_expiry_days` int(11) NOT NULL DEFAULT '0',
  `ndownload_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ndigital_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_digital_product`
--

INSERT INTO `multicart_digital_product` VALUES (1,'wy06202017111720540598_Kalimba.mp3',1,0,'',3,0,'0000-00-00 00:00:00',10,0);

--
-- Table structure for table `multicart_digital_track`
--

CREATE TABLE `multicart_digital_track` (
  `ndigital_id` int(11) NOT NULL AUTO_INCREMENT,
  `vdigital_product_name` varchar(250) NOT NULL DEFAULT '',
  `ndigital_productid` int(11) NOT NULL DEFAULT '0',
  `ndigital_orderid` int(11) NOT NULL DEFAULT '0',
  `vdigital_product_code` text NOT NULL,
  `ndownload_try` int(11) NOT NULL DEFAULT '0',
  `ndownload_count` int(11) NOT NULL DEFAULT '0',
  `ndownload_expiry` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ndownload_expiry_days` int(11) NOT NULL DEFAULT '0',
  `ndownload_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ndigital_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_digital_track`
--


--
-- Table structure for table `multicart_email_templates`
--

CREATE TABLE `multicart_email_templates` (
  `nemail_id` int(11) NOT NULL AUTO_INCREMENT,
  `vtemplate_name` varchar(100) NOT NULL DEFAULT '',
  `vtemplate_title` varchar(100) NOT NULL DEFAULT '',
  `vemail_body` text NOT NULL,
  `vreplaceable_variables` text NOT NULL,
  `vtemplate_flag` char(1) DEFAULT '',
  `artist_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`nemail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_email_templates`
--

INSERT INTO `multicart_email_templates` VALUES (1,'order_acknowledgement','Order Acknowledgement Mail From Seller','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]','[first_name], [last_name], [product_details], [seller_name]','S',NULL),(2,'seller_registration_approval','Seller Account Approval','Dear [first_name] [last_name],\r\n\r\nYour seller account has been approved. <a href=\"[link]\">Click here</a> or copy the url below and paste in your browser to login\r\n\r\n[link]\r\n\r\nRegards,\r\n\r\nAdministrator, \r\n[site_name]\r\n','[first_name], [last_name], [site_name],[link]','A',NULL),(24,'member_registration','New Member Registration','Dear [first_name] [last_name],\r\n\r\nThank you for registering with [site_name]\r\n\r\nYour account details are as follows\r\n\r\nUser Name :- [user_name]\r\nPassword :- [password]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]','[first_name], [last_name], [site_name], [user_name], [password]','A',NULL),(3,'gift_coupon','New Gift Order Placed Mail To Buyer','Dear [buyer_first_name] [buyer_last_name] ,  \r\n\r\n  \r\n\r\n  A new order has  placed for you through the [site_name] site.  The details are as follows. [coupon_details] With \r\n\r\nregards, Administrator, [site_name]','[site_name], [coupon_details]','A',NULL),(4,'order_notification_seller','Stock Reorder Mail ','Dear [site_name] seller,  \r\n\r\n  \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]','[site_name], [order_details]','A',NULL),(6,'digital_product','Digital Product Order Mail to Buyer','Dear [first_name]     [last_name], \r\n\r\n \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]','[first_name], [last_name], [product_details]','Y',NULL),(7,'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\nProduct Code: [product_code]\r\n\r\nProduct Category Name : [category_name]\r\n\r\nProduct Price: [product_price] \r\n\r\n Discount(%) : [product_discount]\r\n\r\n Stock Available : [stock_available]\r\n\r\nShipping Weight :[shipping_weight]\r\n\r\nProduct Image: [product_image]\r\n\r\nIf you want to view please click the below link \r\n[link] \r\n(Listing will be available only after approval) \r\n\r\nThank you,\r\n[seller_name]. ','[seller_username],[date],[product_name],[product_code],[category_name],[product_price],[product_discount],[stock_available],[shipping_weight],[product_image],[link],[seller_name]','A',NULL),(26,'affiliate_registration','New Affiliate Registration','Dear [first_name] [last_name],\r\n\r\nThank you for registering with [site_name]\r\n\r\nYour affiliate account details are as follows\r\n\r\nUser Name :- [user_name]\r\nPassword :- [password]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]\r\n','[first_name], [last_name], [user_name], [password], [site_name]','A',NULL),(8,'refund_registration','Refund Request Registration','Dear [first_name]  [last_name] ,\r\n\r\n Your Refund Request  has been registered  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\n Product 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',NULL),(9,'user_forgotpassword','User Forgot Password','Dear [name],\r\n\r\nYour password with [site_name] is reset on request.\r\n\r\nYour updated 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].','[first_name], [last_name], [site_name]','A',NULL),(28,'seller_forgotpassword','Seller Forgot Password','Dear [name],\r\n\r\n \r\n\r\n You have requested a password reset for your Seller account with [site_name]\r\n\r\nYour updated Seller 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',NULL),(10,'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\nOrder Id : [order_id]\r\n\r\nRefund Id : [refund_id]\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',NULL),(11,'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 Order Id   : [order_id]\r\n\r\n Refund Id : [refund_id]\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',NULL),(12,'refund_request_reg_admin','Refund Request Registartion confirmation for admin','Dear Administrator ,  \r\n\r\n Customer [first_name] [last_name] has requested refund with [site_name] \r\n\r\n  Refund Registration Details are as follows  \r\n\r\n Order Id : [order_id] \r\n\r\n Refund Id : [refund_id]  \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\n Reason for Return :[reason]  \r\n\r\n  Comments :[comments]  \r\n\r\n Quantity :[quantity]  \r\n\r\n Date : [date]  \r\n\r\n Thank you once again for your interest in [site_name]  \r\n\r\n Happy shopping.. With warm regards, Administrator, [site_name]','[first_name], [last_name], [site_name]','A',NULL),(46,'affiliate_registration_status','New Affiliate Registration status','Dear [first_name] [last_name],\r\n\r\nThank you for registering with [site_name]\r\n\r\nYour affiliate account is approved by the administrator. You can login now using your username and password.\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]\r\n','[first_name],[last_name],[site_name]','A',NULL),(22,'order_notification_buyer','Order Notification To Buyer','Dear [buyer_first_name] [buyer_last_name] ,  \r\n\r\n  \r\n\r\n  A new order has  placed for you through the [site_name] site.  The details are as follows. [order_details]  \r\n\r\n With regards, Administrator, [site_name]','[site_name], [order_details]','A',NULL),(43,'product_review','New Product Review Mail To Administrator','Dear Administrator ,\r\n\r\nA new product review has been posted with [site_name] By the User [first_name] [last_name]\r\n\r\nProduct Name :- [product_name].\r\n\r\n[link] to view product details.\r\n\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ','[site_name][first_name][last_name][product_name][link]','A',NULL),(25,'seller_registration','New Seller Registration','Dear [first_name] [last_name]\r\n\r\nThank you for registering with [site_name]\r\n\r\nYour seller account details are as follows\r\n\r\nUser Name :- [user_name]\r\nPassword :- [password]\r\n\r\nThank 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]','','',NULL),(27,'User Forgot Password','user_forgotpassword','Your password with [site_name] is reset on request.\r\n\r\nYour updated 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].','[user_name], [password], [site_name]','A',NULL),(29,'affiliate_forgotpassword','Affiliate Forgot Password','Dear [name],\r\n\r\nYou have requested a password reset for your affiliate account with [site_name]\r\n\r\nUser Name :- [user_name]\r\nPassword :- [password]\r\n\r\nWith regards,\r\n\r\nAdministrator [site_name]\r\n','[name], [user_name], [password], [site_name]','A',NULL),(30,'change_userpassword','Change User Password','Dear [name],\r\n\r\nYour password with [site_name] has been reset by the site Administrator\r\n\r\nThe updated 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',NULL),(31,'change_sellerpassword','Change Seller Password','Dear [name],\r\n\r\nYour Seller account information with [site_name] has been reset by the Administrator.\r\n\r\nThe updated 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',NULL),(32,'change_affiliatepassword','Change Affiliate Password','Dear [name],\r\n\r\nYour password with [site_name] has been reset by the site Administrator\r\n\r\nThe updated 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',NULL),(33,'order_notification_admin','Order Notification To Admin','Dear Administrator,  \r\n\r\n  \r\n\r\n A new order has been placed by [buyer_first_name] [buyer_last_name] through the [site_name] site.The details are as follows. \r\n\r\n[order_details] With regards, [site_name]','[site_name], [order_details]','A',NULL),(34,'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\nFirst Name :- [first_name]\r\n\r\nLast Name :- [last_name]\r\n\r\nEmail :- [email]\r\n\r\n\r\n\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ','[first_name], [last_name], [site_name], [user_name], [email], [password]','A',NULL),(35,'seller_registration_admin','New Seller Registration Mail To Administrator','Dear Administrator ,\r\n\r\nA new seller has been registered with [site_name]\r\n\r\n Account details are as  follows\r\n\r\nUser Name :  [user_name]\r\n\r\nPassword :  [password]\r\n\r\n First Name :  [seller_first_name] \r\n\r\nLast Name :  [seller_last_name]\r\n\r\n Happy shopping..\r\n\r\n \r\nWith warm regards,\r\n\r\n [site_name]  Team ','[seller_first_name], [seller_last_name], [site_name], [user_name], [password]','A',NULL),(37,'stock_reorder','Stock Reorder Mail to Seller','\r\n\r\n  The following product(s) has gone under the reorder level set by you. \r\n\r\n Please refill your stock \r\n\r\n[product_details] \r\n\r\nWith regards, Administrator, [site_name]','[site_name], [product_details]','A',NULL),(39,'order_notification_mail_seller','Order Notification Mail to Seller',' [order_details] \r\n\r\nWith regards, Administrator, [site_name]','[site_name], [order_details]','A',NULL),(40,'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',NULL),(41,'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',NULL),(42,'affiliate_registration_admin','New Affiliate Registration Mail To Administrator','Dear Administrator ,\r\n\r\n A new affiliate has been registered with [site_name]\r\n\r\n Account details are as  follows\r\n\r\nUser Name :- [user_name]\r\n\r\nPassword :- [password]\r\n\r\n First Name :- [first_name]\r\n\r\nLast Name :- [last_name]\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ','[first_name], [last_name], [site_name], [user_name], [password]','A',NULL),(44,'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',NULL),(45,'gift_couponmail_admin','New Gift Order Placed Mail To Admin','Dear Administrator,  \r\n\r\n  \r\n\r\n A new order has been placed by [buyer_first_name] [buyer_last_name] through the [site_name] site.The details are as follows. \r\n\r\n [coupon_details] With regards, [site_name]','[site_name], [coupon_details]','A',NULL),(47,'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 requested refund for the 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\n Product 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',NULL),(48,'new_gift_certificate_seller','New gift certificate notification to admin from seller','Dear Administrator, \r\n\r\nA new gift certificate has been added under the seller [seller_username].\r\nDate of Posting: [date]\r\nGift Certificate Name : [certificate_name]\r\nGift Certificate Code: [certificate_code]\r\nCertificate Details : [imglink]\r\nCertificate Amount : [certificate_amount] USD\r\nStock Available : [stock_available]\r\nStock Reorder Level : [stock_reorder]\r\n\r\n\r\nThank you,\r\n[seller_name].','[seller_username],[date],[certificate_name],[certificate_code],[imglink],[certificate_amount],[stock_available],[stock_reorder]','A',NULL),(49,'order_statuschange_buyer','Order Status Change Mail To Buyer From Admin','Dear [first_name] [last_name],\r\n\r\n \r\n\r\n  Administrator has changed order status of the following order placed in [site_name]. The details are as follows.\r\n\r\n Order ID : [order_id] \r\n\r\n Order status : [order_status] \r\n\r\n Product Name : [product_name] \r\n\r\n Product Code: [product_code] \r\n\r\n Product Price : [product_price] \r\n\r\n Product Quantity : [product_qty]\r\n\r\n  With regards, Administrator, [site_name]','[site_name], [order_details],[seller_first_name],[seller_last_name]','A',NULL),(50,'order_statuschange_buyer_seller','Order Status Change Mail To Buyer','[order_details]','[site_name], [order_details],[seller_first_name],[seller_last_name]','A',NULL),(51,'request_payment_seller','Request payment from seller to administrator','Dear administrator,\r\n\r\n The seller [seller_name] has been made a request for payment in [site_name] site.The details are as follows. \r\n[order_details] \r\n\r\nWith regards, \r\n[site_name] Team','[seller_name],[site_name],[order_details]','A',NULL),(52,'settle_artist_payment','Mail to seller during settle payment','Dear [seller_name], \r\n\r\n  Your payment is settled by the administrator in the [site_name] site. \r\n\r\n Amount paid is : [amount] \r\n\r\n  With regards, [site_name]','[seller_name][site_name][amount] ','A',NULL),(53,'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',NULL),(54,'digital_product_admin','Digital Product Order Mail to Admin',' Dear Administrator ,  \r\n\r\n  \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',NULL),(55,'product_review_approved','Product review status change mail to user','Dear [user_name] ,\r\n\r\n  \r\n\r\n Your product review on [site_name] is [status] by the [approved_by]\r\n\r\nProduct Name :- [product_name].\r\n\r\n[link] to view product details.\r\n\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ','[user_name],[site_name],[approved_by],[product_name],[link]','A',NULL),(56,'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',NULL),(57,'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',NULL),(58,'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',NULL),(59,'seller_previlge_update','Seller account activation mail for existing buyer account','[account_details] \r\n\r\nWith regards, \r\n[site_name] Team','[site_name], [account_details]','A',NULL),(60,'seller_invoice_mail','Monthly Invoice To Seller ','Dear [seller_name],Your invoice for [from_date]-[to_date] in the [site_name] site.[invoice_content] ','[seller_name][site_name][invoice_content]','A',NULL),(61,'seller_account_deactivation_mail','Seller Account Deactivation Mail','Dear [seller_name],[custom_content] ','[seller_name][site_name][custom_content]','A',NULL),(62,'seller_previlge_update','Seller account activation mail for existing buyer account','[account_details] \r\n\r\nWith regards, \r\n[site_name] Team','[site_name], [account_details]','A',NULL),(63,'order_statuschange_buyer_to_seller','Order Status Change Mail From Buyer To Seller','[order_details]','[site_name], [order_details],[buyer_first_name],[buyer_last_name]','A',NULL),(64,'referral_registration','New User Registered With Referral To Affliate','Dear [affliate_name],\r\n\r\nA new user has been registered with your referral link\r\nwith [site_name].\r\n\r\nYou will get commission on his/her first purchase.\r\n\r\nUser Details are as  follows\r\n\r\nFirst Name :- [first_name]\r\n\r\nLast Name :- [last_name]\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ','[site_name], [account_details],[affliate_name],[first_name],[\'last_name\']','A',NULL),(65,'referral_user_purchase','Referral User Purchased mail from admin to affliate','Dear [affiliate_name],\r\n\r\nReferral User purchased his first products,You will get commission on user first purchase.\r\n\r\nSite Owner will settle the payment once the item got delivered.\r\n\r\nPlease login in to your affiliate panel to view the commission details\r\n\r\n\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ','[affiliate_name],[site_name]','A',NULL),(66,'affliate_settlement_mail','Affliate Settlement Mail From Admin to affiliate','Dear [affiliate_name],\r\n\r\nAdministrator has settle the referral commission.\r\n\r\nCommission amount is : [commission_amount]\r\n\r\nPlease login to view further details\r\n\r\n[login_link]\r\n\r\n\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ','[affiliate_name],[site_name],[commission_amount],[login_link]','A',NULL),(67,'plan_subscription','Plan Subscription','Dear [first_name],\r\n\r\nThank you for subscribing plan with [site_name]\r\n\r\nYour plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(68,'plan_subscription_admin','Plan Subscription to administrator','Dear Administrator ,\r\n\r\n A new member has been subcribed plan with [site_name]\r\n\r\n Plan details are as  follows\r\n\r\nFirst Name :- [first_name]\r\n\r\nPlan Name :- [plan_name]\r\n\r\nPlan Amount :- [plan_amount]\r\n\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ','[user_name], [first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(69,'plan_subscription_upgrade','Plan Subscription Upgrade','Dear [first_name],\r\n\r\nThank you for plan upgrade with [site_name]\r\n\r\nYour upgrade plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(70,'plan_subscription_upgrade_admin','Plan Subscription Upgrade to administrator','Dear Administrator ,\r\n\r\n[first_name] has been upgrade plan with [site_name]\r\n\r\n Upgrade Plan details are as  follows\r\n\r\nFirst Name :- [first_name]\r\n\r\nPlan Name :- [plan_name]\r\n\r\nPlan Amount :- [plan_amount]\r\n\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ','[user_name], [first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(71,'recurring_subscription_success','Recurring Subscription Success','Dear [first_name],\r\n\r\nRecurring payment is successull with [site_name]\r\n\r\nYour plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(72,'recurring_subscription_updation','Recurring Subscription Warning Alert','Dear [first_name],\r\n\r\nRecurring payment is failed with [site_name]\r\n\r\nIts may be due to insufficient balance in your card.\r\n\r\nPlease update your card in account.\r\n\r\nYour plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(73,'plan_subscription_cancel','Plan Subscription Cancel','Dear [first_name],\r\n\r\nYour subscription cancelled with [site_name]\r\n\r\nYour cancelled plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\n\r\nWith warm regards,\r\n\r\nAdministrator, [site_name]','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(74,'plan_subscription_cancel_admin','Plan Subscription Cancel  to administrator','Dear Administrator,\r\n\r\n[first_name] \'s subscription cancelled with [site_name]\r\n\r\n[first_name] \'s  cancelled plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL),(75,'recurring_subscription_success_admin','Recurring Subscription Success to administrator','Dear Administrator ,\r\n\r\n[first_name] \'s recurring payment is successull with [site_name]\r\n\r\n[first_name] plan details are as follows\r\n\r\nPlan Name :- [plan_name]\r\nPlan Amount:- [plan_amount]\r\n\r\nThank you once again for your interest in [site_name]\r\n\r\n\r\nWith warm regards,\r\n\r\n [site_name]  Team ','[first_name], [site_name], [plan_name], [plan_amount]','A',NULL);

--
-- Table structure for table `multicart_favourites`
--

CREATE TABLE `multicart_favourites` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nProductId` int(11) NOT NULL,
  `nProductOptionId` int(11) NOT NULL,
  `nUserId` int(11) NOT NULL,
  `seller_id` int(11) NOT NULL,
  `dDate` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y' COMMENT 'Y = Active , N = Deactive',
  PRIMARY KEY (`nId`),
  KEY `nProductId` (`nProductId`,`nProductOptionId`,`nUserId`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 COMMENT='Store favourites Items';

--
-- Dumping data for table `multicart_favourites`
--

INSERT INTO `multicart_favourites` VALUES (1,10,5,9,0,'2017-07-25 05:02:35','Y'),(13,29,25,1,0,'2017-08-18 04:35:33','Y'),(45,36,32,40,0,'2017-10-07 13:15:29','Y'),(43,63,59,39,0,'2017-10-06 04:25:10','Y'),(14,16,12,2,0,'2017-08-19 03:51:16','Y'),(38,68,64,26,0,'2017-10-05 08:15:18','Y'),(39,69,65,26,0,'2017-10-05 08:16:11','Y'),(24,32,28,23,0,'2017-09-22 04:27:11','Y'),(41,35,31,37,0,'2017-10-06 01:58:56','Y'),(27,32,28,20,0,'2017-09-22 07:30:30','Y'),(28,35,31,27,0,'2017-09-22 22:42:48','Y'),(46,172,168,22,0,'2017-10-09 08:06:21','Y'),(47,35,31,22,0,'2017-10-10 00:41:34','Y'),(31,93,89,22,0,'2017-09-26 01:12:32','Y'),(44,60,56,1,0,'2017-10-07 12:34:08','Y'),(33,61,57,33,0,'2017-09-26 09:55:04','Y');

--
-- Table structure for table `multicart_fedexsettings`
--

CREATE TABLE `multicart_fedexsettings` (
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `FedexAccno` varchar(40) DEFAULT NULL,
  `FedexMeterno` varchar(20) DEFAULT NULL,
  `FedexWeight` varchar(20) DEFAULT NULL,
  `FedexServer` varchar(20) DEFAULT NULL,
  `FedexDropOff` varchar(100) DEFAULT NULL,
  `FedexService` text,
  `FedexPassword` varchar(50) DEFAULT NULL,
  `FedexKey` varchar(50) DEFAULT NULL,
  `FedexPackage` varchar(50) DEFAULT NULL,
  `FedexCurrency` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_fedexsettings`
--

INSERT INTO `multicart_fedexsettings` VALUES (1,'510087925','7001069','LBS','test','','PRIORITYOVERNIGHT-PRIORITYOVERNIGHT-FedEx Priority Overnight,STANDARDOVERNIGHT-STANDARDOVERNIGHT-FedEx Standard Overnight,FIRSTOVERNIGHT-FIRSTOVERNIGHT-FedEx First Overnight,FEDEX2DAY-FEDEX2DAY-FedEx 2 Day','5ltFUnC8DD34ZYzAt1DEHOcBH','93MUTAoVptiVrLWf','','USD');

--
-- Table structure for table `multicart_feedbacks`
--

CREATE TABLE `multicart_feedbacks` (
  `feedback_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `feedback_content` text,
  `user_id` bigint(20) DEFAULT NULL,
  `date_added` date DEFAULT NULL,
  `published` char(1) DEFAULT 'N',
  PRIMARY KEY (`feedback_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_feedbacks`
--


--
-- Table structure for table `multicart_flat_rate_default`
--

CREATE TABLE `multicart_flat_rate_default` (
  `flat_rate_default_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `flat_rate_name` varchar(250) NOT NULL,
  `first_Item_charge` float NOT NULL,
  `additional_Item_charge` float NOT NULL,
  PRIMARY KEY (`flat_rate_default_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_flat_rate_default`
--


--
-- Table structure for table `multicart_flat_rate_seller`
--

CREATE TABLE `multicart_flat_rate_seller` (
  `flat_rate_seller_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `flat_rate_name` varchar(250) NOT NULL,
  `first_Item_charge` float NOT NULL,
  `additional_Item_charge` float NOT NULL,
  `seller_id` bigint(20) NOT NULL,
  PRIMARY KEY (`flat_rate_seller_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_flat_rate_seller`
--


--
-- Table structure for table `multicart_genre`
--

CREATE TABLE `multicart_genre` (
  `genre_id` int(11) NOT NULL AUTO_INCREMENT,
  `genre_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`genre_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_genre`
--

INSERT INTO `multicart_genre` VALUES (3,'Rock'),(4,'Pop'),(5,'Star'),(6,'Stars'),(9,'Popsss'),(12,'tracks'),(11,'karaoke'),(13,'Trap'),(14,'R&B'),(15,'yyyyyyy'),(16,'ss\'ss\' sddfdfdf');

--
-- Table structure for table `multicart_giftcertificates`
--

CREATE TABLE `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 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_giftcertificates`
--


--
-- Table structure for table `multicart_giftcoupon_master`
--

CREATE TABLE `multicart_giftcoupon_master` (
  `ngift_id` int(11) NOT NULL AUTO_INCREMENT,
  `ngift_product_id` int(11) NOT NULL DEFAULT '0',
  `ngift_order_id` int(11) NOT NULL DEFAULT '0',
  `vgift_coupon_code` varchar(250) NOT NULL DEFAULT '',
  `ngift_coupon_amount` float NOT NULL DEFAULT '0',
  `ngift_coupon_products` text NOT NULL,
  `vgift_currency` varchar(10) NOT NULL DEFAULT '',
  `vgift_delete_status` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ngift_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_giftcoupon_master`
--


--
-- Table structure for table `multicart_help`
--

CREATE TABLE `multicart_help` (
  `hid` int(11) NOT NULL AUTO_INCREMENT,
  `hcid` int(11) DEFAULT NULL,
  `htitle` varchar(100) DEFAULT NULL,
  `hdescription` text,
  `hposition` int(11) DEFAULT NULL,
  `active` enum('0','1') DEFAULT NULL,
  `himage` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`hid`)
) ENGINE=MyISAM AUTO_INCREMENT=231 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_help`
--

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

--
-- Table structure for table `multicart_helpcategory`
--

CREATE TABLE `multicart_helpcategory` (
  `hcid` int(11) NOT NULL AUTO_INCREMENT,
  `htype` varchar(50) DEFAULT NULL,
  `hctitle` varchar(100) DEFAULT NULL,
  `hcposition` int(11) DEFAULT NULL,
  `active` enum('0','1') DEFAULT NULL,
  PRIMARY KEY (`hcid`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_helpcategory`
--

INSERT INTO `multicart_helpcategory` 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'),(67,'seller_registrar','Registration',1,'1'),(68,'seller_registrar','Logging in',2,'1'),(69,'seller_registrar','My Profile',3,'1'),(70,'seller_registrar','My Catalog',4,'1'),(71,'seller_registrar','Orders',5,'1'),(72,'seller_registrar','Manage Payments',6,'1'),(73,'seller_registrar','Email to Administrator',7,'1'),(74,'seller_registrar','Order Status',8,'1'),(75,'seller_registrar','Gift Certificate',9,'1'),(76,'seller_registrar','Bulk Image Upload',10,'1'),(77,'seller_registrar','Bulk Product Upload',11,'1'),(78,'seller_registrar','Email Templates',12,'1');

--
-- Table structure for table `multicart_homepagebanners`
--

CREATE TABLE `multicart_homepagebanners` (
  `homepage_banner_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `image` varchar(250) NOT NULL,
  `deleted` enum('Y','N') NOT NULL DEFAULT 'N',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `link` varchar(255) NOT NULL,
  `cdn_images_moved` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`homepage_banner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_homepagebanners`
--

INSERT INTO `multicart_homepagebanners` VALUES (14,'banner1507286039.jpg','N','2017-10-06 10:33:59','','N'),(11,'banner1501383423.jpg','Y','2017-07-30 02:57:03','','N'),(6,'banner1501382536.jpg','N','2017-07-30 02:42:16','','N'),(8,'banner1501382670.jpg','N','2017-07-30 02:44:30','','N'),(9,'banner1501382803.jpg','N','2017-07-30 02:46:43','','N'),(15,'banner1507286108.jpg','N','2017-10-06 10:35:08','','N');

--
-- Table structure for table `multicart_language_master`
--

CREATE TABLE `multicart_language_master` (
  `nlanguageId` int(10) NOT NULL AUTO_INCREMENT,
  `languageName` varchar(50) NOT NULL DEFAULT '0',
  `prevLanguage` varchar(50) DEFAULT '0',
  `backupFile` varchar(500) DEFAULT '0',
  `langActive` enum('0','1') DEFAULT '0',
  `langDeleteStatus` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`nlanguageId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_language_master`
--

INSERT INTO `multicart_language_master` VALUES (1,'english','0','0','1','0');

--
-- Table structure for table `multicart_mailbox`
--

CREATE TABLE `multicart_mailbox` (
  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
  `mail_subject` varchar(45) DEFAULT NULL,
  `mail_msg` text,
  `mail_senderid` int(11) DEFAULT NULL,
  `mail_receiverid` int(11) DEFAULT NULL,
  `mail_status` int(11) DEFAULT NULL,
  `mail_allstatus` text,
  `mail_parent_id` int(11) NOT NULL,
  `mail_sub_id` int(11) NOT NULL,
  `mail_userroll` int(11) DEFAULT NULL,
  `mail_sendtime` datetime DEFAULT NULL,
  `mail_delsender` int(11) NOT NULL,
  PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `multicart_mailbox`
--

INSERT INTO `multicart_mailbox` VALUES (7,'test','test mail',0,6,0,'',0,0,0,'2017-08-08 03:54:15',0),(8,'Testing notification','Hi Admin,\r\nTesting notification . Please ignore.',1,0,1,'',0,0,0,'2017-08-08 04:18:37',0),(9,'Testing notification','Thanks. Ignored',0,1,1,'',8,8,0,'2017-08-08 04:31:42',0),(10,'Hows the track download now','Hows the track download now is it posssible',0,1,1,'',10,0,0,'2017-08-12 10:53:28',0),(11,'Hows the track download now','Ys its good and working fine.',1,0,1,'',10,10,0,'2017-08-12 10:54:32',0),(12,'test','sdfsdfs',0,2,0,'',12,0,0,'2017-08-19 01:56:21',0),(13,'dfdfdf','dfd cvcvcvcvcvcv',22,0,1,'',13,0,0,'2017-09-22 02:11:40',0),(14,'dfdfdf','test reply options zxxxxcxcxc',0,1,0,'',13,13,0,'2017-09-22 03:05:01',0),(15,'hjhhj','hjhjhj nmnm \'fgfg\' cvcvcvcvcv',0,22,1,'',15,0,0,'2017-09-22 03:06:09',0),(16,'dfdfdf','ggggg :)',22,0,0,'',13,13,0,'2017-09-22 03:06:37',0),(17,'hjhhj','dfgfg fgfgfg fvgfg\' vb\'bvbv \"FgF\"g cvcvcvc 34 Dfdf&vbdfdfdfdf dxfdfdf',22,0,1,'',15,15,0,'2017-09-22 03:06:56',0),(18,'test sn sdb sndbsd sdmnsbdmnsd dnsdsdsdsdsd','jhjhjhjhjhj  bvbvbvb\r\nvbvb\r\nvbvb\r\nvbvbvbvb\r\nvbvbvb cvvc cv\r\nmn,m,m\r\n cvbvbvbvbvb',22,0,1,'',18,0,0,'2017-09-22 03:09:15',0),(19,'hjhhj','eeeeeeeeeeee',0,1,0,'',15,17,0,'2017-09-22 03:10:11',0),(20,'test sn sdb sndbsd sdmnsbdmnsd dnsdsdsdsdsd','jhjhjhjhjhj  bvbvbvb\r\nvbvb\r\nvbvb\r\nvbvbvbvb\r\nvbvbvb cvvc cv\r\nmn,m,m\r\n cvbvbvbvbvb',22,0,0,'',20,0,0,'2017-09-22 03:10:16',0),(21,'test sn sdb sndbsd sdmnsbdmnsd dnsdsdsdsdsd','jhjhjhjhjhj  bvbvbvb\r\nvbvb\r\nvbvb\r\nvbvbvbvb\r\nvbvbvb cvvc cv\r\nmn,m,m\r\n cvbvbvbvbvb',22,0,0,'',21,0,0,'2017-09-22 03:11:00',0),(22,'test sn sdb sndbsd sdmnsbdmnsd dnsdsdsdsdsd','svdsghd dfvbdf wbw fbdfd dfbdv ddf dfbndfeer dfbn dfd',0,22,1,'',18,18,0,'2017-09-22 03:12:52',0);

--
-- Table structure for table `multicart_message_to_seller`
--

CREATE TABLE `multicart_message_to_seller` (
  `message_to_seller_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `artist_id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `message` text NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `read` enum('Y','N') NOT NULL DEFAULT 'N',
  `seller_viewed_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`message_to_seller_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_message_to_seller`
--


--
-- Table structure for table `multicart_metatags`
--

CREATE TABLE `multicart_metatags` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `vTitle` varchar(200) DEFAULT NULL,
  `vKeywords` text,
  `vDescription` text,
  `vPageName` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_metatags`
--

INSERT INTO `multicart_metatags` VALUES (1,'SubTracs || Beat Tapes','SubTracs , instrumental Tracks, licensing.','SubTracs , Musical Tracks','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');

--
-- Table structure for table `multicart_newsletters`
--

CREATE TABLE `multicart_newsletters` (
  `nl_id` int(11) NOT NULL AUTO_INCREMENT,
  `nl_subject` varchar(200) NOT NULL DEFAULT '',
  `nl_message` text NOT NULL,
  `nl_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`nl_id`),
  UNIQUE KEY `nl_id` (`nl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_newsletters`
--

INSERT INTO `multicart_newsletters` VALUES (1,'rrtrt','<p>vbvbvbvbvbvb</p>','2017-09-21 06:08:30'),(2,'Testing Newsletter','<p>Testing Newsletter</p>','2017-09-25 12:41:32'),(3,'dfdfdfdf','<p>dfdfdfdfvcvcvcv cvdc abavsagvsabsv absva sbavs &quot;DfD&quot;Fdf sdsdsdsd</p>','2017-10-06 06:20:41'),(4,'yuuuuuuuuuuunererer DF\"F\" cvcvc','<p>cvcvc wenbwewe &quot;DfDf&#39; nxcxcxc ddf</p>\r\n\r\n<p>&nbsp;xxcxc sdbsds&nbsp; sdb sbd sdsd&nbsp; vv cvcvc cv</p>\r\n\r\n<p><img alt=\"\" src=\"https://static.pexels.com/photos/248797/pexels-photo-248797.jpeg\" style=\"height:200px; width:500px\" /></p>','2017-10-06 10:28:52');

--
-- Table structure for table `multicart_options`
--

CREATE TABLE `multicart_options` (
  `option_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(250) NOT NULL,
  PRIMARY KEY (`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_options`
--


--
-- Table structure for table `multicart_order_details`
--

CREATE TABLE `multicart_order_details` (
  `order_detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `product_option_id` int(11) NOT NULL,
  `product_name` varchar(200) DEFAULT NULL,
  `product_code` varchar(20) DEFAULT NULL,
  `product_price` double DEFAULT NULL,
  `product_tax` float NOT NULL,
  `product_quantity` int(11) DEFAULT NULL,
  `artist_id` bigint(20) DEFAULT NULL,
  `item_status` smallint(6) DEFAULT NULL,
  `artist_payment_status` smallint(6) DEFAULT NULL,
  `artist_payment_id` bigint(20) DEFAULT NULL,
  `user_refund_id` bigint(20) DEFAULT '0',
  `product_discount` int(11) DEFAULT '0',
  `item_delivery_date` datetime NOT NULL,
  `product_commission_amount` float NOT NULL DEFAULT '0',
  `digital_product_flag` enum('Y','N') DEFAULT 'N',
  `gift_product_flag` enum('Y','N') DEFAULT 'N',
  `subscription_product_flag` enum('Y','N') DEFAULT 'N',
  `product_shipping_price` float DEFAULT '0',
  `product_shipping_name` varchar(255) DEFAULT NULL,
  `allow_free_shipping` enum('Y','N') DEFAULT 'N',
  PRIMARY KEY (`order_detail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_order_details`
--


--
-- Table structure for table `multicart_order_status`
--

CREATE TABLE `multicart_order_status` (
  `order_status_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `order_status` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`order_status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_order_status`
--

INSERT INTO `multicart_order_status` VALUES (1,'Pending'),(2,'Cancelled'),(3,'Shipped'),(4,'Delivered');

--
-- Table structure for table `multicart_orders`
--

CREATE TABLE `multicart_orders` (
  `order_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `billing_first_name` varchar(100) DEFAULT NULL,
  `billing_last_name` varchar(100) DEFAULT NULL,
  `billing_address1` varchar(100) DEFAULT NULL,
  `billing_address2` varchar(100) DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL,
  `billing_country` varchar(100) DEFAULT NULL,
  `billing_zip` varchar(20) DEFAULT NULL,
  `billing_fax` varchar(30) DEFAULT NULL,
  `billing_email` varchar(100) DEFAULT NULL,
  `billing_phone` varchar(20) DEFAULT NULL,
  `shipping_first_name` varchar(100) DEFAULT NULL,
  `shipping_last_name` varchar(100) DEFAULT NULL,
  `shipping_address1` varchar(100) DEFAULT NULL,
  `shipping_address2` varchar(100) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_state` varchar(100) DEFAULT NULL,
  `shipping_country` varchar(100) DEFAULT NULL,
  `shipping_zip` varchar(20) DEFAULT NULL,
  `shipping_fax` varchar(20) DEFAULT NULL,
  `shipping_email` varchar(100) DEFAULT NULL,
  `shipping_phone` varchar(20) DEFAULT NULL,
  `prefered_shippin_method` varchar(200) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `order_total_price` double DEFAULT NULL,
  `taxrate` double DEFAULT '0',
  `couponCode` varchar(50) NOT NULL DEFAULT '0',
  `couponCodeDiscount` float NOT NULL DEFAULT '0',
  `couponCodeSeller_Id` int(11) NOT NULL DEFAULT '0',
  `order_status` tinyint(4) DEFAULT NULL,
  `vorder_currency` varchar(10) NOT NULL DEFAULT '',
  `vpayment_status` char(1) NOT NULL DEFAULT '',
  `transaction_id` varchar(255) DEFAULT NULL,
  `vgiftcertificate_code` varchar(255) NOT NULL DEFAULT '',
  `nused_gift_amount` double NOT NULL DEFAULT '0',
  `namount_paid` double NOT NULL DEFAULT '0',
  `buyer_comments` text NOT NULL,
  `payment_completed_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `seller_viewed_status` tinyint(1) NOT NULL DEFAULT '0',
  `is_subscription_order` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`order_id`),
  KEY `paymentstatus` (`vpayment_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_orders`
--


--
-- Table structure for table `multicart_product_impression`
--

CREATE TABLE `multicart_product_impression` (
  `product_impression_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) NOT NULL,
  `ip` varchar(250) NOT NULL,
  `visited_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`product_impression_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_product_impression`
--

INSERT INTO `multicart_product_impression` VALUES (1,3,'127.0.0.1','2017-06-28 16:07:28'),(2,1,'127.0.0.1','2017-06-29 17:48:33'),(3,4,'182.72.159.3','2017-07-07 12:04:52'),(4,4,'182.72.159.3','2017-07-12 08:59:39'),(5,10,'182.72.159.3','2017-07-12 10:51:10'),(6,10,'173.252.123.134','2017-07-12 10:55:14'),(7,10,'66.220.148.166','2017-07-12 10:55:16'),(8,11,'64.233.173.55','2017-07-14 15:43:22'),(9,18,'172.125.166.226','2017-07-17 00:56:42'),(10,10,'182.72.159.3','2017-07-18 10:22:46'),(11,4,'182.72.159.3','2017-07-18 10:36:03'),(12,10,'172.125.166.226','2017-07-18 10:50:25'),(13,1,'107.211.200.119','2017-07-19 15:42:19'),(14,4,'107.211.200.119','2017-07-19 15:43:01'),(15,18,'107.211.200.119','2017-07-19 15:43:09'),(16,9,'107.211.200.119','2017-07-19 15:43:38'),(17,18,'182.72.159.3','2017-07-21 04:58:12'),(18,10,'182.72.159.3','2017-07-21 05:11:06'),(19,4,'107.211.200.119','2017-07-24 17:39:12'),(20,10,'107.211.200.119','2017-07-24 17:39:35'),(21,19,'172.125.166.226','2017-07-25 00:44:44'),(22,10,'182.72.159.3','2017-07-25 10:02:30'),(23,18,'172.125.166.226','2017-07-30 03:39:47'),(24,17,'172.125.166.226','2017-07-30 03:39:53'),(25,10,'172.125.166.226','2017-07-30 03:39:56'),(26,4,'172.125.166.226','2017-07-30 03:40:13'),(27,10,'73.184.138.203','2017-07-30 17:08:54'),(28,1,'172.125.166.226','2017-07-31 21:51:30'),(29,17,'107.211.200.119','2017-08-01 20:38:51'),(30,3,'172.125.166.226','2017-08-02 16:43:14'),(31,1,'172.125.166.226','2017-08-02 16:43:25'),(32,18,'107.211.200.119','2017-08-03 16:05:38'),(33,10,'107.211.200.119','2017-08-03 16:05:56'),(34,10,'172.125.166.226','2017-08-06 00:36:13'),(35,11,'172.125.166.226','2017-08-06 03:14:19'),(36,18,'107.211.200.119','2017-08-07 14:15:49'),(37,17,'107.211.200.119','2017-08-07 14:15:56'),(38,4,'107.211.200.119','2017-08-07 14:16:05'),(39,3,'107.211.200.119','2017-08-07 14:16:15'),(40,10,'182.72.159.3','2017-08-08 09:57:16'),(41,10,'172.125.166.226','2017-08-08 11:02:08'),(42,18,'107.211.200.119','2017-08-08 17:12:22'),(43,10,'182.72.159.3','2017-08-10 10:43:59'),(44,24,'172.125.166.226','2017-08-14 01:36:36'),(45,1,'172.125.166.226','2017-08-14 02:04:20'),(46,23,'172.125.166.226','2017-08-17 10:51:27'),(47,24,'182.72.159.3','2017-08-17 10:52:08'),(48,24,'172.125.166.226','2017-08-17 10:52:09'),(49,60,'182.72.159.3','2017-10-09 12:22:46');

--
-- Table structure for table `multicart_product_listing_fee_payment`
--

CREATE TABLE `multicart_product_listing_fee_payment` (
  `product_listing_fee_payment_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `amount_paid` int(11) NOT NULL,
  `payment_method` varchar(250) NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `payment_status` enum('PENDING','COMPLETED') NOT NULL,
  PRIMARY KEY (`product_listing_fee_payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_product_listing_fee_payment`
--


--
-- Table structure for table `multicart_product_option_values`
--

CREATE TABLE `multicart_product_option_values` (
  `product_option_value_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_option_id` bigint(20) NOT NULL,
  `option_id` bigint(20) NOT NULL,
  `value` varchar(250) NOT NULL,
  PRIMARY KEY (`product_option_value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_product_option_values`
--


--
-- Table structure for table `multicart_product_options`
--

CREATE TABLE `multicart_product_options` (
  `product_option_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) NOT NULL,
  `additional_price` float NOT NULL,
  `image_small` varchar(250) NOT NULL,
  `image_big` varchar(250) NOT NULL,
  `product_stock` int(11) NOT NULL,
  `reorder_level` int(11) NOT NULL,
  `product_shipping_weight` float NOT NULL,
  `default_option` enum('YES','NO') NOT NULL DEFAULT 'YES',
  `discount` float NOT NULL,
  `discount_description` varchar(250) NOT NULL,
  `product_width` int(11) NOT NULL,
  `product_height` int(11) NOT NULL,
  `product_length` int(11) NOT NULL,
  `cdn_images_moved` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`product_option_id`),
  KEY `defaultoption` (`product_id`,`default_option`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_product_options`
--

INSERT INTO `multicart_product_options` VALUES (1,1,0,'productsmall__0_1497957440Old-School-Vibes.jpg','productbig__0_1497957440Old-School-Vibes.jpg',1000,0,0,'YES',0,'',0,0,0,'N'),(3,3,0,'productsmall__0_1498205144banner1.jpg','productbig__0_1498205144banner1.jpg',100,0,1,'YES',0,'',0,0,0,'N'),(4,4,0,'productsmall__0_1498205222banner2.jpg','productbig__0_1498205222banner2.jpg',100,0,1,'YES',0,'',0,0,0,'N');

--
-- Table structure for table `multicart_product_view_images`
--

CREATE TABLE `multicart_product_view_images` (
  `nproduct_image_id` int(11) NOT NULL AUTO_INCREMENT,
  `nimage_productid` int(11) NOT NULL DEFAULT '0',
  `vimage_name` varchar(250) NOT NULL DEFAULT '',
  `vimage_description` text NOT NULL,
  `vproduct_image_delete_status` char(1) NOT NULL DEFAULT '',
  `cdn_images_moved` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`nproduct_image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_product_view_images`
--


--
-- Table structure for table `multicart_products`
--

CREATE TABLE `multicart_products` (
  `product_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) DEFAULT NULL,
  `product_code` varchar(20) DEFAULT NULL,
  `product_description` text,
  `product_price` double DEFAULT NULL,
  `product_category` int(11) DEFAULT NULL,
  `product_artist_id` int(11) DEFAULT NULL,
  `date_added` date DEFAULT NULL,
  `deleted` char(1) DEFAULT 'N',
  `featured` char(1) DEFAULT 'N',
  `vdigital_product` char(1) NOT NULL DEFAULT '',
  `vapproved` char(2) NOT NULL DEFAULT 'N',
  `payment_status` enum('PENDING','COMPLETED') NOT NULL DEFAULT 'PENDING',
  `seller_viewed_status` tinyint(1) NOT NULL DEFAULT '0',
  `alias` varchar(100) DEFAULT NULL,
  `publish_status` char(1) DEFAULT 'N',
  `publish_scheduled_date` datetime DEFAULT NULL,
  `allow_free_shipping` enum('Y','N') DEFAULT 'N' COMMENT 'Allow free shipping for products',
  `allow_subscription` enum('Y','N') DEFAULT 'N' COMMENT 'Allow free subscription for products',
  `subscription_mode` enum('Daily','Monthly','Yearly') DEFAULT 'Monthly' COMMENT 'Subscription modes',
  `product_tags` text COMMENT 'Product tags for easy searching',
  `publish_timezone` varchar(255) DEFAULT NULL COMMENT 'timezone to publish product',
  `seller_vacation_mode` enum('Y','N') DEFAULT 'N' COMMENT ' N=Vacation mode  not ebaled , Y= Vacation mode enabled',
  `default_image_small` varchar(255) DEFAULT NULL COMMENT 'default image for listing pages',
  `default_stock` int(11) DEFAULT '0' COMMENT 'sum of all  option stock value ',
  `default_additional_price` float DEFAULT '0' COMMENT 'default option additional price value',
  `default_shipping_weight` float DEFAULT '0' COMMENT 'default option weight',
  `default_discount` float DEFAULT '0' COMMENT 'default option discount % ',
  `default_discount_description` varchar(250) DEFAULT NULL COMMENT 'default option discount description ',
  `vSellerStatus` enum('Y','N') DEFAULT 'Y' COMMENT 'seller status',
  `default_option_id` int(11) DEFAULT NULL COMMENT 'default option id refered from product options table',
  `seller_name` varchar(255) DEFAULT NULL COMMENT 'save seller name',
  PRIMARY KEY (`product_id`),
  KEY `vapproved` (`vapproved`),
  KEY `date_added` (`date_added`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_products`
--

INSERT INTO `multicart_products` VALUES (1,'Track1','','<p><span style=\\\"color:rgb(71, 81, 89); font-family:sharpsansno1,avenir,futura,sans-serif; font-size:21px\\\">To access this pack and over 2,000 others you must subscribe to Splice Sounds.</span></p>\r\n',2,2,1,'2017-06-20','N','N','Y','Y','COMPLETED',1,'track1','Y','0000-00-00 00:00:00','Y','N','',NULL,'','N','productsmall__0_1497957440Old-School-Vibes.jpg',0,0,0,0,'','Y',1,'remya'),(3,'Track3','','<p>Track3</p>\r\n',5,2,1,'2017-06-23','N','N','N','Y','COMPLETED',0,'track3','Y','0000-00-00 00:00:00','N','N','',NULL,'','N','productsmall__0_1498205144banner1.jpg',0,0,1,0,'','Y',3,'remya'),(4,'Track4','','<p>Track4</p>\r\n',7,3,1,'2017-06-23','N','N','N','Y','COMPLETED',0,'track4','Y','0000-00-00 00:00:00','N','N','',NULL,'','N','productsmall__0_1498205222banner2.jpg',0,0,1,0,'','Y',4,'remya');

--
-- Table structure for table `multicart_rating`
--

CREATE TABLE `multicart_rating` (
  `nrat_id` int(11) NOT NULL AUTO_INCREMENT,
  `vrating` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`nrat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_rating`
--

INSERT INTO `multicart_rating` VALUES (1,'poor'),(2,'good'),(3,'very good'),(4,'excellent');

--
-- Table structure for table `multicart_record_ratings`
--

CREATE TABLE `multicart_record_ratings` (
  `nrts_id` int(11) NOT NULL AUTO_INCREMENT,
  `nrating_id` int(11) NOT NULL DEFAULT '0',
  `nruser_id` int(11) NOT NULL DEFAULT '0',
  `nrseller_id` int(11) NOT NULL DEFAULT '0',
  `ntotal_ratings` int(11) NOT NULL DEFAULT '0',
  `vType` char(1) NOT NULL DEFAULT 's',
  `vActive` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`nrts_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_record_ratings`
--


--
-- Table structure for table `multicart_refunds`
--

CREATE TABLE `multicart_refunds` (
  `refund_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `seller_id` bigint(20) NOT NULL DEFAULT '0',
  `buyer_id` bigint(20) NOT NULL DEFAULT '0',
  `product_id` bigint(20) NOT NULL DEFAULT '0',
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `quantity` bigint(20) DEFAULT NULL,
  `return_reason` text NOT NULL,
  `Customer_Feedback` text,
  `Status` varchar(255) DEFAULT NULL,
  `Additional_info` text,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `refund_mode` varchar(255) DEFAULT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `seller_viewed_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`refund_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_refunds`
--


--
-- Table structure for table `multicart_report_product`
--

CREATE TABLE `multicart_report_product` (
  `nreport_id` int(11) NOT NULL AUTO_INCREMENT,
  `nreport_product_id` int(11) NOT NULL DEFAULT '0',
  `nreport_customerid` int(11) NOT NULL DEFAULT '0',
  `nproduct_view_count` int(11) NOT NULL DEFAULT '0',
  `dproduct_view_date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`nreport_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_report_product`
--


--
-- Table structure for table `multicart_sellerPlans`
--

CREATE TABLE `multicart_sellerPlans` (
  `plan_Id` int(11) NOT NULL AUTO_INCREMENT,
  `plan_Title` varchar(100) NOT NULL DEFAULT '',
  `plan_Description` text NOT NULL,
  `plan_Period` char(1) NOT NULL DEFAULT '',
  `plan_SubscriptionCharge` double NOT NULL DEFAULT '0',
  `plan_Status` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`plan_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `multicart_sellerPlans`
--

INSERT INTO `multicart_sellerPlans` VALUES (1,'Premium','	<ul >\r\n											<li> <h6>5 Hours  / Month </h6></li>\r\n											                                                                                        <li><h6> Trial Period :  15 Days <h6></li>\r\n                                                                                                                                                                               											\r\n                                                                                      <li>   5 updates per month\r\n</li><li>\r\n</li><li>   1  business day turnaround\r\n</li><li>  \r\n</li><li>  Free service consultations\r\n</li><li> \r\n</li><li> Suitable for large websites\r\n</li><li>\r\n</li><li> Utilize unused hours for next month\r\n</li><li>  </li>              \r\n											                                                                                    		\r\n											<li><a class=\"btn btn-default\" href=\"#\">Continue</a></li>\r\n										                    </ul>','Y',20,'Y'),(2,'Basic','<ul >\r\n											<li> <h6>2 Hours  / Month </h6></li>\r\n											                                                                                        <li><h6> Trial Period :  15 Days <h6></li>\r\n                                                                                                                                                                               											\r\n                                                                                      <li>  1 update per month\r\n</li><li>\r\n</li><li>   2  business day turnaround\r\n</li><li>\r\n</li><li>   Free service consultations\r\n</li><li> \r\n</li><li>  Suitable for less than 10 page static websites\r\n</li><li>\r\n</li><li>Utilize unused hours for next month\r\n</li><li>  </li>              \r\n											                                                                                    		\r\n											<li><a class=\"btn btn-default\" href=\"#\">Continue</a></li>\r\n										                    </ul>','M',10,'Y');

--
-- Table structure for table `multicart_seller_favourites`
--

CREATE TABLE `multicart_seller_favourites` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nUserId` int(11) DEFAULT '0',
  `nSellerId` int(11) DEFAULT '0',
  `dDate` datetime DEFAULT NULL,
  `status` enum('Y','N') DEFAULT 'Y',
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='store favourites sellers';

--
