Premium Features for Total Sync and Control ✨
This premium, feature-rich, secure, and high-performance plugin is designed to update your WooCommerce product catalog from various sources, with advanced logging, reporting, and export capabilities.
📚 Multiple Advanced Data Sources
- Manual Upload: Upload a CSV file directly.
- Server Path: Use a CSV file from a server path.
- Google Sheets: Import from a published Google Sheets CSV link.
- API Endpoints: Support for API Endpoints (JSON/XML).
- Structured Connections: Utilize dedicated fields for FTP/SFTP, Amazon S3, Dropbox, and Google Driveconnections.
- Direct Database Sync: Synchronize directly with your database (SQL).
🔍 Granular Control & Mapping
- Field Mapping Interface: An intuitive table-based interface on the Dashboard for mapping source columns/fields to WooCommerce product fields (ID, SKU, Price, Sale Price, Stock, Image URLs, Description, Short Description).
- Conditional Import Logic: Define rules to control updates based on existing data. For example, “Only update if new price is lower than the current one,” or “Set product status to ‘out of stock’ if the quantity is 0.”
- Advanced Product Matching: Go beyond SKU and ID and match by product name.
🖼️ Image Handling Enhancements
- Image URLs: Option to specify columns for Primary Image URL and Gallery Image URLs.
- Image Import: Ability to import images from external URLs and attach them to the product.
- Multiple Images: Manage multiple gallery images if provided as comma-separated URLs.
⚙️ Robust Automation & Performance
- Improved Scheduling Options: Flexible scheduling, including hourly, every few minutes, specific days of the week/month, and custom cron intervals.
- Delta Updates (Smart Sync): Optimizes the process by only processing products and fields that have actually changed, dramatically reducing resource usage.
- Import Queue Management: A robust queuing system prevents update overlaps, ensuring smooth operation.
- Background Processing: Ensures all heavy lifting happens in the background using WP-Cron, keeping the admin interface responsive.
📊 Detailed Reporting & User Interface
- Comprehensive Reports: A dedicated reports page logs every update, showing what was updated, skipped, or not found.
- Product Log: The “View Details” link for each report opens a dedicated page displaying granular product-level logs (SKU/ID, status, and specific changes).
- Refined Interface: A clean, intuitive, and responsive admin interface built with native WordPress styles.
🛡️ Secure and Compliant
- WordPress Code Standards: Strictly adheres to all WordPress coding standards and best practices.
- Security: Uses nonces and robust capability checks to prevent unauthorized access.
- Architecture: Built with a modern, object-oriented, and modular architecture for easy maintenance and extensibility.
🚀 Simple and Continuous Operation
- Real-time Updates: Dynamic messages provide real-time feedback on the batch processing progress.
- Transparent Operation: “Run Update” buttons are intelligently hidden during an active import to prevent accidental multiple submissions and provide a cleaner interface.
1. **Upload:** Upload the entire `woo-csv-updater-pro` directory to the `/wp-content/plugins/` directory of your WordPress installation.
2. **Deactivate Old Plugin (if applicable):** If you had the old “WooCommerce CSV Product Updater” active, go to `Plugins` in your WordPress admin and **deactivate** it.
3. **Activate New Plugin:** Activate the “WooCommerce CSV Product Updater Pro” plugin through the ‘Plugins’ menu in WordPress.
4. **Verify:** A new menu item “WCU Product Updater Pro” will appear in your WordPress admin menu. Your existing data (sources, reports) should seamlessly transition.
== Frequently Asked Questions ==
= How do I use the plugin? =
After activation, go to `WCU Product Updater Pro` -> `Sources`. You can add a new source (CSV upload, server path, or Google Sheets link). Once added, you can run a manual update from the `Dashboard` or set up an auto-schedule in the `Settings` tab. To view detailed logs, go to `WCU Product Updater Pro` -> `Reports` and click “View Details” next to a report.
= What columns does my CSV need? =
Your CSV file must include either an `id` or `sku` column for product matching. You can also include columns for `price`, `sale_price`, `stock`, `description`, and `short_description` columns.
== Screenshots ==
1. Screenshot showing the admin dashboard with the update status.
2. Screenshot showing the source management page.
3. Screenshot showing the update reports list.
4. Screenshot showing the detailed product logs page with export option.
= 1.0.7 =
* **Robust Automation & Performance Enhancements:**
* Implemented enhanced scheduling options for more granular intervals (e.g., every few minutes).
* Introduced a transient-based import queue management system to prevent concurrent updates.
* Enhanced delta update logic to more thoroughly compare all mapped fields (including descriptions) before updating.
* Improved memory and timeout handling during heavy processing.
= 1.0.6 =
* Fixed a bug where “Price Update Condition” and “Out of Stock Condition” checkboxes on the Dashboard page were not correctly reflecting saved states.
* Added support for mapping Product Description and Short Description fields.
= 1.0.5 =
* **Implemented Granular Control & Mapping:**
* Added a table-based Field Mapping interface on the Dashboard page.
* Introduced initial Conditional Import Logic options (Only update if new price is lower, Set out of stock if quantity is 0).
* Enabled advanced product matching by Product Name.
* **Implemented Image Handling Enhancements:**
* Added fields for Primary Image URL Column and Gallery Image URLs Column in mapping.
* Integrated logic to fetch and attach images from external URLs.
= 1.0.4 =
* Added dedicated input fields for FTP/SFTP, Amazon S3, Dropbox, and Google Drive source types on the Sources page.
* Enhanced JavaScript to dynamically show/hide these new fields based on the selected source type.
* Updated backend logic to store the configuration details for these new source types.
= 1.0.3 =
* Added new “Source Type” options for advanced data integrations.
* Implemented parsing for XML/JSON data from API Endpoints.
* Introduced placeholder structures for Cloud Storage (Dropbox, Google Drive, Amazon S3) via direct URLs, FTP/SFTP, and Direct Database Sync.
* Updated “How to Use” documentation to reflect new source capabilities.
= 1.0.2 =
* Fixed “Save Settings” button position on the Settings page.
* Enhanced “Schedule Interval” dropdown visibility logic: now visible only when scheduler is enabled AND a source is selected.
* Added granular time (Hour, Minute) and day (Day of Week) selectors for scheduled updates.
* Implemented more precise WP-Cron scheduling for granular intervals.
= 1.0.1 =
* Fixed admin menu links not appearing.
* Implemented conditional visibility for “Schedule Interval” dropdown on Settings page: visible only when scheduler is enabled AND a source is selected.
* Corrected “Saved!” text domain string in JavaScript.
= 1.0.0 =
* Initial Pro release.
* Plugin renamed to “WooCommerce CSV Product Updater Pro”.
* Main plugin file renamed to `woo-csv-updater-pro.php`.
* Text domain changed to `woo-csv-updater-pro`.
* “View Details” modal replaced with a dedicated “Product Logs” page.
* Added “Export to CSV” functionality on the product logs page.
* Fixed dropdown source name visibility on the Dashboard page.
