Explore the Wix API data model

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

Try our interactive ERD Or, browse below

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

BookingCategory

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/bookings/services/services-v2/query-categories

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
SortOrder long - -
CreatedDate datetime - -
UpdatedDate datetime - -

Service

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/bookings/services/services-v2/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
AppID guid - -
CreatedByAppID guid - -
Type string - -
TagLine string - -
DefaultCapacity int - -
Hidden boolean - -
CategoryID guid BookingCategory → ID -
MainMediaImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
CoverMediaImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
FormID guid -
  • 1 May 2026 Foreign Key - Refers to 'Form' (not implemented).
PaymentRateType string - -
PaymentPriceValue decimal - -
PaymentCurrency string - -
PaymentOptionOnline boolean - -
BookingPolicyID guid -
  • 1 May 2026 Foreign Key - Refers to 'Form' (not implemented).
ScheduleID guid -
  • 1 May 2026 Foreign Key - Refers to 'Schedule' (not implemented).
ServicePageUrl string - -
CalendarPageUrl string - -
CreatedDate datetime - -
UpdatedDate datetime - -

BusinessLocation

Documentation: https://dev.wix.com/docs/api-reference/business-management/locations/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
TimeZone string - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
IsDefault boolean - -
Status string - -
LocationType string - -
Fax string - -
Email string - -
Phone string - -
Revision string - -
Archived boolean - -
AddressCountry string - -
AddressSubdivision string - -
AddressCity string - -
AddressPostalCode string - -
AddressStreetNumber string - -
AddressStreetName string - -
AddressStreetApt string - -
AddressHint string - -
AddressGeocodeLatitude decimal - -
AddressGeocodeLongitude decimal - -

Contact

Documentation: https://dev.wix.com/docs/api-reference/crm/members-contacts/contacts/contacts/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Revision int - -
SourceSourceType string - -
SourceWixAppID guid - -
SourceAppID guid - -
PrimaryEmail string - -
PrimaryEmailSubscriptionStatus string - -
PrimaryEmailDeliverabilityStatus string - -
PictureID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
FirstName string - -
LastName string - -
MemberID string -
  • 1 May 2026 Foreign Key - Refers to 'Member' (not implemented).
CreatedDate datetime - -
UpdatedDate datetime - -

Order

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/e-commerce/orders/orders/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
PurchasedDate datetime - -
Number string - -
PaymentStatus string - -
FulfillmentStatus string - -
BuyerLanguage string - -
WeightUnit string - -
Currency string - -
TaxIncludedInPrices boolean - -
SiteLanguage string - -
Status string - -
Archived boolean - -
AttributionSource string - -
SeenByAHuman boolean - -
IsInternalOrderCreate boolean - -
CreatedByUserID guid -
  • 28 Apr 2026 Foreign Key - Refers to 'Users' (not implemented).
BuyerInfoContactID guid Contact → ID -
PriceSubtotalAmount decimal - -
PriceShippingAmount decimal - -
PriceTaxAmount decimal - -
PriceDiscountAmount decimal - -
PriceTotalPriceAmount decimal - -
PriceTotalAmount decimal - -
PriceTotalWithGiftCardAmount decimal - -
PriceTotalWithoutGiftCardAmount decimal - -
PriceTotalAdditionalFeesAmount decimal - -
BillingAddressCountry string - -
BillingAddressSubdivision string - -
BillingAddressPostalCode string - -
BillingContactFirstName string - -
BillingContactLastName string - -
ShippingCode string - -
ShippingTitle string - -
ShippingLogisticsDeliveryTime string - -
ShippingDestinationFirstName string - -
ShippingDestinationLastName string - -
ShippingDeliveryTimeSlotFrom datetime - -
ShippingDeliveryTimeSlotTo datetime - -
ShippingCostPriceAmount decimal - -
ShippingCostTotalPriceBeforeTaxAmount decimal - -
ShippingCostTotalPriceAfterTaxAmount decimal - -
TaxTotalTaxAmount decimal - -
TaxManualTaxRate string - -
TaxTotalExemptAmount decimal - -
ChannelInfoType string - -
BalanceAmount decimal - -
BalancePaidAmount decimal - -
BalanceRefundedAmount decimal - -
BalanceAuthorizedAmount decimal - -
BalanceTotalMinusPlatformFeesAmount decimal - -
PayAfterFreeTrialSubtotalAmount decimal - -
PayAfterFreeTrialShippingAmount decimal - -
PayAfterFreeTrialTaxAmount decimal - -
PayAfterFreeTrialDiscountAmount decimal - -
PayAfterFreeTrialTotalPriceAmount decimal - -
PayAfterFreeTrialTotalAmount decimal - -
PayAfterFreeTrialTotalWithGiftCardAmount decimal - -
PayAfterFreeTrialTotalWithoutGiftCardAmount decimal - -
PayAfterFreeTrialTotalAdditionalFeesAmount decimal - -
EditableByEveryone boolean - -
SpecificItemsCouponBehavior string - -
PlatformFeeTotalAmount decimal - -
PlatformFeeTotalPassOnAmount decimal - -
PlatformFeeTotalAbsorbedAmount decimal - -
RecipientContactFirstName string - -
RecipientContactLastName string - -
BusinessLocationID guid BusinessLocation → ID -
CreatedDate datetime - -
UpdatedDate datetime - -

OrderPayment

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/e-commerce/orders/order-transactions/introduction

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
OrderID guid Order → ID -
RefundDisabled boolean - -
SupportReceiptGeneration boolean - -
Status string - -
AmountValue decimal - -
PaymentOrderID guid - -
GatewayTransactionID guid - -
PaymentMethod string - -
ProviderTransactionID guid - -
OfflinePayment boolean - -
SavedPaymentMethod boolean - -
PaymentProvider string - -
PaymentMethodID string - -
PaymentMethodNameBuyerLanguage string - -
PaymentMethodNameSiteLanguage string - -
PaymentMethodNamePredefined string - -
CreatedDate datetime - -
UpdatedDate datetime - -

OrderRefund

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/e-commerce/orders/order-transactions/introduction

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
OrderID guid Order → ID -
CreatedDate datetime - -
ShippingIncluded boolean - -
Reason string - -
SummaryRequestedRefundAmount decimal - -
SummaryRefundedAmount decimal - -
SummaryPending boolean - -

Event

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/events/event-management/events-v3/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Title string - -
PublishedDate datetime - -
ShortDescription string - -
DetailedDescription string - -
Slug string - -
Status string - -
InstanceID guid - -
UserID guid -
  • 1 May 2026 Foreign Key - Refers to 'User' (not implemented).
LocationName string - -
LocationType string - -
LocationTbd boolean - -
LocationCountry string - -
LocationSubdivision string - -
LocationCity string - -
LocationPostalCode string - -
LocationStreetNumber string - -
LocationStreetName string - -
LocationStreetApt string - -
LocationGeocodeLatitude decimal - -
LocationGeocodeLongitude decimal - -
DateAndTimeTbd boolean - -
StartDate datetime - -
EndDate datetime - -
TimeZoneID string - -
HideEndDate boolean - -
ShowTimeZone boolean - -
DateAndTimeRecurrenceStatus string - -
MainImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
RegistrationType string - -
RegistrationStatus string - -
RegistrationAllowedGuestTypes string - -
RegistrationInitialType string - -
RegistrationPaused boolean - -
RegistrationDisabled boolean - -
RegistrationRsvpResponseType string - -
RegistrationRsvpWaitlistEnabled boolean - -
RegistrationRsvpPositiveConfirmationTitle string - -
RegistrationRsvpPositiveConfirmationMessage string - -
RegistrationRsvpPositiveConfirmationAddToCalendarLabel string - -
RegistrationRsvpPositiveConfirmationShareLabel string - -
RegistrationRsvpWaitlistTitle string - -
RegistrationRsvpWaitlistMessage string - -
RegistrationRsvpWaitlistAddToCalendarLabel string - -
RegistrationRsvpWaitlistShareLabel string - -
RegistrationRsvpNegativeTitle string - -
RegistrationRsvpNegativeShareLabel string - -
RegistrationTicketsGuestsAssignedSeparately boolean - -
RegistrationTicketsLimitPerOrder int - -
RegistrationTicketsStockManagerAppID guid - -
RegistrationTicketsCurrency string - -
RegistrationTicketsLowestPriceValue decimal - -
RegistrationTicketsLowestPriceCurrency string - -
RegistrationTicketsHighestPriceValue decimal - -
RegistrationTicketsHighestPriceCurrency string - -
RegistrationTicketsSoldOut boolean - -
RegistrationTicketsReservationDurationInMinutes int - -
RegistrationTicketsGracePeriodInMinutes int - -
RegistrationTicketsConfirmationTitle string - -
RegistrationTicketsConfirmationMessage string - -
RegistrationTicketsConfirmationDownloadLabel string - -
RegistrationTicketsConfirmationAddToCalendarLabel string - -
RegistrationTicketsConfirmationShareLabel string - -
RegistrationTicketsCheckoutType string - -
CalendarUrlsGoogle string - -
CalendarUrlsIcs string - -
EventPageUrlBase string - -
EventPageUrlPath string - -
OnlineConferencingEnabled boolean - -
OnlineConferencingProviderName string - -
OnlineConferencingType string - -
GuestListDisplayedPublicly boolean - -
AssignedContactsLabelDeleted boolean - -
FormRsvpYesOption string - -
FormRsvpNoOption string - -
FormRsvpPositiveTitle string - -
FormMessagesRsvpPositiveConfirmationTitle string - -
FormMessagesRsvpPositiveConfirmationMessage string - -
FormMessagesRsvpPositiveConfirmationAddToCalendarLabel string - -
FormMessagesRsvpPositiveConfirmationShareLabel string - -
FormMessagesRsvpWaitlistTitle string - -
FormMessagesRsvpWaitlistConfirmationTitle string - -
FormMessagesRsvpWaitlistConfirmationMessage string - -
FormMessagesRsvpWaitlistConfirmationAddToCalendarLabel string - -
FormMessagesRsvpWaitlistConfirmationShareLabel string - -
FormMessagesRsvpNegativeTitle string - -
FormMessagesRsvpNegativeConfirmationTitle string - -
FormMessagesRsvpNegativeConfirmationShareLabel string - -
FormMessagesRsvpSubmitActionLabel string - -
FormMessagesCheckoutTitle string - -
FormMessagesCheckoutSubmitActionLabel string - -
FormMessagesCheckoutConfirmationTitle string - -
FormMessagesCheckoutConfirmationMessage string - -
FormMessagesCheckoutConfirmationDownloadTicketsLabel string - -
FormMessagesCheckoutConfirmationAddToCalendarLabel string - -
FormMessagesCheckoutConfirmationShareEventLabel string - -
FormMessagesRegistrationClosedMessage string - -
FormMessagesRegistrationClosedExploreEventsLabel string - -
FormMessagesTicketsUnavailableMessage string - -
FormMessagesTicketsUnavailableExploreEventsLabel string - -
CreatedDate datetime - -
UpdatedDate datetime - -

EventCategory

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/events/event-management/categories/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
CreatedDate datetime - -

TicketDefinition

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/events/event-management/ticket-definitions-v3/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
EventID guid Event → ID -
PolicyText string - -
Hidden boolean - -
Limited boolean - -
InitialLimit int - -
ActualLimit int - -
FeeType string - -
SaleStatus string - -
LimitPerCheckout int - -
PricingMethodType string - -
PricingMethodIsFree boolean - -
CreatedDate datetime - -
UpdatedDate datetime - -

Collection

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/portfolio/collections/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Description string - -
Title string - -
Slug string - -
Hidden boolean - -
SortOrder decimal - -
CoverImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
CreatedDate datetime - -
UpdatedDate datetime - -

Project

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/portfolio/projects/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Description string - -
Title string - -
Hidden boolean - -
Slug string - -
CoverImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
CreatedDate datetime - -
UpdatedDate datetime - -

Menu

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/restaurants/menus/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
Visible boolean - -
UrlQueryParam string - -
BusinessLocationID guid BusinessLocation → ID -
CreatedDate datetime - -
UpdatedDate datetime - -

MenuItem

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/restaurants/menus/items/items/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
Visible boolean - -
Featured boolean - -
PriceInfoPrice decimal - -
ImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
InStock boolean - -
AcceptSpecialRequests boolean - -
TaxGroupID guid -
  • 1 May 2026 Foreign Key - Refers to 'TaxGroup' (not implemented).
CreatedDate datetime - -
UpdatedDate datetime - -

MenuItemLabel

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/restaurants/menus/items/item-labels/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
IconID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
CreatedDate datetime - -
UpdatedDate datetime - -

MenuSection

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/restaurants/menus/sections/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
Visible boolean - -
ImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
BusinessLocationID guid BusinessLocation → ID -
CreatedDate datetime - -
UpdatedDate datetime - -

ReservationLocation

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/restaurants/reservations/reservation-locations/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
IsDefault boolean - -
Archived boolean - -
Currency string - -
SeatingPlanID guid - -
LocationID guid BusinessLocation → ID -
OnlineReservationsApprovalMode string - -
OnlineReservationsPartySizeMin int - -
OnlineReservationsPartySizeMax int - -
OnlineReservationsMinNoticeNumber int - -
OnlineReservationsMinNoticeUnit string - -
OnlineReservationsDefaultTurnoverTime int - -
OnlineReservationsEnabled boolean - -
OnlineReservationsTimeSlotInterval int - -
CreatedDate datetime - -
UpdatedDate datetime - -

TableReservation

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/restaurants/reservations/reservations/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Status string - -
Source string - -
PaymentStatus string - -
ReservationLocationID guid - -
LocationID guid - -
StartDate datetime - -
EndDate datetime - -
PartySize int - -
ReservedByContactID guid Contact → ID -
ReserveeContactID guid Contact → ID -
ReserveeFirstName string - -
ReserveeLastName string - -
ReserveeEmail string - -
CreatedDate datetime - -
UpdatedDate datetime - -

Brand

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/stores/catalog-v3/brands-v3/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Revision string - -
CreatedDate datetime - -
UpdatedDate datetime - -

InventoryItem

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/stores/catalog-v3/inventory-items-v3/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
VariantID guid ProductVariant → ID -
LocationID guid StoresLocation → ID -
ProductID guid Product → ID -
Quantity int - -
InStock boolean - -
TrackQuantity boolean - -
AvailabilityStatus string - -
PreorderEnabled boolean - -
PreorderMessage string - -
PreorderLimit int - -
PreorderCounter int - -
PreorderQuantity int - -
CreatedDate datetime - -
UpdatedDate datetime - -

Product

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/stores/catalog-v3/products-v3/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
NumericID string - -
Slug string - -
Visible boolean - -
VisibleInPos boolean - -
EntityEventSequence string - -
Handle string - -
ProductType string - -
MainCategoryID guid ProductCategory → ID -
MediaMainID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
InventoryAvailabilityStatus string - -
InventoryPreorderStatus string - -
InventoryPreorderAvailability string - -
ActualPriceRangeMin decimal - -
ActualPriceRangeMax decimal - -
VariantCount int - -
CreatedDate datetime - -
UpdatedDate datetime - -

ProductCategory

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/stores/catalog-v3/categories/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
ItemCounter int - -
Visible boolean - -
Slug string - -
Handle string - -
ManagingAppID guid - -
ImageID string -
  • 1 May 2026 Foreign Key - Refers to 'Image' (not implemented, no date filters apparently).
ParentCategoryIndex int - -
TreeReferenceAppNamespace string - -
CreatedDate datetime - -
UpdatedDate datetime - -

StoresLocation

Documentation: https://dev.wix.com/docs/api-reference/business-solutions/stores/catalog-v3/stores-locations-v3/introduction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
LocationType string - -
Revision string - -
DefaultLocation boolean - -
CreatedDate datetime - -
UpdatedDate datetime - -

ServiceLocation

Column Type Relates to Notes
RemoteID string - -
ServiceRemoteID string Service → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
ServiceID guid Service → ID -
Type string - -

ServiceSupportedSlug

Column Type Relates to Notes
RemoteID string - -
ServiceRemoteID string Service → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ServiceID guid Service → ID -
CreatedDate datetime - -
Custom boolean - -

OrderLineItem

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
OrderID guid Order → ID -
RootCatalogItemID guid ProductVariant → ID -
CatalogItemID guid Product → ID -
CatalogVariantID guid ProductVariant → ID -
Quantity int - -
PaymentOption string - -
CustomLineItem boolean - -
PriceUndetermined boolean - -
FixedQuantity boolean - -
InventoryAppID guid - -
TotalDiscountAmount decimal - -
ItemTypePreset string - -
PriceAmount decimal - -
PriceBeforeDiscountsAmount decimal - -
PriceBeforeDiscountsAndTaxAmount decimal - -
TotalPriceBeforeTaxAmount decimal - -
TotalPriceAfterTaxAmount decimal - -
TaxAmount decimal - -
TaxableAmount decimal - -
TaxRate string - -
TaxIncludedInPrice boolean - -
TaxExemptAmount decimal - -
LineItemPriceAmount decimal - -
TaxableAddressType string - -

OrderAppliedDiscount

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
OrderID guid Order → ID -
DiscountType string - -
MerchantDiscountAmount decimal - -
MerchantDiscountDescription string - -

OrderActivity

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
OrderID guid Order → ID -
CreatedDate datetime - -
Type string - -
ActivityType string - -
ChangesAppliedDraftOrderID guid -
  • 1 May 2026 Foreign Key - Refers to 'DraftOrder' (not implemented).
ChangesAppliedReason string - -

OrderAdditionalFee

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
OrderID guid Order → ID -
Source string - -
ProviderAppID guid - -
PriceAmount decimal - -
PriceBeforeTaxAmount decimal - -
PriceAfterTaxAmount decimal - -
TaxRate string - -
TaxIncludedInPrice boolean - -

OrderRefundTransaction

Column Type Relates to Notes
RemoteID string - -
OrderRefundRemoteID string OrderRefund → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderRefundID guid OrderRefund → ID -
PaymentID guid OrderPayment → ID -
RefundStatus string - -
ExternalRefund boolean - -
Amount decimal - -

OrderRefundLineItem

Column Type Relates to Notes
RemoteID string - -
OrderRefundRemoteID string OrderRefund → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderRefundID guid OrderRefund → ID -
LineItemID guid OrderLineItem → ID -
Quantity int - -

OrderRefundBreakdownLineItem

Column Type Relates to Notes
RemoteID string - -
OrderRefundRemoteID string OrderRefund → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderRefundID guid OrderRefund → ID -
LineItemID guid OrderLineItem → ID -
TotalRefundedAmount decimal - -

EventCategoryChild

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid EventCategory → ID -
EventID guid Event → ID -

EventFormControl

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
EventID guid Event → ID -
Deleted boolean - -
Type string - -
System boolean - -
Label string - -
OrderIndex int - -

TicketDefinitionOption

Column Type Relates to Notes
RemoteID string - -
TicketDefinitionRemoteID string TicketDefinition → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
TicketDefinitionID guid TicketDefinition → ID -
OptionID guid - -
PriceValue decimal - -
PriceCurrency string - -

ProjectCollection

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID guid Project → ID -
CollectionID guid Collection → ID -

ProjectDetail

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID guid Project → ID -
Label string - -
Text string - -

MenuSectionChild

Column Type Relates to Notes
RemoteID string - -
MenuRemoteID string Menu → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MenuID guid Menu → ID -
MenuSectionID guid MenuSection → ID -

MenuItemBusinessLocation

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MenuItemID guid MenuItem → ID -
BusinessLocationID guid BusinessLocation → ID -

MenuItemLabelChild

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid MenuItemLabel → ID -
MenuItemID guid MenuItem → ID -

MenuSectionItem

Column Type Relates to Notes
RemoteID string - -
MenuSectionRemoteID string MenuSection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MenuSectionID guid MenuSection → ID -
MenuItemID guid MenuItem → ID -

ReservationLocationOnlineBusinessSchedulePeriod

Column Type Relates to Notes
RemoteID string - -
ReservationLocationRemoteID string ReservationLocation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReservationLocationID guid ReservationLocation → ID -
LineNumber int - -
OpenDay string - -
OpenTime string - -
CloseDay string - -
CloseTime string - -

ReservationLocationTable

Column Type Relates to Notes
RemoteID string - -
ReservationLocationRemoteID string ReservationLocation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
ReservationLocationID guid ReservationLocation → ID -
IsActive boolean - -
SeatsMin int - -
SeatsMax int - -

ReservationLocationTableCombination

Column Type Relates to Notes
RemoteID string - -
ReservationLocationRemoteID string ReservationLocation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
ReservationLocationID guid ReservationLocation → ID -
IsActive boolean - -
SeatsMin int - -
SeatsMax int - -

TableReservationTable

Column Type Relates to Notes
RemoteID string - -
TableReservationRemoteID string TableReservation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TableReservationID guid TableReservation → ID -
TableID guid ReservationLocationTable → ID -

ProductOption

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

ProductInfoSection

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid -
  • 1 May 2026 Foreign Key - Refers to 'InfoSection' (not implemented).
ProductID guid Product → ID -

ProductModifier

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
ProductID guid Product → ID -
ModifierRenderType string - -
Mandatory boolean - -
FreeTextMinCharCount int - -
FreeTextMaxCharCount int - -
FreeTextTitle string - -

ProductVariant

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
ProductID guid Product → ID -
Visible boolean - -
Sku string - -
PriceAmount decimal - -
InStock boolean - -
PreorderEnabled boolean - -

OrderLineItemDescriptionLine

Column Type Relates to Notes
RemoteID string - -
OrderLineItemRemoteID string OrderLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderLineItemID guid OrderLineItem → ID -
LineNumber int - -
NameOriginal string - -
LineType string - -
Color string - -
ModifierDescriptionLine boolean - -
PlainTextOriginal string - -
PlainTextTranslated string - -
PlainTextValueOriginal string - -
PlainTextValueTranslated string - -
ColorInfoOriginal string - -
ColorInfoTranslated string - -
ColorInfoCode string - -

OrderActivityChange

Column Type Relates to Notes
RemoteID string - -
OrderActivityRemoteID string OrderActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderActivityID guid OrderActivity → ID -
LineNumber int - -
LineItemChangedID guid OrderLineItem → ID -
LineItemChangedNameOriginal string - -
LineItemChangedOriginalPriceAmount decimal - -
LineItemChangedNewPriceAmount decimal - -
LineItemAddedID guid OrderLineItem → ID -
LineItemAddedNameOriginal string - -
LineItemAddedQuantity int - -
TotalPriceChangedOriginalTotalAmount decimal - -
TotalPriceChangedNewTotalAmount decimal - -
ShippingInformationChangedOriginalTotalAmount decimal - -
ShippingInformationChangedOriginalShippingTitle string - -
ShippingInformationChangedNewTotalAmount decimal - -
ShippingInformationChangedNewShippingTitle string - -
DiscountAddedID guid OrderAppliedDiscount → ID -
DiscountAddedNameOriginal string - -
DiscountAddedTotalAmount decimal - -

EventFormControlInput

Column Type Relates to Notes
RemoteID string - -
EventFormControlRemoteID string EventFormControl → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
EventFormControlID string EventFormControl → ID -
LineNumber int - -
Array boolean - -
Label string - -
Mandatory boolean - -
MaxLength int - -
Type string - -

ReservationLocationTableCombinationTable

Column Type Relates to Notes
RemoteID string - -
ReservationLocationTableCombinationRemoteID string ReservationLocationTableCombination → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReservationLocationTableCombination guid ReservationLocationTableCombination → ID -
TableID guid ReservationLocationTable → ID -

ProductOptionChoice

Column Type Relates to Notes
RemoteID string - -
ProductOptionRemoteID string ProductOption → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ProductOptionID guid ProductOption → ID -
ChoiceID guid - -
ColorCode string - -
InStock boolean - -

ProductModifierChoice

Column Type Relates to Notes
RemoteID string - -
ProductModifierRemoteID string ProductModifier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ProductModifierID guid ProductModifier → ID -
ChoiceID guid - -
ChoiceType string - -
ColorCode string - -

ProductVariantChoice

Column Type Relates to Notes
RemoteID string - -
ProductVariantRemoteID string ProductVariant → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductVariantID guid ProductVariant → ID -
OptionID guid ProductOption → ID -
ChoiceID guid ProductOptionChoice → ChoiceID -

Need more?

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

Connect your own Wix data Querying Wix using regular SQL