Category Inventory Price Updates

This page reads public/products/category-inventory.json, applies the same pricing and stock formulas as product import, and lists products whose calculated price does not match the price currently stored in the database.

Price formula: source_price + (source_price * margin%) + shipping_fee, where source_price is price_with_vat when available, otherwise price. Stock formula: integer(stock_text) + stock_adjustment.

Pagination

Choose 100, 500, or all products per page. For a custom slice, choose Custom Range and enter an offset and limit, for example offset 0 with limit 500, or offset 500 with limit 850.

Showing 1 to 4 of 4 products with price mismatches.

Apply Inventory Updates

Update matched database products using the inventory JSON. Price is recalculated with the import formula, stock uses integer(stock_text) + stock_adjustment, and SKU is synced from the inventory file.

Products Needing Price Updates