For those still using the (superseded) M2E version  2 and need to find or do something in its database tables, I have here an explanation of what ot find where.

First name is the real table name in M2E Pro 2.0.13, second name is a more intuitive one proposed by me.

  • m2e (m2e_tmpl_projects): Contains listing templates, corresponding to the backend concept of the same name.
  • m2epricetemplates (m2e_tmpl_prices): Contains price templates, just as they can be modified in the backend. Note that listing templates contain the price template information redundantly.
  • m2etemplates (m2e_tmpl_descriptions): Contains description templates, corresponding to the backend concept of the same name. Note that listing templates contain the price template information redundantly.
  • m2e_account (m2e_licences): Contains the licences for the M2E Pro software.
  • m2e_account_list (m2e_ebayaccounts): Contains eBay accounts used in M2E Pro.
  • m2e_api_versions ():
  • m2e_calculated_shipping ():
  • m2e_category_version ():
  • m2e_currency (): Contains currency abbreviations and their long form.
  • m2e_ebay_categories_77 (): The eBay category tree with category numbers, as fetched from eBay.
  • m2e_items ():
  • m2e_item_specifics ():
  • m2e_listings (m2e_projects): Contains listing sets: the things visible immediately when clicking on “M2E Pro -> Listings”. They are called “projects” in the database structure.
  • m2e_listing_item_shipping (m2e_listingtmpl_shipping): Contains the shipping methods of listing templates.
  • m2e_log (m2e_log_projects): The log of projects, containing eBay API results from listing, deleting etc. the articles of projects.
  • m2e_logcleaning_settings (m2e_config_log): Settings when logs should be cleaned automatically.
  • m2e_marketplace (m2e_marketplaces): Definitions of international eBay sites.
  • m2e_product_to_project (m2e_listings): The actual products contained in projects (“listing sets”), together with their linked eBay items if applicable.
  • m2e_p_to_p (m2e_listingtmpl_payments): Contains the payment methods of listing templates. The current name suggests to mean “payment to project”, but that would be wrong: projects are the actual listing sets, not their templates.
  • m2e_shedule_task_settings (m2e_config_sync): Configuration saying which sync tasks are enabled.
  • m2e_store_management (m2e_config_syncwindow): Configuration which start time to use for the time window when fetching updates from eBay. It will be 24 hours before the last successful sync.
  • m2e_synchronization_log (m2e_log_sync): The log of syncing with eBay, as available in “M2E Pro -> Logs -> Synchronization Logs”.
  • m2e_templates_descriptions (m2e_tmpl_ebay): eBay’s article templates, as downloaded from them.
  • m2e_transactions_events (m2e_log_transactions): The transactions done via eBay, as available in “M2E Pro -> Logs -> Transaction Log”.

2 thoughts on “M2E Pro version 2 table structure

  1. I have been exploring for a bit for any high quality articles or blog posts on this sort of space .
    Exploring in Yahoo I at last stumbled upon this website.
    Studying this information So i’m happy to express
    that I have an incredibly excellent uncanny feeling I
    came upon just what I needed. I most for sure will make certain to do not put out of your mind this site and
    give it a glance on a constant basis.

  2. Do you know where I can get an ER diagram of all the M2E tables?

Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>