Inizia
Catalog Change Review

Catalog Change Review

Review bulk price changes before importing a Shopify or WooCommerce CSV. Compare current and proposed prices, flag missed discounts, cleared sale prices, and ambiguous product matches, and export findings to CSV, HTML, or JSON with source line numbers.
#Commercio
Valutazione
Servono altre valutazioni
Venduti
0
Come si usa
Scarica

Review bulk price changes before you import

Compare a current Shopify or WooCommerce product export with a proposed price update. Catalog Change Review shows before-and-after prices and identifies the rows that need attention before you open the store's import preview.

What you get

  • Before-and-after base or regular prices, plus changes to compare-at or sale prices when those columns are present.
  • Optional checks against a planned percentage change, with decimal price calculations and configurable rounding precision.
  • Source line numbers for unexpected prices, cleared values, and ambiguous or unmatched products and variants. WooCommerce profiles can also flag conflicting IDs and SKUs.
  • JSON for scripts, a CSV review queue for spreadsheet work, and an optional standalone HTML report.

When to use it

  • Before a promotion, confirm that a proposed price file applies the intended discount.
  • During catalog maintenance, catch cleared sale prices or changes to the wrong variants before importing.
  • When reviewing another team's price file, share the findings with the people who can confirm the intended edits.

Requirements

Python 3.9 or newer and two comma-delimited UTF-8 CSV files for the same store using supported English headers. Shopify files need the handle, price, and all three option name/value column pairs. Keep the first variant row for each handle before continuation rows. For WooCommerce core product exports, choose either ID or SKU as the matching column and use it in both files. The script uses Python's standard library. The guided workflow also needs an agent client with local file and command access.

How to run

Install the downloaded skill in your agent client. Give it the current export, the proposed update, the store platform, and the identity column for WooCommerce. If every matched product should get the same price adjustment, include the expected percentage.

From the skill folder, run either bundled example with a new HTML output filename.

python3 scripts/review_catalog.py examples/shopify-current.csv examples/shopify-update.csv --profile shopify --expected-percent=-10 --html shopify-review.html
python3 scripts/review_catalog.py examples/woo-current.csv examples/woo-update.csv --profile woo-id --expected-percent=-10 --html woo-review.html

The Shopify example reports one price outside the planned discount and one unmatched variant. The WooCommerce example reports a cleared sale price. Use python in place of python3 if that is your Python command.

For your own files, use --profile woo-sku when SKU is the intended key. Omit --expected-percent to review every detected price change. Use --format csv for a review queue, or --fail-on-findings to return exit code 1 after a completed review with findings. Review flagged rows and check the final file in the store's native import preview. The skill covers price changes for rows in the proposed update. Inventory, market-specific prices, and changes to product or variant structure are outside its scope.

Privacy and data handling

The bundled Python script reads exports on your device. It makes no network requests, requires no store credentials, and leaves the source exports untouched. Reports can contain product identifiers and prices. Running through an agent client may send prompts, file excerpts, or tool output to its configured model provider under that client's settings and terms. To keep the review local, run the Python command directly.

For support, contact [email protected]. Include a synthetic or redacted example if you need to show a problem.