Sam’s Club DSV Integration

Overview

Sam’s Club is an American chain of membership-only warehouse clubs owned and operated by Walmart. Its limited-item business model offers high-quality products at competitive prices unmatched by traditional retail. In addition to discounted pricing, Sam’s Club members receive exclusive benefits, such as free shipping on select items, and more.

Integrating Sam’s Club into your Sellercloud account allows you to import orders, upload tracking information, create invoices, and ensure your listings are 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 a Value Added Network (VAN).

This integration supports two types of orders. The Custom Order Column SAMS_INTEGRATION_TYPE indicates the order type. Sam’s Club orders can be:

• Dropship – You sell products through Sam’s Club and are responsible for storing, packing, and shipping orders directly to customers. As a vendor, you must comply with Sam’s Club fulfillment guidelines, such as packaging standards, shipping speed, and inventory management.
• Ship To Warehouse – Sam’s Club purchases your products, and you ship them to Sam’s Club warehouses. Once received, Sam’s Club stores the inventory and fulfills orders from its distribution centers. These orders will include shipping addresses for Sam’s Club warehouses instead of customer addresses.

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.

---

Prerequisites

Before integrating Sam’s Club into Sellercloud, you must complete the following requirements.

Sellercloud Support

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

• Sams Club DSV 850 and 824 Order Import – Imports Dropship and Ship To Warehouse orders from Sam’s Club to Sellercloud in EDI 850 format.
• Sams Club DSV 855 Order Export – Sends order acknowledgment to Sam’s Club in EDI 855 format.
• Sams Club DSV 856 Tracking Export – Exports tracking information from Sellercloud to Sam’s Club in EDI 856 format.
• Sams Club DSV 810 Order Export – Exports invoices for Dropship orders from Sellercloud to Sam’s Club in EDI 810 format.
• Sams Club Ship To Warehouse 810 Invoice Export – Exports invoices for Ship To Warehouse orders from Sellercloud to Sam’s Club in EDI 810 format.
• Choose an Inventory Export plugin:
  • Sams Club DSV 846 Inventory Export – Exports inventory from Sellercloud to Sam’s Club in EDI 846 format.
  • Sams Club DSV 846 Multi Warehouse Inventory Export – Exports inventory per warehouse from Sellercloud to Sam’s Club in EDI 846 format.
• Sams Club DSV Packing Slip – Generates a printable PDF packing slip in a format that complies with Sam’s requirements.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber

On the company created for the integration:

• SamsClub_Vendor_ISAID – Client ISA ID for Dropship orders. Enter a phone number you don’t use for any other integration.
• SamsClub_810_ISAID – Client ISA ID for Dropship orders. Enter a phone number you don’t use for any other integration.
• SamsClub_ISAID – Sam’s Club ISA ID for Dropship orders. Set it to 925485USSM.
• SamsClub_IDInterchangeQualifier – Sam’s Club ISA Qualifier for Dropship orders. Set it to ZZ.
• SamsClub_IDRecieverQualifier – Client ISA Qualifier for Dropship orders. Set it to 08.
• SCBM_CustomerISAID – Client ISA ID for Ship To Warehouse orders. Enter a phone number you don’t use for any other integration.
• SCBM_CustomerQualifier – Client ISA Qualifier for Ship To Warehouse orders. Set it to 08.
• SCBM_ISAID – Sam’s Club ISA ID for Ship To Warehouse orders. Set it to 925485USSM.
• SCBM_Qualifier – Sam’s Club ISA Qualifier for Ship To Warehouse orders. Set it to ZZ.
• SAMS_VENDORNUMBER – Sams’ Club vendor number. Automatically populated by the Order Import plugin.
• SAMS_DEPARTMENTNUMBER – Sam’s Club department number. Automatically populated. 
• SAMS_BPNAME – Buyer’s name. Automatically populated.
• SAMS_SUPPNAME – Supplier’s name. Automatically populated.
• SAMS_BPGLN – Global Location Number to identify a physical location. Automatically populated.
• SAMS_WHCODE – A Sam’s Club warehouse code. Automatically populated.
• SAMS_ERROREMAILS – Enter a semicolon-separated list of email addresses to receive emails containing information about errors after an EDI 824 import.
• (Optional) EmailAdressesForDuplicateOrders – Enter up to 2 comma-separated email addresses. The Order Import plugin will send email notifications about duplicate orders that are already present in Sellercloud and are re-sent by Sam’s Club.
• (Optional) EnforceSendingFullCatalog – If you configure this setting as True, on its next execution, the Inventory Export plugin skips checking if product quantities have changed since the last update and exports all products. This setting defaults to False, and the plugin automatically resets it back to False after exporting.
• Sams_ShipToWarehouse_GLNNumber – Your GLN (or DUNS) number.
• Sams_SafetyQty – Enter a default Safety Quantity, which will be subtracted from the Available Quantity during Inventory Export to prevent overselling on Sam’s Club.
  
  Only applies if you use the Sams Club DSV 846 Inventory Export plugin, which exports your total inventory across all warehouses.
• SCBM_Email – Enter an email address to receive invoices imported via EDI 864.
  
  If you process both types of orders, your SamsClub_ and SBCM_ identifiers must contain different values. The SamsClub_ settings are for Dropship orders, while the SCBM_ settings are for Ship To Warehouse orders.

Custom Product Columns

Create the following Custom Product Columns:

• SAMS_ITEMNUMBER – The Sam’s Club 9-digit ID (not the Sam’s Club SKU). The Order Import plugin sets it automatically. Set the Data Type to String.
• (Optional) SAMS_Enabled – Enable only specific products for Sam’s Club. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.
• (Optional) Sams_SafetyQty – Enter a product-specific Safety Quantity to be subtracted from the Available Quantity during Inventory Export to prevent overselling on Sam’s Club. When you configure this setting, it overrides the default Safety Quantity from the Custom Company Setting Sams_SafetyQty. Set the Data Type to Integer.
  
  Only applies if you use the Sams Club DSV 846 Inventory Export plugin, which exports your total inventory across all warehouses.

Custom Order Columns

Create the following Custom Order Columns, setting the Data Type for all but the last two to String:

• SamsStoreNumber
• SamsSTW_VendorNumber
• SAMS_PONUMBER
• SAMS_BPGLN_ORDER
• SAMS_BPNAME_ORDER
• SAMS_CUSTOMERORDER
• SAMS_MEMBERSHIPNUMBER
• SAMS_VENDORNUMBER_ORDER
• SAMS_DEPARTMENTNUMBER_ORDER
• SAMS_SHIP_NOT_BEFORE
• SAMS_DO_NOT_DELIVER_AFTER
• SAMS_TERMS
• SAMS_TERMS_NET_DAYS – Set the Data Type to Integer. The value of this column is set as the ITD07 in the Ship To Warehouse Invoice Export EDI file.
• SAMS_INTEGRATION_TYPE – Set the Data Type to Dropdown. The value of this column is set to Dropship or Ship To Warehouse to indicate the order type.

---

Order Import

The Sams Club DSV 850 and 824 Order Import plugin:

• Imports orders from Sam’s Club to Sellercloud in EDI 850 format. The Custom Order Column SAMS_INTEGRATION_TYPE indicates the order type. Sam’s Club orders can be Dropship or Ship To Warehouse.
• Imports error reports from Sam’s Club in EDI 824. The EDI 824 file lets Sam’s Club notify you when EDI documents fail business rule testing. You can enter a semicolon-separated list of email addresses into the Custom Company Setting SAMS_ERROREMAILS to receive emails containing information about export errors.
• Imports invoices from Sam’s Club in EDI 864 format and sends them to the email you enter into the Custom Company Setting SCBM_Email.
• Exports EDI 997 acknowledgment files for Ship To Warehouse orders.

The optional Custom Company Setting EmailAdressesForDuplicateOrders allows you to enter up to two comma-separated emails to notify if the plugin tries to import an order that has already been imported.

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. On the Scheduled Task page, 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 Sams Club DSV 850 and 824 Order Import.
6. In the Import Options panel, set Import From to FTP and fill out the FTP fields with your VAN details.
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.

---

Order Acknowledgment

The Sams Club DSV 855 Order Export plugin sends order acknowledgment for DSV orders to Sam’s Club following the 855 EDI format and marks orders as acknowledged after export. The export does not include pricing.

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
• Payment Status – Charged
• Exported – Not Exported
• Order Ack (Accept) – 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. 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 Sams Club DSV 855 Order Export.
   4. Check Mark Orders As Exported.
   5. Check This is Order Ack (Accept).
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields with your VAN details.
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.

---

Tracking Export

The Sams Club DSV 856 Tracking Export plugin exports tracking from Sellercloud to Sam’s Club following the 856 EDI format.

Consider these important details regarding shipping method mapping:

• SE – FedEx 2Day
• SG – FedEx Home Delivery, FedEx Ground (if it’s FedEx Ground and the AddressClassificationType is Commercial, then it will export CG instead)
• ON – All overnight services

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 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 Sams Club DSV 856 Tracking Export.
   4. Check This Is Tracking Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields with your VAN details.
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

While the Order Import plugin supports both Dropship and Ship To Warehouse orders, there are two separate Invoice Export plugins for each type of order:

• Sams Club DSV 810 Order Export – Exports invoices for Dropship orders.
• Sams Club Ship To Warehouse 810 Invoice Export – Exports invoices for Ship To Warehouse orders.

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 Sams Club DSV 810 Order Export or Sams Club Ship To Warehouse 810 Invoice Export.
   4. Check This Is Invoice Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields with your VAN details.
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

Two plugins are available for updating inventory on Sam’s Club:

• Sams Club DSV 846 Inventory Export – Exports the total inventory across all warehouses from Sellercloud to Sam’s Club in EDI 846 format.
• Sams Club DSV 846 Multi Warehouse Inventory Export – Exports inventory per warehouse in EDI 846 format.

If you set the optional Custom Company Setting EnforceSendingFullCatalog to True, on their next execution, these two plugins will not check whether product quantities have changed since the last update and will export all products. This setting defaults to False, and the plugins automatically reset it back to False after exporting.

If you use the Sams Club DSV 846 Inventory Export plugin, you can add a Safety Quantity to prevent overselling with the optional Custom Product Column Sams_SafetyQty. If this setting doesn’t exist or has an invalid value, the plugin sets 0 as the safety quantity. This column is unavailable for the Sams Club DSV 846 Multi Warehouse Inventory Export plugin.

Optionally, you can enable only specific products for Sam’s Club by setting their SAMS_Enabled Custom Product 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 SAMS_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the SAMS_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 SAMS_Enabled – True. Optionally, you can add more filters to the search to narrow down the export further.

Per Warehouse

You can update inventory per warehouse with the Sams Club DSV 846 Multi Warehouse Inventory Export plugin. This plugin requires creating multiple Scheduled Tasks. Each task will send inventory quantities from a single Sellercloud warehouse to update a specific Sam’s Club warehouse.

To set this up, you need:

• The Warehouse ID of each Sellercloud warehouse you want to export inventory from.
• The corresponding Warehouse Codes of the warehouses you want to update on Sam’s Club.

You can find the Sellercloud Warehouse ID on the Inventory > Warehouses > Manage Warehouses page. By default, it is the first column of the grid.

Next, link your Sellercloud warehouses to your Sam’s Club warehouses. Click a warehouse’s Name or ID to open the Warehouse Details page, and then enter the Sam’s Club Warehouse Code into the Direct Fulfillment Warehouse Code field.

Finally, when you set up the Scheduled Tasks, follow the instructions outlined in the Automate Inventory Export section below, but also make sure to enter a Warehouse ID in the Notes field. With this setup, each task will only send inventory quantities from the Sellercloud warehouse in the Notes to update the Sam’s Club warehouse whose code you entered into the Direct Fulfillment Warehouse Code field.

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 Sams Club DSV 846 Inventory Export or Sams Club DSV 846 Multi Warehouse Inventory Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields with your VAN details.
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 Sams Club DSV Packing Slip plugin set up under your designated company, you can print PDF invoices with information about your Sam’s Club orders and the products they include through Sellercloud or Shipbridge. 

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 > Sams Club DSV Packing Slip.
5. Click Save.

---