Skip to content

billbeeGetOrders - Billbee

← Billbee Add-On Übersicht

This step receives all your Billbee order data.


Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

Name Datentyp Beschreibung Pflichtfeld Werte
account ACCOUNT billbee account data Nein
orderID STRING The internal billbee id of the order. Nein
minOrderDate DATETIME Specifies the oldest order date to include in the response. Nein
maxOrderDate DATETIME Specifies the newest order date to include in the response Nein
shopId STRING Specifies a comma separated list of shop ids for which invoices should be included Nein
orderStateId STRING Specifies a comma separated list of state ids to include in the response Nein
tag STRING Specifies a comma separated list of filtered orders to include in the response Nein
minimumBillBeeOrderId STRING If given, all delivered orders have an Id greater than or equal to the given minimumOrderId Nein
modifiedAtMin DATETIME If given, the last modification has to be newer than the given date Nein
modifiedAtMax DATETIME If given, the last modification has to be older or equal than the given date. Nein

Outputs

Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.

Name Datentyp Beschreibung Werte
OrderData SPREADSHEET
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Standardwert
identifier SINGLE
parent_identifier SINGLE
BillBeeOrderId SINGLE
BillBeeParentOrderId SINGLE
OrderNumber SINGLE
Id SINGLE
RebateDifference SINGLE
ShippingIds SINGLE
AcceptLossOfReturnRight SINGLE
State SINGLE
VatMode SINGLE
CreatedAt SINGLE
ShippedAt SINGLE
ConfirmedAt SINGLE
PayedAt SINGLE
SellerComment SINGLE
Comments SINGLE
InvoiceNumberPrefix SINGLE
InvoiceNumberPostfix SINGLE
InvoiceNumber SINGLE
InvoiceDate SINGLE
PaymentMethod SINGLE
ShippingCost SINGLE
TotalCost SINGLE
AdjustmentCost SINGLE
AdjustmentReason SINGLE
Currency SINGLE
Buyer SINGLE
UpdatedAt SINGLE
TaxRate1 SINGLE
TaxRate2 SINGLE
VatId SINGLE
Tags SINGLE
ShipWeightKg SINGLE
LanguageCode SINGLE
PaidAmount SINGLE
ShippingProfileId SINGLE
ShippingProviderId SINGLE
ShippingProviderProductId SINGLE
ShippingProviderName SINGLE
ShippingProviderProductName SINGLE
ShippingProfileName SINGLE
PaymentInstruction SINGLE
IsCancelationFor SINGLE
PaymentTransactionId SINGLE
DistributionCenter SINGLE
DeliverySourceCountryCode SINGLE
CustomInvoiceNote SINGLE
CustomerNumber SINGLE
PaymentReference SINGLE
ShippingServices SINGLE
Payments SINGLE
LastModifiedAt SINGLE
ApiAccountId SINGLE
ApiAccountName SINGLE
MerchantVatId SINGLE
CustomerVatId SINGLE
IsFromBillbeeApi SINGLE
InvoiceAddress_BillbeeId SINGLE
InvoiceAddress_FirstName SINGLE
InvoiceAddress_LastName SINGLE
InvoiceAddress_Company SINGLE
InvoiceAddress_NameAddition SINGLE
InvoiceAddress_Street SINGLE
InvoiceAddress_HouseNumber SINGLE
InvoiceAddress_Zip SINGLE
InvoiceAddress_City SINGLE
InvoiceAddress_CountryISO2 SINGLE
InvoiceAddress_Country SINGLE
InvoiceAddress_Line2 SINGLE
InvoiceAddress_Email SINGLE
InvoiceAddress_State SINGLE
InvoiceAddress_Phone SINGLE
ShippingAddress_BillbeeId SINGLE
ShippingAddress_FirstName SINGLE
ShippingAddress_LastName SINGLE
ShippingAddress_Company SINGLE
ShippingAddress_NameAddition SINGLE
ShippingAddress_Street SINGLE
ShippingAddress_HouseNumber SINGLE
ShippingAddress_Zip SINGLE
ShippingAddress_City SINGLE
ShippingAddress_CountryISO2 SINGLE
ShippingAddress_Country SINGLE
ShippingAddress_Line2 SINGLE
ShippingAddress_Email SINGLE
ShippingAddress_State SINGLE
ShippingAddress_Phone SINGLE
Seller_Platform SINGLE
Seller_BillbeeShopName SINGLE
Seller_BillbeeShopId SINGLE
Seller_Id SINGLE
Seller_Nick SINGLE
Seller_FirstName SINGLE
Seller_LastName SINGLE
Seller_FullName SINGLE
Seller_Email SINGLE
Customer_Id SINGLE
Customer_Name SINGLE
Customer_Email SINGLE
Customer_Tel1 SINGLE
Customer_Tel2 SINGLE
Customer_Number SINGLE
Customer_PriceGroupId SINGLE
Customer_LanguageId SINGLE
Customer_DefaultMailAddress SINGLE
Customer_DefaultCommercialMailAddress SINGLE
Customer_DefaultStatusUpdatesMailAddress SINGLE
Customer_DefaultPhone1 SINGLE
Customer_DefaultPhone2 SINGLE
Customer_DefaultFax SINGLE
Customer_VatId SINGLE
Customer_Type SINGLE
Customer_MetaData SINGLE
History_Created SINGLE
History_EventTypeName SINGLE
History_Text SINGLE
History_EmployeeName SINGLE
History_TypeId SINGLE
OrderItems_BillBeeOrderId SINGLE
OrderItems_BillbeeId SINGLE
OrderItems_TransactionId SINGLE
OrderItems_Quantity SINGLE
OrderItems_TotalPrice SINGLE
OrderItems_TaxAmount SINGLE
OrderItems_TaxIndex SINGLE
OrderItems_Discount SINGLE
OrderItems_Attributes SINGLE
OrderItems_GetPriceFromArticleIfAny SINGLE
OrderItems_IsCoupon SINGLE
OrderItems_ShippingProfileId SINGLE
OrderItems_DontAdjustStock SINGLE
OrderItems_UnrebatedTotalPrice SINGLE
OrderItems_SerialNumber SINGLE
OrderItems_InvoiceSKU SINGLE
OrderItems_Product_OldId SINGLE
OrderItems_Product_Id SINGLE
OrderItems_Product_Title SINGLE
OrderItems_Product_Weight SINGLE
OrderItems_Product_SKU SINGLE
OrderItems_Product_SkuOrId SINGLE
OrderItems_Product_IsDigital SINGLE
OrderItems_Product_Images SINGLE
OrderItems_Product_EAN SINGLE
OrderItems_Product_PlatformData SINGLE
OrderItems_Product_TARICCode SINGLE
OrderItems_Product_CountryOfOrigin SINGLE
OrderItems_Product_BillbeeId SINGLE
OrderHead SPREADSHEET
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Standardwert
identifier SINGLE
BillBeeOrderId SINGLE
BillBeeParentOrderId SINGLE
OrderNumber SINGLE
Id SINGLE
RebateDifference SINGLE
ShippingIds SINGLE
AcceptLossOfReturnRight SINGLE
State SINGLE
VatMode SINGLE
CreatedAt SINGLE
ShippedAt SINGLE
ConfirmedAt SINGLE
PayedAt SINGLE
SellerComment SINGLE
Comments SINGLE
InvoiceNumberPrefix SINGLE
InvoiceNumberPostfix SINGLE
InvoiceNumber SINGLE
InvoiceDate SINGLE
PaymentMethod SINGLE
ShippingCost SINGLE
TotalCost SINGLE
AdjustmentCost SINGLE
AdjustmentReason SINGLE
Currency SINGLE
Buyer SINGLE
UpdatedAt SINGLE
TaxRate1 SINGLE
TaxRate2 SINGLE
VatId SINGLE
Tags SINGLE
ShipWeightKg SINGLE
LanguageCode SINGLE
PaidAmount SINGLE
ShippingProfileId SINGLE
ShippingProviderId SINGLE
ShippingProviderProductId SINGLE
ShippingProviderName SINGLE
ShippingProviderProductName SINGLE
ShippingProfileName SINGLE
PaymentInstruction SINGLE
IsCancelationFor SINGLE
PaymentTransactionId SINGLE
DistributionCenter SINGLE
DeliverySourceCountryCode SINGLE
CustomInvoiceNote SINGLE
CustomerNumber SINGLE
PaymentReference SINGLE
ShippingServices SINGLE
Payments SINGLE
LastModifiedAt SINGLE
ApiAccountId SINGLE
ApiAccountName SINGLE
MerchantVatId SINGLE
CustomerVatId SINGLE
IsFromBillbeeApi SINGLE
InvoiceAddress_BillbeeId SINGLE
InvoiceAddress_FirstName SINGLE
InvoiceAddress_LastName SINGLE
InvoiceAddress_Company SINGLE
InvoiceAddress_NameAddition SINGLE
InvoiceAddress_Street SINGLE
InvoiceAddress_HouseNumber SINGLE
InvoiceAddress_Zip SINGLE
InvoiceAddress_City SINGLE
InvoiceAddress_CountryISO2 SINGLE
InvoiceAddress_Country SINGLE
InvoiceAddress_Line2 SINGLE
InvoiceAddress_Email SINGLE
InvoiceAddress_State SINGLE
InvoiceAddress_Phone SINGLE
ShippingAddress_BillbeeId SINGLE
ShippingAddress_FirstName SINGLE
ShippingAddress_LastName SINGLE
ShippingAddress_Company SINGLE
ShippingAddress_NameAddition SINGLE
ShippingAddress_Street SINGLE
ShippingAddress_HouseNumber SINGLE
ShippingAddress_Zip SINGLE
ShippingAddress_City SINGLE
ShippingAddress_CountryISO2 SINGLE
ShippingAddress_Country SINGLE
ShippingAddress_Line2 SINGLE
ShippingAddress_Email SINGLE
ShippingAddress_State SINGLE
ShippingAddress_Phone SINGLE
Seller_Platform SINGLE
Seller_BillbeeShopName SINGLE
Seller_BillbeeShopId SINGLE
Seller_Id SINGLE
Seller_Nick SINGLE
Seller_FirstName SINGLE
Seller_LastName SINGLE
Seller_FullName SINGLE
Seller_Email SINGLE
Customer_Id SINGLE
Customer_Name SINGLE
Customer_Email SINGLE
Customer_Tel1 SINGLE
Customer_Tel2 SINGLE
Customer_Number SINGLE
Customer_PriceGroupId SINGLE
Customer_LanguageId SINGLE
Customer_DefaultMailAddress SINGLE
Customer_DefaultCommercialMailAddress SINGLE
Customer_DefaultStatusUpdatesMailAddress SINGLE
Customer_DefaultPhone1 SINGLE
Customer_DefaultPhone2 SINGLE
Customer_DefaultFax SINGLE
Customer_VatId SINGLE
Customer_Type SINGLE
Customer_MetaData SINGLE
History_Created SINGLE
History_EventTypeName SINGLE
History_Text SINGLE
History_EmployeeName SINGLE
History_TypeId SINGLE
OrderItems SPREADSHEET
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Standardwert
identifier SINGLE
OrderItems_BillBeeOrderId SINGLE
OrderItems_BillbeeId SINGLE
OrderItems_TransactionId SINGLE
OrderItems_Quantity SINGLE
OrderItems_TotalPrice SINGLE
OrderItems_TaxAmount SINGLE
OrderItems_TaxIndex SINGLE
OrderItems_Discount SINGLE
OrderItems_Attributes SINGLE
OrderItems_GetPriceFromArticleIfAny SINGLE
OrderItems_IsCoupon SINGLE
OrderItems_ShippingProfileId SINGLE
OrderItems_DontAdjustStock SINGLE
OrderItems_UnrebatedTotalPrice SINGLE
OrderItems_SerialNumber SINGLE
OrderItems_InvoiceSKU SINGLE
OrderItems_Product_OldId SINGLE
OrderItems_Product_Id SINGLE
OrderItems_Product_Title SINGLE
OrderItems_Product_Weight SINGLE
OrderItems_Product_SKU SINGLE
OrderItems_Product_SkuOrId SINGLE
OrderItems_Product_IsDigital SINGLE
OrderItems_Product_Images SINGLE
OrderItems_Product_EAN SINGLE
OrderItems_Product_PlatformData SINGLE
OrderItems_Product_TARICCode SINGLE
OrderItems_Product_CountryOfOrigin SINGLE
OrderItems_Product_BillbeeId SINGLE