Update Inventory

Update Inventory — Functional Description

Companion inventory editor for real-time quantity, weight, dimension, and shelf-location overrides. Opened from pickPackVerifyOrders.php (popup with ?product_id=) or directly from the Inventory menu. Compare OpenCart catalog data against verified warehouse values, then submit corrections to oc_product including primary location and overstock location fields.

  • Product code search — enter a model number, MPN, or alternate MPN (custom field 21) and click View; lookup resolves model first, then MPN, then alternate MPN.
  • Manufacturer / product dropdowns — optionally filter by manufacturer, then select a product from the list (shows alternate MPN in parentheses when present).
  • OpenCart vs. Verified Data — review shelf, pick, pack, order, P/O, and marketplace totals in the OpenCart column; enter corrected values in the Verified Data column.
  • Update — shelf quantity changes invoke SetShelfQuantity() and write to pd_product_log; weight, dimensions, location, and overstock fields update oc_product directly.
  • Close — when opened as a popup from pick/pack, use the Close button to return to the parent screen.
90152 Lee Precision Case Length Gauge & Shell Holder .45-70 Government
#1757 MPN=90152 ALT MPN=
Click here to view Product Log
OpenCart Data Verified Data
Shelf Qty:0
Pick Table:0
Packed:0
Build Table:0
*Total Qty avail:0
Stock Notify: 0
OpenCart Qty:0
Paid Orders Qty:0
Back Orders Qty:0
Unpaid Orders Qty:0
**Total Qty avail:0
P/O:
P/O Qty:0
Weight:0.10
Length:3.75
Width:3.50
Height:0.50
Location:04-01-052
Overstock Location:
Shelf Qty:
   
Weight:
Length:
Width:
Height:
Location:
Overstock Location:
Last Updated: 2026-09-27
Avail for sale: 2 eBay
0 Etsy
0 Gun Broker
0 Walmart

*Total Qty avail = Shelf Qty + Qty Packed + Qty on (Pick Table + Build Table)

**Total Qty avail = OpenCart Qty + Qty in (Paid Orders + Back Orders + Unpaid Orders)

When you adjust the Shelf Qty to represent what is actually on the shelf, the OpenCart Quantity is adjusted.

lee-precision-case-length-gauge-and-shell-holder-45-70-government90152-1757.jpg