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.
FS-MR-50-Pink FS Reloading Plastic Ammo Box Medium Rifle 50 Round Translucent Pink
#3779 MPN=MR-50-Pink ALT MPN=
Click here to view Product Log
OpenCart Data Verified Data
Shelf Qty:75
Pick Table:0
Packed:0
Build Table:0
*Total Qty avail:75
Stock Notify: 0
OpenCart Qty:75
Paid Orders Qty:0
Back Orders Qty:0
Unpaid Orders Qty:0
**Total Qty avail:75
P/O:
P/O Qty:0
Weight:0.40
Length:5.75
Width:3.75
Height:3.50
Location:12-06-015
Overstock Location:12-06-TOP
Shelf Qty:
   
Weight:
Length:
Width:
Height:
Location:
Overstock Location:
Last Updated: 2025-01-11
Avail for sale: 0 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.

fs-reloading-plastic-ammo-box-medium-rifle-50-round-translucent-pinkmr-50-pink-3779.jpg