How To

Configuring an Inventory FTP Push

Before submitting an inventory file via FTP, FTP processing for your account must be enabled, and default settings need to be configured. To get a full overview of this process, see Importing Inventory Using FTP .

Uploading images via FTP is slightly different than inventory; visit the Uploading Images page to learn more.

Prerequisites


You should be familiar with the following topics before continuing:

 

How to Configure FTP Push Settings


ChannelAdvisor supports multiple methods of FTP and HTTP connection in order to submit inventory items in bulk. The preferred method of file transfer is FTP Push , meaning that you place your inventory file(s) on the ChannelAdvisor FTP location ( ftp.ChannelAdvisor.com ) for processing, but other supported methods include FTP/HTTP(S) Pull file transfer. Accepted file formats include:

  • Text Tab Delimited (.txt) 
  • Text Pipe Delimited (.txt) 
  • Comma Separated (.csv)
  • XML
To configure your FTP PUSH settings:

1.  Go to Inventory > Settings > Inventory Settings.

2.  Click   Edit  next to Inventory (Push).

  • Select an Import Method.
    • All : This selection will process ALL rows included in your upload file and create any new item and edit any existing items in your account.
       
    • New Only : This selection will process only rows that DO NOT already exist in your ChannelAdvisor Inventory. Any existing item rows will not be processed .
       
    • Updates Only : This selection will process only rows in your inventory upload file that ALREADY exist in your account. Any new item rows will not be processed .
       
    • Detect Dropped Products : This selection will process your inventory upload file and "detect" any items that are in your inventory but are NOT included in the file you have submitted. These products will be set to quantity of zero (0) using the 'Unshipped" quantity update type , and thus removed from all channels. If you have selected this setting and want your products to remain in any channels they are currently published to, they MUST be included in your upload file.
  • Apply Template - In addition to the default processing selection (above), you can also specify a default t emplate  to be applied to all inventory uploads processed via FTP in your account. By selecting a default option, the template that you have chosen on this settings page will be applied when any new file is processed from your accounts FTP location.

    • Inventory uploads that should use a Template must go in the 'Inventory/Transform' subfolder.
       
    • If a default template has been selected in settings, it will be used unless overridden in the file name.
       
    • A template can be applied to an upload file, or the default template selected in settings can be overridden, using a file naming convention.  To specify a template, add the template code to the end of the upload filename after a "." 
      • EX: "CA Upload.TEMPLATECODE.txt"
          Note: Do not use a period in any other part of the filename or else the file may not process correctly.
  • File Type - Have ChannelAdvisor auto-detect the type of file, or specify the delimiter.
     
  • FTP Response File - If activated a text file will be dropped into your FTP Push file folder and provides details about any potential upload errors.
     
  • Status - Toggle Enabled or Disabled to activate or deactivate the Inventory Push FTP Settings.
     
  • File Processing Overrides - When processing inventory files submitted to the FTP location for your account, ChannelAdvisor can "recognize" how to process the file based on the filename. By using a specific filename prefix, which can be defined on this settings page, the system will know whether to process the entire file content, or only those SKUs that already exist, or those that do not already exist. If you do not use a filename prefix override, the default settings selected for the account will be used.
     
  • Default filename overrides are:

    • AddAndUpdate_ is used to process the entire file.
    • UpdateOnly_ is used to process only SKUs in the file that already exist in the account.
    • AddOnly_ is used to process only those SKUs in the file that do not already exist in the account.
    • DetectDroppedItems_ is used to process the file in full, similar to AddAndUpdate_, but also sets quantity to 0 for any products not included in the upload.
    • TrackingNumbers_ is used to process files containing order/shipment tracking number information.
    • Upsell_  is used to process an Upsell Relationships file for ChannelAdvisor webstores.

     

 

Before submitting an inventory file via FTP, FTP processing for your account must be enabled, and default settings need to be configured. To get a full overview of this process, see Importing Inventory Using FTP .

Uploading images via FTP is slightly different than inventory; visit the Uploading Images page to learn more.

Prerequisites


You should be familiar with the following topics before continuing:

 

How to Configure FTP Push Settings


ChannelAdvisor supports multiple methods of FTP and HTTP connection in order to submit inventory items in bulk. The preferred method of file transfer is FTP Push , meaning that you place your inventory file(s) on the ChannelAdvisor FTP location ( ftp.ChannelAdvisor.com ) for processing, but other supported methods include FTP/HTTP(S) Pull file transfer. Accepted file formats include:

  • Text Tab Delimited (.txt) 
  • Text Pipe Delimited (.txt) 
  • Comma Separated (.csv)
  • XML
To configure your FTP PUSH settings:

1.  Go to Inventory > Settings > Inventory Settings.

2.  Click   Edit  next to Inventory (Push).

  • Select an Import Method.
    • All : This selection will process ALL rows included in your upload file and create any new item and edit any existing items in your account.
       
    • New Only : This selection will process only rows that DO NOT already exist in your ChannelAdvisor Inventory. Any existing item rows will not be processed .
       
    • Updates Only : This selection will process only rows in your inventory upload file that ALREADY exist in your account. Any new item rows will not be processed .
       
    • Detect Dropped Products : This selection will process your inventory upload file and "detect" any items that are in your inventory but are NOT included in the file you have submitted. These products will be set to quantity of zero (0) using the 'Unshipped" quantity update type , and thus removed from all channels. If you have selected this setting and want your products to remain in any channels they are currently published to, they MUST be included in your upload file.
  • Apply Template - In addition to the default processing selection (above), you can also specify a default t emplate  to be applied to all inventory uploads processed via FTP in your account. By selecting a default option, the template that you have chosen on this settings page will be applied when any new file is processed from your accounts FTP location.

    • Inventory uploads that should use a Template must go in the 'Inventory/Transform' subfolder.
       
    • If a default template has been selected in settings, it will be used unless overridden in the file name.
       
    • A template can be applied to an upload file, or the default template selected in settings can be overridden, using a file naming convention.  To specify a template, add the template code to the end of the upload filename after a "." 
      • EX: "CA Upload.TEMPLATECODE.txt"
          Note: Do not use a period in any other part of the filename or else the file may not process correctly.
  • File Type - Have ChannelAdvisor auto-detect the type of file, or specify the delimiter.
     
  • FTP Response File - If activated a text file will be dropped into your FTP Push file folder and provides details about any potential upload errors.
     
  • Status - Toggle Enabled or Disabled to activate or deactivate the Inventory Push FTP Settings.
     
  • File Processing Overrides - When processing inventory files submitted to the FTP location for your account, ChannelAdvisor can "recognize" how to process the file based on the filename. By using a specific filename prefix, which can be defined on this settings page, the system will know whether to process the entire file content, or only those SKUs that already exist, or those that do not already exist. If you do not use a filename prefix override, the default settings selected for the account will be used.
     
  • Default filename overrides are:

    • AddAndUpdate_ is used to process the entire file.
    • UpdateOnly_ is used to process only SKUs in the file that already exist in the account.
    • AddOnly_ is used to process only those SKUs in the file that do not already exist in the account.
    • DetectDroppedItems_ is used to process the file in full, similar to AddAndUpdate_, but also sets quantity to 0 for any products not included in the upload.
    • TrackingNumbers_ is used to process files containing order/shipment tracking number information.
    • Upsell_  is used to process an Upsell Relationships file for ChannelAdvisor webstores.

     

 

0
Your rating: None Average: 2.3 (3 votes)
0
Your rating: None Average: 2.3 (3 votes)
Tags