Nebraska Furniture Mart Account Integration

Overview

Nebraska Furniture Mart (NFM) is one of the largest home furnishing stores in North America. NFM offers a wide range of products, including furniture, mattresses, appliances, electronics, and flooring. In addition to its physical locations, Nebraska Furniture Mart also operates an online store.

Integrating your Sellercloud account with NFM allows you to update the inventory levels of your listings, manage your NFM orders, and more. This integration works through EDI documents transmitting information between the two services. The following plugins are currently available in Sellercloud:

  • Order Import – Imports orders from NFM to Sellercloud in EDI 850 format.
  • Order Acknowledgement – Sends order acknowledgment to NFM in EDI 855 format.
  • Tracking Export  – Exports tracking information to NFM in EDI 856 format.
  • Invoice Export – Exports invoices to NFM in EDI 810 format.
  • Inventory Export – Exports inventory to NFM in EDI 846 format.

If necessary, you can contact Sellercloud Support to request additional customizations or other plugins for this integration.

To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

Prerequisites

Before you can integrate NFM with Sellercloud, complete the following requirements.

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.

NFM Support

Contact NFM’s support team for FTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins. 

In addition, make sure to ask about the values of the NFM_InternalVendorNumber and NFM_ISAID settings.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

  • STControlNumber
  • GSControlNumber
  • ISAControlNumber
  • NFM_InternalVendorNumber – Contact NFM’s support team for the value of this setting.
  • NFM_WarehouseID – Enter the ID of a Sellercloud Warehouse to send its address to NFM. The Inventory Export plugin will export the total available quantity of all NFM-enabled products.
ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The tracking and inventory exports will increment this number accordingly as jobs are processed. If the settings already exist and have values in them, do not edit them.

On the company created for the integration:

  • NFM_ISAID – Set to NEFURNMART. It’s best to verify with NFM that this value is currently valid.
  • NFM_CustomerISAID – Enter a unique phone number that you don’t use for any other integration.
  • NFM_IDInterchangeQualifier – Set to ZZ.
  • NFM_IDRecieverQualifier – Set to ZZ.
  • NFM_997_FTP_Directory – Enter a path on your FTP where the 997 files will be uploaded.
  • NFM_IsInProduction – Set to True when ready for production. Otherwise, we will send T for testing.
  • NFM_AlwasySendProductIDRequested – Set to True to enable exporting NFMSKU or the ProductIDRequested if available.

Sellercloud Support

Contact Sellercloud Support and request:

  1. To install the NFM Plugins on your server.
  2. The following Custom Product and Order Columns:

Custom Product Columns

  • NFM_Enabled – Optional column used to enable only specific products for NFM. Set to True for any products you want to send with the Inventory Export plugin.
  • NFM_SKU – a product’s SKU at NFM.
  • EXPECTED_AVAILABLE_DATE – The product’s estimated availability date. If the inventory in the warehouse is below 0, use this custom setting. Otherwise, the expected available date will be set to 30 days from the Inventory Export.

Custom Order Columns

  • NFMORDERTYPE – Stores the code specifying the type of Purchase Order. Populated automatically for each order by the 850 Order Import plugin. The following codes are available: CN – Consigned Order; DR – Direct Ship; QS – Quick Ship; SA – Stand-alone Order.
  • NFM_DUNS_NUMBER 
  • NFM_REQUIRED_BY_DATE – Type DateTime.
  • NFM_DELIVERY_REQUESTED_DATE – Type DateTime.
  • NFM_REQUESTED_FOR_SHIPMENT_DATE – Type DateTime.
  • NFM_REQUESTED_FOR_DELIVERY_DATE – Type DateTime.
  • NFM_IsOrderRejected – Type Boolean.

Order Import

This plugin imports order data from NFM to Sellercloud in EDI 850 format and then sends an EDI 997 order acknowledgment file. Orders are imported with the Channel set to Wholesale, and the Customer Email is always acknowledgementdinin@nfm.com.

Order prices are determined by the Wholesale Customers Pricing workflow. When such pricing is not found, the price will be set to $0, and the order will be set On Hold.

Automate Order Import

To create a Scheduled Task that imports orders:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Import Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click Create Orders For Company and select the company designated for this integration.
    2. Click the Plugin menu and select NFM Order Import EDI 850.
  7. In the Import Options section, set Import From to FTP and fill out the FTP fields.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable button.
  10. Click Save on the top right.

Order Acknowledgment

This plugin sends order acknowledgment to NFM following the 855 EDI format and marks orders as acknowledged after export.

Before you move on, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration
  • Channel – Wholesale
  • Order Status – InProcess Or Completed
  • Exported – Not Exported
  • Order Ack (Accept) – No
  • Order Ack (Release) – No

Automate Order Acknowledgment

To create a Scheduled Task that sends order acknowledgment:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select NFM Order Export EDI 855.
    4. Check Mark Orders As Exported.
    5. Check This is Order Ack (Accept).
    6. Check This is Order Ack (Release).
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Tracking Export

This plugin exports tracking from Sellercloud to NFM following the 856 EDI format. 

The tracking plugin only exports Direct Ship orders. Such orders are imported with the DR code into the NFMORDERTYPE custom order column, which indicates the Direct Ship type.

Before you move on, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration
  • Channel – Wholesale
  • Order Status – InProcess Or Completed
  • Shipping Status – FullyShipped
  • Payment Status – Charged
  • Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that exports order tracking:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select NFM Tracking Export 856 EDI.
    4. Check This Is Tracking Export.
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Invoice Export

This plugin exports invoices from Sellercloud to NFM in EDI 810 format.

Before you move on, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration
  • Channel – Wholesale
  • Shipping Status – Fully Shipped
  • Order Status – InProcess Or Completed
  • Invoice Uploaded – No
  • Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that exports invoices:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select NFM Invoice Export EDI 810.
    4. Check This Is Invoice Export.
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Inventory Export

This plugin exports inventory from Sellercloud to NFM in EDI 846 format. 

Optionally, you can enable only specific products for NFM by setting their NFM_Enabled Custom Products Column to True:

  • For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the NFM_Enabled column, and Save.
  • For multiple products in bulk: follow the steps to Bulk Update Products and use the NFM_Enabled column – set it to True for all products you want to enable.

Unlike core integrations, plugin integrations don’t require products to be in the company where the scheduled tasks are created. The export will include the products you select with your Saved Search.

Next, create a Saved Search for products filtered by NFM_Enabled True. Optionally, you can add more filters to the search to narrow down the export further.

Automate Inventory Export

To create a Scheduled Task that exports inventory:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Products.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select NFM Inventory Export EDI 846.
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support