Make a template within ChannelAdvisor mapping the columns that you have set up in the Finale report.
It can be simple as two columns (SKU, Quantity). If you need assistance, please contact email@example.com to create the custom Finale stock report that will FTP to ChannelAdvisor.
In the template, choose partial Distribution Center (DC) list if you have multiple DCs and are only uploading to one. If you want the upload file to completely overwrite anything that is in ChannelAdvisor instead, and assume any items that are not included in the report have a 0 quantity, then choose complete DC list. In quantity update type, most users select 'unshipped.'
In ChannelAdvisor under the inventory tab, click inventory settings (far right column of the drop down menu). This will bring you to the file transfer settings. Towards the bottom, there will be the general settings for Push FTP. Create your own login prefix. For example, you can use "Final" (it can only be 6 characters).
In Finale, create a FTP connection
2) Select "Add New Connection"
3) Select "Add FTP Server Connection"
and use the following information:
Connection Name: ChannelAdvisor
Port (leave blank)
Username: final:(then enter your regular channeladvisor login email... for example, it would be final:firstname.lastname@example.org)
Password: your channeladvisor login password
Add the report you want. For the Report options, choose the report to save as, and choose CSV (it's the easiest). FTP options use the following, but instead of report name, write what you actually want it to be called. mine is called Finale_Quantity.csv:
Now you'll need to go back into ChannelAdvisor to finish setting up the report. Go back to the inventory settings page. The second line under "file transfer settings" will be called "Inventory Push". Click edit on this.
Here, do the following:
Input Method: Updates Only Apply Template: choose the template that you created for the upload File Type: Comma Delimited FTP Response File: Enabled Status: Enabled (this is what you click disabled if you ever want to pause the connection) Ignore the file processing overrides section. That doesn't apply to what we're doing.
Article is closed for comments.