1) Description
Lightspeed Retail is a cloud-based POS solution that is suitable for retailers in industries such as apparel, footwear, bike, jewelry, pet, sporting goods and home decor. The solution offers retailers tools including inventory management, retail store management, cash drawer control, payment processing, purchase order management, customer profile access, accounting software integration and integration with POS hardware such as barcode scanner or receipt printer tools. Lightspeed offers a fully integrated, eCommerce platform that allows customers to manage in-store and online inventory, have a single view of customers and analyze multi-channel sales data.
2) Setup
Lightspeed Retail is quite easy to set up, please follow the next steps:
Step 1: Select the Lightspeed Retail Integration
Either while Creating a Task or in the Integrations menu.
Enter the name of the integration in the search bar .
Step 2. Enter the Name of the Integration.
You can optionally also enter a description .
And press next.
Step 3: Press the Login Button
You will be prompted to Log In.
Step 4: Press Authorize Application
Log in to your Lightspeed Retail, Authorize and click Finish!
3) Lightspeed as Source
3.1 Get Customers
3.1.1 Source Configuration
Account ID
You can find your account in your Lightspeed Account.
To do so navigate to the bottom left and select the help button and the account ID will be displayed there.
3.1.2 Filtering
customerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
First name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
title | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
companyRegistrationNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vatNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
creditAccountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
customerTypeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.1.3 Mapping
Field | Type |
Customer ID | Text |
First Name | Text |
lastName | Text |
Title | Text |
Company | Text |
companyRegistrationNumber | Text |
vatNumber | Text |
createTime | Text |
Timestamp | Text |
Archived | Text |
constantID | Text |
creditAccountID | Text |
customerTyoeID | Text |
discountID | Text |
taxCategoryID | text |
3.2 Get Categories
3.2.1 Source Configuration
Account ID
You can find your account in your Lightspeed Account.
To do so navigate to the bottom left and select the help button and the account ID will be displayed there.
3.2.2 Filtering
.
categoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
nodeDepth | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
fullPathName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
leftNode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
rightNode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
parentID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.2.3 Mapping
categoryID | Text |
Name | Text |
nodeDepth | Text |
fullPathName | Text |
leftNode | Text |
rightNode | Text |
parentID | Text |
createTime | Text |
timestamp | Text |
3.3 Get Discounts
3.3.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.3.2 Filtering
discountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountAmount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountPercent | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
requireCustomer | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.3.3 Mapping
discountID | Text |
Name | Text |
discountAmount | Text |
discountPercent | Text |
requireCustomer | Text |
Archived | Text |
createTime | Text |
timestamp | text |
3.4. Get Employees
3.4.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.4.2 Filtering
employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lockOut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
clockInEmployeeHoursID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
employeeRoleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
limitToShopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastShopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastSaleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastRegisterID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.4.3 Mapping
employeeID | Text |
firstName | Text |
lastName | Text |
lockout | Text |
Archied | Text |
timestamp | Text |
createTime | Text |
constantID | Text |
clockInEmployeeHoursID | Text |
employeeRoleId | Text |
limitToShopID | Text |
lastShopID | Text |
lastSaleID | Text |
lastRegisterID | text |
3.5 Get Industries
3.5.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.5.2 Filtering
industryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
enabled | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
catalogIndustryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.5.3 Mapping
industryID | Text |
Name | Text |
Enabled | Text |
catalogIndustryID | Text |
3.6 Get Items
3.6.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.6.2 Filtering
seasonID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
systemSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
defaultCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
avgCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountable | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemType | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
serialized | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
description | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
modelYear | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
upc | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ean | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
customSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
manufacturerSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
publishToEcom | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
categoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxClassID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
departentID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemMatrixID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
manufacturerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
seasonID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
defaultVendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.6.3 Mapping
ItemID | Text |
systemSku | Text |
defaultCost | Text |
avgCost | Text |
Discountable | Text |
Tax | Text |
Archived | Text |
ItemType | Text |
Serialized | Text |
Description | Text |
modelYear | Text |
Upc | Text |
Ean | Text |
customSku | Text |
manufacturerSku | Text |
createTime | Text |
timestamp | Text |
publishToEcom | Text |
categoryID | Text |
taxClassId | Text |
departmentID | Text |
itemMatrixID | Text |
manufacturerID | Text |
seasonID | Text |
defaultVendorID | Text |
Iamount | Text |
useTypeID | Text |
useType | text |
3.7 Get Orders
3.7.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.7.2 Filtering
orderID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
orderedDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipInstructions | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
stockInstructions | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipVendorCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
otherCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
otherVendorCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
complete | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
totalDiscount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
totalQuantity | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
arrivalDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
refNum | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vendorCurrencyRate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vendorCurrencyCode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
noteID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createdByEmployeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.7.3 Mapping
orderID | Text |
orderedDate | Text |
shipInstructions | Text |
stockInstructions | Text |
shipCost | Text |
shipVendorCost | Text |
otherCost | Text |
otherVendorCost | Text |
Complete | Text |
Archived | Text |
Discount | Text |
TotalDiscount | Text |
totalQuiantity | Text |
arrivalDate | Text |
timestamp | Text |
refNum | Text |
createTime | Text |
vendorCurrencyRate | Text |
vendorCurrencyCode | Text |
vendorID | Text |
noteID | Text |
shopID | Text |
createdbyEmployeeID | text |
3.8 Get Shops
3.8.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.8.2 Filtering
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
serviceRate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeZone | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxLabor | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
labelTitle | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
labelMsrp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
companyRegistrationNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vatNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
zebraBrowserPrint | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
receiptSetupID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ccGatewayID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
gatewayconfigID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
priceLevelID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.8.3 Mapping
shopID | Text |
Name | Text |
serviceRate | Text |
timeZone | Text |
taxLabor | Text |
labelTitle | Text |
labelMsrp | Text |
Archived | Text |
timestamp | Text |
companyRegistrationNumber | Text |
vatNumber | Text |
zebraBrowserPrint | Text |
contactID | Text |
taxCategoryID | Text |
receiptSetupID | Text |
ccGatewayID | Text |
gatewayConfigID | Text |
priceLevelID | text |
3.9 Get Vendors
3.9.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be
displayed there.
3.9.2 Filtering
vendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence
|
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
accountNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
priceLevel | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
updatePrice | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
updateCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
updateDescription | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shareSellThrough | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.9.3 Mapping
vendorID | Text |
Name | Text |
Archived | Text |
accountNumber | Text |
priceLevel | Text |
updatePrice | Text |
updateCost | Text |
updateDescription | Text |
shareSellThrough | Text |
timestamp | text |
3.10 Get Registers
3.10.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.10.2 Filtering
registerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
open | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
openTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
openEmployeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.10.3 Mapping
registerID | Text |
Name | Text |
Open | Text |
openTime | Text |
Archived | Text |
openEmployeeID | Text |
shopID | text |
3.11 Get Sales
3.11.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.11.2 Filtering
saleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountPercent | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
completed | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
voided | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
enablePromotions | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
isTaxInclusive | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tipEnabled | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
updateTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
completeTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
referenceNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
referenceNumberSource | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax1Rate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax2Rate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
change | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
receiptPreference | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
displayableSubtotal | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ticketNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcDiscount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcTotal | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcSubtotal | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcTaxable | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcNonTaxable | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcAvgCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcFIFOCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcTax1 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcTax2 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcPayments | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
calcTips | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
total | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
totalDue | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
displayableTotal | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
balance | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
customerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
quoteID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
registerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipToID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tipEmployeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.customerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.dob | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.title | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.companyRegistrationNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.vatNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.creditAccountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.customerTypeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.discountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.noteID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.taxTotal | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
MetaData.tipOption1 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
MetaData.tipOption2 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
MetaData.tipOptions3 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.11.3 Mapping
saleID | Text |
timestamp | Text |
discountPercent | Text |
Completed | Text |
Archived | Text |
Voided | Text |
enablePromotions | Text |
isTaxInclusive | Text |
createTime | Text |
updateTime | Text |
referenceNumber | Text |
referenceNumberSource | Text |
Tax1Rate | Text |
Tax2Rate | Text |
Change | Text |
receiptPreference | Text |
displayableSubtotal | Text |
ticketNumber | Text |
calckDiscount | Text |
calcTotal | Text |
calcSubtotal | Text |
calcTaxable | Text |
calcNonTaxable | Text |
calcAvgCost | Text |
calcFIFOCost | Text |
calcTax1 | Text |
calcTax2 | Text |
calcPayments | Text |
Total | Text |
Totaldue | Text |
displayableTotal | Text |
Balance | Text |
customerID | Text |
discountID | Text |
employeeID | Text |
quoteID | Text |
registerID | Text |
shopToID | Text |
shopID | Text |
taxCategoryID | Text |
taxTotal | text |
3.12 Get Ships To
3.12.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.12.2 Filtering
shipToID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipped | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipNote | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
customerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
saleLineID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
saleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.12.3 Mapping
shipToID | Text |
Shipped | Text |
timestamp | Text |
shipNote | Text |
firstName | Text |
lastName | Text |
Company | Text |
customerID | Text |
SaleLineID | Text |
saleID | text |
3.13 Get Tax Categories
3.13.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.13.2 Filtering
taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
isTaxInclusive | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax1Name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax2Name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax1Rate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Tax2Rate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.13.3 Mapping
taxCategoryID | Text |
isTaxInclusive | Text |
Tax1Name | Text |
Tax2Name | Text |
Tax1rate | Text |
Tax2rate | Text |
timestamp | text |
3.14. Get All Employee Hours
3.14.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.14.2 Filtering
emploeeHoursID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
checkIn | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
checkOut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.14.3 Mapping
employeeHoursID | Text |
checkIn | Text |
checkout | Text |
employeeID | Text |
shopID | Text |
3.15 Display Template Workorders
3.15.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.15.2 Filtering
workorderID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
systemSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeIn | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
etaOut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
note | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
internalNote | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
warranty | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
hookIn | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
hookOut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
saveParts | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
assignEmployeeToAll | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
customerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
serializedID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
saleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
saleLineID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
workorderStatusID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.customerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.dob | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.title | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.companyRegistrationNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.vatNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.creditAccountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.customerTypeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.discountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer.taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lockOut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.systemUserID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.clockInEmployeeHoursID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.employeeRoleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.limitToShopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastShopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastSaleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastRegisterID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.serviceRate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.timeZone | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ShoptaxLabor | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.labelTitle | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.labelMsrp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.companyRegistrationNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.vatNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.zebraBrowserPrint | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.receiptSetupID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.gatewayConfigID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.priceLevelID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
WorkorderStatus.workorderStatusID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
WorkorderStatus.name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
WorkorderStatus.sortOrder | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
WorkorderStatus.htmlColor | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
WorkorderStatus.systemValue | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
m.labor | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
m.parts | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
m.discount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
m.tax | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
m.total | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.15.3 Mapping
workorderID | Text |
systemSku | Text |
timeIn | Text |
etaOut | Text |
Note | Text |
internalNote | Text |
Warranty | Text |
Tax | Text |
Archived | Text |
hookIn | Text |
hookOut | Text |
saveParts | Text |
assignEmployeeToAll | Text |
timestamp | Text |
customerID | Text |
discountID | Text |
employeeID | Text |
serializedID | Text |
shopID | Text |
saleID | Text |
saleLineId | Text |
workorderStatusID | Text |
Customer Collection |
|
customerID | Text |
firstName | Text |
lastName | Text |
Dob | Text |
Archived | Text |
Title | Text |
Company | Text |
companyRegistrationNumber | Text |
vatNumber | Text |
createTime | Text |
timestamp | Text |
creditAccountID | Text |
customerTypeID | Text |
discountID | Text |
taxcategoryID | Text |
Contact (Complex) |
|
Custom | Text |
noEmail | Text |
noPhone | Text |
noMail | Text |
Timestamp | Text |
ContstantAdress | Complex |
Phone | Text |
Emails | Text |
Website | Text |
Employee | Complex |
employeeID | Text |
firstName | Text |
lastName | Text |
lockout | Text |
Archived | Text |
timestamp | Text |
createTime | Text |
contactID | Text |
systemUserID | Text |
clockInEmployeeHoursID | Text |
employeeRoleID | Text |
limittoShopID | Text |
lastshopId | Text |
lastsaleID | Text |
lastRegisterID | Text |
Shop | Complex |
ShopID | Text |
Name | Text |
serviceRate | Text |
timeZone | Text |
taxLabor | Text |
labelTitle | Text |
labelMsrp | Text |
Archived | Text |
timestamp | Text |
companyRegistrationNumber | Text |
Vatnumber | Text |
zebraBrowserPrint | Text |
constantID | Text |
taxCategoryID | Text |
receiptSetupID | Text |
gatewayConfigID | Text |
priceLevelID | Text |
Constant | Complex |
contactID | Text |
Custom | Text |
noEmail | Text |
noPhone | Text |
noMail | Text |
timestamp | Text |
Website | Text |
ReceiptSetup | Complex |
receiptSetupID | Text |
generalMSg | Text |
workorderAgree | Text |
creditcardAgree | Text |
hasLogo | Text |
Logo | Text |
logoHeights | Text |
logoWidth | Text |
Header | Text |
Workorderstatus | Complex |
workoderStatusID | Text |
Name | Text |
sortOrder | Text |
htmlColor | Text |
SystemValue | Text |
M | Complex |
Labor | Text |
Parts | Text |
Discount | Text |
Tax | Text |
Total | text |
3.16 Get All Price Levels
3.16.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.16.2 Filtering
priceLevelID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
canBeArchived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
type | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Calculation | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.16.3 Mapping
priceLevelID | Text |
Name | Text |
Archived | Text |
canBeArchived | Text |
Type | Text |
Calculation | text |
3.17 Get Items with Relations
3.17.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.17.2 Filtering
itemID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
systemSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
defaultCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
avgCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discountable | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemType | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
serialized | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
description | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
modelYear | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
upc | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ean | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
customSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
manfucaturerSku | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
publishToEcom | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
categoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxClassID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
departmentID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemMatrixID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
manufacturerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
seasonID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
defaultVendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.categoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.nodeDepth | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.fullPathName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.leftNode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.rightNode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Category.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Cateogry.parentID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
TaxClass.taxClassID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
TaxClass.name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
TaxClass.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Manufacturer.manufacturerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Manufacturer.createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Manufacturer.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.note | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.isPublic | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemECommerce.itemEcommerceID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemEcommerce.longDescription | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemEcommerce.shortDescription | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemEcommerce.weight | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemECommerce.width | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemECommerce.height | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemEcommerce.length | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemEcommerce.listOnStore | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemAttributes.attribute1 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemAttributes.attribute2 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemAttributes.attribute3 | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ItemAttriutes.itemAttributeSetID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.17.3 Mapping
ItemID | Text |
systemSKu | Text |
defaultCost | Text |
avgCost | Text |
Discountable | Text |
Tax | Text |
Archived | Text |
itemType | Text |
Serialized | Text |
Description | Text |
modelYear | Text |
Upc | Text |
Ean | Text |
customSKu | Text |
manufacturerSku | Text |
createTime | Text |
timestamp | Text |
publishToEcom | Text |
categoryID | Text |
taxClassID | Text |
departmentID | Text |
ItemMatrixID | Text |
manufacturerID | Text |
seasonID | Text |
defaultVendorID | Text |
Category | Complex |
categoryID | Text |
Name | Text |
nodeDepth | Text |
fullPathName | Text |
leftNode | Text |
rightNode | Text |
createTime | Text |
timestamp | Text |
parentID | Text |
TaxClass | Complex |
taxClassID | Text |
Name | Text |
timestamp | Text |
Manufacturer | Complex |
ManufacturerID | Text |
Name | Text |
createTime | Text |
timestamp | Text |
Note | Complex |
Note | Text |
isPublic | Text |
timestamp | Text |
Image | Collection |
imageID | Text |
Description | Text |
Filename | Text |
Ordering | Text |
publicID | Text |
baseImageURL | Text |
Size | Text |
createTime | Text |
timestamp | Text |
itemID | Text |
itemMatrixID | Text |
ItemShop | Collection |
itemShopID | Text |
Qoh | Text |
Sellable | Text |
Backorder | Text |
componentQoh | Text |
componentBackorder | Text |
reorderPoint | Text |
reorderLevel | Text |
Timestamp | Text |
itemID | Text |
shopID | Text |
ItemUUID | Complex |
productUUID | Text |
ItemPrice | Collection |
Amount | Text |
useTypeID | Text |
useType | Text |
itemVendorNum | Complex |
ItemVendorNumID | Text |
Value | Text |
Timestamp | Text |
Cost | Text |
itemID | Text |
VendorID | Text |
ItemECommerce | Complex |
itemEcommerceID | Text |
longDescription | Text |
shortDescription | Text |
Weights | Text |
Width | Text |
Heights | Text |
Length | Text |
listOnStore | Text |
ItemAttributes | Complex |
Attributte1 | Text |
Attribute2 | Text |
Attributes 3 | Text |
itemAttributeSetID | Text |
ItemAttributeSet | Complex |
ItemAttributeSetID | Text |
Name | Text |
attributeName1 | Text |
attributeName2 | Text |
AttributeName3 | Text |
System | Text |
Archived | Text |
ItemComponents | Complex |
itemComponentID | Text |
Quantity | Text |
componentGroup | Text |
assemblyItemID | Text |
componentItemID | text |
3.18 Get Item Inventory Count
3.18.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.18.2 Filtering
inventoryCountItemID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
qty | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
inventoryCountID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.18.3 Mapping
inventoryCountItemID | Text |
Qty | Text |
Timestamp | Text |
inventoryCountID | Text |
itemID | Text |
employeeID | Text |
3.19 Get Item Images
3.19.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
Item ID
Simply type out your Item ID.
3.19.2 Filtering
baseImageURL | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
size | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemMatrixID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
imageID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
description | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
filename | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
ordering | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
publicID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.19.3 Mapping
imageID | Text |
Description | Text |
Filename | Text |
Ordering | Text |
publicID | Text |
baseimageURL | Text |
Size | Text |
createTime | Text |
Timestamp | Text |
itemID | Text |
itemMatrixID | Text |
3.20 Get Orders with Relations
3.20.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.20.2 Filtering
orderID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
orderedDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
receivedDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipInstructions | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
stockInstructions | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shipVendorCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
otherCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
otherVendorCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
complete | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
discount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
totalDiscount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
totalQuantity | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
arrivalDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
refNum | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vendorCurrencyRate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vendorCurrencyCode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
noteID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createdByEmployeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.vendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.accountNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.integrationName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.integrationLogin | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.integrationPassword | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.integrationAccount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.integrationEnabled | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.priceLevel | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.updatePrice | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.updateCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.updateDescription | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.shareSellThrough | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.noteID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Vendor.currencyRateID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.noteID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.note | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.isPublic | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Note.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.shopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.serviceRate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.timeZone | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.taxLabor | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.labelTitle | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.labelMsrp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.companyRegistrationNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.vatNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.zebraBrowserPrint | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.taxCategoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.receiptSetupID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.vendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.ccGatewayID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.gatewayConfigID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Shop.priceLevelID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.employeeID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lockOut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.contactID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.systemUserID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.clockInEmployeeHoursID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.employeeRoleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.limitToShopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastShopID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastSaleID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Employee.lastRegisterID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.20.3 Mapping
orderID | Text |
orderedDate | Text |
recievedDate | Text |
shipInstructions | Text |
stockInstructions | Text |
shipCost | Text |
shipVendorCost | Text |
otherCost | Text |
otherVendorCast | Text |
Complete | Text |
Archived | Text |
Discount | Text |
totalDiscount | Text |
totalQuantity | Text |
arrivalDate | Text |
timestamp | Text |
refNum | Text |
CreateTime | Text |
vendorCurrencyRate | Text |
vendorCurrencyCode | Text |
vendorID | Text |
noteID | Text |
shopID | Text |
createdbyEmployeeID | Text |
Vendor | Complex |
vendorID | Text |
Name | Text |
Archived | Text |
accountNumber | Text |
integrationName | Text |
integrationLogin | Text |
integrationPassword | Text |
integrationAccount | Text |
integrationEnabled | Text |
priceLevel | Text |
updatePrice | Text |
Updatecost | Text |
updateDescription | Text |
shareSellThrough | Text |
Timestamp | Text |
contactID | Text |
noteID | Text |
currencyRateID | Text
|
Note | Complex |
noteID | Text |
Note | Text |
isPublic | Text |
timestamp | Text |
Shop | Complex |
shopID | Text |
Name | Text |
serviceRate | Text |
Timezone | Text |
Taxlabor | Text |
Labeltitle | Text |
Labelmsrp | Text |
Archived | Text |
Timestamp | Text |
companyregistrationNumber | Text |
vatNumber | Text |
Zebrabrowserprint | Text |
contactID | Text |
taxcategoryID | Text |
receiptsetupID | Text |
vendorID | Text |
ccgatewayID | Text |
gatewayConfigID | Text |
priceLevelID | Text |
Employee | Complex |
employeeID | Text |
FirstName | Text |
lastName | Text |
lockout | Text |
Archived | Text |
Timestamp | Text |
createTime | Text |
contactID | Text |
systemUserID | Text |
clockInEmployeeHoursID | Text |
employeeRoleID | Text |
limitToShopID | Text |
lastShopID | Text |
lastSaleID | Text |
lastRegisterID | Text |
OrderLine | Complex |
orderlineiD | Text |
Quantity | Text |
Price | Text |
OriginalPrice | Text |
vendorCost | Text |
checkedIn | Text |
numRecieved | Text |
timestamp | Text |
Total | Text |
orderID | Text |
itemID | text |
3.21 Item Matrix
3.21.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.21.2 Filtering
itemMatrixID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
description | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
tax | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
defaultCost | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemType | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
serialized | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
modelYear | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
archived | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
itemAttributeSetID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
manufactutrerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
categoryID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
defaultVendorID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
taxClassID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
seasonID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
departmentID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
attribute1Values | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
attribute2Values | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.21.3 Mapping
ItemMatrixID | Text |
Description | Text |
Tax | Text |
defaultCost | Text |
ItemType | Text |
Serialized | Text |
Modelyear | Text |
Archived | Text |
Timestamp | Text |
itemAttributeSetId | Text |
manufacturerID | Text |
categoryID | Text |
defaultVendorID | Text |
taxClassID | Text |
seasionID | Text |
departmentID | Text |
ItemPrice | Collection |
Amount | Text |
useTypeID | Text |
useType | Text |
Attribute1Values | Text |
Attribute2Values | Text |
3.22 Get Manufacturers
3.22.1 Source Configuration
Account ID
You can find your account ID here.
Otherwise navigate to the bottom left and select the help button and the account ID will be displayed there.
3.22.2 Filtering
manufacturerID | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
createTime | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
timeStamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
3.22.3 Mapping
manufacturerID | Text |
Name | Text |
Createtime | Text |
timestamp | text |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article