EmberPrice – Supplier Price List Import for WooCommerce
| 开发者 | emberprice |
|---|---|
| 更新时间 | 2026年7月30日 06:42 |
| PHP版本: | 8.2 及以上 |
| WordPress版本: | 7.0 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
- Upload a supplier's XLSX, XLS, or CSV price list.
- Map columns: code, description, price are auto-detected; confirm or correct once per supplier.
- Review matches: a matching cascade (learned aliases → SKU/GTIN → exact name → fuzzy matching) resolves each row against your real catalog; anything uncertain is flagged for a quick manual confirm, reject, or assign.
- Set pricing rules: margin (percentage or fixed), VAT handling, rounding (none, decimals, psychological
.99/.90endings, or nearest multiple), existing sale-price policy, and per-category overrides. - Preview the diff: old price → new price, percent change, confidence, and guardrail flags, exportable to CSV before anything touches your store.
- Apply: batched in the background via Action Scheduler, with a snapshot taken first so the whole import can be rolled back in one click.
$ 1.234,56, codes with leading zeros or no code column at all, section rows, discontinued items. EmberPrice's column detection and matching cascade are built around exactly these cases, and nothing is ever written to a product until you've seen the diff.
Safety by design
- A hard floor prevents any computed price from falling below the supplier's own list price (catches parsing errors before they reach your store).
- Guardrails flag any change beyond a configurable percentage for manual review, even when the product match itself is perfect.
- Every apply takes a snapshot first, so a rollback restores prices byte-for-byte.
- AI-assisted matching, planned as a future opt-in Pro feature (Anthropic or OpenAI, bring your own API key), is designed to only ever see the supplier's row text and your own catalog's product names/SKUs. It never sees customer, order, or other personal data.
安装:
- Make sure WooCommerce 8.0 or later is active.
- Upload the plugin (or install from the WordPress plugin directory) and activate it.
- Go to WooCommerce → EmberPrice to run the import wizard, or try it first with the bundled sample price list. History (past imports, rollback) is also under the WooCommerce menu.
屏幕截图:
常见问题:
Does this change my product prices immediately when I upload a file?
No. Nothing is written to any product until you reach the last step and explicitly apply the job. Every earlier step (mapping, matching, rules, preview) is read-only.
What file formats are supported?
XLSX, XLS, and CSV. PDF price lists (text-layer only, not scanned images) are planned for a future update.
Does it work with price lists that don't have a SKU column?
Yes. The matching cascade doesn't require a SKU: it also matches by learned alias (from your past confirmations), exact product name, and fuzzy name matching, so lists with only a description column still resolve.
Do I need an AI/LLM API key to use this plugin?
No. This release doesn't use one at all: the full wizard runs on local column detection and matching (alias, SKU/GTIN, exact name, fuzzy). AI-assisted matching and mapping is planned as a future opt-in, bring-your-own-key (BYOK) Pro feature; this plugin doesn't have or need its own AI backend.
What data would be sent to the AI provider?
Nothing today: this release doesn't include the AI-assisted matching code at all, so it never connects to Anthropic, OpenAI, or any other external service. When the feature ships in a future update, it will only run while explicitly enabled with your own API key, sending the supplier's own row text (names/codes) and matching candidates already in your store's catalog (product names, SKUs) only. Never customer, order, or other personal data.
Does it work with variable products?
Yes. The matching cascade resolves a supplier row directly to a variation (by its own SKU, name, or fuzzy match), and pricing rules apply to the matched variation.
What happens if the matching gets something wrong?
Any row the cascade isn't confident about is left for manual review: nothing auto-applies without a confirmed match. You can always search and manually assign a row to any product.
Can I undo a price update?
Yes. Every apply snapshots the previous prices first. Roll back any applied job from the History screen, not just the most recent one: snapshots are kept until the retention period expires.
Does this touch stock, cost prices, or multiple currencies?
Not in this version: EmberPrice is scoped to regular/sale price updates from a supplier list. Stock, cost fields, multi-currency, and scheduled/watched-folder imports are on the roadmap but not implemented yet.
更新日志:
- Admin: EmberPrice is now a single entry under WooCommerce instead of three separate submenus. Import, History, and Settings are tabs inside one screen with a shared header and navigation. Links and bookmarks to the previous screens redirect to the new ones, and resuming an import from History still works.
- Admin: more consistent, responsive, and accessible layout across the wizard, history, and settings.
- Renamed the plugin to "EmberPrice – Supplier Price List Import for WooCommerce" so the listing states what it does. The menu entry under WooCommerce is still just "EmberPrice".
- Fixed: the plugin description shown on the WordPress Plugins screen was in Spanish instead of English.
- No changes to importing, matching, pricing rules, applying, or rollback. Existing suppliers, aliases, jobs, and rollback history are preserved.
- Security: encrypt supplier uploads at rest and reject damaged, disguised, oversized, or unsafe workbooks.
- Reliability: resume interrupted jobs, detect and retry stalled background work, support WordPress Application Passwords, report partial failures, and block stale previews and duplicate product targets.
- Import quality: improve Spanish and Northwind column detection, enforce valid one-to-one mappings, and invalidate stale saved mappings.
- UX: give every WooCommerce submenu a distinct label, add useful paginated history with resume links, confirm rollbacks, and improve responsive and accessible controls.
- Initial public release: 6-step import wizard, matching cascade (alias/SKU/exact-name/fuzzy), pricing rules and guardrails, preview/export, batched apply with snapshot-based rollback, history screen, onboarding sample data.