CSV PRICE UPDATER FOR CE PHOENIX CART
Version 1.0

Compatibility
-------------
CE Phoenix Cart 1.1.0.6
PHP 8.2

Purpose
-------
Compares a supplier CSV price list with active Phoenix products. It displays
the current and supplier costs, a suggested selling price, net and gross
selling prices, product-specific VAT, margin, profit, and supplier RRP.

Nothing is changed until an administrator reviews the preview and selects
Commit All Data.

CSV format
----------
The first row must contain headings. The first three columns must be:

  Column A: product model / part number
  Column B: supplier net cost
  Column C: supplier net RRP

Comma, semicolon and tab-separated files are supported. Currency symbols and
UK or European decimal formatting are accepted.

Important behaviour
-------------------
- Only active products are matched and updated.
- Duplicate Phoenix products with the same model are all shown separately.
- Sync Cost is selected by default and may be cleared for individual products.
- Suggested selling price keeps the existing cash margin by adding the supplier
  cost difference to the current net selling price.
- Gross figures use the tax class assigned to each product.
- The add-on supports products_cost_price and legacy products_cost columns.
- If neither cost column exists, selling prices can still be compared and saved.
- Existing Phoenix specials are not changed. An active special may therefore
  continue to override the product's normal selling price in the shop.
- Uploads are read from PHP's protected temporary location and are not retained.
- The preview is protected by the signed-in administrator's session and a CSRF
  token. The database update runs inside a transaction.

No core files are changed and no database installation is required.

Licence
-------
GNU General Public License v2.0 or later.
