← Back to Genius hub

Order Data Field Map

The exact fields linking order data across WooCommerce, Amazon, Vendors, Genius ERP, FreightPop, Veeqo, Zoho CRM, Carriers, Production Schedule 3.0, and Returns – Kenosha — and how the Order Lookup Portal resolves any input to the full order picture.

strip pfx → WEB-{n} daily sync ↓ alt: strip HR- prefix ShipHeader.Code dispatch / tracking prepend WEB-{n} as-is Order Lookup Portal — oc.handiproducts.com/customer-service/order-lookup Accepts order references → resolves the full order picture → enriches from Production Schedule 3.0 and Returns – Kenosha WooCommerce order_number BG11737 channel_prefix BG / HT / HR Zoho CRM Order_Number HR-81888 Genius_Order_Number 10539632 id deep-link key Amazon OrderId (SC) 112-0088405-9659408 PO Number (VC) 5008154258 channel Seller Central / VC Vendors (Retail / EDI) vendor_po_number raw / varies vendor HD · Lowe's · Wayfair Genius ERP — Central Hub SalesOrder.Code 10539632 SalesOrder.PoNumber WEB-11737 Invoice.Code INV-00xxxxx Invoice.CustomerOrder ↑ SO.Code ShippingDetail.SOCode ↑ SO.Code ShippingDetail.ShipCode ↓ ShipHeader ShippingHeader.Code 00050409 FreightPop OrderNumber = ShipHeader.Code ShipmentID 14476280 QuoteID → UI URL key tracking 1ZXX… / 943… Carriers tracking_number FedEx/UPS/USPS carrier / service Ground/Express Veeqo orders.number 11737 → WEB-{n} orders.channel_id GetBiggies ch. shipments.tracking optional LTL: PoNumber/Code → expand variants → match exact row Production: SO.Code exact → Returns: exact logged handle → LTL Dashboard sheet orderRefRaw PoNumber variant shipper payload, not a key BOL # / tracking # payload, not a key Production Schedule 3.0 geniusSo SO.Code ATT/AST · CVR-AV · SDR MISC · Closed · YR Stock Status, dates & shop data Returns – Kenosha Order Numbers exact source token Company HR only Part # / Qty / Received Disposition (Column G) Production Schedule needs resolved Genius SO #. Returns – Kenosha compares only exact, recorded resolved-order handles — neither sheet creates order identity. Cross-system join key WooCommerce → Genius Veeqo → Genius Genius ↔ Zoho (sync) Genius → FreightPop Alt lookup path Amazon → Genius (stored as-is) Vendors → Genius (vendor PO raw)