ChannelAdvisor Setup

Purpose: CWSerenade’s integration with ChannelAdvisor requires the setup described below.

In this topic:

ChannelAdvisor Properties File Settings

ChannelAdvisor: Related System Control Values

ChannelAdvisor: Periodic Functions

Mapping Data between ChannelAdvisor and CWSerenade

Additional required setup:

Working with ChannelAdvisor Accounts (WCAA)

Working with ChannelAdvisor Integration Offers (WCAO)

Note: The ChannelAdvisor integration has been designed and tested to work for the Amazon Marketplace. To use the ChannelAdvisor integration with a marketplace other than Amazon, contact your MICROS project manager.

ChannelAdvisor Properties File Settings

Set the interface properties and logging properties, described below, to support the ChannelAdvisor integration.

Interface properties: Set the following properties in the cwdirectcp_interface.properties file:

CA_INVENTORY_FILE_NAME

The file name for the CAINV periodic function to use when creating a file of current inventory levels for items. See Sending Current Inventory Information to ChannelAdvisor for background.

CA_INVENTORY_FILE_LOCAL_FOLDER

The folder on the CWSerenade server where the CAINV periodic function writes the inventory file. See Sending Current Inventory Information to ChannelAdvisor for background.

Note: You should create this folder on your server if the folder does not already exist.

CHANNELADVISOR_ORDER_URL

The URL for:

• the CAORDUP periodic function to use when requesting new orders from ChannelAdvisor; see Importing Orders from ChannelAdvisor for background.

Processing Refunds (MREF) to use when sending refund information to ChannelAdvisor; see Submitting Refunds for ChannelAdvisor Orders for background.

CHANNELADVISOR_SHIPPING_URL

The URL for the CASHIP periodic function to use when sending shipment confirmations to ChannelAdvisor; see Sending Shipment Confirmations to ChannelAdvisor for background.

CHANNELADVISOR_ PULL_ORDERS_MAX

The maximum number of orders that the GetOrderList function processes at once before sending the notification to ChannelAdvisor that the orders were successfully received and created. Each batch can include up to 50 orders. For example, if you set this property to 100, the function imports two batches of 50 orders.

If no maximum is specified, a default of 50 orders applies.

For more information: See Properties File Configuration for background.

Logging properties: Set the following properties in the Logging Properties File:

INTEGRATIONORDER_FILE_NAME

The name of the log that tracks activity related to the ChannelAdvisor integration.

The delivered setting is IntegrationOrder.log.

INTEGRATIONORDER_LOG_LEVEL

The level of detail to include in the log. See Logging Level for more information.

INTEGRATIONORDER_MAXBACKUP_DAYS

The number of days to store a backup copy of a log before deleting it. If you wish to retain a month’s worth of logs, set this field to 30. The system deletes any log file older than 30 days.

For more information: See Logs for more information on logging.

ChannelAdvisor: Related System Control Values

The system control values related to the ChannelAdvisor integration are listed below.

System Control Value

Setting

ChannelAdvisor Order Type (L90)

The order type to assign to orders from ChannelAdvisor.

ChannelAdvisor Inventory Level Default (L91)

The available quantity to submit to ChannelAdvisor for drop ship, non-inventory, gift card, subscription, and membership items.

ChannelAdvisor SKU X-Ref Offer (L92)

The offer you use to set up cross references between the ChannelAdvisor item identifier and the CWSerenade item/SKU.

Additional system control value requirement: The Tax Included in Price (E70) system control value needs to be unselected for to prevent errors when creating new customers from ChannelAdvisor.

ChannelAdvisor: Periodic Functions

Build and schedule one or more periodic processes to include the following periodic functions:

Periodic Function

Purpose

More Information

CAINV

Generates a file of current inventory levels for FTP to ChannelAdvisor.

Sending Current Inventory Information to ChannelAdvisor

CAPRICE

Generates a file of current pricing for items sold through the ChannelAdvisor integration.

Sending Current Prices to ChannelAdvisor

CAORDUP

Sends ChannelAdvisor a request for new orders and creates orders based on the information in the order response message.

Importing Orders from ChannelAdvisor

CASHIP

Sends shipment confirmation messages to Channel Advisor.

Sending Shipment Confirmations to ChannelAdvisor

For more information: See Scheduling Jobs for an overview.

Refunds? There is no periodic function to send refunds to ChannelAdvisor; the Processing Refunds (MREF) function sends refunds for ChannelAdvisor orders.

Pricing Setup for ChannelAdvisor

Set up the following prices for the CAPRICE periodic function to extract when building the price file for FTP to ChannelAdvisor:

Buy It Now Price: from through the Original retail $ in the SKU table

Retail Price: from through the List price in the SKU table

Additional price: the function uses the most current SKU Price (based on Effective date), if any, for your ChannelAdvisor offer; otherwise, it uses the most current Item Price. The label of the additional price field is from the Price output name specified for the ChannelAdvisor offer through the Working with ChannelAdvisor Integration Offers (WCAO) option.

Note: Any SKU or Item Prices you set up for the ChannelAdvisor offer should have a quantity of 1.

Mapping Data between ChannelAdvisor and CWSerenade

Purpose: In order to map data correctly from ChannelAdvisor to CWSerenade, you need to set up cross references in CWSerenade. This required setup is described briefly below.

Mapping Data

Menu Option

Used By

Notes

Sku cross ref for the ChannelAdvisor SKU X-Ref Offer (L92)

Maintaining SKU Cross Reference Codes (MSKR)

The CAINV, CAPRICE, CAORDUP, and CASHIP periodic functions. See ChannelAdvisor Integration Overview for process overviews.

The offer needs to match the ChannelAdvisor SKU X-Ref Offer (L92) system control value.

CA cross reference # and CA type for a pay type

Note: Should be a cash/check pay type.

Working with Pay Types (WPAY) and Working with ChannelAdvisor Accounts (WCAA)

The CAORDUP periodic function and the Processing Refunds (MREF) option. See Importing Orders from ChannelAdvisor and Submitting Refunds for ChannelAdvisor Orders.

The function uses the ItemSaleSource passed for an order to identify the marketplace set up through Working with ChannelAdvisor Accounts (WCAA), and assigns the corresponding payment method.

The CA type indicates whether to calculate tax and shipping at the item level (consistent with the Amazon and eBay with premium tax marketplaces) or the order level (consistent with the eBay marketplace without premium tax).

Integration carrier and Integration service class for a ship via

Working with Ship Via Codes (WVIA)

The CAORDUP and CASHIP periodic functions. See Importing Orders from ChannelAdvisor and Sending Shipment Confirmations to ChannelAdvisor.

 

ChannelAdvisor Order Type (L90)

Establishing Order Types (WOTY)

The CAORDUP periodic function. See Importing Orders from ChannelAdvisor.

This order type also determine which orders to include when sending shipment confirmations and refunds to ChannelAdvisor. See Sending Shipment Confirmations to ChannelAdvisor and Submitting Refunds for ChannelAdvisor Orders.

Source associated with a marketplace

Working with Source Codes (WSRC) and Working with ChannelAdvisor Accounts (WCAA)

The CAORDUP periodic function. See Importing Orders from ChannelAdvisor.

The function uses the the ItemSaleSource passed for an order to identify the marketplace, and assigns the corresponding source code set up through Working with ChannelAdvisor Accounts (WCAA).

The source code must use a line-level freight method.

price override reason code of W

Establishing Price Override Reason Codes (WPOR)

The CAORDUP periodic function. See Importing Orders from ChannelAdvisor.

You need to use a price override reason code of W, and cannot change this default.

ISO country code

Setting Up the Country Table (WCTY)

The CAORDUP periodic function. See Importing Orders from ChannelAdvisor.

The ISO code must be set to the country’s two-position ISO country code.

SO17_02 Serenade 5.0 March 2015