Bed Bath & Beyond Account Integration


Overview

Bed Bath & Beyond is an iconic home furnishing chain store. While their core product offerings are primarily for the bedroom, bathroom, kitchen, and dining room, they have expanded their online catalog to include gardening and lawn care, jewelry, baby products and more.

Bed Bath & Beyond’s drop-ship program allows vendors to sell products on Bed Bath & Beyond’s website. Inventory feeds will keep available quantity updated, and customer purchases will be forwarded to the vendor for fulfillment.


Integrate with Bed Bath & Beyond

There are two ways to integrate your Bed Bath & Beyond account. One is described in this article and the other one is through Mirakl. Read more here about the integration with Mirakl.

To Integrate with Bed Bath & Beyond you will need:

  1. Seller Account with Bed Bath & Beyond.
  2. CommerceHub account.
  3. To configure Bed Bath & Beyond’s settings.
  4. To configure Bed Bath & Beyond’s Shipping Method Mapping.
  5. To complete the CommerceHub EDI Test Environment.

Seller Account with Bed Bath & Beyond – Bed Bath & Beyond purchases products through dedicated buyers, so you must contact them to become an approved seller and connect with a buyer. You submit a catalog file to the buyer, who decides which products to purchase and negotiates a price. Like other fulfillment channels, you do not post items to Bed Bath & Beyond from Sellercloud; rather, Sellercloud is used for inventory and order management.

CommerceHub Account – To integrate with Bed Bath & Beyond, you must open an account with CommerceHub.com, the software they use for document transmission. This integration transmits EDI documents via SFTP connections. (Sellercloud is not currently supporting integration via VAN connections.) You will be assigned a Partner Setup Specialist who will work with Sellercloud Support to integrate your account and get you live on Bed Bath & Beyond. Be sure to determine if you will be using an SFTP.  CommerceHub will ask you to provide a Customer ISA Qualifier and Customer ISA ID. See below for those values.


Integrate Bed Bath & Beyond with Sellercloud

Note: See instructions about setting co-op fees here for dropship.

To integrate your account in Sellercloud:

  1. Go to Settings > Companies > Manage Companies > Open a company.
  2. Go to Toolbox > Bed Bath and Beyond > General Settings > Edit.
  3. Go to General Settings panel > Check BedBathAndBeyond Enabled > Complete the credential fields.general settings
  4. Go to FTP Settings panel > Select Use Secure FTP (SSH) if using SFTP > Complete the FTP credential fields > Save.ftp settings
  5.  To test the connection, go to Actions menu > Test FTP Credentials > Save. test ftp credentials
  6. Enable the automatic control settings.
    1. CommerceHub will create 7 test orders for the test environment.
    2. Download these orders into Sellercloud.
    3. On CommerceHub, find the packing slips on the home page and download them.
    4. Follow the CommerceHub instructions for each order. Note: Orders should be shipped through Sellercloud. Any order involving cancellations should be managed through Commerce Hub, including partial cancellation orders.
    5. After completing the test environment, CommerceHub will move the account to production. Switch the Bed Bath & Beyond FTP Server path to the production URL.
  7. Enable the Inventory Control setting and save.

 


Bed Bath & Beyond Settings Explained

You can configure the following settings on the Bed Bath & Beyond General Settings page:settings panels

SETTING DESCRIPTION
BED BATHAND BEYOND GENERAL SETTINGS
BedBathAndBeyond Enabled Makes products available for Bed Bath & Beyond listing. If this is not enabled, an inventory of zero will upload for that product.
Customer ISA Qualifier Enter ZZ.
Customer ISA ID Customer ID is typically a phone number.
BestBuyDS ISA Qualifier Provided by CommerceHub.
BestBuyDS ISA ID Provided by CommerceHub
BestBuyDS Seller ID Provided by CommerceHub.
Supplier/Warehouse ID Gathered from Bed Bath & Beyond.
Order Handling Fee Fee for the order per item.
Terms Net Days When the payment is due.
Login Email Enter login email.
Login Password Enter login password.
Safety Qty The number of items that will not be set to the channel in order to prevent overselling.
Default Qty Use this option for replenishable products to set a default number of items that will always be available on the channel.
Enable Inventory Upload Enable this setting to let Bed Bath & Beyond upload inventory information from Sellercloud.
Note: The UPC is required on the item to update inventory.
Enable Invoice Upload Enable this setting for invoice uploads.
Enable Order Download Enable this setting to let Bed Bath & Beyond orders be downloaded to Sellercloud.
Enable Order Functional Acknowledgement Enable this setting to receive a FA document for the order.
Enable Order Acknowledgement Accept Enable this setting to allow confirmation that the order will be shipped out.
Enable Order Acknowledgement Release Enable this setting to allow confirmation that the order was canceled.
Enable Order Fulfillment Upload Enable this setting to let Bed Bath & Beyond upload tracking and shipping date from Sellercloud.
Requires Third Party Shipping This indicates that the product requires third-party shipping.
FTP SETTINGS
Server Provided by CommerceHub.
Username
Password
Port
Use Passive Check this option to connect to the server in passive mode.
Use Secure FTP (SSH) Check this option to use Secure Shell (SSH) FTP protocol.
Delete FTP Files After Processing Check this option to delete FTP files after processing.
Folder For Orders Choose a folder for storing the orders.
Folder For Tracking Choose a folder for tracking the orders.
Folder For Ack (Accept) Choose a folder for shipped orders.
Folder For Ack (Release) Choose a folder for canceled orders.
Folder For Ack (Functional) Choose a folder for FA documents.
Folder For Invoices Choose a folder for invoices.
Folder For Inventory Choose a folder for inventory.
You can easily bulk-update products by choosing the column header BedBathAndBeyondEnabled from the template’s Select fields you want to update dropdown list. The expected column values will be either True or False.

If you have multiple warehouses on CommerceHub that you need inventory updates, you must map the warehouse names to Bed Bath & Beyond:

  1. Go to Settings > Companies > Manage Companies > Open a company.
  2. Go to Toolbox > Channel Warehouse Mapping > Edit > Enter the CommerceHub warehouse name of each warehouse.
  3. Enter a safety quantity for the warehouses if desired.
  4. Save.channel warehouse mapping

Bed Bath & Beyond is an iconic home furnishing chain store. While their core product offerings are primarily for the bedroom, bathroom, kitchen, and dining room, they have expanded their online catalog to include gardening and lawn care, jewelry, baby products and more.

Bed Bath & Beyond’s drop-ship program allows vendors to sell products on Bed Bath & Beyond’s website. Inventory feeds will keep available quantity updated, and customer purchases will be forwarded to the vendor for fulfillment.


Workflow to integrate and sell on Bed Bath & Beyond

  1. Seller Account with Bed Bath & Beyond.
  2. CommerceHub account.
  3. Configure Bed Bath & Beyond’s settings.
  4. Configure Bed Bath & Beyond’s Shipping Method Mapping.
  5. Complete the CommerceHub EDI Test Environment.

Seller Account with Bed Bath & Beyond – Bed Bath & Beyond purchases products through dedicated buyers, so you must contact them to become an approved seller and connect with a buyer. You submit a catalog file to the buyer, who decides which products to purchase and negotiates a price. Like other fulfillment channels, you do not post items to Bed Bath & Beyond from Sellercloud; rather, Sellercloud is used for inventory and order management.

CommerceHub Account – To integrate with Bed Bath & Beyond, you must open an account with CommerceHub.com, the software they use for document transmission. This integration transmits EDI documents via SFTP connections. (Sellercloud is not currently supporting integration via VAN connections.) You will be assigned a Partner Setup Specialist who will work with Sellercloud Support to integrate your account and get you live on Bed Bath & Beyond. Be sure to determine if you will be using an SFTP.  CommerceHub will ask you to provide a Customer ISA Qualifier and Customer ISA ID. See below for those values.


Integrate Bed Bath & Beyond with Sellercloud

Note: See instructions about setting co-op fees here for dropship.

  1. Open Company Settings > Bed Bath and Beyond > General Settings.
  2. Complete the credential fields:
    1. Customer ISA Qualifier – ZZ
    2. Customer ISA ID – Arbitrary number. Typically,  the client’s phone number is used.
    3. BedBathAndBeyond EDI ISA Qualifier – Provided by CommerceHub
    4. BedBathAndBeyond EDI ISA ID – Provided by CommerceHub
  3. Select Enable Secure FTP (SSH) – If using SFTP.
  4. BedBathAndBeyond EDI FTP information – Provided by CommerceHub.
  5. FTP Port (default 990, 22 for SFTP, leave zero or blank for auto).
  6. Action Menu > xhoose Test FTP Credentials > Go.
  7. Save Settings.
  8. Enable the automatic control settings.
    1. CommerceHub will create 7 test orders for the test environment.
    2. Download these orders into Sellercloud.
    3. On CommerceHub, find the packing slips on the home page and download them.
    4. Follow the CommerceHub instructions for each order. Note: Orders should be shipped through Sellercloud. Any order involving cancellations should be managed through Commerce Hub, including partial cancellation orders.
    5. After completing the test environment, CommerceHub will move the account to production. Switch the Bed Bath & Beyond FTP Server path to the production URL.
  9. Enable the Inventory Control setting and save.

Important! For available inventory to upload, the product must be Bed Bath And Beyond Enabled on the Bed Bath & Beyond properties page; otherwise, an inventory of zero will upload for that product.

You can easily bulk-update products by choosing the column header “BedBathAndBeyondEnabled” from the template’s Select fields you want to update dropdown list. The expected column values will be either True or False.
If you have multiple warehouses on CommerceHub that you want sent in inventory updates, you must map the warehouse names to Bed Bath & Beyond. Show me where. In the company’s Toolbox > choose BedBathAndBeyond from the Select Channel list > enter the CommerceHub warehouse name of each warehouse > Save. Also, you can enter a safety quantity for the warehouses if desired.

Was this article helpful?

Related Articles