MultiMerch 8.x Developer Reference
This reference is intended to provide MultiMerch developers with information on core MultiMerch structures and systems.
For a more detailed reference, see MultiMerch code comments.
MultiMerch application directory structure
MultiMerch follows OpenCart's regular MVC system with a number of additional files and directories.
+---admin < Admin-area MultiMerch MVC | +---controller < Admin-area MultiMerch controllers | | +---module < Module controllers | | | multimerch.php < Core MultiMerch controller (setup & setting management) | | | multimerch_newsellers.php < New sellers module controller | | | multimerch_topsellers.php < Top sellers module controller | | | | | +---multimerch < Interface controllers (admin-area MultiMerch pages) | | | | attribute.php < Attribute management | | | | badge.php < Badge management | | | | base.php | | | | category.php < Category management | | | | conversation.php < Conversation management | | | | coupon.php < Coupon management | | | | custom-field.php < Custom fields | | | | dashboard.php < Dashboards | | | | debug.php < Debug info | | | | event.php < Events | | | | import.php < Import management | | | | option.php < Options | | | | order.php < Orders | | | | payment-gateway.php < Payment gateways | | | | payment-request.php < Payment requests | | | | payment.php < Payments | | | | payout.php < Payouts | | | | product.php < Products | | | | question.php < Product questions | | | | reportbase.php < Report base controller | | | | review.php < Reviews | | | | seller-group.php < Seller groups | | | | seller.php < Sellers | | | | settings.php < Settings | | | | shipping-method.php < Shipping methods | | | | social_link.php < Social media links | | | | suborder-status.php < Suborders | | | | transaction.php < Transactions | | | | | | | +---payment < MultiMerch payment method controllers | | | | bank_transfer.php < BT | | | | paypal.php < PayPal | | | | | | | \---report < Individual report controllers | | | finances-payment.php < Payment reports | | | finances-payout.php < Payout reports | | | finances-seller.php < Seller reports | | | finances-transaction.php < Transaction reports | | | sales-customer.php < Sales reports | | | sales-day.php | | | sales-month.php | | | sales-product.php | | | sales-seller.php | | | sales.php | | | | | +---payment < MultiMerch payment extensions for OpenCart | | | ms_pp_adaptive.php < MultiMerch PayPal Adaptive payment gateway controller | | | | | \---total < MultiMerch order totals | | mm_shipping_total.php | | ms_coupon.php | | | +---language < Admin-area MultiMerch language files | | \---en-gb | | +---module | | | multimerch.php | | | multimerch_newsellers.php | | | multimerch_topsellers.php | | | | | +---multimerch | | | \---payment | | | bank_transfer.php | | | paypal.php | | | | | +---multiseller | | | multiseller.php < Core admin-area MultiMerch language file | | | | | +---payment | | | ms_pp_adaptive.php | | | | | \---total | | mm_shipping_total.php | | ms_coupon.php | | | +---model < Admin-area MultiMerch models | | \---multimerch | | install.php < MultiMerch setup routines | | upgrade.php < MultiMerch upgrade routines | | | \---view < Admin-area MultiMerch views and scripts | +---image <..> < Various MultiMerch images | | | | | \---multiseller <..> | | | | | \---payment <..> | | | +---javascript < Admin-area MultiMerch JavaScripts | | \---multimerch | | | attribute.js < Attribute listing | | | category-form.js < Single category edit form | | | category.js < Category listing | | | common.js < Common MultiMerch scripts | | | coupon.js < Coupon listing | | | custom-field-form.js < Single custom field edit form | | | custom-field.js < Custom field listing | | | dashboard.js < Dashboard scripts | | | moment.min.js | | | option.js < Option listing | | | payment-form.js < Payment execution form (payouts) | | | payment-request.js < Invoice listing | | | payment.js < Payment listing | | | payout-confirm.js < Payout confirmation form | | | payout-view.js < Single payout views | | | payout.js < Payout listing | | | question.js < Question listing | | | review.js < Review listing | | | settings.js < MultiMerch settings | | | | | +---chartjs <..> | | | | | +---datatables <..> | | | | | +---daterangepicker <..> | | | | | +---report < Individual MultiMerch report scripts | | | date_ranges.js | | | finances-payment.js | | | finances-payout.js | | | finances-seller.js | | | finances-transaction.js | | | report_datatables.js | | | sales-customer.js | | | sales-day.js | | | sales-month.js | | | sales-product.js | | | sales-seller.js | | | sales.js | | | | | \---tag-editor <..> | | | +---stylesheet < Admin-area MultiMerch styles | | \---multimerch | | | dashboard.css < Dashboard styles | | | multiseller.css < Core styles | | | | | \---payment | | bank_transfer.css | | | \---template < Admin-area MultiMerch templates | +---module < Module templates (new/top sellers) | | multimerch_newsellers.tpl | | multimerch_topsellers.tpl | | | +---multimerch < MultiMerch core templates (new structure) | | | dashboard.tpl < Dashboard page | | | settings.tpl < Setting page | | | | | +---payment < MultiMerch payment method templates | | | bank_transfer.tpl < Bank Transfer module configuration form | | | bank_transfer_payment_form.tpl< Bank Transfer payment form | | | bank_transfer_settings_form.tpl < Bank Transfer setting form | | | paypal.tpl < PayPal module configuration form | | | paypal_payment_form.tpl < PayPal MassPay payment form | | | paypal_settings_form.tpl < PayPal setting form | | | paypal_standard_payment_form.tpl < PayPal Standard payment form | | | | | \---report < MultiMerch report templates | | finances-payment.tpl | | finances-payout.tpl | | finances-seller.tpl | | finances-transaction.tpl | | sales-customer.tpl | | sales-day.tpl | | sales-month.tpl | | sales-product.tpl | | sales-seller.tpl | | sales.tpl | | | +---multiseller < MultiMerch core templates (old structure) | | attribute.tpl | | badge-form.tpl | | badge.tpl | | category-form.tpl | | category.tpl | | conversation.tpl | | conversation_view.tpl | | coupon.tpl | | custom-field-form.tpl | | custom-field-group-form.tpl | | custom-field.tpl | | debug.tpl | | dialog-withdrawal-markpaid.tpl | | event.tpl | | import-list.tpl | | option.tpl | | order.tpl | | payment-form.tpl | | payment-gateway.tpl | | payment-request.tpl | | payment.tpl | | payout-confirm.tpl | | payout-view.tpl | | payout.tpl | | product.tpl | | question-form.tpl | | question.tpl | | review-form.tpl | | review.tpl | | seller-form.tpl | | seller-group-form.tpl | | seller-group.tpl | | seller.tpl | | shipping-method-form.tpl | | shipping-method.tpl | | social_link.tpl | | social_link_form.tpl | | suborder-status-form.tpl | | suborder-status.tpl | | transaction-form.tpl | | transaction.tpl | | | +---payment < PayPal Adaptive settings | | ms_pp_adaptive.tpl | | | \---total < Order total settings | mm_shipping_total.tpl | ms_coupon.tpl | +---catalog < Catalog-area MultiMerch MVC | +---controller < Catalog-area MultiMerch controllers | | +---account < Customer account / common account MultiMerch controllers | | | msconversation.php < Conversation management controller (My conversations) | | | msmessage.php < Individual message management controller (View conversation) | | | register-seller.php < Register seller Step 1 controller | | | | | +---catalog < Front autocomplete controllers | | | filter.php < Filter autocomplete | | | product.php < Related product autocomplete | | | | | +---customer < Customer review management | | | review.php | | | | | +---module < Front module controllers (new/top sellers) | | | multimerch_newsellers.php | | | multimerch_topsellers.php | | | | | +---multimerch | | | | account_account.php < OpenCart customer account controller override | | | | account_order.php < OpenCart customer order list controller override | | | | cart_coupon.php < Cart coupon controller | | | | checkout_shipping_method.php < MultiMerch shipping method controller (Step 4 checkout) | | | | module_account.php < OpenCart account sidebar controller override | | | | product_question.php < Product question tab (product page) | | | | product_review.php < Product review tab (product page) | | | | product_shipping.php < Product shipping tab (product page) | | | | | | | \---payment < MultiMerch payment method controllers (front) | | | bank_transfer.php | | | paypal.php | | | | | +---payment < PayPal Adaptive controller (front) | | | ms_pp_adaptive.php | | | | | +---seller < Core MultiMerch seller account controllers | | | | account-attribute.php < Attribute management | | | | account-category.php < Category management | | | | account-coupon.php < Coupon management | | | | account-dashboard.php < Seller's dashboard | | | | account-import.php < Mass product imports | | | | account-option.php < Option management | | | | account-order.php < Order management | | | | account-payment-request.php < Invoice management | | | | account-payment.php < Payment management | | | | account-product.php < Product management | | | | account-profile.php < Seller's profile edit form | | | | account-question.php < Product question management | | | | account-review.php < Product review management | | | | account-setting.php < Seller's settings | | | | account-stats.php < Seller stats | | | | account-transaction.php < Transactions | | | | account.php < Base account controller (common routines) | | | | catalog-seller.php < Catalog controller (list of sellers, seller's profile and store) | | | | catalog.php < Base catalog controller (common routines) | | | | report.php < Base report controller (common routines) | | | | | | | \---report < Seller report controllers (Account > Reports) | | | finances-payment.php | | | finances-payout.php | | | finances-transaction.php | | | sales-day.php | | | sales-month.php | | | sales-product.php | | | sales.php | | | | | \---startup < MultiMerch core startup controllers | | multimerch_seo_microdata.php < SEO microdata controller | | multimerch_seo_url.php < MultiMerch SEO core controller | | | +---language < MultiMerch catalog language files | | \---en-gb | | +---multimerch | | | | import-export.php | | | | | | | \---payment | | | bank_transfer.php | | | paypal.php | | | | | +---multiseller | | | multiseller.php < Core MultiMerch catalog language file | | | | | \---payment | | ms_pp_adaptive.php | | | +---model < MultiMerch catalog models (OC compatibility + shipping totals) | | +---catalog | | | option.php | | | | | +---localisation | | | length_class.php | | | order_status.php | | | weight_class.php | | | | | +---payment | | | ms_pp_adaptive.php | | | | | \---total | | mm_shipping_total.php | | ms_coupon.php | | | \---view < Catalog-area MultiMerch views and scripts | +---javascript < MultiMerch JavaScripts | | | account-product-form.js < Seller's product listing form scripts | | | account-seller-profile.js < Seller's profile edit form scripts | | | account-settings.js < Seller settings | | | dialog-sellercontact.js < Contact seller dialog | | | ms-common.js < Common scripts | | | ms-question.js | | | ms-review.js | | | pagination.min.js | | | star-rating.js | | | | | +---multimerch < Core MultiMerch JavaScripts (new structure) | | | | account-attribute.js | | | | account-category-form.js | | | | account-category.js | | | | account-coupon-form.js | | | | account-coupon.js | | | | account-customer-product-review.js | | | | account-dashboard.js | | | | account-import.js | | | | account-message.js | | | | account-option.js | | | | account-payment-form.js | | | | account-product-form-options.js | | | | account-question.js | | | | account-register-seller.js | | | | account-review.js | | | | account-seller-setting.js | | | | common.js | | | | moment.min.js | | | | ms-google-map.js | | | | Sortable.js | | | | | | | +---chartjs <..> | | | +---ckeditor <..> | | | +---datatables <..> | | | +---daterangepicker <..> | | | +---googlemap <..> | | | | | | | +---report < MultiMerch report scripts (Account > Reports) | | | | date_ranges.js | | | | finances-payment.js | | | | finances-payout.js | | | | finances-transaction.js | | | | report_datatables.js | | | | sales-day.js | | | | sales-month.js | | | | sales-product.js | | | | sales.js | | | | | | | +---selectize <..> | | | \---summernote <..> | | | | | \---plupload <..> | | | \---theme < MultiMerch catalog template files | \---default | +---image <..> | | | +---stylesheet < MultiMerch catalog-area styles | | | multimerch_messaging.css | | | multimerch_social_links.css | | | multiseller.css < Core MultiMerch stylesheet | | | pagination.css | | | star-rating.css | | | | | \---multimerch | | | account-dashboard.css < MultiMerch seller's dashboard styles | | | account.css | | | bootstrap-nav-wizard.css | | | flags.css | | | import.css | | | | | \---invoice | | default.css | | | \---template < MultiMerch catalog-area templates | +---account | | register-seller.tpl < Register seller Step 1 form | | | +---customer | | review.tpl < Customer account > Leave a review form | | | +---module | | multimerch_newsellers.tpl | | multimerch_topsellers.tpl | | | +---multimerch < Core MultiMerch templates (new structure) | | +---account < OpenCart template overrides | | | account.tpl < New customer account page | | | order.tpl < New customer order history page | | | order_info.tpl < Order info > Order details by seller block | | | | | +---checkout < MultiMerch checkout templates | | | cart_coupon.tpl | | | shipping_method.tpl < Vendor shipping Step 4 | | | | | +---module | | | account.tpl < MultiMerch account sidebar template | | | | | +---payment < MultiMerch payment method templates (catalog-area) | | | bank_transfer.tpl < Bank Transfer settings (seller account) | | | bank_transfer_payment_form.tpl < Bank Transfer payment form (seller payments) | | | paypal.tpl < PayPal settings (seller account) | | | paypal_payment_form.tpl < PayPal MassPay payment form (seller payments) | | | paypal_standard_payment_form.tpl < PayPal Standard payment form (seller payments) | | | | | \---seo < MultiMerch SEO microdata templates | | \---microdata | | product.tpl | | | +---multiseller < Core MultiMerch templates (old structure), account-* indicate seller account templates | | | account-attribute-form.tpl | | | account-attribute-group-form.tpl | | | account-attribute.tpl | | | account-category-form.tpl | | | account-category.tpl | | | account-conversation.tpl | | | account-coupon-form.tpl | | | account-coupon.tpl | | | account-dashboard.tpl | | | account-message.tpl | | | account-option-form.tpl | | | account-option.tpl | | | account-order-info-conversation.tpl < Conversation block within order details | | | account-order-info.tpl | | | account-order.tpl | | | account-payment-form.tpl < Payment form (e.g. fee payments) | | | account-payment-request.tpl | | | account-payment.tpl | | | account-product-form-options-values.tpl | | | account-product-form-options.tpl | | | account-product-form.tpl | | | account-product.tpl | | | account-profile.tpl | | | account-question-form.tpl | | | account-question.tpl | | | account-review-form.tpl | | | account-review.tpl | | | account-stats.tpl | | | account-transaction.tpl | | | catalog-seller-products.tpl < Seller's store page | | | catalog-seller-profile.tpl < Seller's profile page | | | catalog-seller.tpl < List of sellers page | | | dialog-sellercontact.tpl | | | | | +---import < Mass product import templates | | | account-import.tpl | | | prepare.tpl | | | step1.tpl | | | step2.tpl | | | step3.tpl | | | step4.tpl | | | | | +---invoice < Seller invoice templates | | | body-default.tpl | | | footer.tpl | | | header.tpl | | | | | +---report < Seller report templates | | | finances-payment.tpl | | | finances-payout.tpl | | | finances-transaction.tpl | | | sales-day.tpl | | | sales-month.tpl | | | sales-product.tpl | | | sales.tpl | | | | | \---settings < Seller settings | | default.tpl | | | +---payment | | ms_pp_adaptive.tpl | | | \---product < Product page templates (tabs) | mm_question.tpl | mm_question_answer.tpl | mm_review.tpl | mm_review_comment.tpl | mm_shipping.tpl | +---image <..> < Various MultiMerch catalog-area images | +---system < MultiMerch system files | +---config < MultiMerch config files | | \---multimerch | | ms_import-export-system_full.php | | | +---library < Core MultiMerch models used by both catalog and admin-area controllers | | | msattribute.php < Product attribute management routines | | | msbadge.php < Seller badge management routines | | | msbalance.php < Seller balance management routines | | | mscategory.php | | | mscommission.php | | | msconversation.php | | | mscoupon.php | | | mscustomfield.php | | | msfile.php < MultiMerch file management (uploads) | | | msfilter.php | | | mshelper.php < MultiMerch helper finctions | | | msloader.php < Core MultiMerch loader | | | msmail.php < Core MultiMerch mailer | | | msmessage.php | | | msoption.php | | | msorderdata.php | | | mspayout.php | | | mspgpayment.php | | | mspgrequest.php | | | msproduct.php | | | msquestion.php | | | msreport.php | | | msreturn.php | | | msreview.php | | | msseller.php | | | mssellergroup.php | | | mssetting.php | | | msshippingmethod.php | | | msstatistic.php | | | mssuborder.php | | | mssuborderstatus.php | | | mstransaction.php | | | msvalidator.php < MultiMerch form validator | | | | | \---multimerch < Core MultiMerch models (new structure) | | | msimportexportdata.php < Import/Export data manager | | | msimportexportfile.php < Import/Export file manager | | | mssociallink.php | | | | | \---payment | | paypal.php < PayPal class | | | \---vendor | \---multimerchlib < MultiMerch libraries (new structure, late 8.x versions) | +---config < MultiMerch configs | | config.php | | factory.php | | | +---core < Core MultiMerch libraries | | | hook.php < MultiMerch hook system | | | | | \---event < MultiMerch event system | | | eventmanager.php | | | handler.php | | | | | \---handlers | | log.php | | mail.php | | marketplaceactivity.php | | | +---event < MultiMerch event system (old) | | event.php | | eventcollection.php | | eventmanager.php | | | +---logger < MultiMerch logger | | | logger.php | | | loggerinterface.php | | | | | \---handler | | filehandler.php | | handlerinterface.php | | | +---mail < MultiMerch mail handlers (deprecated) | | +---exception | | | transport.php | | | | | +---message < Core message library | | | | message.php | | | | messagecollection.php | | | | | | | +---admin < Admin emails | | | | editproductawaitingmoderation.php | | | | newproductawaitingmoderation.php | | | | productcreated.php | | | | selleraccountcreated.php | | | | sellerawaitingmoderation.php | | | | withdrawrequestsubmitted.php | | | | | | | +---catalog < Catalog emails | | | | attributeconvertedtoglobal.php | | | | attributecreated.php | | | | attributegroupcreated.php | | | | attributegroupstatuschanged.php | | | | attributesellerchanged.php | | | | attributestatuschanged.php | | | | categorycreated.php | | | | categorystatuschanged.php | | | | optionconvertedtoglobal.php | | | | optioncreated.php | | | | optionsellerchanged.php | | | | optionstatuschanged.php | | | | | | | +---orders | | | | updated.php | | | | | | | +---product < Product-related emails | | | | awaitingmoderation.php | | | | modified.php | | | | purchased.php | | | | returned.php | | | | reviewed.php | | | | | | | +---seller | | | | accountcreated.php | | | | accountmodified.php | | | | awaitingmoderation.php | | | | privatemessage.php | | | | remindlisting.php | | | | | | | +---transaction | | | | performed.php | | | | | | | \---withdraw | | | requestcompleted.php | | | requestdeclined.php | | | requestsubmitted.php | | | | | \---transport < Mail transport libraries | | factory.php | | multimerchmail.php | | sendmail.php | | smtp.php | | | +---module | | | multimerch.php | | | | | +---catalog < MultiMerch mail templates (deprecated) | | | \---view | | | \---theme | | | \---default | | | \---msmail | | | +---admin | | | | edit_product_awaiting_moderation.tpl | | | | new_product_awaiting_moderation.tpl | | | | product_created.tpl | | | | seller_account_created.tpl | | | | seller_awaiting_moderation.tpl | | | | withdraw_request_submitted.tpl | | | | | | | +---catalog | | | | attribute_converted_to_global.tpl | | | | attribute_created.tpl | | | | attribute_group_created.tpl | | | | attribute_group_status_changed.tpl | | | | attribute_seller_changed.tpl | | | | attribute_status_changed.tpl | | | | category_created.tpl | | | | category_status_changed.tpl | | | | option_converted_to_global.tpl | | | | option_created.tpl | | | | option_seller_changed.tpl | | | | option_status_changed.tpl | | | | | | | +---orders | | | | updated.tpl | | | | | | | +---partials | | | | footer.tpl | | | | header.tpl | | | | layout.tpl | | | | | | | +---product | | | | awaiting_moderation.tpl | | | | modified.tpl | | | | purchased.tpl | | | | returned.tpl | | | | reviewed.tpl | | | | | | | +---seller | | | | account_created.tpl | | | | account_modified.tpl | | | | awaiting_moderation.tpl | | | | private_message.tpl | | | | remind_listing.tpl | | | | | | | +---transaction | | | | performed.tpl | | | | | | | \---withdraw | | | request_completed.tpl | | | request_declined.tpl | | | request_submitted.tpl | | | | | \---config < MultiMerch config files | | config.php | | hash_file.json | | multimerch.php | | oc_version.php | | | +---servicelocator | | | factoryinterface.php | | | servicelocator.php | | | servicelocatorawareinterface.php | | | servicelocatorawaretrait.php | | | servicelocatorinterface.php | | | | | \---exception | | servicelocatorexception.php | | | +---stdlib | | arrayutils.php | | cli.php | | cname.php | | files.php | | | +---translator | | factory.php | | translator.php | | translatorinterface.php | | | \---view | | variables.php | | | \---renderer | factory.php | phprenderer.php | \---vqmod \---xml < Core MultiMerch vQmod xml files multimerch_core.xml < Core modifications multimerch_core_admin.xml < Admin-area modifications multimerch_core_overrides.xml < OpenCart template overrides multimerch_core_productpage.xml < Product page modifications multimerch_core_sellerinfos.xml < Modifications related to seller information throughout OpenCart multimerch_core_sellermenu.xml < Seller menus multimerch_core_seo.xml < MultiMerch SEO system hook multimerch_core_seourl.xml < MultiMerch SEO system hook (legacy, deprecated) multimerch_core_transactions.xml < Modifications related to generating seller transactions for orders multimerch_c_hooks.xml < MultiMerch template hooks for theme compatibility multimerch_oc21x_controllerfix.xml_ < OpenCart 2.1 compatibility modifications (deprecated) multimerch_oc23_compatibility_fixes.xml < OpenCart 2.3 compatibility modifications multimerch_pre_oc23_fixes.xml_ < OpenCart 2.0/2.2 compatibility modifications (deprecated)
MultiMerch database structure description
// MultiMerch database version/schema changes (used for upgrades) CREATE TABLE ms_db_schema (schema_change_id int(11) NOT NULL AUTO_INCREMENT,
major TINYINT NOT NULL,minor TINYINT NOT NULL,
build TINYINT NOT NULL,revision SMALLINT NOT NULL,
date_applied DATETIME NOT NULL, PRIMARY KEY (schema_change_id
)) // Commissions (fees) CREATE TABLE ms_commission (commission_id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (
commission_id)) // Commission (fee) rates CREATE TABLE ms_commission_rate (
rate_id int(11) NOT NULL AUTO_INCREMENT,rate_type int(11) NOT NULL,
commission_id int(11) NOT NULL,flat DECIMAL(15,4),
percent DECIMAL(15,2),payment_method TINYINT DEFAULT NULL, PRIMARY KEY (
rate_id)) // Seller groups CREATE TABLE ms_seller_group (
seller_group_id int(11) NOT NULL AUTO_INCREMENT,commission_id int(11) DEFAULT NULL,
product_period int(5) DEFAULT 0,product_quantity int(5) DEFAULT 0, PRIMARY KEY (
seller_group_id)) // Seller group descriptions CREATE TABLE ms_seller_group_description (
seller_group_description_id int(11) NOT NULL AUTO_INCREMENT,seller_group_id int(11) NOT NULL,
name VARCHAR(32) NOT NULL DEFAULT '',description TEXT NOT NULL DEFAULT '',
language_id int(11) DEFAULT NULL, PRIMARY KEY (seller_group_description_id
)) // MultiMerch product data (complements OpenCart's product table) CREATE TABLE ms_product (product_id int(11) NOT NULL,
seller_id int(11) DEFAULT NULL,product_status TINYINT NOT NULL,
product_approved TINYINT NOT NULL,list_until DATE DEFAULT NULL,
commission_id int(11) DEFAULT NULL, PRIMARY KEY (product_id
)) // Sellers CREATE TABLE ms_seller (seller_id int(11) NOT NULL AUTO_INCREMENT,
nickname VARCHAR(32) NOT NULL DEFAULT '',company VARCHAR(32) NOT NULL DEFAULT '',
website VARCHAR(2083) NOT NULL DEFAULT '',description TEXT NOT NULL DEFAULT '',
country_id INT(11) NOT NULL DEFAULT '0',zone_id INT(11) NOT NULL DEFAULT '0',
avatar VARCHAR(255) DEFAULT NULL,banner VARCHAR(255) DEFAULT NULL,
date_created DATETIME NOT NULL,seller_status TINYINT NOT NULL,
seller_approved TINYINT NOT NULL,seller_group int(11) NOT NULL DEFAULT '1',
commission_id int(11) DEFAULT NULL, PRIMARY KEY (seller_id
)) // Seller descriptions CREATE TABLE ms_seller_description (seller_description_id int(11) NOT NULL AUTO_INCREMENT,
seller_id int(11) NOT NULL,language_id int(11) NOT NULL,
description text DEFAULT '', PRIMARY KEY (seller_description_id
), UNIQUE KEYseller_language_id (
seller_id,
language_id)) DEFAULT CHARSET=utf8"); // Seller balances (transactions) CREATE TABLE ms_balance (
balance_id int(11) NOT NULL AUTO_INCREMENT,seller_id int(11) NOT NULL,
order_id int(11) DEFAULT NULL,product_id int(11) DEFAULT NULL,
order_product_id int(11) DEFAULT NULL,withdrawal_id int(11) DEFAULT NULL,
balance_type int(11) DEFAULT NULL,amount DECIMAL(15,4) NOT NULL,
balance DECIMAL(15,4) NOT NULL,description TEXT NOT NULL DEFAULT '',
date_created DATETIME NOT NULL,date_modified DATETIME DEFAULT NULL, PRIMARY KEY (
balance_id)) // MultiMerch order product data (complements OpenCart's order product data) CREATE TABLE ms_order_product_data (
order_product_data_id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NOT NULL,
product_id int(11) NOT NULL,order_product_id int(11) DEFAULT NULL,
seller_id int(11) DEFAULT NULL,store_commission_flat DECIMAL(15,4) NOT NULL,
store_commission_pct DECIMAL(15,4) NOT NULL,seller_net_amt DECIMAL(15,4) NOT NULL,
suborder_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (order_product_data_id
)) // Deprecated CREATE TABLE ms_criteria (criteria_id int(11) NOT NULL AUTO_INCREMENT,
criteria_type TINYINT NOT NULL,range_id int(11) NOT NULL, PRIMARY KEY (
criteria_id)) // Deprecated CREATE TABLE ms_range_int (
range_id int(11) NOT NULL AUTO_INCREMENT,from int(11) NOT NULL,
to int(11) NOT NULL, PRIMARY KEY (range_id
)) // Deprecated CREATE TABLE ms_range_decimal (range_id int(11) NOT NULL AUTO_INCREMENT,
from DECIMAL(15,4) NOT NULL,to DECIMAL(15,4) NOT NULL, PRIMARY KEY (
range_id)) // Deprecated CREATE TABLE ms_range_date (
range_id int(11) NOT NULL AUTO_INCREMENT,from DATETIME,
to DATETIME NOT NULL, PRIMARY KEY (range_id
)) // Deprecated CREATE TABLE ms_seller_group_criteria (seller_group_criteria_id int(11) NOT NULL AUTO_INCREMENT,
commission_id int(11) NOT NULL,criteria_id int(11) NOT NULL, PRIMARY KEY (
seller_group_criteria_id)) // Deprecated CREATE TABLE ms_return (
return_id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NOT NULL,
suborder_id int(11) NOT NULL,seller_id int(11) NOT NULL,
customer_id int(11) DEFAULT 0 NOT NULL,date_created DATETIME NOT NULL, PRIMARY KEY (
return_id)) // Deprecated CREATE TABLE ms_return_product (
return_product_id int(11) NOT NULL AUTO_INCREMENT,return_id int(11) NOT NULL,
product_id int(11) NOT NULL,order_product_id int(11) NOT NULL,
product_quantity int(4) NOT NULL,return_reason_id int(11) NOT NULL,
return_action_id int(11) NOT NULL, PRIMARY KEY (return_product_id
)) // Deprecated CREATE TABLE ms_return_history (return_history_id int(11) NOT NULL AUTO_INCREMENT,
return_id int(11) NOT NULL,return_status_id int(11) NOT NULL,
seller_comment TEXT NULL DEFAULT '',customer_comment TEXT NULL DEFAULT '',
date_created DATETIME NOT NULL, PRIMARY KEY (return_history_id
)) // Deprecated CREATE TABLE ms_order_comment (order_comment_id int(11) NOT NULL AUTO_INCREMENT,
order_id int(11) NOT NULL,product_id int(11) NOT NULL,
seller_id int(11) NOT NULL,comment text NOT NULL, PRIMARY KEY (
order_comment_id) ) DEFAULT CHARSET=utf8"); // Seller orders (suborders) CREATE TABLE ms_suborder (
suborder_id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NOT NULL,
seller_id int(11) NOT NULL,invoice_no int(11) NOT NULL DEFAULT '0',
invoice_prefix varchar(26) NOT NULL DEFAULT '',order_status_id int(11) NOT NULL,
date_added datetime NOT NULL,date_modified datetime NOT NULL, PRIMARY KEY (
suborder_id) ) DEFAULT CHARSET=utf8"); // Seller order history (suborder history) CREATE TABLE ms_suborder_history (
suborder_history_id int(5) NOT NULL AUTO_INCREMENT,suborder_id int(5) NOT NULL,
order_status_id int(5) NOT NULL,comment text NOT NULL DEFAULT '',
date_added datetime NOT NULL, PRIMARY KEY (suborder_history_id
) ) DEFAULT CHARSET=utf8"); // Seller order statuses CREATE TABLE ms_suborder_status (ms_suborder_status_id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (
ms_suborder_status_id)) // Seller order status names CREATE TABLE ms_suborder_status_description (
ms_suborder_status_id int(11) NOT NULL,language_id int(11) NOT NULL,
name varchar(256) NOT NULL DEFAULT '', PRIMARY KEY (ms_suborder_status_id
,language_id
)) // Seller settings CREATE TABLE ms_seller_setting (id int(11) unsigned NOT NULL AUTO_INCREMENT,
seller_id int(11) unsigned DEFAULT NULL,name varchar(50) DEFAULT NULL,
value varchar(250) DEFAULT NULL,is_encoded smallint(1) unsigned DEFAULT NULL, PRIMARY KEY (
id) ) DEFAULT CHARSET=utf8;"); // Seller group settings CREATE TABLE ms_seller_group_setting (
id int(11) unsigned NOT NULL AUTO_INCREMENT,seller_group_id int(11) unsigned DEFAULT NULL,
name varchar(50) DEFAULT NULL,value varchar(250) DEFAULT NULL,
is_encoded smallint(1) unsigned DEFAULT NULL, PRIMARY KEY (id
) ) DEFAULT CHARSET=utf8;"); // Seller badges CREATE TABLE".DB_PREFIX."ms_badge (
badge_id int(11) NOT NULL AUTO_INCREMENT,image varchar(255) DEFAULT NULL, PRIMARY KEY (
badge_id)) // Seller badge names and descriptions CREATE TABLE
".DB_PREFIX."ms_badge_description (badge_id int(11) NOT NULL,
name varchar(32) NOT NULL DEFAULT '',description text NOT NULL,
language_id int(11) NOT NULL, PRIMARY KEY (badge_id
,language_id
)) // Seller group badges CREATE TABLE".DB_PREFIX."ms_badge_seller_group (
badge_seller_group_id INT(11) NOT NULL AUTO_INCREMENT,badge_id INT(11) NOT NULL,
seller_id int(11) DEFAULT NULL,seller_group_id int(11) DEFAULT NULL, PRIMARY KEY (
badge_seller_group_id)) // Social media links CREATE TABLE
".DB_PREFIX."ms_channel (channel_id int(11) NOT NULL AUTO_INCREMENT,
image varchar(255) DEFAULT NULL, PRIMARY KEY (channel_id
)) // Social media link names CREATE TABLE".DB_PREFIX."ms_channel_description (
channel_id int(11) NOT NULL,language_id int(11) NOT NULL,
name VARCHAR(32) NOT NULL DEFAULT '',description TEXT NOT NULL DEFAULT '', PRIMARY KEY (
channel_id,
language_id)) // Seller social media links CREATE TABLE
".DB_PREFIX."ms_seller_channel (seller_id int(11) NOT NULL,
channel_id int(11) NOT NULL,channel_value varchar(255) DEFAULT NULL, PRIMARY KEY (
seller_id,
channel_id)) // Conversations CREATE TABLE ms_conversation (
conversation_id int(11) NOT NULL AUTO_INCREMENT,conversation_from int(11) DEFAULT NULL,
title varchar(256) NOT NULL DEFAULT '',date_created DATETIME NOT NULL, PRIMARY KEY (
conversation_id)) // Conversation messages CREATE TABLE ms_message (
message_id int(11) NOT NULL AUTO_INCREMENT,conversation_id int(11) NOT NULL,
from int(11) DEFAULT NULL,from_admin tinyint(1) NOT NULL DEFAULT 0,
message text NOT NULL DEFAULT '',read tinyint(1) NOT NULL DEFAULT 0,
date_created DATETIME NOT NULL, PRIMARY KEY (message_id
)) // Product questions CREATE TABLE" . DB_PREFIX ."ms_question (
question_id int(11) NOT NULL AUTO_INCREMENT,author_id int(11) NOT NULL,
product_id int(11) NOT NULL,text text NOT NULL DEFAULT '',
date_created DATETIME NOT NULL, PRIMARY KEY (question_id
)) DEFAULT CHARSET=utf8"); // Answers to product questions CREATE TABLE ms_answer (answer_id int(11) NOT NULL AUTO_INCREMENT,
question_id int(11) NOT NULL,author_id int(11) NOT NULL,
date_created DATETIME NOT NULL,rating int(11) DEFAULT NULL,
text text NOT NULL DEFAULT '', PRIMARY KEY (answer_id
)) DEFAULT CHARSET=utf8"); // Deprecated CREATE TABLE ms_user_vote (answer_id int(11) NOT NULL,
user_id int(11) NOT NULL,type tinyint(1) NOT NULL) DEFAULT CHARSET=utf8"); // Product reviews CREATE TABLE ms_review (
review_id int(11) NOT NULL AUTO_INCREMENT,author_id int(11) NOT NULL,
product_id int(11) NOT NULL,order_product_id int(11) NOT NULL,
order_id int(11) DEFAULT NULL,seller_id int(11) DEFAULT NULL,
rating int(1) NOT NULL,title varchar(128) NOT NULL DEFAULT '',
comment text NOT NULL DEFAULT '',helpful int(11) DEFAULT NULL,
unhelpful int(11) DEFAULT NULL,date_created DATETIME NOT NULL,
date_updated DATETIME DEFAULT NULL,status tinyint DEFAULT 0, PRIMARY KEY (
review_id)) // Review attachments CREATE TABLE ms_review_attachment (
review_attachment_id int(11) NOT NULL AUTO_INCREMENT,review_id int(11) NOT NULL,
attachment text NOT NULL, PRIMARY KEY (review_attachment_id
)) // Deprecated CREATE TABLE ms_review_comment (comment_id int(11) NOT NULL AUTO_INCREMENT,
review_id int(11) NOT NULL,author_id int(11) NOT NULL,
text text NOT NULL,rating int(11) NOT NULL,
date_created DATETIME NOT NULL,date_updated DATETIME DEFAULT NULL, PRIMARY KEY (
comment_id)) // Shipping methods CREATE TABLE ms_shipping_method (
shipping_method_id int(11) NOT NULL AUTO_INCREMENT,logo TEXT DEFAULT '',
status tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (shipping_method_id
)) // Shipping method descriptions CREATE TABLE ms_shipping_method_description (shipping_method_description_id int(11) NOT NULL AUTO_INCREMENT,
shipping_method_id int(11) NOT NULL,name VARCHAR(32) NOT NULL DEFAULT '',
description TEXT DEFAULT '',language_id int(11) DEFAULT NULL, PRIMARY KEY (
shipping_method_description_id)) // Shipping method delivery times CREATE TABLE ms_shipping_delivery_time (
delivery_time_id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (delivery_time_id
)) // Delivery time names CREATE TABLE ms_shipping_delivery_time_description (delivery_time_desc_id int(11) NOT NULL AUTO_INCREMENT,
delivery_time_id int(11) NOT NULL,name TEXT DEFAULT '',
language_id int(11) NOT NULL DEFAULT 1, PRIMARY KEY (delivery_time_desc_id
)) // Product shipping rates CREATE TABLE ms_product_shipping (product_shipping_id int(11) NOT NULL AUTO_INCREMENT,
product_id int(11) NOT NULL,from_country int(11) NOT NULL DEFAULT 0,
free_shipping int(11) NOT NULL DEFAULT 0,processing_time int(11) NOT NULL DEFAULT 0,
override int(11) DEFAULT 0, PRIMARY KEY (product_shipping_id
)) // Product shipping locations CREATE TABLE ms_product_shipping_location (product_shipping_location_id int(11) NOT NULL AUTO_INCREMENT,
product_id int(11) NOT NULL,to_geo_zone_id int(11) NOT NULL,
shipping_method_id int(11) NOT NULL DEFAULT 0,delivery_time_id int(11) NOT NULL DEFAULT 1,
cost DECIMAL(15,4) NOT NULL,additional_cost DECIMAL(15,4) NOT NULL, PRIMARY KEY (
product_shipping_location_id)) // Order product shipping data (complements OpenCart's order product data) CREATE TABLE ms_order_product_shipping_data (
order_product_shipping_id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NOT NULL,
product_id int(11) NOT NULL,order_product_id int(11) NOT NULL,
fixed_shipping_method_id int(11) DEFAULT NULL,combined_shipping_method_id int(11) DEFAULT NULL,
shipping_cost DECIMAL(15,4) DEFAULT NULL, PRIMARY KEY (order_product_shipping_id
)) // Payments CREATE TABLE ms_pg_payment (payment_id int(11) NOT NULL AUTO_INCREMENT,
seller_id int(11) NOT NULL,payment_type int(11) NOT NULL,
payment_code VARCHAR(128) NOT NULL,payment_status int(11) NOT NULL,
amount DECIMAL(15,4) NOT NULL,currency_id int(11) NOT NULL,
currency_code VARCHAR(3) NOT NULL,sender_data TEXT NOT NULL,
receiver_data TEXT NOT NULL,description TEXT NOT NULL,
date_created DATETIME NOT NULL, PRIMARY KEY (payment_id
)) // Invoices CREATE TABLE ms_pg_request (request_id int(11) NOT NULL AUTO_INCREMENT,
payment_id VARCHAR(128) DEFAULT NULL,seller_id int(11) NOT NULL,
product_id int(11) DEFAULT NULL,order_id int(11) DEFAULT NULL,
request_type int(11) NOT NULL,request_status int(11) NOT NULL,
description TEXT NOT NULL,amount DECIMAL(15,4) NOT NULL,
currency_id int(11) NOT NULL,currency_code VARCHAR(3) NOT NULL,
date_created DATETIME NOT NULL,date_modified DATETIME DEFAULT NULL, PRIMARY KEY (
request_id)) // Seller shipping rates (weight-based combined shipping) CREATE TABLE ms_seller_shipping (
seller_shipping_id int(11) NOT NULL AUTO_INCREMENT,seller_id int(11) NOT NULL,
from_country_id int(11) NOT NULL,processing_time int(11) NOT NULL DEFAULT 0, PRIMARY KEY (
seller_shipping_id)) // Seller shipping locations (weight-based combined shipping) CREATE TABLE ms_seller_shipping_location (
seller_shipping_location_id int(11) NOT NULL AUTO_INCREMENT,seller_shipping_id int(11) NOT NULL,
shipping_method_id int(11) NOT NULL,delivery_time_id int(11) NOT NULL,
to_geo_zone_id int(11) NOT NULL,weight_from DECIMAL(15,4) NOT NULL,
weight_to DECIMAL(15,4) NOT NULL,weight_class_id int(11) NOT NULL,
cost_fixed DECIMAL(15,4) NOT NULL,cost_pwu DECIMAL(15,4) NOT NULL DEFAULT 0, PRIMARY KEY (
seller_shipping_location_id)) // Category commission rates (category-based sales fees) CREATE TABLE ms_category_commission (
category_commission_id int(11) NOT NULL AUTO_INCREMENT,category_id int(11) NOT NULL,
commission_id int(11) DEFAULT NULL, PRIMARY KEY (category_commission_id
)) // Seller product attributes CREATE TABLE ms_attribute (attribute_id int(11) NOT NULL AUTO_INCREMENT,
seller_id int(11) DEFAULT 0,attribute_status int(11) NOT NULL, PRIMARY KEY (
attribute_id)) // Seller product attribute groups CREATE TABLE ms_attribute_group (
attribute_group_id int(11) NOT NULL AUTO_INCREMENT,seller_id int(11) DEFAULT 0,
attribute_group_status int(11) NOT NULL, PRIMARY KEY (attribute_group_id
)) // Seller product options CREATE TABLE ms_option (option_id int(11) NOT NULL AUTO_INCREMENT,
seller_id int(11) DEFAULT 0,option_status int(11) NOT NULL, PRIMARY KEY (
option_id)) // Adaptive payment keys CREATE TABLE ms_customer_ppakey (
customer_id int(11) NOT NULL,preapprovalkey varchar(255) NOT NULL,
active smallint(1) NOT NULL DEFAULT '0', PRIMARY KEY (customer_id
)) DEFAULT CHARSET=utf8;"); // Seller product categories CREATE TABLE ms_category (category_id int(11) NOT NULL AUTO_INCREMENT,
parent_id int(11) NOT NULL DEFAULT 0,seller_id int(11) NOT NULL DEFAULT 0,
image VARCHAR(255) DEFAULT NULL,sort_order int(11) NOT NULL DEFAULT 0,
category_status int(11) NOT NULL, PRIMARY KEY (category_id
)) // Seller product category descriptions CREATE TABLE ms_category_description (category_id int(11) NOT NULL,
language_id int(11) NOT NULL,name VARCHAR(255) NOT NULL DEFAULT '',
description TEXT NOT NULL DEFAULT '',meta_title VARCHAR(255) NOT NULL DEFAULT '',
meta_description VARCHAR(255) NOT NULL DEFAULT '',meta_keyword VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (
category_id,
language_id)) // Seller category filters CREATE TABLE ms_category_filter (
category_id int(11) NOT NULL,oc_filter_id int(11) NOT NULL, PRIMARY KEY (
category_id,
oc_filter_id)) // Seller categories linked to OpenCart stores CREATE TABLE ms_category_to_store (
category_id int(11) NOT NULL,store_id int(11) NOT NULL, PRIMARY KEY (
category_id,
store_id)) // Category paths CREATE TABLE ms_category_path (
category_id int(11) NOT NULL,path_id int(11) NOT NULL,
level int(11) NOT NULL, PRIMARY KEY (category_id
,path_id
)) // Products linked to categories CREATE TABLE ms_product_to_category (product_id int(11) NOT NULL,
ms_category_id int(11) NOT NULL, PRIMARY KEY (product_id
,ms_category_id
)) // Conversations linked to orders CREATE TABLE " . DB_PREFIX . "ms_conversation_to_order (order_id int(11) NOT NULL,
suborder_id int(11) NOT NULL,conversation_id int(11) NOT NULL, PRIMARY KEY (
order_id,
suborder_id,
conversation_id)) default CHARSET=utf8"); // Conversation participants CREATE TABLE " . DB_PREFIX . "ms_conversation_participants (
conversation_id int(11) NOT NULL,customer_id int(11) NOT NULL DEFAULT '0',
user_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (conversation_id
,customer_id
,user_id
)) default CHARSET=utf8"); // Conversations linked to products CREATE TABLE " . DB_PREFIX . "ms_conversation_to_product (product_id int(11) NOT NULL,
conversation_id int(11) NOT NULL, PRIMARY KEY (product_id
,conversation_id
)) default CHARSET=utf8"); // Message attachments CREATE TABLE " . DB_PREFIX . "ms_message_upload (message_id int(11) NOT NULL,
upload_id int(11) NOT NULL, PRIMARY KEY (message_id
,upload_id
)) default CHARSET=utf8"); // MultiMerch events CREATE TABLE ms_event (event_id int(11) NOT NULL AUTO_INCREMENT,
admin_id int(11) unsigned DEFAULT NULL,customer_id int(11) unsigned DEFAULT NULL,
seller_id int(11) unsigned DEFAULT NULL,event_type tinyint NOT NULL,
data text NOT NULL,body text DEFAULT NULL,
date_created DATETIME NOT NULL, PRIMARY KEY (event_id
)) // Deprecated CREATE TABLE ms_import_config (config_id int(11) NOT NULL AUTO_INCREMENT,
customer_id int(11) NOT NULL,config_name varchar(255) DEFAULT NULL,
import_type varchar(100) DEFAULT NULL,attachment_code varchar(255) DEFAULT NULL,
mapping text,start_row int(11) DEFAULT NULL,
finish_row int(11) DEFAULT NULL,cell_container varchar(10) DEFAULT NULL,
cell_separator varchar(10) DEFAULT NULL,update_key_id int(11) DEFAULT NULL,
file_encoding int(11) DEFAULT NULL,date_added datetime NOT NULL,
date_modified datetime NOT NULL, PRIMARY KEY (config_id
) ) // Import histories CREATE TABLE ms_import_history (import_id int(11) NOT NULL AUTO_INCREMENT,
seller_id int(11) NOT NULL,name varchar(255) NOT NULL,
filename varchar(255) NOT NULL,date_added datetime NOT NULL,
type varchar(100) NOT NULL,processed int(11) NOT NULL,
added int(11) NOT NULL,updated int(11) NOT NULL,
errors int(11) NOT NULL,product_ids text DEFAULT NULL, PRIMARY KEY (
import_id) ) // Custom field groups CREATE TABLE ms_custom_field_group (
custom_field_group_id int(11) NOT NULL AUTO_INCREMENT,admin_id int(11) NOT NULL DEFAULT 0,
status tinyint NOT NULL DEFAULT 0,sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (
custom_field_group_id)) // Custom field group names CREATE TABLE ms_custom_field_group_description (
custom_field_group_id int(11) NOT NULL,language_id int(11) NOT NULL,
name text NOT NULL, PRIMARY KEY (custom_field_group_id
,language_id
)) // Custom field links to locations (e.g. custom field to product) CREATE TABLE ms_custom_field_group_to_location (custom_field_group_id int(11) NOT NULL,
location_id int(11) NOT NULL DEFAULT 1, PRIMARY KEY (custom_field_group_id
,location_id
)) // Custom field group descriptions CREATE TABLE ms_custom_field_group_note (custom_field_group_id int(11) NOT NULL,
language_id int(11) NOT NULL,note text NOT NULL DEFAULT '', PRIMARY KEY (
custom_field_group_id,
language_id)) // Custom fields CREATE TABLE ms_custom_field (
custom_field_id int(11) NOT NULL AUTO_INCREMENT,custom_field_group_id int(11) NOT NULL,
admin_id int(11) NOT NULL DEFAULT 0,type varchar(100) NOT NULL DEFAULT '',
required tinyint NOT NULL DEFAULT 0,validation text NOT NULL DEFAULT '',
status tinyint NOT NULL DEFAULT 0,sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (
custom_field_id)) // Custom field names CREATE TABLE ms_custom_field_description (
custom_field_id int(11) NOT NULL,language_id int(11) NOT NULL,
name text NOT NULL, PRIMARY KEY (custom_field_id
,language_id
)) // Custom field values CREATE TABLE ms_custom_field_value (custom_field_value_id int(11) NOT NULL AUTO_INCREMENT,
custom_field_id int(11) NOT NULL,sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (
custom_field_value_id)) // Custom field CREATE TABLE ms_custom_field_value_description (
custom_field_value_id int(11) NOT NULL,custom_field_id int(11) NOT NULL,
language_id int(11) NOT NULL,name text NOT NULL, PRIMARY KEY (
custom_field_value_id,
language_id)) // Custom field descriptions CREATE TABLE ms_custom_field_note (
custom_field_id int(11) NOT NULL,language_id int(11) NOT NULL,
note text NOT NULL DEFAULT '', PRIMARY KEY (custom_field_id
,language_id
)) // Custom field values for products CREATE TABLE ms_product_custom_field (product_id int(11) NOT NULL,
custom_field_id int(11) NOT NULL,value text NOT NULL DEFAULT '', PRIMARY KEY (
product_id,
custom_field_id)) // Payouts CREATE TABLE ms_payout (
payout_id int(11) NOT NULL AUTO_INCREMENT,name text NOT NULL DEFAULT '',
date_created datetime NOT NULL,date_payout_period datetime NOT NULL, PRIMARY KEY (
payout_id)) // Invoices linked to payouts CREATE TABLE ms_payout_to_invoice (
payout_id int(11) NOT NULL,invoice_id int(11) NOT NULL, PRIMARY KEY (
payout_id,
invoice_id)) // Coupons CREATE TABLE ms_coupon (
coupon_id int(11) NOT NULL AUTO_INCREMENT,seller_id int(11) DEFAULT NULL,
name varchar(255) NOT NULL DEFAULT '',description text NOT NULL DEFAULT '',
code varchar(255) NOT NULL DEFAULT '',type tinyint NOT NULL DEFAULT 1,
value decimal(15,4) NOT NULL DEFAULT 0,date_start datetime DEFAULT NULL,
date_end datetime DEFAULT NULL,max_uses int(11) DEFAULT NULL,
max_uses_customer int(11) DEFAULT NULL,total_uses int(11) NOT NULL DEFAULT 0,
min_order_total decimal(15,4) NOT NULL DEFAULT 0,login_required tinyint NOT NULL DEFAULT 1,
status tinyint NOT NULL DEFAULT 1,date_created datetime NOT NULL, PRIMARY KEY (
coupon_id)) // Coupon histories CREATE TABLE ms_coupon_history (
coupon_history_id int(11) NOT NULL AUTO_INCREMENT,coupon_id int(11) NOT NULL,
order_id int(11) NOT NULL,suborder_id int(11) NOT NULL,
customer_id int(11) NOT NULL,amount decimal(15,4) NOT NULL,
date_created datetime NOT NULL, PRIMARY KEY (coupon_history_id
)) // Coupon restrictions to customers CREATE TABLE ms_coupon_customer (coupon_customer_id int(11) NOT NULL AUTO_INCREMENT,
coupon_id int(11) NOT NULL,customer_id int(11) NOT NULL,
exclude tinyint DEFAULT 0, PRIMARY KEY (coupon_customer_id
)) // Coupon restrictions to products CREATE TABLE ms_coupon_product (coupon_product_id int(11) NOT NULL AUTO_INCREMENT,
coupon_id int(11) NOT NULL,product_id int(11) NOT NULL,
exclude tinyint DEFAULT 0, PRIMARY KEY (coupon_product_id
)) // Coupon restrictions to OpenCart categories CREATE TABLE ms_coupon_oc_category (coupon_oc_category_id int(11) NOT NULL AUTO_INCREMENT,
coupon_id int(11) NOT NULL,oc_category_id int(11) NOT NULL,
exclude tinyint DEFAULT 0, PRIMARY KEY (coupon_oc_category_id
)) // Coupon restrictions to seller categories CREATE TABLE ms_coupon_ms_category (coupon_ms_category_id int(11) NOT NULL AUTO_INCREMENT,
coupon_id int(11) NOT NULL,ms_category_id int(11) NOT NULL,
exclude tinyint DEFAULT 0, PRIMARY KEY (coupon_ms_category_id
))
MultiMerch class method description
system/library/paypal.php Paypal
decodePayPalIPN < Decode PayPal IPN response preapproval_request < Send a PayPal preapproval request request < Make an API request validateIPN < Validate the IPN response
system/library/msimportexportdata.php MsImportExportData
_addCategory < Create a category during import _addProduct < Create a product during import _addProductCategories < Create product category links during import _createHistory < Create an import history record _savePath < Create a category path during import _updateCategory < Update a category during import _updateProduct < Update a product during import addImportConfig < Create an import config CSV_ENCLOSURE < CSV enclosure CSV_SEPARATOR < CSV separator deleteImport < Delete an import record getFilename < Get the import file name getImportConfigById < Get the import config by id getImportConfigs < Get the list of import conigs getImportHistory < Get the history of imports getSellerAttributes < Get seller's attributes getStockStatus < Get stock statuses importCategory < Import a category importProduct < Import a product prepareImageByImageUrl < Prepare an image for import updateImportConfig < Save an import config
system/library/msimportexportfile.php MsImportExportFile
getFieldCaption < Get field captions for the data to be imported getSamplesData < Get a sample of the data to be imported (Step 4)
system/library/mssociallink.php MsSocialLink
createChannel < Create a social media channel deleteChannel < Delete a social media channel editChannel < Edit a channel editSellerChannels < Edit seller's channels getChannelDescriptions < Get channel descriptions getChannels < Get the list of channels getSellerChannels < Get seller's channels getTotalSellersByChannelId < Get the total number of sellers linked to a channel
system/library/msattribute.php MsAttribute
createOrUpdateMsAttribute < Create/update seller's attribute createOrUpdateMsAttributeGroup < Create/update seller's attribute group deleteAttribute < Delete seller's attribute deleteAttributeGroup < Delete seller's attribute group getAttributeGroups < Get seller attribute groups getAttributes < Get the list of seller attribbutes getProductsByAttributeId < Get products linked to an attribute isMsAttribute < Verify if an attribute is a MultiMerch attribute isMsAttributeGroup < Verify if an attribute group is a MultiMerch attribute group ocGetAttribute < Get an OpenCart attribute ocGetAttributes < Get OpenCart attributes ocGetProductAttributes < Get OpenCart product attribbutes ocGetTotalAttributesByAttributeGroupId < Get the total number of OpenCart attributes linked to a product ocGetTotalProductsByAttributeId < Get the total number of products linked to an OpenCart attribute sellerCreateAttribute < Create a seller attribbute sellerCreateAttributeGroup < Create seller's attribute group sellerUpdateAttribute < Update seller's attribute sellerUpdateAttributeGroup < Update seller's attribute group STATUS_ACTIVE < Active attributes STATUS_APPROVED < Approved attributes STATUS_DISABLED < Disabled attributes STATUS_INACTIVE < Deleted attributes
system/library/msbadge.php MsBadge
createBadge < Create a new badge deleteBadge < Delete badge editBadge < Edit badge getBadgeDescriptions < Get badge descriptions (translated) getBadges < Get badges getSellerGroupsByBadgeId < Get seller groups by badge id getSellersByBadgeId < Get sellers by badge id
system/library/msbalance.php MsBalance
addBalanceEntry < Create a new balance entry (transaction) getAvailableSellerFunds < Get seller's available balance (non-reserved) getBalanceEntries < Get balance entries getBalanceEntry < Get a single balance entry getReservedSellerFunds < Get the amount of seller's reserved funds getSellerBalance < Get seller's balance getSellerBalanceEntries < Get seller's balance entries getTotalBalanceAmount < Get total across all balances getTotalBalanceEntries < Get the total number of balance entries getTotalSellerBalanceEntries < Get the total number of seller's transactions getWaitingSellerFunds < Get reserved seller funds MS_BALANCE_TYPE_GENERIC < Generic balance records MS_BALANCE_TYPE_LISTING < Product listing balance records (fees) MS_BALANCE_TYPE_MSCOUPON < Coupon balance records MS_BALANCE_TYPE_RECURRING < Recurring balance records MS_BALANCE_TYPE_REFUND < Refund balance records MS_BALANCE_TYPE_SALE < Sale balance records MS_BALANCE_TYPE_SHIPPING < Shipping balance records MS_BALANCE_TYPE_SIGNUP < Sign up fee records MS_BALANCE_TYPE_WITHDRAWAL < Payout records
system/library/mscategory.php MsCategory
_getDescriptions < Get category descriptions (translated) _getFilters < Get category filters _getStores < Get category to store relations _saveDescriptions < Save category names and descriptions (translated) _saveFilters < Save category filters _saveKeyword < Save the SEO keyword of a category _savePath < Save category hiearchies _saveStores < Save category to store relations changeSeller < Change the seller a category belongs to changeStatus < Change category status createCategory < Create a new seller category deleteCategory < Delete a single seller category getCategories < Get seller categories getChildCategoriesByCategoryId getMsCategoryName < Get MultiMerch category name (translated) getMsCategoryPath < Get MultiMerch category hierarchy getOcCategories < Get OpenCart categories getOcCategoryCommission < Get OpenCart category commissions getOcCategoryName < Get OpenCart category name (translated) getOcCategoryPath < Get complete hiearchy of OpenCart categories getProductsByCategoryId < Get products belonging to a specific category isMsCategory < Check if MultiMerch seller category exists saveCategoryCommission < Save OpenCart category commission STATUS_ACTIVE < Active seller category status STATUS_DISABLED < Disabled seller category status STATUS_INACTIVE < Inactive seller category status updateCategory < Update a seller category
system/library/mscommission.php MsCommission
calculateCommission < Calculate seller's commission (fee) rates (Default group > Group > Seller) createCommission < Create a new commission rate editCommission < Edit a commission rate getCommissionRates < Fetch commission rates RATE_LISTING < Listing fees RATE_SALE < Sale fees RATE_SIGNUP < Signup fees TYPE_DATE_UNTIL < Deprecated TYPE_PERIODIC < Deprecated TYPE_SALES_AMOUNT < Deprecated TYPE_SALES_QUANTITY < Deprecated
system/library/msconversation.php MsConversation
addConversationParticipants < Add a new participant to a conversation createConversation < Create a new conversation deleteConversation < Delete a conversation getConversationParticipants < Fetch all conversation participants getConversationParticipantsIds < Fetch all conversation participants (ids) getConversations < Get all conversations getOrderConversation < Get order-related conversation getWith < Get the other party in a conversation isParticipant < Validate conversation's participant SENDER_TYPE_ADMIN < Admin-initiated conversations SENDER_TYPE_CUSTOMER < Customer-initiated conversations SENDER_TYPE_SELLER < Seller-initiated conversations sendMailForParticipants < Notify conversation participants via email updateConversation < Update a conversation
system/library/mscoupon.php MsCoupon
checkCouponBelongsToSeller < Verify if a coupon belongs to a seller createCouponHistory < Create a coupon usage history entry createOrUpdateCoupon < Create/update a coupon deleteCoupon < Delete coupon deleteCouponHistory < Delete a coupon history entry getCouponHistory < Get coupon usage history entries getCoupons < Get coupons getCustomerByCouponId < Get the customer list for a coupon (restrictions) getMsCategoryByCouponId < Get the seller category list for a coupon (restrictions) getOcCategoryByCouponId < Get the OpenCart category list for a coupon (restrictions) getProductByCouponId < Get products for a coupon (restrictions) incrementTotalUses < Increment coupon's total use number STATUS_ACTIVE < Active coupons STATUS_DISABLED < Disabled coupons TYPE_DISCOUNT_FIXED < Fixed (flat rate) coupons TYPE_DISCOUNT_PERCENT < Percentage coupons
system/library/mscustomfield.php MsCustomField
createOrUpdateCustomField < Create/update a custom field createOrUpdateCustomFieldGroup < Create/update a custom field gorup createOrUpdateProductCustomField < Create/update field to product link deleteCustomField < Delete a custom field deleteCustomFieldGroup < Delete a custom field group getCustomFieldGroups < Get custom field groups getCustomFields < Get custom fields getCustomFieldType < Get custom field type getCustomFieldValidation < Get custom field validation status getCustomFieldValueName < Get custom field value (translated) getCustomFieldValues < Get custom field values getProductCustomFields < Get custom field to product links getProductsByCFId < Get products linked to a custom field LOCATION_PRODUCT < Custom product fields STATUS_ACTIVE < Active custom fields STATUS_DISABLED < Disabled custom fields
system/library/msfile.php MsFile
_checkExistingFiles < Check if the file with this name already exists _checkExistingFilesMd5 < Check if the file with this name already exists (MD5) _checkExistingFilesSizes < Check if the file with this name already exists (file size) _isNewUpload < Check if the file is a new upload checkDownload < Run a set of security checks against a download file checkFile < Run a set of security checks against an uploaded file checkFileAgainstSession < Verify if the file being uploaded is present in a session checkImage < Run a set of security checks against an image file checkImportFile < Run a set of security checks against an import file checkPostMax < Verify whether a file exceeds the maximum post size deleteDownload < Delete a download deleteImage < Delete an image moveDownload < Move a file upload to the storage folder moveImage < Move an image upload to the storage folder resizeImage < Resize an image uploadDownload < Upload a product/seller file uploadImage < Upload a product/seller image uploadImportFile < Upload an import file
system/library/msfilter.php MsFilter
getFilter < Get an OpenCart filter getFilters < Get OpenCart filters getProductFilters < Get OpenCart filters for a product
system/library/mshelper.php MsHelper
activePpreapprovalkey < Activate Adaptive preapproval key addHttp < Add schema to a URL (deprecated) addOcDownload < Insert a new OpenCart download record addPpreapprovalkey < Create Adaptive preapproval key addScheme < Add schema to a URL addStyle < Add a new stylesheet to OpenCart's $styles arra adminUrlLink < Create an admin-area URL admLoadTemplate < Load an admin-area template admSetBreadcrumbs < Init admin-area breadcrumbs ceiling < Ceil a number to the higher significance number createOCSetting < Create an OpenCart setting DB entry deleteOcDownload < Delete an OpenCart download file deleteOCSetting < Delete OpenCart setting generateAddressForGoogleGeoLocation < Format an address for Google's geolocation API generateMetaDescription < Generate a meta description getFilterParams < Get filter parameters getIntegrationPackVersion < Get the version of the currently installed MultiMerch theme integration getLanguageId < Get the current language id getNumberOfSignificantDigits < Get the number of significant digits getOcDownload < Fetch an OpenCart download getPpreapprovalkey < Get Adaptive preapproval key getSortParams < Get sort parameters for DataTables getStatusName < Get the name of an order status (translated) getStockStatuses < Get OpenCart stock statuses getTaxClasses < Get OpenCart tax classes isInstalled < Verify if MultiMerch is installed isPowerOf < Verify if one number is power of another one isUnsignedFloat < Verify if a number is an unsigned float isValidUrl < Verify if a parameter is a valid URL loadTemplate < Load a catalog-area template renderPmDialog < Render a private message dialog setBreadcrumbs < Init catalog-area breadcrumbs setVqmod < Turn a vQmod modification file on/off slugify < Create a SEO-friendly slug from a string trueCurrencyFormat < Convert a number to a true currency format uniformDecimalPoint < Replace all non-default decimal points in a number
system/library/msloader.php MsLoader
_autoloadController < Autoload MultiMerch controllers _autoloadLibrary < Autoload MultiMerch models _autoloadMultimerchlib < Autoload MultiMerch libraries appVer < MultiMerch application version dbVer < MultiMerch database schema version getInstance < Get the Loader instancec getRegistry < Get Registry langVer < MultiMerch language file version load < Load a MultiMerch class with namespace support setRegistry < Set Registry
system/library/msmail.php MsMail
_getOrderProducts < Get products belonging to an order _modelExists < Verify if a model exists (deprecated) sendOrderMails < Send emails related to an order
system/library/msmessage.php MsMessage
createMessage < Create a new message in a conversation createMessageAttachment < Create a new message attachment deleteMessage < Delete a message getMessageAttachments < Get message attachments getMessages < Get conversation messages
system/library/msoption.php MsOption
createOrUpdateMsOption < Create/update an option deleteOption < Delete an option getOptions < Get options getOptionValues < Get option values getProductsByOptionId < Get products linked to an option isMsOption < Verify if an id belongs to a valid MultiMerch seller option ocGetTotalProductsByOptionId < Get the total number of products linked to an option sellerActivateOption < Activate an option (seller account) sellerCreateOption < Create a seller option sellerDeactivateOption < Deactivate an option (seller account) sellerUpdateOption < Update a seller option STATUS_ACTIVE < Active options STATUS_APPROVED < Approved options STATUS_DISABLED < Disabled options STATUS_INACTIVE < Inactive options
system/library/msorderdata.php MsOrderData
addOrderComment < Create a new order comment addOrderProductData < Create a new order product data record (products linked to an order) addOrderProductShippingData < Create a new order product shipping data record (vendor shipping data linked to an order) getOrderComment < Get an order comment getOrderData < Get order data records getOrderMsCouponTotal < Get order coupon totals getOrderProducts < Get order products getOrderProductShippingCost < Get order shipping costs (vendor shipping) getOrders < Get orders getOrderStateByStatusId < Get order state by order status id getOrderStateData < Get order state data (transalted) getOrderTotal < Get the order total value isOrderCreatedByCustomer < Verify if the order was created by a specific customer STATE_CANCELLED < Cancelled orders STATE_COMPLETED < Completed orders STATE_FAILED < Failed orders STATE_PENDING < Pending orders STATE_PROCESSING < Processing orders
system/library/mspayout.php MsPayout
createPayout < Create a new payout deletePayout < Delete a payout getInvoiceIdByPayoutId < Get the invoice number for a payout getPayoutIdByInvoiceId < Get the payout number for an invoice getPayouts < Get payouts getSellers < Get sellers within a payout updatePayout < Update a payout
system/library/mspgpayment.php MsPgPayment
ADMIN_ID < Admin's DB id ADMIN_SETTING_PREFIX < Prefox for admin settings createPayment < Create a payment deletePayment < Delete a payment getPayments < Get payments getPaymentStatus < Get payment's status METHOD_BALANCE < Payments from seller's balance METHOD_PG < Payments via MultiMerch payment methods SELLER_SETTING_PREFIX < Prefix for seller settings STATUS_COMPLETE < Complete payments STATUS_INCOMPLETE < Incomplete payments STATUS_WAITING_CONFIRMATION < Unconfirmed payments TYPE_PAID_REQUESTS < Payouts TYPE_SALE < Sale payments (Adaptive) updatePayment < Update a payment
system/library/mspgrequest.php MsPgRequest
createRequest < Create an invoice (payment request) deleteRequest < Delete an invoice getRequests < Get invoices getRequestType < Get invoice type getTotalAmount < Get the total invoice amount STATUS_PAID < Paid invoices STATUS_REFUND_REQUESTED < Refund requests STATUS_REFUNDED < Refund invoices STATUS_UNPAID < Unpaid invoices TYPE_LISTING < Listing invoices TYPE_PAYOUT < Payout invoices TYPE_PAYOUT_REQUEST < Payout request invoices (deprecated) TYPE_RECURRING < Recurring invoices (deprecated) TYPE_SALE < Sale invoices (Adaptive) TYPE_SIGNUP < Signup fee invoices updateRequest < Update an invoice
system/library/msproduct.php MsProduct
_createProduct < Create a new product record _saveAttributes < Save product attributes _saveCustomFields < Save custom product fields _saveDescriptions < Save product descriptions (translated) _saveDiscounts < Save product discounts _saveDownloads < Save product downloads _saveFilters < Save product filters _saveImages < Save product images _saveKeyword < Save product SEO slug _saveMsCategories < Save product categories (MultiMerch seller categories) _saveOcCategories < Save product categories (OpenCart) _saveOptions < Save product options _saveRelated < Save related products _saveShipping < Save product shipping rates (vendor shipping) _saveSpecials < Save product specials _saveStores < Save product to store links _updateDescriptions < Update product descriptions _updateDownloads < Update product downloads _updateImages < Update product images _updateProduct < Update a product record approve < Approve a product changeSeller < Assign a product to a new seller changeStatus < Change product's status createRecord < Create a MultiMerch product record for an OpenCart product (ms_product) deleteProduct < Delete a product disapprove < Unapprove a product editProduct < Edit a product getDefaultStockStatus < Get the default OpenCart stock status getDownload < Get a download getManufacturers < Get OpenCart manufacturers getProduct < Fetch a product record getProductCommissionId < Get product commission records (fees) getProductDiscounts < Get product discounts getProductDownloads < Get product downloads getProductImages < Get product images getProductMsCategories < Get product categories (MultiMerch seller categories) getProductOcCategories < Get product categories (OpenCart) getProducts < Get products getProductShipping < Get product shipping records (vendor shipping) getProductSpecials < Get product specials getProductStores < Get product to store links getProductThumbnail < Get product's thumbnail getSellerId < Get seller owning the product getStatus < Get product status getTotalProducts < Get total products across the marketplace getTotalProductViews < Get total product views across the marketplace hasDownload < Verify if a download belongs to a product isEnabled < Verify if a product is enabled isShippableByOC < Verify if a product is shippable by OpenCart MS_PRODUCT_VALIDATION_APPROVAL < Products requiring admin approval MS_PRODUCT_VALIDATION_NONE < Products not requiring validation productOwnedBySeller < Verify if a product is owned by a specific seller saveProduct < Save a product record STATUS_ACTIVE < Active products STATUS_DELETED < Deleted products STATUS_DISABLED < Disabled products STATUS_IMPORTED < Imported products STATUS_INACTIVE < Inactive products STATUS_UNPAID < Unpaid products
system/library/msquestion.php MsQuestion
addAnswer < Create an answer to a question addQuestion < Create a question deleteAnswer < Delete an answer deleteQuestion < Delete a question getAnswers < Get answers getQuestions < Get questions STATUS_DISABLED < Disabled questions STATUS_ENABLED < Deleted questions
system/library/msreport.php MsReport
_calculateDateEnd < Get time period end date _calculateDateStart < Get time period start date _getAnalyticsData < Execute an SQL request and populate an array with sales analytics data getCustomersCount < Get the total number of customers getCustomersOnlineCount < Get the total number of customers online getLastOrders < Get 5 latest orders getOrdersCount < Get the total number of orders getPaymentsData < Get the data for Payment report getPayoutsData < Get the data for Payout report getProductsCount < Get the number of products getProductsViewCount < Get the number of product views getSalesAnalytics < Get total orders and gross totals for each metric unit (week, month etc.) over a time period getSalesByCustomerData < Get the data for Sales by customer report getSalesByPeriodData < Get the data for Sales by period report getSalesByProductData < Get the data for Sales by product report getSalesBySellerData < Get the data for Sales by seller report getSalesCount < Get the total number of sales getSalesData < Get the data for Sales report getSellerFinancesData < Get the data for Seller finances report getSellerLastMessages < Get seller's last messages getSellerLastOrders < Get seller's last orders getSellersBalanceCount < Get the number of seller's balance records getSellersCount < Get the number of sellers getTopCountriesAnalytics < Get the data for Top countries dashboard block getTopCustomersAnalytics < Get the data for Top customers dashboard block getTopProductsAnalytics < Get the data for Top products dashboard block getTopProductsByViewsAnalytics < Get the data for Top viewed products dashboard block getTopSellersAnalytics < Get the data for Top sellers dashboard block getTransactionsData < Get the data for Transactions report
system/library/msreturn.php (Deprecated)
MsReturn _createReturnProduct createReturn createReturnHistory getReturnData getReturnHistory getReturnsList STATUS_CLOSED STATUS_OPENED
system/library/msreview.php MsReview
addReviewComment < Create a new review comment (deprecated) createOrUpdateReview < Create/update a review createReviewAttachment < Create a review attachment deleteReview < Delete a review deleteReviewAttachment < Delete a review attachment deleteReviewComment < Delete a review comment (deprecated) getFeedbackHistory < Get a history of reviews getReviewAttachments < Get the list of review attachments getReviewComments < Get the list of review comments getReviews < Get reviews setHelpful < Increment the helpful counter (deprecated) STATUS_ACTIVE < Active reviews STATUS_INACTIVE < Inactive reviews
system/library/msseller.php MsSeller
_dupeSlug < Generate a suffixed SEO slug if one already exists adminEditSeller < Edit seller (for admin-area use) changeApproval < Approve/unapprove a seller changeStatus < Change seller's status createSeller < Create a seller account deleteSeller < Delete a seller account editSeller < Edit seller getCompany < Get seller's company getCountryId < Get seller's country id getCustomers < Get customers getDescription < Get seller's store description (translated) getNickname < Get seller's nickname getSalt < Get seller's DB salt getSeller < Get seller data getSellerAvatar < Get seller's avatar getSellerBanner < Get seller's banner getSellerCustomers < Get seller's customer list getSellerDescriptions < Get seller descriptions in bulk (translated) getSellerEmail < Get seller's email getSellerFullName < Get seller's full name getSellerGoogleGeoLocation < Get seller's geolocation data getSellerMsCategories < Get seller's categories getSellerName < Get seller's name getSellerNickname < Get seller's nickname getSellers < Get the list of sellers getStatus < Get seller's status getTotalEarnings < Get seller's total earnings getTotalSellers < Get the total number of sellers isCustomerSeller < Verify if the customer has a seller account MS_SELLER_VALIDATION_ACTIVATION (deprecated) MS_SELLER_VALIDATION_APPROVAL < Sellers requiring approval MS_SELLER_VALIDATION_NONE < Sellers requiring no validation nicknameTaken < Verify if the nickname is free STATUS_ACTIVE < Active sellers STATUS_DELETED < Deleted sellers STATUS_DISABLED < Disabled sellers STATUS_INACTIVE < Inactive sellers STATUS_INCOMPLETE < Incomplete sellers STATUS_UNPAID < Unpaid seller accounts updateSellerPositions < Update seller geolocation positions
system/library/mssellergroup.php MsSellerGroup
createSellerGroup < Create a seller group deleteSellerGroup < Delete a seller group editSellerGroup < Edit a seller group getSellerGroup < Get seller group getSellerGroupBySellerId < Get specific seller's group getSellerGroupDescriptions < Get seller group descriptions (translated) getSellerGroups < Get seller groups getTotalSellerGroups < Get the total number of seller groups
system/library/mssetting.php MsSetting
_slr_gr_settings < The array of default seller group settings _slr_settings < The array of default seller settings calculateSellerSettingValue < Calculate settings that apply to a specific seller createSellerGroupSetting < Create seller group settings createSellerSetting < Create seller settings deleteSellerGroupSetting < Delete seller group settings deleteSellerSetting < Delete seller settings getSellerDefaults < Get seller's default settings getSellerGroupDefaults < Get group's default settings getSellerGroupSettings < Get settings for a seller group getSellerSettings < Get settings for a seller
system/library/msshippingmethod.php MsShippingMethod
createShippingDeliveryTime < Create delivery times for a shipping method createShippingMethod < Create a shipping method deleteShippingDeliveryTime < Delete delivery times for a shipping method deleteShippingMethod < Delete a shipping method editShippingDeliveryTime < Edit delivery times for a shipping method editShippingMethod < Edit a shipping method getSellerShipping < Get seller's shipping settings getShippingAvailability < Verify if a shipping method is available for a product getShippingCompanies < Get the list of shipping companies getShippingCountries < Get the list of shipping countries getShippingDeliveryTimes < Get the list of shipping delivery times getShippingGeoZones < Get the list of shipping geozones getShippingMethods < Get the list of shipping methods getTotalCombinedShippingRulesByMethodId < Get the total number of combined shipping rules for a specific method getTotalProductShippingRulesByMethodId < Get the total number of product shipping rules for a specific method saveSellerShipping < Save seller's shipping settings shippingMethodExists < Verify if a shipping method exists STATUS_DISABLED < Disabled shipping methods STATUS_ENABLED < Enabled shipping methods
system/library/msstatistic.php MsStatistic (Deprecated)
_getConcatStatuses getGrandTotalSales getSalesByDay getSalesByMonth getSalesByYear getStatsByProducts getStatsByYears getTotalByYear getYearsOfOrdersBySeller
system/library/mssuborder.php MsSuborder
addSuborderHistory < Create a seller order history record createSuborder < Create a new seller order getOrders < Get the list of orders getSuborderHistory < Get suborder's history getSuborders < Get the list of suborders getSuborderStatus < Get the status of a seller order getSuborderTotals < Get the totals for a seller order isValidSeller < Verify if a seller is valid STATE_CANCELLED < Cancelled seller orders STATE_COMPLETED < Completed seller orders STATE_FAILED < Failed seller orders STATE_PENDING < Pending seller orders STATE_PROCESSING < Processing seller orders updateSuborderStatus < Update the status of a seller order
system/library/mssuborderstatus.php MsSuborderStatus
addMsSuborderStatus < Create a new seller order status record deleteMsSuborderStatus < Delete a seller order status editMsSuborderStatus < Edit a seller order status getMsSuborderStatuses < Get the list of seller order statuses getOcOrderStatuses < Get the list of OpenCart order statuses getSuborderStateByStatusId < Get the state of a specific seller order getSuborderStateData < Get the data of a seller order state getSubStatusName < Get the name of a seller order (Deprecated)
system/library/mstransaction.php MsTransaction
_getOrderProducts < Get the products belonging to an order _getTotalSellerProductsInCart < Get the total number of seller's products in cart adminUpdateMsOrderDataEntries < Update seller order data entries (for admin-area use) createMsOrderBalanceEntries < Create seller order balance entries (transactions) createMsOrderDataEntries < Create seller order data entries (seller order details) getOrderCoupon < Get order coupon processBalance < Seller's order balance processing routine (at order status change) processCommission < Seller's commission processing routine (at order status change) processMsCoupon < Process seller coupon discounts (at order status change) processMsOrderData < Create order data entries for each order product (at order status change) processShipping < Create order shipping entries for each order product (at order status change) processSuborder < Create seller orders (at order status change)
system/library/msvalidator.php MsValidator
validate < Core validator method validate_alpha_numeric < Validate alphanumeric values validate_max_len < Validate maximum variable length validate_min_len < Validate minimum variable length validate_numeric < Validate numeric variables validate_phone_number < Validate phone numbers validate_required < Validate requireed fields validate_valid_url < Validate URLs