How to send NetSuite files to external suppliers

One common use case we have with Couchdrop and NetSuite is one company sending files like stock/inventory flows from NetSuite to an external supplier. 

Our NetSuite Connector supports several methods of exporting files, including SFTP, Mailboxes, and Webhooks, each of which can work for getting files to suppliers. When sending files to external parties, the most common way to do this in Couchdrop is by sending the files to their SFTP server/endpoint.

Since the most common method is SFTP, we'll use that as the focus of this guide, although the process will be relatively similar for the other methods as well. 

The final flow looks like this:

1. The NetSuite file is exported on a set schedule. 

2. The file is sent via SFTP and arrives in Couchdrop.
3. You send the file to the supplier using the details they give you for their SFTP endpoint.

Configuring Couchdrop and NetSuite for SFTP exports

Setting up NetSuite to send files to external suppliers requires four steps: setting up connections on the Couchdrop side, setting up the connection to the supplier, configuring & scheduling the file export in NetSuite, and sending the files to the external supplier. 

Step 1 - Set up the connections on the Couchdrop side

Before you can send data to suppliers, you need to set up a way to get the files from NetSuite. You can do this by creating an SFTP user for this connection in Couchdrop. 

To add a new user, choose to create a new SFTP user. This will take you to the configuration screen where you can set the username/password (or have Couchdrop generate one automatically), and set permissions.

Here, you can also set the root folder for the user. This folder will be where NetSuite sends the file export, and can be a directory in any connected storage platform. Instead of connecting your own storage, you can also use Couchdrop hosted storage, which is included in all plans. 

Step 2 - Set up the connection to the supplier

Next, you need to make the connection to the supplier. Since this endpoint will be owned by them, you'll need to set up a Partner/Provider connection, and they'll need to provision your credentials for the endpoint.

While NetSuite itself doesn't support direct FTP connections, using Couchdrop as the midpoint, you can send the file to any FTP, SFTP, or AS2 endpoint, which means if the supplier has an FTP server/endpoint, this method will still work.  

Add the information for the supplier's endpoint and use the credentials they gave you to authorize the connection. Once you've tested and saved the connection, it will appear as a folder in the virtual file browser, and adding files to that folder is the same as directly uploading them to the endpoint via FTP/SFTP. 

For this guide, we'll call this folder Supplier_SFTP. 

Step 3 - Configure the SFTP Export in NetSuite

When you have the Couchdrop side done, you need to choose the files to send and set up the export in NetSuite. Because SFTP isn't a fundamental part of NetSuite, this is a much more complicated process than with Couchdrop, and requires creating scripts for finding/generating the file and scheduling the export. 

To see how to set up SFTP in NetSuite, see their documentation on Setting up an SFTP Transfer. Be sure to include the SFTP details for the user you set up in step 1. 

Next, you need to decide what data to send and set up the export itself. Once you've done that, set up the script to export the data via SFTP to your Couchdrop user. 

Step 4 - Send the files to the external suppliers from Couchdrop

Now that you've set up the export, the files will be sent via SFTP into the directory connected to the SFTP user.

From there, all you have to do is move the file from where it landed into the supplier's folder (Supplier_SFTP in this example), which you can do in a number of ways, such as downloading/reuploading, or by using automations.  

Optional - Automate sending files to suppliers

While you certainly can manually move files as they arrive, it's not practical to do this at scale, especially when many of the NetSuite files can involve updated data like stock changes that the supplier needs ASAP. 

In the case of a single export going to a single supplier, you could set Supplier_SFTP as the root. This would essentially create a passthrough for NetSuite to send the folders to that Couchdrop user, which is a connection to the supplier's SFTP endpoint. With this setup, exported files will then go directly to the supplier. However, you lose a lot of control with this method. 

Instead, we recommend setting up an automation to transfer the file to the external supplier. At its most basic, you simply need to set up a trigger or schedule, then choose the transfer or copy action and select the virtual folder for the supplier. Once you enable the automation, it will take effect immediately. 

You can also add data processing steps like renaming the file, making a copy for archival in your own storage, and much more. Multiple actions can be done in a single flow, so you can have the file prepared for your own use or have it ready for the supplier to use immediately. This way, if you need to add another supplier, you can quickly create a connection for them, route the files as needed, and also do any required housework before sending them off.

Simplify sending NetSuite files to external suppliers with Couchdrop 

Couchdrop is the simple, secure, and reliable way to send NetSuite files to external suppliers. Simply set up a user for NetSuite, add the SFTP connection details, then export the data. 

This same basic process works for other ERPs such as SAP, Workday, and Microsoft Dynamics 365, allowing you to freely exchange data between these platforms. To try this process for yourself, log in to Couchdrop now or you can start a free 14-day trial with no credit card required.