{"slug":"wp-all-import","name":"WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets","description":"Easily import any file of any size into any plugin, post type, custom field, or taxonomy. Supports WooCommerce, ACF, images, galleries, users, real es …","author":"WP All Import","active_installs":100000,"version":"4.0.1","wp_org_url":"https://wordpress.org/plugins/wp-all-import/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"files","full_table_name":"wp_files","description":"Stores files data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"hash","full_table_name":"wp_hash","description":"Stores hash data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"history","full_table_name":"wp_history","description":"Stores history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"import_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"ENUM('manual','processing','trigger','continue','')","nullable":false,"primary_key":false},{"name":"time_run","type":"TEXT","nullable":true,"primary_key":false},{"name":"date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"summary","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_history ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, import_id BIGINT(20) UNSIGNED NOT NULL, type ENUM('manual','processing','trigger','continue','') NOT NULL DEFAULT '', time_run TEXT, date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', summary TEXT, PRIMARY KEY (id) ) $charset_collate;\");"},{"table_name":"images","full_table_name":"wp_images","description":"Stores images data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"imports","full_table_name":"wp_imports","description":"Stores imports data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"pmxi_files","full_table_name":"wp_pmxi_files","description":"Stores pmxi files data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_files` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `import_id` bigint unsigned NOT NULL,\\n  `name` text COLLATE utf8mb4_unicode_520_ci,\\n  `path` text COLLATE utf8mb4_unicode_520_ci,\\n  `registered_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"pmxi_hash","full_table_name":"wp_pmxi_hash","description":"Stores pmxi hash data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_hash` (\\n  `hash` binary(16) NOT NULL,\\n  `post_id` bigint unsigned NOT NULL,\\n  `import_id` smallint unsigned NOT NULL,\\n  `post_type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  PRIMARY KEY (`hash`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"pmxi_history","full_table_name":"wp_pmxi_history","description":"Stores pmxi history data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_history` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `import_id` bigint unsigned NOT NULL,\\n  `type` enum('manual','processing','trigger','continue','cli','') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `time_run` text COLLATE utf8mb4_unicode_520_ci,\\n  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `summary` text COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"pmxi_images","full_table_name":"wp_pmxi_images","description":"Stores pmxi images data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_images` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `attachment_id` bigint unsigned NOT NULL,\\n  `image_url` text COLLATE utf8mb4_unicode_520_ci,\\n  `image_filename` text COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"pmxi_imports","full_table_name":"wp_pmxi_imports","description":"Stores pmxi imports data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_imports` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `parent_import_id` bigint NOT NULL DEFAULT '0',\\n  `name` text COLLATE utf8mb4_unicode_520_ci,\\n  `friendly_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `feed_type` enum('xml','csv','zip','gz','') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `path` text COLLATE utf8mb4_unicode_520_ci,\\n  `xpath` text COLLATE utf8mb4_unicode_520_ci,\\n  `options` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `registered_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `root_element` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `processing` tinyint(1) NOT NULL DEFAULT '0',\\n  `executing` tinyint(1) NOT NULL DEFAULT '0',\\n  `triggered` tinyint(1) NOT NULL DEFAULT '0',\\n  `queue_chunk_number` bigint NOT NULL DEFAULT '0',\\n  `first_import` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `count` bigint NOT NULL DEFAULT '0',\\n  `imported` bigint NOT NULL DEFAULT '0',\\n  `created` bigint NOT NULL DEFAULT '0',\\n  `updated` bigint NOT NULL DEFAULT '0',\\n  `skipped` bigint NOT NULL DEFAULT '0',\\n  `deleted` bigint NOT NULL DEFAULT '0',\\n  `changed_missing` bigint NOT NULL DEFAULT '0',\\n  `canceled` tinyint(1) NOT NULL DEFAULT '0',\\n  `canceled_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `failed` tinyint(1) NOT NULL DEFAULT '0',\\n  `failed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `settings_update_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `last_activity` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `iteration` bigint NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"pmxi_posts","full_table_name":"wp_pmxi_posts","description":"Stores pmxi posts data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_posts` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `import_id` bigint unsigned NOT NULL,\\n  `unique_key` text COLLATE utf8mb4_unicode_520_ci,\\n  `product_key` text COLLATE utf8mb4_unicode_520_ci,\\n  `iteration` bigint NOT NULL DEFAULT '0',\\n  `specified` tinyint(1) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"pmxi_templates","full_table_name":"wp_pmxi_templates","description":"Stores pmxi templates data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pmxi_templates` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `options` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `scheduled` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `title` text COLLATE utf8mb4_unicode_520_ci,\\n  `content` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `is_keep_linebreaks` tinyint(1) NOT NULL DEFAULT '0',\\n  `is_leave_html` tinyint(1) NOT NULL DEFAULT '0',\\n  `fix_characters` tinyint(1) NOT NULL DEFAULT '0',\\n  `meta` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"templates","full_table_name":"wp_templates","description":"Stores templates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":13}