← Back to Genius hub

Order Data Field Map

The exact fields linking order data across WooCommerce, Amazon, Vendors, Genius ERP, FreightPop, Veeqo, Zoho CRM, and Carriers — 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 — handiramp.com/genius/order-lookup Accepts any: WC order # · Genius SO Code · Invoice # · Shipping header # · FP ShipmentID · carrier tracking → resolves full order picture 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 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)