How To

Updating a Lookup List via File Upload

Lookup lists can be uploaded in bulk by uploading a file directly in the ChannelAdvisor application or via FTP.

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Update Types


Lookup lists can be updated in one of two ways:

  • Merge: Records in the file that do not already exist are added. Records in the file that match one already in the lookup list are updated. This is the default behavior.
  • Delete All and Replace: This will completely replace all lookup list content with the contents of the file.

 

Prepare the File


The file format for uploading a lookup list is the same whether using FTP or from within the ChannelAdvisor application. To help, you may download the lookup list item upload file template .

  • File Type: Both txt (tab-delimited) and xlsx (Excel) are supported.
  • Contents: The file should contain two columns – Name and Value
  • File Name (FTP Only): The file should have the same name as the lookup list you are attempting to update. The filename is not relevant when not using FTP.
    • To merge file contents with the existing lookup list, prefix the filename with Merge_
    • To delete and replace the lookup list with the file contents, prefix the filename with Replace_
  • Limitations: File must be less than 10MB in size and not contain more than 500,000 list items.

 

Upload the File


The file may be submitted directly in the ChannelAdvisor application or via FTP.

Please complete the following steps:

  1. Via ChannelAdvisor application:
    1. Select Inventory > Product Mapping > Lookup Lists from the ChannelAdvisor menu.
    2. Select an existing Lookup List from the selection on the page, or create a new one.
    3. Click the Upload File button, then select your file.
  2. Via FTP:
    1. Setup the connection in your FTP client.
    2. Upload the file to the folder LookupList on the ChannelAdvisor FTP server.

You can review the processing status on the Inventory Upload/Download Status page (Inventory > Products > Upload/Download Status).

Lookup lists can be uploaded in bulk by uploading a file directly in the ChannelAdvisor application or via FTP.

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Update Types


Lookup lists can be updated in one of two ways:

  • Merge: Records in the file that do not already exist are added. Records in the file that match one already in the lookup list are updated. This is the default behavior.
  • Delete All and Replace: This will completely replace all lookup list content with the contents of the file.

 

Prepare the File


The file format for uploading a lookup list is the same whether using FTP or from within the ChannelAdvisor application. To help, you may download the lookup list item upload file template .

  • File Type: Both txt (tab-delimited) and xlsx (Excel) are supported.
  • Contents: The file should contain two columns – Name and Value
  • File Name (FTP Only): The file should have the same name as the lookup list you are attempting to update. The filename is not relevant when not using FTP.
    • To merge file contents with the existing lookup list, prefix the filename with Merge_
    • To delete and replace the lookup list with the file contents, prefix the filename with Replace_
  • Limitations: File must be less than 10MB in size and not contain more than 500,000 list items.

 

Upload the File


The file may be submitted directly in the ChannelAdvisor application or via FTP.

Please complete the following steps:

  1. Via ChannelAdvisor application:
    1. Select Inventory > Product Mapping > Lookup Lists from the ChannelAdvisor menu.
    2. Select an existing Lookup List from the selection on the page, or create a new one.
    3. Click the Upload File button, then select your file.
  2. Via FTP:
    1. Setup the connection in your FTP client.
    2. Upload the file to the folder LookupList on the ChannelAdvisor FTP server.

You can review the processing status on the Inventory Upload/Download Status page (Inventory > Products > Upload/Download Status).

0
Your rating: None
0
Your rating: None