CUTPRICE STOCK RESET - 25 SEPTEMBER 2026

The stock report contains 2,210 rows for CUTPRICE WHOLESALE STORE.
AVCO is the selling price in ZAR (as instructed); Product Cost is the cost in ZAR.
Repeated names have separate product codes CP000001 to CP002210.
One in-stock row (Captain Ginger wi, 5 units) has AVCO R0 and is inactive until priced.

EXISTING DATABASE (XAMPP/Laragon or Namecheap)
1. In phpMyAdmin, select the database actually used by this CutPrice installation.
2. Export the complete database as SQL and save that backup outside the web folder.
3. In the same selected database, import:
   database/CUTPRICE_RESET_TEST_POS_AND_IMPORT_STOCK.sql
4. Upload the updated PHP files from this package to the matching installation.
5. Check that products show 2,210 items and that Sales Report is empty.
   Check A4 BOOK PACK: stock 59,000, ZAR selling price R35, cost R30.

The reset removes the current POS products, sales and sale items, sales returns,
credit sale/payment/ledger records, cashier sessions and related POS stock history.
It does not clear grocery orders, remittance transactions, customers, payroll or
unrelated cashbook entries. Review the backup before applying it to a live database.
Do not import the fresh database SQL over an existing database.

NEW EMPTY DATABASE
Import database/CUTPRICE_FRESH_DATABASE_REAL_STOCK_2026-09-25.sql once, then
upload the updated PHP files. This is a complete starting database from the
provided CutPrice package with its old POS test sales removed and real stock added.

The CSV in database/ is a reference copy of the source rows, not the built-in
bulk_stock_upload.php template. Use the SQL file for this reset.

Currency: product sell_price and cost_price are stored as ZAR. The POS displays
the ZAR sticker price and converts it to its existing USD accounting base using
exchange_rates.zar_rate (17.50 if no saved rate exists). Small ZAR cent differences
can occur when a USD line or total is rounded for the existing ledger. Check the
rate and a sample receipt before taking real payments. The stock source has no
barcodes, supplier, VAT classification or branch IDs; these were not invented.
