---
schema_version: "1"
id: efe01406ba3c60edee3912592aa0a67a78b58685508054a008a735aa20cb9987
title: SFTP Setup Guide
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/manufacturing/latest/sftp-setup-guide.md
canonical_url: https://docs.mulesoft.com/manufacturing/latest/sftp-setup-guide
source_site: docs.mulesoft.com
content_type: documentation
content_hash: a58f83f041625f54621250a11f0a47acc46c74390c6063a325ff1c61d911698a
description: MuleSoft Documentation Site
release: "1.4"
latest: true
---
---
product: Manufacturing
version: 1.4
is-latest-version: true
---

# SFTP Setup Guide

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

This setup guide enables customers to upload existing customer, product, and order data to
Manufacturing Cloud via SFTP. Data can be exported in `` csv` `` or `xlsx` format for loading into
Salesforce.

## High-level Architecture

_Load data to Manufacturing Cloud_

![Architecture for loading customer, product, and order data into Manufacturing Cloud through SFTP](/mulesoft/current/en-us/manufacturing/latest/_images/mfg-data-load.png)

### Functional Considerations

- Customer, product and order data needs to be in csv or xlsx format.

- Customer and product data needs be loaded into Manufacturing Cloud before loading order data so
  that orders can be attached existing customers and products.

### Technical Considerations

This section lists the technical considerations and constraints on the solution design.

- The csv and xlsx files need to be in the format specified [below](#file-formats)

- MDM implementation is required in order to reference customer and product data in orders

### Systems Involved

- Salesforce Manufacturing Cloud

- SFTP Server

- PIM Database

- Anypoint MQ

- Global Data Management

### Processing Logic

- SFTP CIM handler reads the files from sftp location and converts the records to respective CIM
  structures and publishes the records to the customers, products and orders exchanges for the
  related objects.

- The corresponding process APIs process the messages in CIM format and insert the data into
  Manufacturing Cloud via the corresponding system APIs.

## SFTP Setup

In your SFTP server create inbox, archive and error folders for customers, products and orders.

## File Configuration

- The sftp integrations can only read comma separated text file with \*.csv extension or Microsoft
  Excel file with \*.xlsx extension

- For excel files, make sure all the data is in one tab and the tab names must be following:
  CustomerInfo, OrderInfo and ProductInfo respectively

### File Formats

#### Customer File Format

<table><colgroup><col> <col> <col></colgroup><thead><tr><th>Field Name</th><th>Field Description</th><th>Comments</th></tr></thead><tbody><tr><td><p>ExternalId</p></td><td><p>Customer ID in external system</p></td><td><p>Required field</p></td></tr><tr><td><p>FirstName</p></td><td><p>The first name of the Party</p></td><td><p>Required for individual</p></td></tr><tr><td><p>MiddleName</p></td><td><p>The middle initial of the Party</p></td><td><p>Optional field for individual</p></td></tr><tr><td><p>LastName</p></td><td><p>The last name of the Party</p></td><td><p>Required for individual</p></td></tr><tr><td><p>OrgAccountName</p></td><td><p>Organization name</p></td><td><p>Required for an organization</p></td></tr><tr><td><p>EmailAddress</p></td><td><p>Email address</p></td><td><p>Optional</p></td></tr><tr><td><p>EmailType</p></td><td><p>Email type (examples: Home, Work)</p></td><td><p>Optional</p></td></tr><tr><td><p>PhoneNumber</p></td><td><p>Phone number</p></td><td><p>Optional</p></td></tr><tr><td><p>InternationalCode</p></td><td><p>Phone country code</p></td><td><p>Optional the default is "001"</p></td></tr><tr><td><p>PhoneType</p></td><td><p>Phone Type</p></td><td><p>Optional the default is "Home"</p></td></tr><tr><td><p>PhoneExt</p></td><td><p>Phone extension</p></td><td><p>Optional</p></td></tr><tr><td><p>AddressLine1</p></td><td><p>Address Line</p></td><td><p>Optional</p></td></tr><tr><td><p>AddressLine2</p></td><td><p>Address Line</p></td><td><p>Optional</p></td></tr><tr><td><p>City</p></td><td><p>City name</p></td><td><p>Optional</p></td></tr><tr><td><p>State</p></td><td><p>State or province name</p></td><td><p>Optional</p></td></tr><tr><td><p>Country</p></td><td><p>Country name</p></td><td><p>Optional the default is "USA"</p></td></tr><tr><td><p>PostalCode</p></td><td><p>Postal code</p></td><td><p>Required</p></td></tr><tr><td><p>AddressType</p></td><td><p>Address type (examples: Home, Work)</p></td><td><p>Optional the default is "Home"</p></td></tr></tbody></table>

#### Order File Format

<table><colgroup><col> <col> <col></colgroup><thead><tr><th>Field Name</th><th>Field Description</th><th>Comments</th></tr></thead><tbody><tr><td><p>Id</p></td><td><p>Order ID</p></td><td><p>Optional</p></td></tr><tr><td><p>Name</p></td><td><p>Order name</p></td><td><p>Required</p></td></tr><tr><td><p>OrderNumber</p></td><td><p>Order number</p></td><td><p>Required</p></td></tr><tr><td><p>Description</p></td><td><p>Order description</p></td><td><p>Optional</p></td></tr><tr><td><p>TotalPriceAmount</p></td><td><p>Total order cost</p></td><td><p>Required</p></td></tr><tr><td><p>AccountId</p></td><td><p>Account id</p></td><td><p>Required</p></td></tr><tr><td><p>TotalDeliveryFeeAmount</p></td><td><p>Shipping fee</p></td><td><p>Optional</p></td></tr><tr><td><p>EffectiveDate</p></td><td><p>Order date</p></td><td><p>Required</p></td></tr><tr><td><p>ExternalId</p></td><td><p>Order id in external system</p></td><td><p>Optional</p></td></tr><tr><td><p>ProductCode</p></td><td><p>Product sku code of the ordered item</p></td><td><p>Required</p></td></tr><tr><td><p>ProductDescription</p></td><td><p>Product description of the ordered item</p></td><td><p>Optional</p></td></tr><tr><td><p>OrderedQuantity</p></td><td><p>Quantity ordered</p></td><td><p>Required</p></td></tr><tr><td><p>UnitPriceAmount</p></td><td><p>Unit price of the product</p></td><td><p>Required</p></td></tr><tr><td><p>TotalPriceAmount</p></td><td><p>Total cost of all items</p></td><td><p>Required</p></td></tr><tr><td><p>OrderProductNumber</p></td><td><p>Total amount including tax</p></td><td><p>Required</p></td></tr><tr><td><p>TotalTaxAmount</p></td><td><p>Total sales tax</p></td><td><p>Required</p></td></tr></tbody></table>

#### Product File Format

<table><colgroup><col> <col> <col></colgroup><thead><tr><th>Field Name</th><th>Field Description</th><th>Comments</th></tr></thead><tbody><tr><td><p>Id</p></td><td><p>Product ID</p></td><td><p>Optional</p></td></tr><tr><td><p>Name</p></td><td><p>Product name</p></td><td><p>Required</p></td></tr><tr><td><p>ProductCode</p></td><td><p>Product sku code</p></td><td><p>Required</p></td></tr><tr><td><p>ProductCategory</p></td><td><p>Product category</p></td><td><p>Optional</p></td></tr><tr><td><p>Description</p></td><td><p>Product description</p></td><td><p>Required</p></td></tr><tr><td><p>ShortDescription</p></td><td><p>Product short description</p></td><td></td></tr><tr><td><p>LongDescription</p></td><td><p>Product long description</p></td><td></td></tr><tr><td><p>Status</p></td><td><p>Product status (example: Active)</p></td><td><p>Required</p></td></tr><tr><td><p>ExternalId</p></td><td><p>Product id in the external system</p></td><td><p>Required</p></td></tr><tr><td><p>Type</p></td><td><p>Product type</p></td><td><p>Required</p></td></tr><tr><td><p>UnitListPrice</p></td><td><p>Product unit price</p></td><td><p>Required</p></td></tr></tbody></table>

## See Also

- [Prerequisites](https://docs.mulesoft.com/manufacturing/latest/prerequisites)

- [MuleSoft Accelerator for Manufacturing](https://docs.mulesoft.com/manufacturing/latest/)