Establishing API and FTP Connections and Preferences to ChannelAdvisor
API Configuration
-
Navigate to the ChannelAdvisor workspace and click Site Configuration.
-
Click the (+) icon to add a new site.
-
The multi-site configuration allows users to add multiple ChannelAdvisor sites with differing configurations.
-
-
Enter a Unique ID for the ChannelAdvisor Site.
-
Enter a Description for the ChannelAdvisor Site.
-
Enter Access Configuration Details
-
Enter the Account ID.
-
Enter the Profile ID.
-
This can be found in the URL of the ChannelAdvisor merchant site of the homepage. It is the final 8 digits of the URL (e.g. https://complete.channeladvisor.com/?apid=12345678, profile ID is 12345678)
-
-
Enter the Developer Key.
-
Enter the Password for the ChannelAdvisor Developer Account.
-
Enter the Mode of the ChannelAdvisor Merchant Account that has been created.
-
-
Once credentials are inserted, click Request API Access.
-
If the connection is successfully configured, you will see a green circle with a check mark
-
If the connection is unsuccessful, you will see a red circle with an X.
-
-
Navigate to the ChannelAdvisor Merchant site when the connection is successfully configured.
-
Click Account.
-
Under Advanced, click Developer Authorizations.
-
A new authorization should appear with a Approve Access icon next to the request that was created in Step 2.
Developer Console
Now that the API Access has been requested and approved, the Refresh Token, Application ID, and Shared Secret Data must be collected from the ChannelAdvisor Developer Site.
-
Navigate to the ChannelAdvisor Developer Site and click Developer Console.
ChannelAdvisor Developer Console.
-
Click the Login link.
-
Login with the developer key and password that was created with the Developer Site account.
-
Click on Create New Application
-
Enter the Name of the application (e.g. KensiumConnector).
-
Enter a Description of the application (e.g. Kensium Acumatica CA Connector).
-
Click Create Application.
-
This will create an Application ID and a Shared Secret key.
-
-
Click Add Integration and Request Tokens.
-
Select the account that access is necessary for.
-
Click Grant Access to Generate the Refresh Token ID.
-
Copy the Refresh Token ID.
-
Paste the Refresh Token ID into the Site Configuration field of the ChannelAdvisor workspace.
-
Copy the Application ID and Shared Secret key from the Developer Console homepage into the Site Configuration fields of the ChannelAdvisor workspace.
-
Click Save.
-
Click Verify API Access
If the connection is successful, you will see a green circle with a check mark.
If the connection is unsuccessful, you will see a red circle with an X.
FTP Configuration
When using the sync process between ChannelAdvisor and Acumatica, the primary method of data transfer will be API. However, significant API volume can throttle a server.
To ensure that the API service does not hinder server speed, data synchronization can be also sent via File Transfer Protocol (FTP) after a pre-defined point.
This is a slower method of data transfer that occurs by automatically consolidating and exporting product via a spreadsheet with a reduced impact on a server.
PROCESS
-
To obtain the FTP settings for ChannelAdvisor, on the ChannelAdvisor site, navigate to the Products tab and click Automated Imports under the Product Data section.
-
Toggle the Status of Images Push to Enabled.
-
Toggle the Status of Product Data Push to Enabled.
-
Selecting Edit on these file types will allow a user to set up a schedule if necessary for FTP calls.
-
-
Enter a Push FTP Login Prefix
-
This is a user generated prefix necessary to ensure the FTP connection is made. Enter a 6-digit alphanumeric value in this field.
-
-
Click Save
In ChannelAdvisor
-
Navigate to the ChannelAdvisor Workspace.
-
Enter FTP Configuration Details.
-
Enter
ftps.channeladvisor.com
in the Hostname field. -
Enter the Username with the Push FTP Login Prefix: preceding it (e.g. ABCDEF:jsmith@kensium.com).
-
Enter the Password.
-
This is the same password used for the ChannelAdvisor Merchant Site.
-
-
Enter the Input Directory.
-
-
Click Verify FTP Access.
If the connection is successful, you will see a green circle with a check mark.
If the connection is unsuccessful, you will see a red circle with an X.
Preferences Configuration
Additional configuration details must be entered to ensure the connection is successful.
Enter Additional Configuration Details for Sales Orders
-
Enter the Entity Usage Type for the ChannelAdvisor site.
-
If using a native Acumatica tax integration, such as Vertex or Avalara, this can be configured at this level for ChannelAdvisor products and orders.
-
-
In the Branch field, select the branch(es) that will be used in ChannelAdvisor.
-
This field is used to map the orders being imported to Acumatica from ChannelAdvisor. This branch will be associated with incoming ChannelAdvisor marketplace orders.
-
-
Enter the Default Warehouse for Non-FBA Orders.
-
In the Customer Class field, select the customer class in Acumatica that will be used for creating orders and shipments in Acumatica that will be exported to ChannelAdvisor.
-
Enter the Default Order Type.
-
Enter the Default Acumatica ShipVia.
-
Select the Number of Days to Go Back for Order Import.
-
This field gives users the power to select the number of days for the connector to check for orders that may have been missed. For example, if the field was given the value of 7, the connector would look for orders from the last 7 days and add any new records that would have been missed by the connector.
-
-
Select Mark Order as Exported in ChannelAdvisor after Successful Import
-
Select Mark Order as Pending Shipment in ChannelAdvisor after Successful Import
-
These are options to send order status back to ChannelAdvisor on successful import of order details into Acumatica. One or both options may be selected upon order import.
-
-
Next, select Configurations for FBA Orders.
-
If importing FBA orders into Acumatica, toggle on Import FBA Orders.
-
When toggled ON, incoming FBA orders will be entered into Acumatica as Invoices. When toggled OFF, FBA orders will not be imported into Acumatica. It is generally considered good practice to leave this setting OFF when not leveraging FBA as a part of the merchant business process to avoid disruption to the connector.
-
-
-
Enter the Entity Usage Type.
-
Enter the Branch.
-
Select a Warehouse.
-
Select a Customer Class.
-
Select the Default Shipping Method for FBA Orders.
-
Select the Default Box for FBA Orders.
-
Select Mark Order as Exported in ChannelAdvisor after Successful Import.
Price Sync Preferences
-
Navigate to the Price Sync Preferences section.
-
Enter the Additional Attributes to sync Price to, separated by a comma.
-
In some business cases, attributes can be used to sync pricing from Acumatica to ChannelAdvisor. For example, Acumatica text attributes can be created for an item class that includes attributes EBAYPRICE, AMZNPRICE, etc., and these attributes can be mapped and synced with ChannelAdvisor as price attributes. If this business process is being followed, enter all ChannelAdvisor pricing attributes EXACTLY as they appear in ChannelAdvisor (comma separated). These attributes can then be mapped in Attribute Mapping.
Tax Sync Preferences
-
Select the Tax Sync Preferences.
-
Taxes can be synced as-is from ChannelAdvisor, or a default Tax Zone can be selected in Acumatica for taxes on incoming orders.
-
Import Tax Through Manual Tax Zone – a Tax Zone can be created in Acumatica specifically for ChannelAdvisor orders. This will bring in the tax on orders by the Tax Zone’s definition and have tax added as is.
-
Calculate Tax as per Acumatica – taxes can be calculated per Acumatica functionality with a tax provider.
-
Cash Account Preferences
-
Navigate to the Cash Account Preferences section.
-
Define the Cash Account preferences based on business process.
-
From Payment Method Configuration – Transactions made in ChannelAdvisor that have been imported to Acumatica will be allocated to the mapped payment method’s cash account. For example, if an order was completed using an AmEx card, and the payment method of AMEX in Acumatica has been mapped to the AmEx payment method in ChannelAdvisor, then the order will be imported to Acumatica and the payment will be allocated to the AMEX payment method cash account.
-
Apply Specific Cash Account – a new cash account may be created specifically for payments received in ChannelAdvisor, regardless of the payment method used. For business processes that require payments be isolated from other transactions using the same payment methods, create a new cash valid cash account, ensuring that it has been marked for use in AR and is eligible for use in all configured payment methods. When created, select this Cash Account in the CashAccountID field.
-
Message Queue Threshold Value
-
Designate a Message Queue Threshold Value.
-
This field is designated for the number of API calls that will occur prior to FTP calls being made. (e.g. If only 5,000 calls can be made through API, this value can be set to 5,000. If 6,000 shipment details of orders are being exported from Acumatica to ChannelAdvisor, 5,000 of them will be sent through API, and 1,000 will be sent via FTP.)
-
-
Enter a Batch Count.
-
The Batch Count will indicate how many records will be sent in batches once the Message Queue Threshold Value has been reached.
-
Note: Products will export to ChannelAdvisor from Acumatica using FTP and not API. Inventory and Price Updates for products will export via API, then FTP based on the set threshold.
-
-
Marketplace Settings
-
Click on the Marketplace Settings tab.
-
Marketplace specific configurations can be made for order types, taxes, and customer classes.
-
-
In the Marketplaces table, click the (+) icon.
-
Select the Avalara Customer Usage Type for customer tax specific configuration to a marketplace.
-
Select the Marketplace ID for the configuration.
-
Enter a Description.
-
Enter the Default Order Type for the Marketplace.
-
Select the Default Tax Zone and Toggle On the Import Tax Value using Site ID Tax Zone if importing orders from this marketplace requires a specific tax zone.
-
Select the Default Customer Class.
-
Select the Default Shipping Terms.
Avalara or Vertex
-
If you are using Avalara or Vertex, navigate to the Tax Management Table.
-
Click the (+) icon.
-
Select the Avalara Customer Usage Type.
-
Select the Country affected by this configuration .
-
Select the State affected by this configuration.
-
Select the Default Tax Zone and Toggle On the Import Tax Value using Site ID Tax Zone if importing orders from this marketplace requires a specific tax zone.
Once complete, click Save.
All steps need to be repeated for additional sites to be configured in Acumatica.
If using multiple sites, new API and FTP tokens will be required for your new sites.
FBA Orders
It is considered a best practice to create a new Warehouse and Branch in Acumatica specific to FBA orders.
This is not a necessary step, however doing so will allow for the separation of FBA orders from FBM orders in Acumatica.
If a new Warehouse and Branch is created, enter the details in the applicable Additional Configuration fields.