Palette Commerce Kit for WooCommerce
| 开发者 | paletteagencyy |
|---|---|
| 更新时间 | 2026年8月7日 14:59 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.0 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
Palette Commerce Kit for WooCommerce is a focused data-management toolkit for WooCommerce stores. It combines import, export, visual field mapping and operational logs in one WordPress administration menu.
The current feature set is intentionally focused on WooCommerce data operations: importing, exporting, field mapping, validation, row-level logs, rollback and scheduled processing.
The plugin is designed for store migrations, supplier files, recurring inventory updates, catalog maintenance and auditable bulk operations. Files remain on your server and no store data is sent to an external service.
Supported WooCommerce data
- Products, variable products and variations.
- Orders and order items.
- Customers and billing fields.
- Coupons and usage restrictions.
- Product inventory and stock operations.
- Read CSV, XLSX, Excel 2003 XML with an XLS extension, JSON, TXT, ODS and XML files.
- Download a separate starter template for each supported data type.
- Preview and validate data before modifying WooCommerce.
- Update an existing product when its SKU already exists, or create a new product for a new SKU.
- Create missing product categories and registered taxonomies when required.
- Import product images and galleries from WordPress attachment IDs or allowed URLs.
- Handle variable parent products and connect variations using a parent SKU or parent ID.
- Import product attributes, variation attributes, public custom fields and mapped metadata.
- Process normalized data in private packages of up to 500 KB.
- Queue packages sequentially through WooCommerce Action Scheduler, with WP-Cron as a fallback.
- Inspect file headers and sample rows without importing data.
- Connect source columns to WooCommerce product fields using drag and drop or select controls.
- Save, select, reset and delete reusable mapping profiles through AJAX.
- Use built-in presets for simple products, variable parent products and variations.
- Discover registered WooCommerce attributes and public taxonomies on the current site.
- Discover compatible ACF and MetaBox fields when their field definitions are available.
- Export products, orders, customers, coupons and inventory as CSV or XLSX.
- Select product columns and product categories.
- Include or exclude variations as separate product rows.
- Filter orders by date range, status, product and customer role.
- Filter customers by role and inventory by stock status.
- Protect spreadsheet exports against CSV formula injection.
- Download immediately or schedule recurring exports.
- Record the status, source row number and exact message for each processed row.
- Record operational failures from upload, parsing, mapping, queue, database and export operations.
- Display log and history dates in the Jalali calendar while retaining canonical timestamps for sorting.
- Download logs through an authenticated, nonce-protected CSV action.
- Clear row-level logs without removing rollback history.
- Roll back recorded imports by removing newly created records and restoring captured previous values.
- Retain import history for 30 days and row-level logs for 90 days.
- Store scheduled files and processing packages in a protected private location outside the public web root whenever the hosting layout permits it.
- Use randomized operating-system temporary storage as a protected fallback.
- Remove stale processing packages and temporary files automatically.
- Avoid storing raw customer identifiers in operational log contexts.
- Integrate with the WordPress personal-data exporter and eraser.
- Remove plugin options, schedules, private files and the custom log table on uninstall.
- Dedicated Palette-styled Import, Export, Logs and Training screens.
- Contextual information tooltips available by mouse, keyboard and touch.
- Locally bundled Vazirmatn typography with no remote font request.
- Responsive RTL-aware interface with LTR isolation for technical values.
安装:
- Upload the
palette-commerce-kitfolder to/wp-content/plugins/, or install the release ZIP from Plugins > Add New > Upload Plugin. - Make sure WooCommerce is installed and active.
- Activate Palette Commerce Kit for WooCommerce.
- Open Palette Commerce Kit in the WordPress administration menu.
- Visit the Training submenu for the recommended first-import workflow.
其他记录:
Palette Commerce Kit for WooCommerce is developed by Palette Agency.
This plugin bundles Vazirmatn version 33.003 by the Vazirmatn Project Authors. Vazirmatn is distributed under the SIL Open Font License 1.1. The complete license is included at
assets/fonts/vazirmatn/OFL.txt, and the upstream project is available at github.com/rastikerdar/vazirmatn.常见问题:
Does the template limit the fields I can import?
No. The template contains common fields for a quick start. The mapping screen discovers WooCommerce fields, product attributes, registered taxonomies and compatible custom fields available on the current website.
What happens when a product SKU already exists?
The matching WooCommerce product is updated. A new product is created when no matching SKU exists.
Can the plugin import variable products and variations?
Yes. Use a variable parent row and connect variation rows with parent_sku or parent_id. The built-in mapping presets provide the common parent and variation fields.
What does rollback restore?
Rollback removes records created by the selected import and restores captured previous values for updated records. It is not a full database backup. Take a complete site backup before large production imports.
Where are scheduled and temporary files stored?
They are stored in a private directory outside the public WordPress web root when possible. If the hosting layout does not allow that location, the plugin uses a randomized operating-system temporary directory.
Does the plugin send data to Palette Agency, Google or another service?
No. Store data is processed locally. The administration font is bundled inside the plugin and no remote font service is contacted.
Why is an imported file split into 500 KB packages?
Smaller sequential jobs reduce the execution time and memory required by each request. This lowers the likelihood of server timeouts, although server resources and cron configuration still affect very large operations.
Does the plugin support old binary XLS files?
No. The XLS parser supports Excel 2003 XML workbooks. Convert legacy binary BIFF XLS files to XLSX or CSV first.
How long are logs retained?
Row-level logs are retained for 90 days. Import history used for rollback is retained for 30 days. Administrators can clear row-level logs manually at any time.
更新日志:
4.0.1 - 2026-07-28
- Updated the WordPress.org contributor username.
- Removed bundled locale files so translations are delivered through Translate.WordPress.org.
- Removed an unnecessary direct load of the WordPress user administration file.
- Routed parser reads and writes through the WordPress Filesystem API with explicit failure handling.
- Rebranded the plugin as Palette Commerce Kit for WooCommerce.
- Changed the directory, main file, text domain, PHP namespace and internal identifiers to the
palette-commerce-kitnaming system. - Focused the repository description on the plugin's current WooCommerce import, export and data-management features.
- Rebuilt the Persian translations and release package for the new identity.
- Resolved Plugin Check false positives for translated internal exception messages with precise PHPCS annotations.
- Prefixed local loop variables in the advanced order export template.
- Added complete internationalization for PHP and JavaScript administration interfaces.
- Added a translation template and bundled Persian (fa_IR) PO/MO translations.
- Added automatic script translation loading for the field-mapping interface.
- Increased the contrast of information icons inside the import header with a white default state and amber hover/focus state.
- Applied the locally bundled Vazirmatn font to every plugin administration descendant while preserving the Dashicons icon font.
- Changed the variable-font source declaration to the broadly compatible WOFF2 format and retained version-based cache busting.
- Aligned the plugin text domain and translation calls with the directory slug required by WordPress.org Plugin Check.
- Kept administration and storage identifiers stable for that release.
- Updated the public plugin branding and added the Palette Agency author URL.
- Added a complete in-plugin training screen with import, mapping, export, logging, rollback and troubleshooting guidance.
- Added accessible contextual information tooltips for administration sections and clarified the import header indicators.
- Bundled Vazirmatn locally under the SIL Open Font License 1.1 and applied it throughout the plugin interface.
- Improved contrast for the log-page header actions.
- Expanded the WordPress.org readme with complete features, usage, privacy, limitations and third-party license information.
- Corrected the private-storage class import used by immediate export downloads.
- Fixed log-table creation on MySQL 8 by replacing the reserved row_number column and adding a compatible migration.
- Removed automatic Google Fonts requests and all unapproved external asset loading.
- Added private storage outside the public web root and migrated legacy scheduled files.
- Added MIME, extension, upload-state and size validation for import and mapping files.
- Added queued 500 KB import packages using WooCommerce Action Scheduler with WP-Cron fallback.
- Added CSV formula-injection protection for exported spreadsheet data.
- Removed personal customer data from row-level log contexts and added privacy exporter/eraser integration.
- Added 30-day history retention, 90-day log retention and uninstall cleanup.
- Added authenticated CSV log downloads and improved output escaping.
- Updated the WordPress.org metadata and release documentation.
- Added multi-entity WooCommerce import and export for products, variations, orders, customers, coupons and inventory.
- Added product images, galleries, attributes, parent SKU and variation attribute support.
- Added preview validation, scheduling, rollback, AJAX mapping profiles and Jalali log dates.