Advanced Database Mapping Schema Registry

Advanced Database Mapping Schema Registry

Use this registry after confirming Advanced Database Mapping Platform Eligibility. Choose the Source or Target side you need to check, then locate the Entity and corresponding Table Name for the platform and version in use.

The registry publishes platform database structures that are available for Advanced Database Mapping. It does not imply support for every table or column in a platform database, and it does not present file-based Source fields or project-specific Custom Platform structures as native platform database Tables.

How to read the schema

Term	Meaning in Advanced Database Mapping
Database	The complete data store used by the platform.
Entity	A core business object such as Products, Customers, Orders, Categories, Reviews, or CMS Pages.
Table	A database structure that stores part or all of an Entity’s data. One Entity can span multiple Tables.
Row	One stored record inside a Table, such as one Product or one Customer record.
Column	One stored attribute within a Table, such as SKU, price, email, or phone number.

A useful spreadsheet analogy is: Database = workbook, Table = sheet, Row = row, and Column = column. The Entity describes the business object represented by one or more of those Tables.

Supported Tables are a defined subset

Advanced Database Mapping supports the standard primary Tables represented in this registry and exposed for the active migration. System, cache, session, operational-log, auxiliary, and unsupported third-party plugin or extension Tables are not automatically supported. A supported Entity does not mean that every Table belonging to that Entity is available.

Source and Target platform database schemas

Use the tab that matches the side of the migration you are checking. The Source view contains published database schemas for supported Sources; the Target view contains only schemas for supported Targets. A platform can therefore appear in one view or both.

Source Platform

Platform	Version / variant	Entity	Table Name
AbanteCart	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers categories, category_descriptions products, product_descriptions customers, addresses orders, order_products reviews
Adobe Commerce	-	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_order, sales_order_item review, review_detail cms_page
Bagisto	-	Categories Products Customers Orders Reviews	categories, category_translations products, product_flat customers, addresses orders, order_items product_reviews
CS-Cart	2.x	Categories Products Customers Orders Reviews	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating
CS-Cart	4.x	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CS-Cart	4.10	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CS-Cart	4.9	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CS-Cart	Multi-Vendor 4.10	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CubeCart	4.x	Categories Products Customers Orders Reviews	category, cats_lang inventory, inv_lang customer, addressbook order_sum, order_inv reviews
CubeCart	6.x	Manufacturers Categories Products Customers Orders Reviews	manufacturers category, category_language inventory, inventory_language customer, addressbook order_summary, order_inventory reviews
DJ-Catalog2	-	Manufacturers Categories Products Customers Orders Reviews	djc2_producers djc2_categories djc2_items djc2_users, users djc2_orders, djc2_order_items djc2_item_reviews
Easy Digital Downloads	-	Categories Products Customers Orders Reviews	term_taxonomy, terms posts edd_customers, users posts comments
EasyStore	-	Categories Products Customers Orders Reviews Coupons Blog Posts	easystore_categories easystore_products easystore_users, users easystore_orders, easystore_order_product_map easystore_reviews easystore_coupons content
eShop	-	Manufacturers Categories Products Customers Orders Reviews Blog Posts	manufacturers, manufacturerdetails categories, categorydetails products, productdetails customers, addresses orders, orderproducts reviews content
Gambio	Standard schema	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
HikaShop	-	Manufacturers Categories Products Customers Orders Reviews	hikashop_category hikashop_category hikashop_product hikashop_user, users, hikashop_address hikashop_order, hikashop_order_product hikashop_vote
Interspire	-	Manufacturers Categories Products Customers Orders Reviews	brands, brand_words categories products customers, shipping_addresses orders, order_products reviews
J2Store	-	Manufacturers Categories Products Customers Orders	j2store_manufacturers categories j2store_products, content users, j2store_addresses j2store_orders, j2store_orderitems
Jigoshop	legacy	Categories Products Customers Orders Reviews Blog Posts CMS Pages	term_taxonomy, terms posts users posts comments posts posts
Jigoshop	2.x	Categories Products Customers Orders Reviews Blog Posts CMS Pages	term_taxonomy, terms posts users posts, jigoshop_order_item comments posts posts
JooCart	-	Manufacturers Categories Products Customers Orders Reviews CMS Pages Blog Posts	manufacturer category, category_description product, product_description customer, address order, order_product review information, information_description content
Joomla!	-	Customers Blog Posts	users content
JoomShopping	-	Manufacturers Categories Products Customers Orders Reviews Blog Posts	jshopping_manufacturers jshopping_categories jshopping_products jshopping_users jshopping_orders, jshopping_order_item jshopping_products_reviews content
LiteCart	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_info products, products_info customers orders, orders_items review
Loaded Commerce	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
Magento	1.3	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_flat_order, sales_flat_order_item review, review_detail cms_page
Magento	1.4	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_flat_order, sales_flat_order_item review, review_detail cms_page
Magento	1.9	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_flat_order, sales_flat_order_item review, review_detail cms_page
Magento	2.x	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_order, sales_order_item review, review_detail cms_page
Magento	2.x Enterprise	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_order, sales_order_item review, review_detail cms_page
MijoShop	-	Manufacturers Categories Products Customers Orders Reviews Blog Posts	manufacturer category, category_description product, product_description customer, address order, order_product review content
OpenCart	-	Manufacturers Categories Products Customers Orders Reviews Coupons	manufacturer category, category_description product, product_description customer, address order, order_product review coupon
osCMax	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
osCommerce	legacy	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
osCommerce	v4	Manufacturers Categories Products Customers Orders Reviews Coupons CMS Pages	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description coupons information
OXID eShop	-	Manufacturers Categories Products Customers Orders Reviews Coupons	oxmanufacturers oxcategories oxarticles oxuser, oxaddress oxorder, oxorderarticles oxreviews oxvouchers
PrestaShop	1.4	Manufacturers Categories Products Customers Orders Reviews Blog Posts	manufacturer, manufacturer_lang category, category_lang product, product_lang customer, address orders, order_detail product_comment cms, cms_lang
PrestaShop	1.7	Manufacturers Categories Products Customers Orders Reviews Coupons CMS Pages Blog Posts	manufacturer, manufacturer_lang category, category_lang product, product_lang customer, address orders, order_detail product_comment cart_rule cms, cms_lang cms, cms_lang
PrestaShop	9	Manufacturers Categories Products Customers Orders Reviews Coupons CMS Pages Blog Posts	manufacturer, manufacturer_lang category, category_lang product, product_lang customer, address orders, order_detail product_comment cart_rule cms, cms_lang cms, cms_lang
Shop-Script	-	Manufacturers Categories Products Customers Orders Reviews	manufacturer shop_category shop_product wa_contact, wa_contact_data shop_order, shop_order_items shop_product_reviews
Shopp	-	Categories Products Customers Orders Reviews CMS Pages Blog Posts	term_taxonomy, terms posts shopp_customer, shopp_address shopp_purchase, shopp_purchased reviews posts posts
Shopware	legacy	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts	s_articles_supplier s_categories s_articles s_user, s_user_addresses s_order, s_order_details s_articles_vote s_emarketing_voucher_codes s_blog
Shopware	6	Manufacturers Categories Products Customers Orders Reviews Coupons	product_manufacturer, product_manufacturer_translation category, category_translation product, product_translation customer, customer_address order, order_line_item product_review promotion
SunShop	-	Manufacturers Categories Products Customers Orders Reviews Coupons	manufacturers categories products users, address orders, orders_products products_reviews coupons
Sylius	-	Manufacturers Categories Products Customers Orders Reviews	odiseo_vendor, odiseo_vendor_translation sylius_taxon, sylius_taxon_translation sylius_product, sylius_product_translation sylius_customer, sylius_address sylius_order, sylius_order_item sylius_product_review
VirtueMart	1.x	Manufacturers Categories Products Customers Orders Reviews Blog Posts	vm_manufacturer vm_category vm_product users, vm_user_info vm_orders, vm_order_item vm_product_reviews content
VirtueMart	3.x	Manufacturers	virtuemart_manufacturers
WooCommerce	standard	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts CMS Pages	term_taxonomy, terms term_taxonomy, terms posts users posts, wc_orders, woocommerce_order_items comments posts posts posts
WooCommerce	Polylang	Categories Products Customers Orders Reviews Coupons	term_taxonomy, terms posts users posts, wc_orders, woocommerce_order_items comments posts
WooCommerce	WPML	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts CMS Pages	term_taxonomy, terms term_taxonomy, terms posts users posts, wc_orders, woocommerce_order_items comments posts posts posts
WordPress	-	Customers Blog Posts CMS Pages	users posts posts
WP EasyCart	-	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts CMS Pages	ec_manufacturer ec_category ec_product ec_user, ec_address ec_order, ec_orderdetail ec_review ec_promocode posts posts
WP eCommerce	-	Categories Products Customers Orders Blog Posts CMS Pages	term_taxonomy, terms posts users wpsc_purchase_logs, wpsc_cart_contents posts posts
X-Cart	4	Manufacturers Categories Products	manufacturers, manufacturers_lng categories, categories_lng products, products_lng
X-Cart	5	Categories Products Customers Orders Reviews	categories, category_translations products, product_translations profiles, profile_addresses orders, order_items reviews
xt-Commerce	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_addresses orders, orders_products products_reviews
Zen Cart	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description

Target Platform

Platform	Version / variant	Entity	Table Name
Adobe Commerce	-	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_order, sales_order_item review, review_detail cms_page
Bagisto	-	Categories Products Customers Orders Reviews	categories, category_translations products, product_flat customers, addresses orders, order_items product_reviews
CS-Cart	2.x	Categories Products Customers Orders Reviews	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating
CS-Cart	4.x	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CS-Cart	4.10	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CS-Cart	4.9	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
CS-Cart	Multi-Vendor 4.10	Categories Products Customers Orders Reviews Blog Posts CMS Pages	categories, category_descriptions products, product_descriptions users, user_profiles orders, order_details discussion_posts, discussion_messages, discussion_rating pages, page_descriptions pages, page_descriptions
EasyStore	-	Categories Products Customers Orders Reviews Coupons Blog Posts	easystore_categories easystore_products easystore_users, users easystore_orders, easystore_order_product_map easystore_reviews easystore_coupons content
eShop	-	Manufacturers Categories Products Customers Orders Reviews Blog Posts	manufacturers, manufacturerdetails categories, categorydetails products, productdetails customers, addresses orders, orderproducts reviews content
Gambio	Standard schema	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
J2Store	-	Manufacturers Categories Products Customers Orders	j2store_manufacturers categories j2store_products, content users, j2store_addresses j2store_orders, j2store_orderitems
JooCart	-	Manufacturers Categories Products Customers Orders Reviews CMS Pages Blog Posts	manufacturer category, category_description product, product_description customer, address order, order_product review information, information_description content
Joomla!	-	Customers Blog Posts	users content
Loaded Commerce	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
Magento	1.3	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_flat_order, sales_flat_order_item review, review_detail cms_page
Magento	1.4	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_flat_order, sales_flat_order_item review, review_detail cms_page
Magento	1.9	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_flat_order, sales_flat_order_item review, review_detail cms_page
Magento	2.x	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_order, sales_order_item review, review_detail cms_page
Magento	2.x Enterprise	Categories Products Customers Orders Reviews CMS Pages	catalog_category_entity catalog_product_entity customer_entity, customer_address_entity sales_order, sales_order_item review, review_detail cms_page
MijoShop	-	Manufacturers Categories Products Customers Orders Reviews Blog Posts	manufacturer category, category_description product, product_description customer, address order, order_product review content
OpenCart	-	Manufacturers Categories Products Customers Orders Reviews Coupons	manufacturer category, category_description product, product_description customer, address order, order_product review coupon
osCMax	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
osCommerce	legacy	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description
osCommerce	v4	Manufacturers Categories Products Customers Orders Reviews Coupons CMS Pages	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description coupons information
Phoca Cart	-	Manufacturers Categories Products Customers Orders Reviews Blog Posts	phocacart_manufacturers phocacart_categories phocacart_products users, phocacart_users phocacart_orders, phocacart_order_products phocacart_reviews content
PrestaShop	1.4	Manufacturers Categories Products Customers Orders Reviews Blog Posts	manufacturer, manufacturer_lang category, category_lang product, product_lang customer, address orders, order_detail product_comment cms, cms_lang
PrestaShop	1.7	Manufacturers Categories Products Customers Orders Reviews Coupons CMS Pages Blog Posts	manufacturer, manufacturer_lang category, category_lang product, product_lang customer, address orders, order_detail product_comment cart_rule cms, cms_lang cms, cms_lang
PrestaShop	9	Manufacturers Categories Products Customers Orders Reviews Coupons CMS Pages Blog Posts	manufacturer, manufacturer_lang category, category_lang product, product_lang customer, address orders, order_detail product_comment cart_rule cms, cms_lang cms, cms_lang
Shopware	legacy	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts	s_articles_supplier s_categories s_articles s_user, s_user_addresses s_order, s_order_details s_articles_vote s_emarketing_voucher_codes s_blog
Shopware	6	Manufacturers Categories Products Customers Orders Reviews Coupons	product_manufacturer, product_manufacturer_translation category, category_translation product, product_translation customer, customer_address order, order_line_item product_review promotion
VirtueMart	1.x	Manufacturers Categories Products Customers Orders Reviews Blog Posts	vm_manufacturer vm_category vm_product users, vm_user_info vm_orders, vm_order_item vm_product_reviews content
VirtueMart	3.x	Manufacturers	virtuemart_manufacturers
WooCommerce	standard	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts CMS Pages	term_taxonomy, terms term_taxonomy, terms posts users posts, wc_orders, woocommerce_order_items comments posts posts posts
WooCommerce	Polylang	Categories Products Customers Orders Reviews Coupons	term_taxonomy, terms posts users posts, wc_orders, woocommerce_order_items comments posts
WooCommerce	WPML	Manufacturers Categories Products Customers Orders Reviews Coupons Blog Posts CMS Pages	term_taxonomy, terms term_taxonomy, terms posts users posts, wc_orders, woocommerce_order_items comments posts posts posts
WordPress	-	Customers Blog Posts CMS Pages	users posts posts
X-Cart	4	Manufacturers Categories Products	manufacturers, manufacturers_lng categories, categories_lng products, products_lng
X-Cart	5	Categories Products Customers Orders Reviews	categories, category_translations products, product_translations profiles, profile_addresses orders, order_items reviews
Zen Cart	-	Manufacturers Categories Products Customers Orders Reviews	manufacturers, manufacturers_info categories, categories_description products, products_description customers, customers_info, address_book orders, orders_products reviews, reviews_description

File-based and Custom Platform Source structures

CSV, XLS, and XML use their required Product file structures rather than a published platform database schema. Their included file scope contains Product fields only. Additional entity structures or an unlisted Custom Platform are evaluated within the approved Custom Service scope and are not represented here as standard platform database Tables.

For a file-based Source, only Product fields present in the required file structure are available by default. For project-specific Custom Platform work, use only the fields or columns approved for that migration. Blank or null values remain blank or null unless Data Transformation changes the value.

Field and Value Type compatibility

A supported Table Name does not make every column pair valid. For each rule:

1. select a Source field or column exposed for the active migration;
2. select a supported Target field or column that represents the intended business meaning;
3. confirm the Target location can represent the complete value received from earlier Add-on processing;
4. use Data Transformation only when the value itself must change before database mapping.

Advanced Database Mapping routes the value it receives. It does not modify that value during mapping.

Stored data versus application behavior

A value can be written to a supported Target database location without automatically being used by the Target Store admin, storefront, theme, app, extension, integration, or business logic. Validate the consuming behavior after migration processing produces a result.

Related references and task

• Advanced Database Mapping Platform Eligibility for Source and Target availability.
• Add-on Platform Compatibility for the wider Standard Add-on compatibility model.
• Connect Your Source and Target Platforms for the connection setup and required values assigned to each supported platform.
• Configure Advanced Database Mapping for the active Configuration procedure.