BJ’s Wholesale Club Account Integration

Overview

BJ’s Wholesale Club is a membership-based warehouse club chain in the US selling a wide range of products, including groceries, electronics, furniture, appliances, clothing, and more. By buying products from manufacturers and suppliers in large quantities, BJ’s can offer discounts to their members.

Integrating BJ’s allows you to sell on their platform from Sellercloud. The integration works with EDI documents transmitting information between the two services. The document exchange goes through a third-party platform called CommerceHub, which provides the Secure File Transfer Protocol (SFTP) server and credentials.

The following plugins are currently available in Sellercloud:

• Order Import – Imports orders from BJ’s to Sellercloud in EDI 850 format.
• Tracking Export  – Exports tracking information to BJ’s in EDI 856 format.
• Invoice Export – Exports invoices to BJ’s in EDI 810 format.
• Inventory Export – Exports inventory to BJ’s in EDI 846 format.

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

---

Prerequisites

Before you can integrate BJ’s with Sellercloud, complete the following requirements.

Contact CommerceHub for your SFTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins. Also, make sure to ask for their ISA ID and Vendor Number – you will need those when populating the custom company settings.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber

On the company created for the integration:

• BJs_CustomerISAID – Enter a phone number that is not used for any other EDI integration.
• BJs_ISAID – Contact BJ’s for the value of this column.
• BJs_CustomerQualifier – Set to ZZ.
• BJs_Qualifier – Set to 12.
• BJs_VendorNumber – Contact BJ’s for the value of this column.
• BJs_MarkOrdersUnpaid – Optional setting. Set to True to import orders as unpaid.
• BJs_ShippingRequiresThirdPartyBilling – Optional setting, defaults to False. Set to True to import orders as requiring Third-Party Billing for shipping.

Sellercloud Support

You must contact Sellercloud Support and request:

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

Custom Product Columns

• BJs_Enabled – Optional column used to enable only specific products for BJ’s. Set to True for any products you want to send with the Inventory Export plugin.
• BJs_SKU – A product’s SKU at BJ’s.
• BJsDiscontinued – Optional setting. Set to True to mark SKUs as discontinued for BJ’s and send a quantity of zero.

Custom Order Columns

• BJ_OrderInternalControlNumber

---

Order Import

This plugin imports order data from BJ’s to Sellercloud in EDI 850 format and exports order acknowledgment in EDI 997.

Automate Order Import

To create a Scheduled Task that regularly 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 BJs EDI 850 Order Import.
7. In the Import Options section, set Import From to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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.

---

Tracking Export

This plugin exports tracking from Sellercloud to BJ’s following the 856 EDI format.

This plugin supports backorders and cancellations:

• Such orders must be PartiallyShipped, FullyShipped, or canceled.
• To backorder items, set their Backorder Quantity to anything above 0 and export the order.
• To cancel specific items, Split Them Off from the original order and Cancel the split-off order. To cancel all items, cancel the original order and export it.

When sending product quantities normally (without backorder or cancellations), Sellercloud matches the item’s Ship From Warehouse to the Channel Warehouse Mapping. Make sure your Sellercloud Warehouses are mapped correctly to BJ’s Warehouse Codes.

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
• Payment Status – Charged
• Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that regularly 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 BJs EDI 856 Order Export.
   4. Check This Is Tracking Export.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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 BJ’s 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 regularly 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 BJs EDI810 Order Invoice Export.
   4. Check This Is Invoice Export.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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 BJ’s in EDI 846 format, including product identifiers, pricing, and quantities. 

After setting up Channel Warehouse Mapping for the integration company, the plugin sends different product quantities per warehouse. The Warehouse Codes you set for the Website Channel must correspond to warehouses in BJ’s. If you don’t set up this mapping, the plugin will send a quantity of zero.

Optionally, you can enable only specific products for BJ’s by setting their BJs_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 BJs_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the BJs_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 BJs_Enabled – True. Optionally, you can add more filters to the search.

Automate Inventory Export

To create a Scheduled Task that regularly 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 BJs EDI 846 Product Export.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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.

---