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”.
Leave a Reply