Lightspeed Retail (R-Series)

Created by Maja Bradonjic, Modified on Tue, 14 Feb, 2023 at 1:31 PM by Ivana B





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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

First name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

title 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

companyRegistrationNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vatNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

creditAccountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

customerTypeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

nodeDepth 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

fullPathName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

leftNode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

rightNode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

parentID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountAmount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountPercent 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

requireCustomer 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lockOut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

clockInEmployeeHoursID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

employeeRoleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

limitToShopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastShopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastSaleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastRegisterID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

enabled 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

catalogIndustryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

systemSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

defaultCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

avgCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountable 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemType 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

serialized 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

description 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

modelYear 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

upc 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ean 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

customSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

manufacturerSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

publishToEcom 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

categoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxClassID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

departentID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemMatrixID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

manufacturerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

seasonID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

defaultVendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

orderedDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipInstructions 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

stockInstructions 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipVendorCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

otherCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

otherVendorCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

complete 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

totalDiscount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

totalQuantity 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

arrivalDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

refNum 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vendorCurrencyRate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vendorCurrencyCode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

noteID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createdByEmployeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

serviceRate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeZone 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxLabor 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

labelTitle 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

labelMsrp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

companyRegistrationNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vatNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

zebraBrowserPrint 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

receiptSetupID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ccGatewayID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

gatewayconfigID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

priceLevelID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

accountNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

priceLevel 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

updatePrice 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

updateCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

updateDescription 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shareSellThrough 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

open 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

openTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

openEmployeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountPercent 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

completed 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

voided 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

enablePromotions 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

isTaxInclusive 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tipEnabled 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

updateTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

completeTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

referenceNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

referenceNumberSource 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax1Rate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax2Rate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

change 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

receiptPreference 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

displayableSubtotal 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ticketNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcDiscount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcTotal 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcSubtotal 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcTaxable 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcNonTaxable 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcAvgCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcFIFOCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcTax1 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcTax2 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcPayments 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

calcTips 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

total 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

totalDue 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

displayableTotal 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

balance 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

customerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

quoteID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

registerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipToID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tipEmployeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.customerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.dob 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.title 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.companyRegistrationNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.vatNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.creditAccountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.customerTypeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.discountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.noteID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.taxTotal 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

MetaData.tipOption1 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

MetaData.tipOption2 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

MetaData.tipOptions3 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipped 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipNote 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

customerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

saleLineID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

saleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

isTaxInclusive 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax1Name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax2Name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax1Rate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Tax2Rate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

checkIn 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

checkOut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

systemSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeIn 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

etaOut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

note 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

internalNote 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

warranty 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

hookIn 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

hookOut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

saveParts 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

assignEmployeeToAll 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

customerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

serializedID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

saleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

saleLineID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

workorderStatusID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.customerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.dob  

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.title 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.companyRegistrationNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.vatNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.creditAccountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.customerTypeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.discountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer.taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lockOut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.systemUserID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.clockInEmployeeHoursID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.employeeRoleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.limitToShopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastShopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastSaleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastRegisterID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.serviceRate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.timeZone 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ShoptaxLabor 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.labelTitle 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.labelMsrp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.companyRegistrationNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.vatNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.zebraBrowserPrint 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.receiptSetupID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.gatewayConfigID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.priceLevelID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

WorkorderStatus.workorderStatusID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

WorkorderStatus.name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

WorkorderStatus.sortOrder 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

WorkorderStatus.htmlColor 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

WorkorderStatus.systemValue 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

m.labor 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

m.parts 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

m.discount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

m.tax 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

m.total 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

canBeArchived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

type 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Calculation 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

systemSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

defaultCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

avgCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discountable 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemType 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

serialized 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

description 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

modelYear 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

upc 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ean 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

customSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

manfucaturerSku 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

publishToEcom 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

categoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxClassID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

departmentID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemMatrixID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

manufacturerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

seasonID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

defaultVendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.categoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.nodeDepth 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.fullPathName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.leftNode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.rightNode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Category.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Cateogry.parentID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

TaxClass.taxClassID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

TaxClass.name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

TaxClass.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Manufacturer.manufacturerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Manufacturer.createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Manufacturer.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.note 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.isPublic 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemECommerce.itemEcommerceID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemEcommerce.longDescription 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemEcommerce.shortDescription 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemEcommerce.weight 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemECommerce.width 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemECommerce.height 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemEcommerce.length 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemEcommerce.listOnStore 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemAttributes.attribute1 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemAttributes.attribute2 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemAttributes.attribute3 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ItemAttriutes.itemAttributeSetID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

qty 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

inventoryCountID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

size 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemMatrixID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

imageID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

description 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

filename 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

ordering 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

publicID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

orderedDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

receivedDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipInstructions 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

stockInstructions 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shipVendorCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

otherCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

otherVendorCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

complete 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

discount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

totalDiscount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

totalQuantity 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

arrivalDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

refNum 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vendorCurrencyRate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vendorCurrencyCode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

noteID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createdByEmployeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.vendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.accountNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.integrationName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.integrationLogin 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.integrationPassword 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.integrationAccount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.integrationEnabled 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.priceLevel 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.updatePrice 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.updateCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.updateDescription 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.shareSellThrough 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.noteID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Vendor.currencyRateID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.noteID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.note 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.isPublic 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Note.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.shopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.serviceRate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.timeZone 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.taxLabor 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.labelTitle 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.labelMsrp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.companyRegistrationNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.vatNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.zebraBrowserPrint 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.taxCategoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.receiptSetupID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.vendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.ccGatewayID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.gatewayConfigID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Shop.priceLevelID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.employeeID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lockOut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.contactID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.systemUserID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.clockInEmployeeHoursID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.employeeRoleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.limitToShopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastShopID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastSaleID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Employee.lastRegisterID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

description 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

tax 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

defaultCost 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemType 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

serialized 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

modelYear 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

archived 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

itemAttributeSetID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

manufactutrerID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

categoryID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

defaultVendorID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

taxClassID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

seasonID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

departmentID 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

attribute1Values 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

attribute2Values 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

createTime 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

timeStamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article