Explore the Sellbrite API data model

Pulling data from the Sellbrite 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 Sellbrite 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.

Channel

Documentation: https://developer.sellbrite.com/endpoints/channels

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
Uuid	guid	-	-
CreatedAt	datetime	-	-
State	string	-	-
ChannelTypeDisplayName	string	-	-
SiteID	string	-	-
ChannelSiteRegion	string	-	-

Inventory

Documentation: https://developer.sellbrite.com/endpoints/inventory

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
WarehouseUuid	guid	Warehouse → Uuid	-
Sku	string	Product → Sku	-
OnHand	decimal	-	-
Available	decimal	-	-
Reserved	decimal	-	-
BinLocation	string	-	-

Product

Documentation: https://developer.sellbrite.com/endpoints/products

Column	Type	Relates to	Notes
RemoteID	string	-	-
InventoryRemoteID	string	Inventory → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Description	string	-	-
Sku	string	-	-
ModifiedAt	datetime	-	-
Asin	string	-	-
Condition	string	-	-
Brand	string	-	-
Manufacturer	string	-	-
ManufacturerModelNumber	string	-	-
Price	decimal	-	-
Cost	decimal	-	-
PackageLength	decimal	-	-
PackageWidth	decimal	-	-
PackageHeight	decimal	-	-
PackageUnitOfLength	string	-	-
PackageWeight	decimal	-	-
PackageUnitOfWeight	string	-	-
Msrp	decimal	-	-
CategoryName	string	-	-
ConditionNote	string	-	-
Upc	string	-	-
Ean	string	-	-
Isbn	string	-	-
Gtin	string	-	-
Gcid	string	-	-
Epid	string	-	-
ParentSku	string	Product → Sku	-
Quantity	decimal	-	-
Notes	string	-	-

Warehouse

Documentation: https://developer.sellbrite.com/endpoints/warehouses

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
Uuid	guid	-	-
Archived	boolean	-	-
InventoryMaster	string	-	-
Address1	string	-	-
Address2	string	-	-
City	string	-	-
StateRegion	string	-	-
PostalCode	string	-	-
CountryCode	string	-	-

ProductFeature

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductSKU	string	Product → Sku	-
LineNumber	int	-	-
Value	string	-	-

ProductCustomAttribute

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductSKU	string	Product → Sku	-
AttributeName	string	-	-
AttributeValue	string	-	-

ProductVariation

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ParentProductSKU	string	Product → Sku	-
VariationSKU	string	Product → Sku	-

ProductVariationField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductVariationRemoteID	string	ProductVariation → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
VariationField	string	-	-
VariationFieldValue	string	-	-