Anchor CSV Prep

=== Anchor CSV Prep === Contributors: anchorsystems Tags: csv, import, woocommerce, data cleanup, spreadsheet Requires at least: 6.2 Tested up to: 7.1 Requires PHP: 8.1 Stable tag: 1.1.1 License: GPLv2 or later License URI: https://www.gnu.org/licenses/gpl-2.0.html

Prepare messy CSV data for WordPress and WooCommerce imports — without Excel formulas or developer help.

== Description ==

Anchor CSV Prep helps store administrators prepare supplier and marketplace CSV files before importing them with tools such as the WooCommerce product CSV importer or WP All Import.

It is a focused CSV prep workflow inside wp-admin:

1. Upload a CSV
2. Review structure and delimiter
3. Clean data with an ordered pipeline
4. Preview before/after samples
5. Check import readiness
6. Download a cleaned CSV for your importer

= Why use it =

• Fix whitespace, headers, combined fields, and inconsistent values without Excel formulas
• Live before/after preview while you build steps
• WooCommerce products target that checks common product CSV headers
• Formula-like cells neutralized on export so Excel does not execute them
• Files stay on your WordPress site and expire automatically

= Cleanup operations =

• Trim whitespace
• Find and replace
• Map values
• Fill blanks
• Rename, delete, and reorder columns
• Split and merge columns
• Remove duplicate rows
• Filter rows

= Important =

This plugin does not import products, posts, or users into WordPress or WooCommerce yet. It prepares a CSV for your existing importer.

Product site: https://wp-data-transformer.vercel.app Author: Anchor Systems (https://www.anchorsystems.dev)

== Installation ==

1. Upload the plugin zip via Plugins → Add New → Upload Plugin, or copy the anchor-csv-prep folder to /wp-content/plugins/
2. Activate Anchor CSV Prep
3. Open CSV Import Prep in the admin menu

== Frequently Asked Questions ==

= Does this import into WooCommerce? =

Not yet. It prepares a clean CSV for your existing importer. Choose the WooCommerce products target to get readiness checks for common product headers.

= Where are uploaded files stored? =

On your WordPress site under wp-content/uploads/anchor-csv-prep/, protected from direct web access. Jobs expire after 48 hours. See the Privacy page on the product site for details.

= What file size is supported? =

By default, uploads are limited to about 5 MB and 25,000 rows. Advanced sites can adjust these with filters.

= Who can use the plugin? =

Administrators (or users granted the wpdt_manage capability).

== Screenshots ==

1. Upload a CSV and review detected columns
2. Build a cleanup pipeline with live before/after preview
3. WooCommerce products readiness check
4. Download a prepared CSV for your importer

== Changelog ==

= 1.1.1 =

• Clear remaining Plugin Check errors (no phpcs.xml in package; inline PHPCS for WP-free core)
• Use $wpdb %i identifiers for job table queries
• Requires WordPress 6.2+

= 1.1.0 =

• Renamed to Anchor CSV Prep (slug: anchor-csv-prep) for WordPress.org trademark compliance
• Plugin Check remediation: escaping/SQL patterns, upload handling, ABSPATH guards, PHPCS ruleset
• Tested up to WordPress 7.1; readme tags limited to five
• Removed hidden packaging files and discouraged load_plugin_textdomain() call

= 1.0.0 =

• Public packaging for WordPress.org listing
• Product site links (docs, support, privacy)
• Filter rows; WooCommerce products readiness profile
• Clean UI polish (reorder steps, readable summaries, multi-select columns)

= 0.2.0 =

• Filter rows; WooCommerce products target; Clean UI polish

= 0.1.0 =

• Initial MVP: upload, pipeline, preview, readiness, safe export

== Upgrade Notice ==

= 1.1.1 = Plugin Check cleanup for WordPress.org; requires WordPress 6.2+.

= 1.1.0 = Renamed to Anchor CSV Prep for WordPress.org trademark rules; Plugin Check fixes for listing readiness.

= 1.0.0 = First public release packaging with docs/privacy links and WooCommerce readiness profile.