ChannelAdvisor Connector

Developer Key

Enter your ChannelAdvisor API developer key.

Developer Password

Enter your ChannelAdvisor developer password.

Report

Select the ChannelAdvisor report you want to run. The following reports are available:

Account ID

Select the ID for the account you want to retrieve data for.

Date Range Field

Select how you want dates to be broken down in your report. You can choose to break down dates by creation date, last updated date, or quantity last modified date.

Inventory Start Date

Select the start date for the date range in your report.

Inventory End Date

Select the end date for the date range in your report.

Sort Field

Select whether you want your report rows to be sorted by title or SKU.

Duration 

Select whether you want to pull data for a specific date or a date range. 

Report Date 

Select whether the report data is for a specific date or for a relative number of days back from today. 

Select Specific Date 

Select the date for the report. 

Days Back

Enter the number of past days that should appear in the report.  

Start Date

Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date. 

End Date

Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date.  

Select Specific Start Date

Select the first date in your date range. 

Select Specific End Date

Select the second date in your date range. 

Days Back to Start From

Enter the number of the farthest day back that should be represented in the report. Combine with Days Back to End At to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago.

Days Back to End At

Enter the number of the most recent day back that should be represented in the report. Combine with Days Back to Start From to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago.

Sort Direction 

Select whether you want an ascending or descending sort order in your report.

Classification Name (Optional)

Enter a classification name to pull the data for all of the SKUs assigned to that classification.

Label Name (Optional)

Enter a label name to pull the data for all of the SKUs assigned to that label.

Quantity Check Field

Combine with Quantity Check Type and Quantity Check Value to build a filter query for the SKU data in your report.

For example, if you wanted to show all open items under 10, you would select Open for Quantity Check Field and Less Than for Quantity Check Type and enter 10 for Quantity Check Value.  

Quantity Check Type 

Combine with Quantity Check Field and Quantity Check Value to build a filter query for the SKU data in your report.

For example, if you wanted to show all open items under 10, you would select Open for Quantity Check Field and Less Than for Quantity Check Type and enter 10 for Quantity Check Value.  

Quantity Check Value

Combine with Quantity Check Field and Quantity Check Type to build a filter query for the SKU data in your report.

For example, if you wanted to show all open items under 10, you would select Open for Quantity Check Field and Less Than for Quantity Check Type and enter 10 for Quantity Check Value.  

Order Create Date

Select the desired order create date. The report will returns only those orders created after this timestamp. Combine with Order End Date to create a range of data for your report. 

Order End Date

Select the desired order end date. The report will returns only those orders created before this timestamp. Combine with Order Create Date to create a range of data for your report. 

Detail Level (Optional)

Select the detail level for your report. 

Export State (Optional)

Select the desired export state for your report, either Exported, Not Exported, or Unknown.

Order State (Optional)

Select the desired order state for your report, either Active, Archived, or Cancelled.

Payment Status (Optional)

Select the payment status you want to retrieve information for.

Checkout Status (Optional)

Select the checkout status you want to retrieve information for.

Shipping Status (Optional)

Select the shipping status you want to retrieve information for.

Refund Status (Optional)

Select the refund status you want to retrieve information for.

Distribution Center Code (Optional)

Enter the code for the distribution center you want to retrieve information for. 

SKU

Enter the SKU of the inventory item you want to retrieve information for. For example: SGFSKSKYMD