Pier 1 Account Integration

Overview

Pier 1 operates exclusively as an online store, focusing on home décor, furniture, accessories, lighting, wall art, and seasonal decorations, targeting customers looking for unique and stylish home goods.

Integrating Pier 1 into your Sellercloud account allows you to seamlessly import orders, upload tracking information, and ensure your Pier 1 store is always up-to-date with the latest inventory data. This integration works through EDI documents, transmitting information between the two services via plugins and Scheduled Tasks. The document exchange goes through RevCascade.

Prerequisites

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

Sellercloud Support

Open a ticket with Sellercloud Support and request the following plugins be installed on your server:

• Pier1 RevCascade Order Import 850 – Imports orders from Pier 1 to Sellercloud in EDI 850 format.
• Pier1 Tracking Export EDI 856 – Exports tracking from Sellercloud to Pier 1 in EDI 856 format.
• Pier1 Invoice Export EDI 810 – Exports invoices to Pier 1 in EDI 810 format.
• Pier1 Inventory Export EDI 846 – Exports available inventory count from Sellercloud to Pier 1 in EDI 846 format.
•  Pier1 Packing Slip – Generates a printable packing slip in a format that complies with Pier 1’s requirements.

If necessary, you can open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

Pier 1 Support

Contact Pier 1 Support for the following:

• FTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins.
• Pier 1’s ISA ID and Qualifier.
• Provide Pier 1 with your Customer ISA ID and Qualifier.

Custom Company Settings

Create the following Custom Company Settings:

On your Default company:

• STControlNumber – Set to 1.
• GSControlNumber – Set to 1.
• ISAControlNumber – Set to 1.

On the company created for the integration:

• Pier1_ISAID – Provided by Pier 1.
• Pier1_Qualifier – Provided by Pier 1.
  
• Pier1_CustomerISAID – Your ISA ID. Typically, this is your phone number, but it can be whatever you set up with CommerceHub.
• Pier1_CustomerQualifier – Provided by Pier 1.
• Pier1_SupplierIdentificationCode – Provided by Pier 1.
• (Optional) Revcascade Integration Name – This setting allows you to use the Pier 1 plugins to import and fulfill Linens ‘N Things orders. If you don’t create the setting or leave it empty, orders will be imported under customer email Pier1[CompanyID]@SellerCloud.com. If you set the value to LinensNThings the order customer email will be LinensNThings[CompanyID]@SellerCloud.com.
• (Optional) Pier1_MarkOrdersUnpaid – When set to TRUE, all imported orders will have Payment Status: Unpaid in Sellercloud.
• (Optional) Pier1_ShippingRequiresThirdPartyBilling – Defaults to TRUE even if you do not create it in your Company. When this setting is enabled, all orders will be imported as Require third-party billing. To disable it, you must create the setting in your company and set its value to FALSE.
• (Optional) Consider replenishable products – Defaults to FALSE. When enabled, the plugin will check if any of the products being exported are marked as Replenishable. If there is a replenishable SKU that currently has 0 available quantity, we will send the value configured in the Replenishable qty custom setting.
• (Optional) Replenishable qty – When the setting Consider replenishable products is enabled, the plugin sends this quantity for all exported products with 0 available inventory.

Custom Product Columns

Create the following Custom Product Columns:

• Pier1SafetyQty – This column allows you to set a Safety Quantity for Pier 1 for each individual product.
• (optional) Pier1_Enabled – This column is used to enable only specific products for Pier 1. Set to True for any SKUs you want to send with the Inventory Export plugin.

Order Import

The Pier1 RevCascade Order Import 850  plugin imports order data from Pier 1 to Sellercloud in EDI 850 format. By default, it creates the orders in Sellercloud as Fully Charged. However, you can override this by enabling the Custom Company Setting Pier1_MarkOrdersUnpaid.

The plugin matches order items by their Sellercloud SKUs. If an order comes in with a Product ID that doesn’t exist in your Catalog, the order will be created with Unknown Product.

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 newly created Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click Create Orders For Company and select the company designated for this integration.
   2. Click the Plugin menu and select Pier1 RevCascade Order Import 850.
6. In the Import Options panel:
   1. Set Import From to FTP
   2. Fill out the FTP fields.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
9. Click Save.

Tracking Export

The Pier1 Tracking Export EDI 856 plugin exports tracking from Sellercloud to Pier 1 following the 856 EDI format.

The plugin sends tracking for the SKUs originally imported by the Order Import plugin. This means that if the order contains a Shadow Product and Sellercloud automatically replaces it with the Parent, this plugin will send back the ProductIDRequested.

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

• Company – The company you created for the integration
• Order Status – InProcess Or Completed
• Shipping Status – FullyShipped
• 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. On the Scheduled Task page, click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Pier1 Tracking Export EDI 856.
   4. Check This Is Tracking Export.
6. In the Export Options panel:
   1. Set Export To to FTP.
   2. Fill out the FTP fields.
   3. Check Use Secure FTP.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable toggle button.
9. Click Save.

Invoice Export

The Pier1 Invoice Export EDI 810 plugin exports invoices from Sellercloud to Pier 1 in EDI 810 format.

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

• Company – The company you created for the integration.
• 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. On the Scheduled Task page, click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Pier1 Invoice Export EDI 810.
   4. Check This Is Invoice Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable toggle button.
9. Click Save.

Inventory Export

The Pier1 Inventory Export EDI 846 plugin exports inventory from Sellercloud to Pier 1 in EDI 846 format.

Optionally, you can enable only specific products for Pier 1 by setting their Pier1_Enabled Custom Column for Products to True:

• For one product at a time, go to the Product Details Page > click Toolbox and select Custom Columns > click Edit > update the Pier1_Enabled column > Save.
• For multiple products, follow the steps to Bulk Update Products and use the Pier1_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 with the scheduled tasks. The export will include the products you select with your Saved Search.

Next, create a Saved Search for products filtered by Pier1_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. On the Scheduled Task page, click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Pier1 Inventory Export EDI 846.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable toggle button.
9. Click Save.

Configure PDF Invoices

With the Pier1 Packing Slip plugin set up under your designated company, you can print PDF invoices with information about your orders and the products they include through Sellercloud or Shipbridge. The invoice includes the logo of the company designated for the integration.

To set up the invoice plugin:

1. Go to the Company Settings of the company you created for the integration.
2. Click Toolbox and select Invoice Settings.
3. Click Per Channel Preferences.
4. For Website, select Plugin > Pier1 Packing Slip.
5. Click Save.