Interactive financial admin screen for cataloging musical instruments purchased for resale
or repair, recording purchase and sale economics, and attaching line-item repair parts drawn
from OpenCart inventory. Select or create an instrument, edit descriptive and financial fields,
and maintain a parts grid keyed by OpenCart product model.
- Select instrument — choose an existing record from the dropdown; the form reloads with that instrument's details and repair lines.
- Add instrument — enter brand and model, then submit to create a new
pd_instrument row.
- Update / Delete — save master-field changes or remove the instrument record (repair lines should be cleared separately as needed).
- Repair parts — enter an OpenCart model on a line, quantity, and rate; saving adjusts
oc_product quantity, logs to pd_product_log, and flags eBay revise.
- Profit summary — net sales and total repair costs roll into a profit row at the bottom of the parts table.