Takayuki Miyauchi

DigitalCube Inc.

<p>The Advanced CSV Importer will import the following content from a CSV file.</p>
<p>Advanced CSV Importer is fully unit-tested. The plugin is stable and ready to be used in large projects like enterprise applications.</p>
<ul>
<li>Posts, pages and other custom post types</li>
<li>Custom fields and post meta</li>
<li>Categories, tags</li>
</ul>
<p>https://github.com/miya0001/advanced-csv-importer</p>
<p>This plugin requires PHP 5.3 or later.</p>
<h4>Default CSV field names</h4>
<ul>
<li>ID</li>
<li>post_content</li>
<li>post_name</li>
<li>post_title</li>
<li>post_status</li>
<li>post_type</li>
<li>post_author</li>
<li>ping_status</li>
<li>post_parent</li>
<li>menu_order</li>
<li>to_ping</li>
<li>pinged</li>
<li>post_password</li>
<li>guid</li>
<li>post_content_filtered</li>
<li>post_excerpt</li>
<li>post_date</li>
<li>post_date_gmt</li>
<li>comment_status</li>
<li>post_category</li>
<li>tags_input</li>
<li>page_template</li>
</ul>
<p>You can change field name via <code>acsv_post_object_keys</code> hook like following.</p>
<pre><code>add_filter( 'acsv_post_object_keys', function( $post_object_keys ){
    $post_object_keys['title'] = 'post_title';
    $post_object_keys['content'] = 'post_content';
    return $post_object_keys;
} );
</code></pre>
<p>Other columns will be saved to the custom field.</p>
<p>There is a sample of the CSV.</p>
<p><style>.gist table { margin-bottom: 0; }</style>
<div style="tab-size: 8" id="gist17649185" class="gist">
<div class="gist-file" translate="no" data-color-mode="light" data-light-theme="light">
<div class="gist-data">
<div class="js-gist-file-update-container js-task-list-container">
<div id="file-test-csv" class="file my-2">
<div itemprop="text"
      class="Box-body p-0 blob-wrapper data type-csv  "
      style="overflow: auto" tabindex="0" role="region"
      aria-label="test.csv content, created by miya0001 on 06:51PM on December 27, 2014."
    ></p>
<div class="blob-interaction-bar">
  <svg aria-hidden="true" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-search">
    <path d="M10.68 11.74a6 6 0 0 1-7.922-8.982 6 6 0 0 1 8.982 7.922l3.04 3.04a.749.749 0 0 1-.326 1.275.749.749 0 0 1-.734-.215ZM11.5 7a4.499 4.499 0 1 0-8.997 0A4.499 4.499 0 0 0 11.5 7Z"></path>
</svg><br />
  <input type="text" name="filter" class="form-control js-csv-filter-field blob-filter" autocapitalize="off"
         placeholder="Search this file…" aria-label="Search this file…">
</div>
<div class="markdown-body js-check-hidden-unicode" data-line-alert="before" data-hpc>
    <template class="js-file-alert-template"></p>
<div data-view-component="true" class="flash flash-warn flash-full d-flex flex-items-center">
  <svg aria-hidden="true" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-alert">
    <path d="M6.457 1.047c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0 1 14.082 15H1.918a1.75 1.75 0 0 1-1.543-2.575Zm1.763.707a.25.25 0 0 0-.44 0L1.698 13.132a.25.25 0 0 0 .22.368h12.164a.25.25 0 0 0 .22-.368Zm.53 3.996v2.5a.75.75 0 0 1-1.5 0v-2.5a.75.75 0 0 1 1.5 0ZM9 11a1 1 0 1 1-2 0 1 1 0 0 1 2 0Z"></path>
</svg><br />
    <span><br />
      This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.<br />
      <a class="Link--inTextBlock" href="https://github.co/hiddenchars" target="_blank" rel="nofollow ugc">Learn more about bidirectional Unicode characters</a><br />
    </span></p>
<div data-view-component="true" class="flash-action">        <a href="{{ revealButtonHref }}" data-view-component="true" class="btn-sm btn" rel="nofollow ugc">    Show hidden characters<br />
</a>
</div>
</div>
<p></template><br />
<template class="js-line-alert-template"><br />
  <span aria-label="This line has hidden Unicode characters" data-view-component="true" class="line-alert tooltipped tooltipped-e"><br />
    <svg aria-hidden="true" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-alert">
    <path d="M6.457 1.047c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0 1 14.082 15H1.918a1.75 1.75 0 0 1-1.543-2.575Zm1.763.707a.25.25 0 0 0-.44 0L1.698 13.132a.25.25 0 0 0 .22.368h12.164a.25.25 0 0 0 .22-.368Zm.53 3.996v2.5a.75.75 0 0 1-1.5 0v-2.5a.75.75 0 0 1 1.5 0ZM9 11a1 1 0 1 1-2 0 1 1 0 0 1 2 0Z"></path>
</svg><br />
</span></template></p>
<table class="js-csv-data csv-data js-file-line-container">
<thead>
<tr id="file-test-csv-LC1" class="js-file-line">
<td id="file-test-csv-L1" class="blob-num js-line-number" data-line-number="1"></td>
<th>ID</th>
<th>post_name</th>
<th>post_author</th>
<th>post_date</th>
<th>post_type</th>
<th>post_status</th>
<th>post_title</th>
<th>post_content</th>
<th>post_category</th>
<th>tags_input</th>
<th>custom_field</th>
</tr>
</thead>
<tbody>
<tr id="file-test-csv-LC2" class="js-file-line">
<td id="file-test-csv-L2" class="blob-num js-line-number" data-line-number="2"></td>
<td></td>
<td>Import-test</td>
<td>admin</td>
<td>2013/9/13 0:00</td>
<td>post</td>
<td>publish</td>
<td>CSV Import Test</td>
<td>This is a post for csv import.<br />
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<br />
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</td>
<td>fruits</td>
<td>apple,banana</td>
<td>this is custom field value.</td>
</tr>
<tr id="file-test-csv-LC3" class="js-file-line">
<td id="file-test-csv-L3" class="blob-num js-line-number" data-line-number="3"></td>
<td></td>
<td></td>
<td>editor</td>
<td></td>
<td>post</td>
<td>publish</td>
<td>define author test</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr id="file-test-csv-LC4" class="js-file-line">
<td id="file-test-csv-L4" class="blob-num js-line-number" data-line-number="4"></td>
<td></td>
<td></td>
<td>2</td>
<td></td>
<td>post</td>
<td></td>
<td>define author id test</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr id="file-test-csv-LC5" class="js-file-line">
<td id="file-test-csv-L5" class="blob-num js-line-number" data-line-number="5"></td>
<td>1</td>
<td>Hello-world-updated</td>
<td></td>
<td></td>
<td>post</td>
<td></td>
<td>Hello world! Updated!</td>
<td>Welcome to WordPress. This is your first post. Updated by RS CSV Importer!</td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table></div>
</p></div>
</p></div>
</div></div>
<div class="gist-meta">
        <a href="https://gist.github.com/miya0001/06f1a8e2bf1789c7ddee/raw/3c95de96302f556e58049e550f9a14b047048dbe/test.csv" style="float:right" class="Link--inTextBlock" rel="nofollow ugc">view raw</a><br />
        <a href="https://gist.github.com/miya0001/06f1a8e2bf1789c7ddee#file-test-csv" class="Link--inTextBlock" rel="nofollow ugc"><br />
          test.csv<br />
        </a><br />
        hosted with ❤ by <a class="Link--inTextBlock" href="https://github.com" rel="nofollow ugc">GitHub</a>
      </div>
</p></div>
</div>
<h4>Action Hooks</h4>
<ul>
<li>acsv_after_insert_post</li>
</ul>
<h4>Filter Hooks</h4>
<ul>
<li>acsv_post_object_keys</li>
<li>acsv_post_defaults</li>
<li>acsv_import_upload_size_limit</li>
<li>acsv_pre_get_post_objects</li>
<li>acsv_after_get_post_objects</li>
<li>acsv_csv_format</li>
<li>acsv_csv_to_hash_array</li>
<li>acsv_get_user_by_field</li>
</ul>
<h4>WP-CLI</h4>
<p>Importing:</p>
<pre><code>$ wp csv import tests/_data/wp/sample.csv
+------+-----------------------+------+---------+------------+---------------------+
| ID   | Title                 | Type | Status  | Author     | Date                |
+------+-----------------------+------+---------+------------+---------------------+
| 1720 | CSV Import Test       | post | publish | admin      | 2013-09-13 00:00:00 |
| 1721 | define author test    | post | publish | admin      | 2014-12-27 18:44:46 |
| 1722 | define author id test | post | publish | themedemos | 2014-12-27 18:44:46 |
| 1    | Hello world! Updated! | post | publish | admin      | 2014-12-27 18:44:46 |
+------+-----------------------+------+---------+------------+---------------------+
</code></pre>
<p>History:</p>
<pre><code>$ wp csv log
+----------+-----------------------------+---------------------+---------+---------+
| ID       | Title                       | Date                | Success | Failure |
+----------+-----------------------------+---------------------+---------+---------+
| e0a66344 | Imported from WP-CLI.       | 2014-12-27 18:44:46 |       4 |       0 |
| 43c47af6 | Imported from admin screen. | 2014-12-27 16:53:17 |       4 |       0 |
| df0f140b | Imported from WP-CLI.       | 2014-12-27 16:21:42 |       4 |       0 |
+----------+-----------------------------+---------------------+---------+---------+
</code></pre>
<p>Details of the history:</p>
<pre><code>$ wp csv log e0a66344
+------+-----------------------+------+---------+------------+---------------------+
| ID   | Title                 | Type | Status  | Author     | Date                |
+------+-----------------------+------+---------+------------+---------------------+
| 1720 | CSV Import Test       | post | publish | admin      | 2013-09-13 00:00:00 |
| 1721 | define author test    | post | publish | admin      | 2014-12-27 18:44:46 |
| 1722 | define author id test | post | publish | themedemos | 2014-12-27 18:44:46 |
| 1    | Hello world! Updated! | post | publish | admin      | 2014-12-27 18:44:46 |
+------+-----------------------+------+---------+------------+---------------------+
</code></pre>


Advanced CSV Importer

Import posts, pages, custom fields, categories, tags and more from a CSV file.

Gerasimos

WP Republic

<p><strong>Building a WooCommerce store is easy. Maintaining a massive one is hard.</strong></p>
<p>We built <strong>WPRepublic Bulk Category Removal for WooCommerce</strong> to be the Swiss Army knife that every store administrator wishes they had. This plugin is designed to host a variety of essential add-ons and utilities, evolving into a complete operations center for your shop.</p>
<h3>The First Module: The “Bulk Delete” Solution</h3>
<p>Have you ever tried to delete a product category in WooCommerce, only to realize the <em>products</em> inside it stay behind?</p>
<p>You are left with thousands of orphaned items, and the default interface only lets you delete them 20 at a time. It is slow, it times out, and it frustrates even the most patient admins.<br />
<strong>For years, there wasn’t a simple, native way to say: “Delete this category AND everything inside it.”</strong></p>
<p><strong>Now there is.</strong></p>
<p>The <strong>WPRepublic Bulk Category Removal Cleanup Module</strong> allows you to select specific categories and surgically remove all products contained within them.</p>
<h3>Why this is the tool you’ve been looking for:</h3>
<ul>
<li><strong>The “Missing” Feature:</strong> Finally, you can bulk delete thousands of products based on their category with a few clicks.</li>
<li><strong>Deep Cleaning:</strong> It doesn’t just delete the post. It scrubs the database of orphaned relationships, <code>postmeta</code>, and <code>wc_product_meta_lookup</code> entries, keeping your database lean and fast.</li>
<li><strong>Safety First:</strong> Includes a <strong>Dry Run</strong> mode (enabled by default). Simulate the entire process and read the logs before you delete a single byte of data.</li>
</ul>
<h3>🚀 Supercharged with WP-CLI</h3>
<p>For developers and site reliability engineers, the graphical interface is just the beginning.<br />
<strong>WPRepublic Bulk Category Removal</strong> comes with robust <strong>WP-CLI integration</strong> out of the box.</p>
<ul>
<li><strong>No Timeouts:</strong> managing 50,000 products? Run the cleanup from the terminal. It is faster, more stable, and immune to browser timeouts (PHP max_execution_time).</li>
<li><strong>Secure & Scriptable:</strong> Automate your store maintenance via cron jobs or shell scripts securely.</li>
<li><strong>Dry Runs in Terminal:</strong> Test your cleanup logic directly in the command line before executing.</li>
</ul>
<h3>What’s Next?</h3>
<p>This is just the beginning. <strong>WPRepublic Bulk Category Removal for WooCommerce</strong> is being actively developed to include more modules for bulk editing, customer management, and store optimization.</p>
<blockquote>
<p><strong>WARNING:</strong> This is a powerful, destructive tool. Always perform a full database backup before running a live cleanup.</p>
</blockquote>
<h3>WP-CLI Commands</h3>
<p>Use the power of the command line to manage your store cleanup efficiently.</p>
<h3>1. List Categories</h3>
<p>View a table of all product categories, their IDs, slugs, and product counts.</p>
<pre><code>wp wpr-bulk-category-removal-woocommerce list-categories
</code></pre>
<h3>2. Run Cleanup</h3>
<p>Execute the cleanup process for specific categories.</p>
<p><strong>Options:</strong></p>
<ul>
<li><code>--term-id=<ids></code> : A comma-separated list of category IDs to process.</li>
<li><code>--category-slug=<slugs></code> : A comma-separated list of category slugs.</li>
<li><code>--dry-run</code> : (Optional) Simulate the cleanup without deleting data.</li>
</ul>
<p><strong>Examples:</strong></p>
<p><strong>Safe Simulation (Dry Run):</strong><br />
    wp wpr-bulk-category-removal-woocommerce run –category-slug=temp-collection –dry-run</p>
<p><strong>Live Cleanup (By ID):</strong><br />
    wp wpr-bulk-category-removal-woocommerce run –term-id=152,189</p>
<p><strong>Live Cleanup (By Slug):</strong><br />
    wp wpr-bulk-category-removal-woocommerce run –category-slug=clothing,accessories</p>


WPRepublic Bulk Category Removal for WooCommerce

The ultimate modular toolkit for WooCommerce admins. Starts with the "Missing Feature": Bulk Delete Products by Category (with WP-CLI support).

Advanced CSV Importer vs WPRepublic Bulk Category Removal for WooCommerce