How To

Importing Inventory using FTP

Visit our new Community site! The SSC is no longer updated. If you have bookmarked this page, click on the banner below – this will lead you to the corresponding page in the Community. Then, you can use the Star to save it there to show in the new ‘My Support Center’, in your Favourite Articles section. Use the search bar to find any other topics you're interested in.

Visit our New Community!


ChannelAdvisor provides the option to send inventory uploads over FTP (File Transfer Protocol). This method of data transfer allows you to create a product file and upload it without having to log into the ChannelAdvisor application. FTP allows for easier transfer of large files to the ChannelAdvisor application, and can be more efficient when transferring multiple files at a time because of its ability to queue files for transfer. FTP also allows for increased automation in delivering files to ChannelAdvisor. You will need to determine which FTP method you intend to use before proceeding with setup.

We support two types of File Transfer Protocol (FTP):

  • FTP Push – The FTP Push setting means that you intend to place your file on the ChannelAdvisor FTP location, ftp.ChannelAdvisor.com, for processing. This is the preferred method of FTP configuration in an account.
  • FTP/HTTP/HTTPS Pull – Using the PULL setting means that you intend for ChannelAdvisor to scan an FTP or HTTP(S) location that you specify, and pick up inventory files for processing. You can establish multiple "pull" configurations to get files from different locations across the internet - for example, if you have multiple suppliers that send you inventory information directly.

We support two ways of uploading product information via FTP:

  • Custom Format – If using your own Custom Format, you must map your fields to the ChannelAdvisor inventory system to ensure the data in your file is placed in the proper fields. Custom file formats and XML files require the use of a Template to map your fields to ChannelAdvisor Inventory.

 

Prerequisites


You should be familiar with the following topic before continuing:

 

Tasks to Complete


Complete the following tasks related to this topic:

  1. Compile your product data and save it in the ChannelAdvisor Inventory format or a Custom Format . Make sure you save your file as UTF-8 encoded to avoid issues with special characters during upload.
  2. Configure FTP/HTTP Settings in Inventory > Settings > Inventory Settings.
  3. Transfer Files Using FTP

 

How to FTP an Inventory File to ChannelAdvisor


Follow these steps to complete this task:

  1. Using an FTP client, connect to ftp.ChannelAdvisor.com (for FTP over SSL, connect to ftps.ChannelAdvisor.com ).
  2. Transfer your inventory file.
    • If using the ChannelAdvisor default format, place the file in the /Inventory directory.
    • If using a template, place the file in the /Inventory/Transform directory.

 

File Requirements


The files that you will send to us through the FTP site will need to meet the same format / requirements as files you would upload in the ChannelAdvisor UI. Accepted file formats are:

  • Text Tab Delimited (.txt)
  • Text Pipe Delimited (.txt)
  • Comma Separated (.csv)
  • XML
  • Excel Spreadsheet (.xlsx)

Please note that text files can be compressed before they are sent to ChannelAdvisor if you are using ftp push or an FTP "Pull" configuration . These compressed files must use the extension ".zip", ".gz", ".gzip", or ".tar.gz". Other compression extensions will not be accepted.

The file that you submit can be in the ChannelAdvisor Inventory Upload Spreadsheet format , or it can be in your own custom format . If you are using a custom format file, you must configure a Template that maps your files fields to the ChannelAdvisor inventory fields. XML files are considered to be "custom" formats and require the use of a template.

Typically SKU is the key identifier in your data, but if you need to use an alternate identifier, you can configure it from Inventory > Settings > Inventory Settings.

  • Ensure that at least one of the 5 other identifiers are populated in your upload – identifiers are (UPC, MPN, ISBN, ASIN, EAN).
  • The upload process will detect the already existing SKU in our system and fill in the inventory number column during the upload.
  • Please note the Inventory Number/SKU column still needs to be present on your file but the value is not required.

 

File Naming and Frequency


There is no required file naming convention, however, if you specify a prefix on your file in settings. When a prefix is used, ChannelAdvisor can interpret how you would like to have the data file processed. The default file prefixes are:

  • AddAndUpdate_  : To process the entire file contents
  • UpdateOnly_  : To process only SKUs that already exist in your account
  • AddOnly_  : To process only SKUs that do not already exist in your account
  • TrackingNumbers_  : To process order shipment tracking number files
  • DetectDroppedItems_  : To process entire file and set dropped items quantity to Zero

Any file that is placed in the inventory directory will be picked up by ChannelAdvisor within one hour.

 

Status of File


To see the status of a FTP file:

  1. Log into ChannelAdvisor.
  2. Navigate to Inventory > All Products > Upload/Download Status.
  3. Locate the entry for your FTP'd file in the grid.
  4. If the file fails a pre-processing validation, you will still see an entry for the file and a link to its errors.

ChannelAdvisor provides a response file that includes the status of each line in the inventory upload file. The response file is dropped in the inventory directory on your FTP site every time an upload runs. The file is named using the original filename with a timestamp in the format "YYYY.MM.DD.HH.MM.SS.SSSS" and  "_RESPONSE" appended to it.  For example, INV_UPLOAD.txt will have a response file called INV_UPLOAD_2017.03.15.06.15.31.4828_RESPONSE.txt. The response file is tab delimited with the following columns:

  • Line Number – Header is line number 1, so the first SKU in your file will be line number 2.
  • SKU
  • Status – Success or Error
  • Message – Validation messages are similar to upload validation messages seen in the UI.

With this functionality, you can fully automate the process of uploading data into ChannelAdvisor.

 

Applying Templates on an FTP Upload File


  • Place the file in the Transform folder under the Inventory directory to apply a template to your upload.
  • In the FTP settings you can specify a default Template to be applied to all inventory uploads processed in your account. By selecting a default option, the template that you have chosen on this settings page will be applied when a new file is processed. The default template will be applied unless a naming convention override is applied. This is done by placing the template code preceded by a '.' before the file extension. For example: CAUpload.TEMPLATE01.txt would look for a template with a template code of TEMPLATE01 to apply to the upload.

 

Reference


View this page for additional information on this topic:

Visit our new Community site! The SSC is no longer updated. If you have bookmarked this page, click on the banner below – this will lead you to the corresponding page in the Community. Then, you can use the Star to save it there to show in the new ‘My Support Center’, in your Favourite Articles section. Use the search bar to find any other topics you're interested in.

Visit our New Community!


ChannelAdvisor provides the option to send inventory uploads over FTP (File Transfer Protocol). This method of data transfer allows you to create a product file and upload it without having to log into the ChannelAdvisor application. FTP allows for easier transfer of large files to the ChannelAdvisor application, and can be more efficient when transferring multiple files at a time because of its ability to queue files for transfer. FTP also allows for increased automation in delivering files to ChannelAdvisor. You will need to determine which FTP method you intend to use before proceeding with setup.

We support two types of File Transfer Protocol (FTP):

  • FTP Push – The FTP Push setting means that you intend to place your file on the ChannelAdvisor FTP location, ftp.ChannelAdvisor.com, for processing. This is the preferred method of FTP configuration in an account.
  • FTP/HTTP/HTTPS Pull – Using the PULL setting means that you intend for ChannelAdvisor to scan an FTP or HTTP(S) location that you specify, and pick up inventory files for processing. You can establish multiple "pull" configurations to get files from different locations across the internet - for example, if you have multiple suppliers that send you inventory information directly.

We support two ways of uploading product information via FTP:

  • Custom Format – If using your own Custom Format, you must map your fields to the ChannelAdvisor inventory system to ensure the data in your file is placed in the proper fields. Custom file formats and XML files require the use of a Template to map your fields to ChannelAdvisor Inventory.

 

Prerequisites


You should be familiar with the following topic before continuing:

 

Tasks to Complete


Complete the following tasks related to this topic:

  1. Compile your product data and save it in the ChannelAdvisor Inventory format or a Custom Format . Make sure you save your file as UTF-8 encoded to avoid issues with special characters during upload.
  2. Configure FTP/HTTP Settings in Inventory > Settings > Inventory Settings.
  3. Transfer Files Using FTP

 

How to FTP an Inventory File to ChannelAdvisor


Follow these steps to complete this task:

  1. Using an FTP client, connect to ftp.ChannelAdvisor.com (for FTP over SSL, connect to ftps.ChannelAdvisor.com ).
  2. Transfer your inventory file.
    • If using the ChannelAdvisor default format, place the file in the /Inventory directory.
    • If using a template, place the file in the /Inventory/Transform directory.

 

File Requirements


The files that you will send to us through the FTP site will need to meet the same format / requirements as files you would upload in the ChannelAdvisor UI. Accepted file formats are:

  • Text Tab Delimited (.txt)
  • Text Pipe Delimited (.txt)
  • Comma Separated (.csv)
  • XML
  • Excel Spreadsheet (.xlsx)

Please note that text files can be compressed before they are sent to ChannelAdvisor if you are using ftp push or an FTP "Pull" configuration . These compressed files must use the extension ".zip", ".gz", ".gzip", or ".tar.gz". Other compression extensions will not be accepted.

The file that you submit can be in the ChannelAdvisor Inventory Upload Spreadsheet format , or it can be in your own custom format . If you are using a custom format file, you must configure a Template that maps your files fields to the ChannelAdvisor inventory fields. XML files are considered to be "custom" formats and require the use of a template.

Typically SKU is the key identifier in your data, but if you need to use an alternate identifier, you can configure it from Inventory > Settings > Inventory Settings.

  • Ensure that at least one of the 5 other identifiers are populated in your upload – identifiers are (UPC, MPN, ISBN, ASIN, EAN).
  • The upload process will detect the already existing SKU in our system and fill in the inventory number column during the upload.
  • Please note the Inventory Number/SKU column still needs to be present on your file but the value is not required.

 

File Naming and Frequency


There is no required file naming convention, however, if you specify a prefix on your file in settings. When a prefix is used, ChannelAdvisor can interpret how you would like to have the data file processed. The default file prefixes are:

  • AddAndUpdate_  : To process the entire file contents
  • UpdateOnly_  : To process only SKUs that already exist in your account
  • AddOnly_  : To process only SKUs that do not already exist in your account
  • TrackingNumbers_  : To process order shipment tracking number files
  • DetectDroppedItems_  : To process entire file and set dropped items quantity to Zero

Any file that is placed in the inventory directory will be picked up by ChannelAdvisor within one hour.

 

Status of File


To see the status of a FTP file:

  1. Log into ChannelAdvisor.
  2. Navigate to Inventory > All Products > Upload/Download Status.
  3. Locate the entry for your FTP'd file in the grid.
  4. If the file fails a pre-processing validation, you will still see an entry for the file and a link to its errors.

ChannelAdvisor provides a response file that includes the status of each line in the inventory upload file. The response file is dropped in the inventory directory on your FTP site every time an upload runs. The file is named using the original filename with a timestamp in the format "YYYY.MM.DD.HH.MM.SS.SSSS" and  "_RESPONSE" appended to it.  For example, INV_UPLOAD.txt will have a response file called INV_UPLOAD_2017.03.15.06.15.31.4828_RESPONSE.txt. The response file is tab delimited with the following columns:

  • Line Number – Header is line number 1, so the first SKU in your file will be line number 2.
  • SKU
  • Status – Success or Error
  • Message – Validation messages are similar to upload validation messages seen in the UI.

With this functionality, you can fully automate the process of uploading data into ChannelAdvisor.

 

Applying Templates on an FTP Upload File


  • Place the file in the Transform folder under the Inventory directory to apply a template to your upload.
  • In the FTP settings you can specify a default Template to be applied to all inventory uploads processed in your account. By selecting a default option, the template that you have chosen on this settings page will be applied when a new file is processed. The default template will be applied unless a naming convention override is applied. This is done by placing the template code preceded by a '.' before the file extension. For example: CAUpload.TEMPLATE01.txt would look for a template with a template code of TEMPLATE01 to apply to the upload.

 

Reference


View this page for additional information on this topic:

0
Your rating: None
0
Your rating: None

Previous Comments


but what about the account number?

how do we know what account the file will be uploaded to?

I dont see a reference to how to specify what account number to ftp a document to

Sun, 02/19/2017 - 04:24 - David Wei - 42948