=== Excel Price Updater for WooCommerce ===
Contributors: acreativestudio
Tags: woocommerce, prices, excel, csv, bulk update
Requires at least: 5.8
Tested up to: 7.1
Requires PHP: 7.4
Requires Plugins: woocommerce
Stable tag: 1.0.0
License: GPLv2 or later
License URI: https://www.gnu.org/licenses/gpl-2.0.html

Update WooCommerce prices in bulk from an Excel or CSV file, matched by SKU. Simulate first, apply, and undo with one click.

== Description ==

**Excel Price Updater for WooCommerce** lets you change the prices of hundreds or thousands of products with a single spreadsheet. Upload an .xlsx or .csv file, check what would change, apply it and – if you change your mind – restore the previous prices.

= What you can do =

* Update the **regular price** and the **sale price** of your products from an Excel (.xlsx) or CSV file.
* Match products by **SKU** (or by product ID).
* Run a **simulation** first: nothing is changed, and you get a report of what would happen.
* Follow the progress with a **progress bar**: large files are processed in small batches, so there are no timeouts.
* Download **CSV reports** of the simulation, the update and the restore.
* **Undo** an update with one click: the previous prices are saved automatically.
* **Resume** an interrupted update from where it stopped.
* Safety options: ignore empty or zero prices, block rows whose price changes by more than a percentage you choose, optionally remove existing sales when the sale price is empty.
* Understands prices written as `12,50`, `1.234,56`, `€ 12,5` or `1,234.56`, and common Italian column names (`codice`, `prezzo`, `prezzo_scontato`…).
* Compatible with WooCommerce High-Performance Order Storage (HPOS).
* Translated into Italian.

= How it works =

1. Prepare a file with the columns `sku`, `regular_price` and, if you want, `sale_price`.
2. Go to **WooCommerce → Update prices (Excel)** and upload the file.
3. Run the simulation and check the report.
4. Apply the prices. Download the report. Undo if needed.

An example file is included in the plugin.

= Need more? =

The **Pro version** adds VAT conversion, markup and discount, price rounding, minimum margin check, variable products and variations, stock, EAN and sale dates, matching by EAN or custom field, supplier profiles, scheduled updates from a URL or Google Sheets, background processing with email notification, interactive preview, bulk delete from Excel and WP-CLI. Learn more at [Excel Price Updater Pro](https://a-creativestudio.com/excel-price-updater-pro-for-woocommerce/).

== Installation ==

1. Make sure WooCommerce is installed and active.
2. Upload the plugin folder to `/wp-content/plugins/`, or install it from the Plugins screen in WordPress.
3. Activate the plugin.
4. Go to **WooCommerce → Update prices (Excel)**.

== Frequently Asked Questions ==

= Does it change anything before I confirm? =

No. The analysis and the simulation only read your file and your products. Prices change only when you click "Apply prices now".

= How do I undo an update? =

In the results, or in "Recent jobs", click "Restore previous prices". The plugin stores the previous prices of every product it changed.

= How long are the files kept? =

Uploaded data, reports and price backups are stored in a protected folder inside `wp-content/uploads` and deleted automatically after 30 days, or when you delete the job or the plugin.

= Are variable products supported? =

In this free version the price of a variable product cannot be set directly: use the SKU of each variation. Handling of variable products and all their variations is part of the Pro version.

= Which columns are required? =

`sku` (or `id`) and at least one of `regular_price` and `sale_price`. Other columns are ignored.

= My prices include VAT, the file does not. =

The prices in the file are written to WooCommerce exactly as they are. Automatic VAT conversion is part of the Pro version.

= Does the plugin send data anywhere? =

No. The plugin does not contact external servers and does not track you.

== Screenshots ==

1. Upload the file and check the detected columns.
2. Simulation results with the list of issues.
3. Recent jobs: reports, resume and restore.

== Changelog ==

= 1.0.0 =
* First release.

== Upgrade Notice ==

= 1.0.0 =
First release.
