Explore the Ordoro API data model

See how the various Ordoro endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Ordoro API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Ordoro API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Address

Documentation: https://docs.ordoro.com/#tag/Address/operation/Address_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Company string - -
Street1 string - -
Street2 string - -
Zip string - -
City string - -
State string - -
Country string - -
Email string - -
Phone string - -
Fax string - -
ReferenceNumber string - -
CartAddressID string - -

Cart

Documentation: https://docs.ordoro.com/#tag/Cart/operation/Cart_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Vendor string - -
VendorDisplay string - -
WorkerMachinga string - -
IsDemo boolean - -
ArchivedDate datetime - -
V3MigrationDate datetime - -
DefaultPackingListID long PackingList → ID -
DefaultProductSync boolean - -
DefaultMinExportQty decimal - -
PreventWriteBackSettingsAdjustment boolean - -

GoodsReceipt

Documentation: https://docs.ordoro.com/#tag/GoodsReceipt/operation/GoodsReceipt_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
GoodsReceiptID string - -
PoID string PurchaseOrder → PoID -
PoStatus string - -
Status string - -
Created datetime - -
Updated datetime - -
Received datetime - -

Order

Documentation: https://docs.ordoro.com/#tag/Order/operation/Order_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderNumber string - -
Barcode string - -
OrderPlacedDate datetime - -
CancelledDate datetime - -
Status string - -
AllocationStatus string - -
Shippability string - -
OrderAddressCompany string - -
OrderAddressStreet1 string - -
OrderAddressStreet2 string - -
OrderAddressZip string - -
OrderAddressName string - -
OrderAddressCity string - -
OrderAddressState string - -
OrderAddressCountry string - -
OrderAddressEmail string - -
OrderAddressPhone string - -
OrderAddressFax string - -
OrderAddressReferenceNumber string - -
ShippingAddressCompany string - -
ShippingAddressStreet1 string - -
ShippingAddressStreet2 string - -
ShippingAddressZip string - -
ShippingAddressName string - -
ShippingAddressCity string - -
ShippingAddressState string - -
ShippingAddressCountry string - -
ShippingAddressEmail string - -
ShippingAddressPhone string - -
ShippingAddressFax string - -
ShippingAddressReferenceNumber string - -
UpdatedDate datetime - -
CreatedDate datetime - -
Weight decimal - -
NotesFromCustomer string - -
InternalNotes string - -
RequestingShippingMethod string - -
ShipToIsBillTo boolean - -
HasRevision boolean - -
IsOrderParent boolean - -
ParentOrderNumber string Order → OrderNumber -
DeliverByDate datetime - -
ShipByDate datetime - -
WarehouseID long Warehouse → ID -
SalesChannelID long - -
DropshippingInfoRequestedDate datetime - -
DropshippingInfoSupplierID datetime - -
DropshippingInfoShowPrice boolean - -
DropshippingInfoShowShipToEmail boolean - -
DropshippingInfoRequestedShippingMethod string - -
DropshippingInfoRequestedShippingCarrier string - -
DropshippingInfoRequestedShippingAccount string - -

OrderTag

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Text string - -
Color string - -

PackingList

Documentation: https://docs.ordoro.com/#tag/Packing-List/operation/PackingList_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
IsDefault boolean - -
CustomText string - -
Email string - -
Phone string - -
Website string - -
Footer string - -
LogoHash string - -
ReturnEmailSubject string - -
ReturnEmailContent string - -
ShipFromAliasName string - -
CustomerNotesLabel string - -
Created datetime - -
Updated datetime - -
ArchiveDate datetime - -

Product

Documentation: https://docs.ordoro.com/#tag/Product/operation/Product_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Sku string - -
Cost decimal - -
CompanyID string - -
Taxable string - -
Weight decimal - -
Length decimal - -
Width decimal - -
Height decimal - -
Price decimal - -
CustomerText string - -
InternalNotes string - -
TotalOnHand decimal - -
IsKitParent boolean - -
ArchiveDate datetime - -
Created datetime - -
Updated datetime - -
HsCode string - -
CountryOfOrigin string - -
CustomsDescription string - -
ImageUrl string - -
DefaultImageID string - -
Upc string - -
Asin string - -
TotalCommitted decimal - -
TotalAvailable decimal - -
TotalAllocated decimal - -
TotalUnallocated decimal - -
PoTotalCommitted decimal - -
ToBeShipped decimal - -
AvailableOnHand decimal - -
OnPos decimal - -
FulfillmentType string - -

PurchaseOrder

Documentation: https://docs.ordoro.com/#tag/Purchase-Order/operation/PurchaseOrder_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PoID string - -
Status string - -
ShippingMethod string - -
PaymentMethod string - -
Instructions string - -
Created datetime - -
Updated datetime - -
CancelledDate datetime - -
Sent datetime - -
EstimatedDeliveryDate datetime - -
ShippingAmount decimal - -
TaxAmount decimal - -
DiscountAmount decimal - -
SupplierID long - -
WarehouseID long Warehouse → ID -

Shipper

Documentation: https://docs.ordoro.com/#tag/Shipper/operation/Shipper_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Vendor string - -
ArchiveDate datetime - -

Supplier

Documentation: https://docs.ordoro.com/#tag/Supplier/operation/Supplier_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CompanyID long Company → ID -
DropshipPreferCartOrderLineNames string - -
DefaultShippingMethod string - -
AutomaticallyShowShipToEmail boolean - -
AutomaticallyShowSupplierPrice boolean - -
WarehouseID long Warehouse → ID -
AddressID long Address → ID -
Created datetime - -
Updated datetime - -
ArchiveDate datetime - -

User

Documentation: https://docs.ordoro.com/#tag/User/operation/User_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CompanyID long Company → ID -
Email string - -
IsActive boolean - -
IsApiUser boolean - -
LastLogin datetime - -
DateJoined datetime - -
OrderPermission boolean - -
ProductPermission boolean - -
SettingsPermission boolean - -
AnalyticsPermission boolean - -
PurchaseOrderPermission boolean - -
CanManageUser boolean - -

Warehouse

Documentation: https://docs.ordoro.com/#tag/Warehouse/operation/Warehouse_GET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
WarehouseName string - -
UpdatedDate datetime - -
CreatedDate datetime - -
AddressID long Address → ID -
IsConfiguredForShipping boolean - -
IsDefaultLocation boolean - -

GoodsReceiptComment

Column Type Relates to Notes
RemoteID string - -
GoodsReceiptRemoteID string GoodsReceipt → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
GoodsReceiptID string GoodsReceipt → GoodsReceiptID -
Iterator int - -
Text string - -
User string - -
Date datetime - -

GoodsReceiptItem

Column Type Relates to Notes
RemoteID string - -
GoodsReceiptRemoteID string GoodsReceipt → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
GoodsReceiptID string GoodsReceipt → GoodsReceiptID -
PoItemID long PurchaseOrderItem → ID -
Quantity decimal - -
ProductID long Product → ID -

OrderComment

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderID string Order → OrderNumber -
Iterator int - -
Text string - -
User string - -
Date datetime - -

OrderAssignedTag

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long OrderTag → ID -
OrderID string Order → OrderNumber -

SiblingOrder

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ParentOrderID string Order → OrderNumber -
OrderID string Order → OrderNumber -

OrderLine

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
OrderID string Order → OrderNumber -
Quantity decimal - -
ItemPrice decimal - -
SupplierPrice decimal - -
Sku string - -
ProductName string - -
ProductIsKitParent boolean - -
ProductLink string - -
OrderLineProductName string - -
ProductCategory string - -
CartOrderID long - -
CartOrderitemID long - -
CartShipmentID long - -
Cogs decimal - -
Details string - -
Upc string - -
IsAllocated boolean - -
ShippabilityType string - -
SupplierID long Supplier → ID -
IsDropship boolean - -

WarehouseProduct

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Warehouse → ID -
ProductID long Product → ID -
LowStockThreshold decimal - -
OutOfStockThreshold decimal - -
LocationInWarehouse string - -
OnHand decimal - -
PhysicalOnHand decimal - -
Available decimal - -
Committed decimal - -
Allocated decimal - -
Unallocated decimal - -
PoCommitted decimal - -

KitComponent

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Warehouse → ID -
ProductID long Product → ID -

ProductTag

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ProductID long Product → ID -
Color string - -

PurchaseOrderComment

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderID string PurchaseOrder → PoID -
Iterator int - -
Text string - -
User string - -
Date datetime - -

PurchaseOrderItem

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
PurchaseOrderID string PurchaseOrder → PoID -
Quantity decimal - -
UnitPrice decimal - -
DiscountAmount decimal - -
ToBeShipped decimal - -
AvailableOnHand decimal - -
QuantityReceived decimal - -
ProductID long Product → ID -

PurchaseOrderTag

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PurchaseOrderID string PurchaseOrder → PoID -
Color string - -

SupplierShippingMethod

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
SupplierID long Supplier → ID -
Updated datetime - -
Created datetime - -
Active boolean - -
RequestedShippingMethod string - -
MappedShippingMethod string - -
MappedShippingAccount string - -
MappedShippingCarrier string - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Ordoro data Querying Ordoro using regular SQL