CatalogDock — Product CSV Check & Price/Stock Update for WooCommerce
| 开发者 | drakkarwave |
|---|---|
| 更新时间 | 2026年11月13日 22:36 |
| 捐献地址: | 去捐款 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
- Check a product file before you import it. See which rows the WooCommerce importer would skip or link to the wrong parent, and why.
- Update prices and stock. Give it a CSV or Excel file with the SKU and the new Regular price, Sale price or Stock. The plugin compares it with your store by SKU and gives you CSV files that contain only the values that changed.
- Get pictures out of an Excel sheet. The pictures you choose are uploaded to the Media Library, and their URLs are written into the CSV.
- Parent / variation links: missing, ambiguous or misspelled
ParentSKUs, variations placed before their parent, parents that are not variable, links to other variations. - SKUs: duplicates, SKUs that differ only in letter case or spaces.
- Attributes: variation values that the parent does not offer (
LvsLarge), attributes missing on the parent, duplicate combinations. - Encoding and structure: UTF-8 only (other encodings are reported, never guessed), duplicate headers, broken quoting, up to 50,000 product records and 50 MB per file.
- Two safe automatic fixes: variations moved right after their parent, and outer spaces removed from
Parentwhen the match is unambiguous. Nothing else is changed: SKUs, prices and attributes are never rewritten. - The complete corrected CSV (with or without UTF-8 BOM), an HTML report, report.json and changes.csv.
- Excel workbooks (.xlsx, .xlsm): choose the sheet, header row and range; saved formula values are used, formulas are not recalculated, macros are never run.
- Store catalog. Reads the products and variations of your store through this site's REST API, page by page (ID, SKU, type, parent, attributes and terms, prices, stock and backorders). Then:
- Compare with the store: rows the importer would skip because the SKU or ID already exists, variations whose parent is already in the store (attributes and values checked against that parent), global attributes and terms the import would create.
- Update prices and stock: compares the file's SKUs with the catalog and prepares CSV files for Products → Import with "Update existing products" that contain only the changed prices and stock. The screen and the downloadable comparison report say when you compared, which read of the catalog was used (in UTC), and that the files hold the values of that moment. The plugin never creates or changes products, attributes or terms itself.
- Pictures embedded in an Excel sheet. Pictures are linked to product rows by their position on the sheet. You choose which files to upload, confirm, and they are added to the media library one by one (each result is shown). The plugin then writes their media library URLs into the Images column of the corrected CSV and checks it again.
安装:
- Upload the plugin ZIP under Plugins → Add New → Upload Plugin, and activate it.
- Open Products → CatalogDock (Tools → CatalogDock if WooCommerce is not active).
- Choose a CSV or Excel file and click "Check file".
屏幕截图:
常见问题:
Which importer is it for?
The built-in WooCommerce importer (Products → Import). The checks follow its rules. Files for WP All Import, WP-CLI or product feeds were not tested.
Can a price update change my stock?
No. Products where only the price changed go into a file with the SKU and price columns only. A stock column appears only in the file for products whose quantity changed.
What if stock changes between the comparison and the import?
The update file contains absolute quantities taken from your file. It knows nothing about sales made after the comparison: importing it sets the stock to the number in the file. The screen and the downloaded comparison report show when you compared and which read of the catalog was used. Read the store catalog again and compare once more right before you import.
Does the plugin send my file anywhere?
No. The file is processed in your browser tab. The plugin itself makes no requests to external servers. The "About the checks" link on the plugin page opens the tool's website in a new tab only when you click it; nothing is loaded from it.
What does the plugin store?
Nothing, except when you upload pictures: they become normal media library attachments, each with a SHA-256 marker (post meta _csvrepair_sha256) so that uploading the same file again reuses the attachment instead of creating a duplicate. Uninstalling the plugin removes the markers and keeps the attachments.
Who can use it?
The page needs the edit_products capability (administrators and shop managers). Reading the catalog also needs read_private_products; uploading pictures needs upload_files. The REST routes check these capabilities themselves.
Is a clean check a guarantee that the import will work?
No. The rules follow the WooCommerce 11.1.2 importer source code and were confirmed with real imports, but other versions, settings and plugins were not tested. Import into a staging copy first.
Why is the Excel sheet read this way?
Values are taken as stored: text stays text (007 stays 007), numbers are written without exponent, dates as YYYY-MM-DD. Hidden rows are included unless you skip them, as in Excel's own CSV export.
What is the difference between this plugin and the CatalogDock.org website?
This WordPress plugin runs inside your WordPress admin dashboard (Products → CatalogDock). All its features are free, with no pass. Full corrected downloads are free, within the supported file limits (50,000 product records and 50 MB per file). After reading your store's catalog through this site's REST API, it compares the file with your store's products, global attributes and terms in the supported scenarios, and it can upload chosen Excel pictures to the Media Library. The website CatalogDock.org works in any browser, without WordPress or store access. The file is processed locally in the browser tab: once the checker has loaded, CSV checks keep working without a connection, but reading an Excel file, payment and restoring a purchase need the network. The website adds supplier file preparation (it recognizes supplier column headers in 12 languages; the interface is in English), building parents and variations from flat rows, saved supplier mappings, and import batches of about 500 records per file, which reduce the risk of server timeouts on large catalogs. It checks only the files you give it and cannot see your store's global attribute settings. On the website, the check and a sample of up to 50 records are free; large results use a one-time CatalogDock Pass.
Where can I find documentation or get support?
Help and guides are at catalogdock.org/help and catalogdock.org/guides/woocommerce-import. For support, email support@catalogdock.org or open a topic in the WordPress.org support forum for this plugin.
更新日志:
- Price and stock update: the screen and the downloadable comparison report (update-report.csv) show the time of the comparison with your time zone, the read of the store catalog it used (in UTC), and a warning that the update files hold the values of that moment: importing them later can overwrite a price or stock changed in the store since, for example by a sale. The update files themselves do not change.
- Plugin name and description now say what it does: Product CSV Check & Price/Stock Update for WooCommerce.
- Check: a Stock value that WooCommerce would not store exactly as written (only spaces, a decimal or a unit, or a number beyond the range it keeps exactly) is reported as a warning.
- Check: clearer messages for SKUs and Parent values that differ only in spaces or letter case, naming the value WooCommerce stores.
- Price and stock update files: a stock value larger than WooCommerce can store exactly is not written.
- HTML report: wide tables can be scrolled with the keyboard; on narrow screens each table row is shown as a labelled card.
- Admin page: one spelling of "catalog", correct singular and plural forms, issue tables that keep codes, SKUs and field names whole, and short SHA-256 fingerprints (the full value on hover).
- New screenshots in English.
- Aligned text domain with WordPress.org slug for localization.
- Corrected menu navigation path to Products → CatalogDock.
- Added documentation and support links.
- First version: file check with automatic fixes and the complete corrected CSV, Excel sheets, store catalogue comparison, price and stock update files, upload of embedded pictures to the media library with a CSV containing their URLs.