Data eXchange (DX) Channels

Introduction

Data Exchange channels are used to import inventory information to StoreAutomator. This is useful if you have an internal inventory controlling program already set up, up & running. You would like to use StoreAutomator to communicate with sales channels like Amazon or eBay.

 You can reach DX channel and their settings through:

Menu > Tools > DX Channels

The upcoming screen is a list of data channels created in the system.

 

Adding an Import Channel

This is the place where you provide information to download the data from. Click on the “Add Import Channel” button towards the upper right-hand side.

There are five methods of downloading inventory listings.

mceclip0.png

  • Channel Input imports the information into one of your selected channels as overrides, daily, through API connection protocol or a file,
  • FTP Channel obtains information through File Transfer Protocol or FTP connection from a remote computer and imports to your inventory,
  • Import Channel imports information from one of your pre-selected StoreAutomator channels; e.g., Amazon, Shopify, BigCommerce, WooCommerce, etc. to your inventory,
  • Inventory Input, imports information from a data source into your inventory under a selected supplier’s inventory,
  • Warehouse Input obtains information from any channel or data source into your inventory under a selected warehouse’s inventory,

The below table compares Data Source, Target, and purposes of methods:

Import Type

Data Source

Target

Template

Channel Input

API connection, Excel, CSV file

One of StoreAutomator Channels

Needed

FTP Channel

FTP connection

Inventory

NO need

Import Channel

Selected SA Channel

Inventory

NO need

Inventory Input

API connection, Excel, CSV file

Inventory of a supplier

Needed

Warehouse Input

API connection, Excel, CSV file

Inventory of a warehouse

Needed

 

Channel Input

Channel Input imports information into one of your selected Channels as overrides. It can either directly import from a remote connection through an API protocol, or you can upload a .cvs, text, or excel file manually. First, the channel needs to be correctly set up through the Settings button.

 

Click on API Connection to enter the server address, authentication type, username, and password. Before enabling the connection, API connection settings must be completed.

 

Click on Template to assign a template for the channel, which defines the incoming file format and assigns fields to StoreAutomator native fields. Before enabling the connection, a template must be assigned. Click on “Add” to create one.

Tools > Dx Channels > Wheel icon > Template

Click on Upload File to drag and drop a file for processing,

 

Click on Data Exchange to change settings about this operation:

  • Channel name is the Channel’s display name,
  • Enable or Disable Channel; Enabling will execute the job within the set parameters,
  • Enable Daily schedule will set up a time, which StoreAutomator will connect to the import channel and download data daily.
  • Action for Missing Items tells StoreAutomator what to do in case there are missing items in the incoming feed (in comparison to the SA inventory); it is either do nothing or Assign a zero quantity to those items in SA inventory,
  • Target Channel sets up the Target channel you would like to download the information to. If you don’t select a channel operation will not execute,
  • Make sure to click on the Save button to save your work, and the system takes you back to the list of DX Channels.

FTP Channel

FTP Channel imports information through File Transfer Protocol or FTP connection from a remote computer to your SA inventory; and returns the job result to the remote folder. The first channel needs to be correctly set up through the FTP Connection Settings button:

Fill in the FTP information correctly:

  • Server URL is the FTP server address,
  • Import Directory is the place that the file to be processed is in,
  • Directory for Processed Files, this is the place the output file to be put in,
  • User Name is the FTP username,
  • Password is the FTP password,

Click on Data Exchange to change settings about this operation:

  • Channel name is the channel’s display name,
  • Enable or Disable Channel Enabling will execute the job within the set parameters,
  • Enable Daily schedule, will set up a time, which StoreAutomator will connect to the import channel and download data daily.

Make sure to click on the Save button to save your work, and the system takes you back to the list of DX Channels.

 

Import Channel

Import Channel imports information from one of your pre-selected SA channels, e.g., Amazon, Shopify, Big Commerce, Woo Commerce, etc.. to your inventory.

First, choose a channel to import from the drop-down list, and choose your importing mode. Below are your options:

  • Create Only: This option gets information for nonexistent items and creates them if it doesn’t exist in your inventory products list.
  • Create Update: This option gets information for nonexistent items and updates existing items in your inventory.
  • Quantity Only: This option gets the quantity information and updates quantities for existing items in your inventory.
  • Update Only: This option updates all information (Product Data, Inventory, Quantity) for existing items in your inventory.
  • Price Only: This option updates only Prices for existing items in your inventory
  • Price and Quantity Only: This option updates Prices and Quantities for existing items in your inventory.
  • Update Shipping Template Only: This option obtains the target channel’s shipping template and imports it to the target channel without importing any other information.

Let’s give an example to explain these modes. In your channel and inventory, you have the following items:

Remote Channel: 1, 2, 3, x, y

Inventory: 4, x, y, z

Create Only, creates items 1, 2, 3 in your inventory, and don’t do anything with x, y

Create Update, creates items 1, 2, 3 in your inventory, and updates x, y information.

Quantity Only, Updates the quantity information for x, y and does not add 1, 2, 3 to inventory.

Update Only, Updates all information for x, y and does not add 1, 2, 3 to inventory

Price Only: Updates only Prices of x, y

Price and Quantity Only: Updates Price and Quantity of x, y.

Click on Data Exchange to change settings about this operation:

Click on Data Exchange to change settings about this operation:

  • Channel name is the Channel’s display name,
  • Enable or Disable Channel; Enabling will execute the job within the set parameters,
  • Enable Daily schedule will set up a time, which StoreAutomator will connect to the import channel and download data daily.

Make sure to click on the Save button to save your work, and the system takes you back to the list of DX Channels.

 

Inventory Input

Inventory Input pulls information from a data source and imports it into your inventory under a selected supplier inventory. It can either directly import from a remote connection through an API connection protocol, a .cvs, text, or an excel file uploaded manually. First, the channel needs to be correctly set up through the Settings button.

Click on API Connection to enter the server address, authentication type, username, and password. Before enabling the connection, API connection settings must be completed,

Click on Template to assign a template for the channel, which defines the incoming file format and assigns fields to StoreAutomator native fields. Before enabling the connection, a template must be assigned. Click on “Add” to create one.

Click on Upload File to drag and drop a file for processing,

Click on Data Exchange to change settings about this operation:

  • Channel name is the Channel’s display name,
  • Enable or Disable Channel; Enabling will execute the job within the set parameters,
  • Enable Daily schedule will set up a time, which StoreAutomator will connect to the import channel and download data daily.
  • Action for Missing Items tells StoreAutomator what to do in case there are missing items in the incoming feed (in comparison to the SA inventory); it is either do nothing or Assign a zero quantity to those items in SA inventory,
  • Target Supplier sets up the Target supplier you would like to download the information to. If you don’t select a supplier, the operation will not execute,

Make sure to click on the Save button to save your work, and the system takes you back to the list of DX Channels.

 

Warehouse Input

Warehouse Input obtains information from any channel or data source and imports it into your inventory, under a selected warehouse’s inventory. It can either directly import from a remote connection through an API connection protocol, or you can upload a .csv, text, or excel file manually. First, the channel needs to be correctly set up through the Settings button.

Click on API Connection to enter the server address, authentication type, username, and password. Before enabling the connection, API connection settings must be completed,

Channel > Channel Settings > API Connection

Click on Template to assign a template for the channel, which defines the incoming file format and assigns fields to StoreAutomator native fields. Before enabling the connection, a template must be assigned. Click on “Add” to create one.

Click on Upload File to drag and drop a file for processing,

Click on Data Exchange to change settings about this operation:

  • Channel name is the Channel’s display name,
  • Enable or Disable Channel Enabling will execute the job within the set parameters,
  • Enable Daily schedule will set up a time, which StoreAutomator will connect to the import channel and download data daily.
  • Action for Missing Items tells StoreAutomator what to do in case there are missing items in the incoming feed (in comparison to the SA inventory); it is either do nothing or Assign a zero quantity to those items in SA inventory,
  • Target Inventory sets up the Target inventory you would like to download the information to. If you don’t select an inventory, the operation will not execute,

Make sure to click on the Save button to save your work, and the system takes you back to the list of DX Channels.

If StoreAutomator can establish a connection link with the remote channel, a Green square can be seen next to the channel name. If there is missing information and a connection cannot be established, a red square is visible; you must go back and correct connection information at this point.

StoreAutomator performs jobs at the designated times. Source file will be sought, and if found, the job will be performed. SA will create a job report after processing the feed, which can be found in, Tools> Import> Import History.

 

Template Preparation

Templates are basically a guide for the StoreAutomator system to figure which field in the incoming file needs to be written to which field in the StoreAutomator inventory or Channels. Templates are required for the said methods to perform, failing to define a template will prematurely terminate the process.

  • To create Templates, you can either click on the “Add” text in the Template section or go to Settings> Templates and the “Add Template” button.
  • Select Template type, as “Generic Import.”
  • Choose your template type. Chosen template types provide the StoreAutomator system with the available fields for this type of upload. Once a template is selected, while you are adding fields, the fields defined are available for selection. You can choose these fields and match your own file’s fields, telling the StoreAutomator system to look into your file, look for a certain field name and send the data in that field to the corresponding StoreAutomator field. Templates are purpose-based, which means they will provide different fields for your usage; they need to be chosen correctly for your purposes. Here is a list of the templates and their purposes for your information:
  • Channel: Channel Descriptions: For importing description related fields,
  • Channel: Channel Inclusions: For importing channel-related fields,
  • Channel: Channel Products: For importing all fields of products, use this one,
  • Channel: Repricer Settings: For importing Price related fields,
  • Inventory: Alias Conversion: For importing alias, AltSKU related fields,
  • Inventory: Bundle Conversion: For importing bundle related fields,
  • Inventory: Liquidation Settings: For importing Liquidation related fields,
  • Inventory: Multi-Channel Sync: For importing sync related fields,
  • Inventory: Multi-Channel Alias: For importing alias, AltSKU related fields,
  • Inventory: Product Data: For importing alias, AltSKU related fields,
  • Inventory: Publish State: For importing publish state-related fields,
  • Order: Import Tracking: For importing Tracking related fields,
  • Warehouse: Warehouse Product: For importing warehouse related fields.

It is better to use “Channel Products” and “Product Data” type templates to provide plenty of fields for importing purposes.

 

Once the correct template is selected, the next step is to match and assign your fields to StoreAutomator fields. Make sure to save your work occasionally not to lose work. Prepared templates must be tested to see if they work properly and as expected.

 

After the Import

After the import your file will be converted to a StoreAutomator import file and then will be forwarded to the importer. Importer will process the file and you will receive a notification in the upper right corner. Click on the notification to view any errors or warnings about the import operation. If you got some errors, it means that these items did not make it to the inventory and the errors need fixing.

Also, you can find any imported file in the Import history, which is in Tools> Import> Import History.

mceclip1.png

 

This is a list of all imports in the last 30 days, their results, the original file and the result file. Clicking on the 'Download' button gets you the Original file and to get the results click on the text Results.

The best way to fix errors, since this is a converted file, download the converted file and correct the errors on this file. After the necessary corrections are made, the file can be uploaded using the normal import method (not the DX channel Method). You don't need to erase the successful items, they will be omitted.

The normal import method of StoreAutomator is from the menu, Tools>Import>From File; and dragging & dropping the correct file to the shaded area.

It is advised that you check the results every time an import file is uploaded to the system and correct any errors the last file might have.

Was this article helpful?

0 out of 0 found this helpful