Macy’s Account Integration via CommerceHub

Overview 

Macy’s is one of the largest and oldest department store chains in the United States. The company features a wide range of clothing, accessories, home goods, gifts, and food.

Macy’s does not have an online marketplace like other channels. Instead, a vendor can sell their products to Macy’s and become a Macy’s Vendor. This integration works via CommerceHub EDI integration via plugins. The following plugins are currently available:

• Order Import – Imports your orders from Macy’s to Sellercloud in EDI 850 + 997 formats.
• Tracking Export – Exports your order from Sellercloud to Macy’s in EDI 856 format.
• Invoice Export – Export Invoices to Macy’s in EDI 810 format.

• Inventory Export – Exports inventory to Macy’s in EDI 846 format.
• Macy’s And Bloomingdale’s Packing Slip – Creates printable PDF packing slips. 

You can contact Sellercloud Support to request additional customizations or other plugins for this integration if necessary.

Prerequisites

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

The integration method for Macy’s through CommerceHub works with plugins that import and export via a VAN (Value-Added Network). You must contact CommerceHub for your VAN Details and obtain the ISA ID and Qualifier from Macy’s.

Custom Company Settings

Create the following Custom Company Settings on your Default Company:

• ISAControlNumber 

• GSControlNumber
• STControlNumber

• Macys_CustomerQualifier – Set to ZZ.
• Macys_CustomerISAID – Enter a unique phone number, no spaces or symbols.
• Macys_Qualifier – Set to ZZ.
• Macys_ISAID_846 – Obtain from Macy’s.
• Macys_ISAID_820 – Obtain from Macy’s.
• MacysVendorID – Typically the VendorID consists of 6 digits and is a combination of the department and vendor numbers.
• MacysVendorName – Obtain from Macy’s.
• MacysVendorDunsNumber – Obtain from Macy’s.
• MacysCH_UPC – Product’s UPC in MAcy’s.
• MacysCH_ISAID – Enter a unique phone number, no spaces or symbols.
• MacysCH_IDInterchangeQualifier – Set to ZZ.
• MacysCH_IDRecieverQualifier – Set to ZZ.
• MacysCH_LockShippingMethod – If set to true, it will lock the shipping method for your Macy’s orders. 
• MacysCH_IDInterchangeQualifier – Obtain from Macy’s.
• MacysCH_IDRecieverQualifier – Obtain from Macy’s.
• CompanyIDToUseForWarehouseBreakdown – enter a company ID here, which will be used instead of the default company in cases of looking at warehouse breakdowns.
• UseUPCFromCustomColumn – If this is set to true, Custom Column MacysCH_UPC will be used instead. 
• MacysSendOTHRasDefaultShipCode – If set to True, we will send OTHR.

Optional Custom Company settings on your Default Company:

• SendProductAsUnavailableWhenQtyIsZero – If this is set to True, it will mark the product as unavailable, once the inventory is 0.
• MacysCH_ShippingRequiresThirdParty – Enabling this setting will restrict the use of your own carrier account for these orders in Shipbridge. Instead, 3rd party billing will be enforced.
• UseMultipleWarehouseForCHExport – If set to True, it will allow for multiple warehouses to be under the same code.
• MultipleWarehouseCode – The warehouse code you want to send to CH.
• MultipleWarehouseIDs – Enter any number of warehouses to use that code, comma-separated.
• UseReplenishableQty – Set to True to enable the product’s default replenishable qty.
• MacysFixedPriceQty – This allows you to set a fixed price for a quantity.
• UseCustomSettingWHMapping – Set to True to use the below setting instead of channel warehouse mapping.
• If the ‘UseCustomSettingWHMapping‘ setting is set to true, Warehouses fetched are mapped to warehouses listed in ‘WarehouseMappingForCH‘.
• If UseMultipleWarehouseForCHExport is set to true, warehouses in MultipleWarehouseIDs are mapped to the ID in MultipleWarehouseCode (using a different logic).
• If UseMultipleWarehouseForCHExport is set to false, only the mapping from ‘WarehouseMappingForCH‘ is used, and only sellable warehouses are fetched.
• If the UseCustomSettingWHMapping setting is set to false, Warehouses fetched are mapped to warehouses in the ChannelWarehouseMapping table for the specified company (e.g., Company 225).
• If UseMultipleWarehouseForCHExport is set to true, warehouses in MultipleWarehouseIDs are mapped to the ID in MultipleWarehouseCode (using a different logic).
• If  UseMultipleWarehouseForCHExport is set to false, only the mapping from ChannelWarehouseMapping is used, and only sellable warehouses are fetched.
• Additionally, there is a custom company setting called WarehouseMappingForCH for the queued job’s company, where you can enter a comma-separated list of ‘SCWHID_CHCode’ pairs to map the information. For example – 119_California,135_Weston.

Create the following Custom Company Settings for the company created for this integration:

• MacysCH_CustomerISAID – Enter a unique phone number.
• MacysCH_ISAID – Enter a unique phone number.
• MacysCH_IDInterchangeQualifier – Set to ZZ.
• MacysCH_IDRecieverQualifier – Set to ZZ.
• Мacys_CompanyForOrders 

Sellercloud Support

You must contact Sellercloud Support and request:

1. To install the Macy’s Plugins on your server.
2. The following custom order columns:

Custom Order Columns:

• SALES_DIVISION
• SOURCE_CODE – Valid values for Macy’s are 11, 13, 15, and 16.
• RETURNS_CODE – Valid values are NV, NN, NM, NX, BT, SV, SN, and SM. Orders with a different or no returns code will be skipped since no relevant returns message can be assigned.
• RESERVATION_NUMBER
• REGISTRY_NUMBER

Optional Custom Order Columns

• IsShipToStore – boolean data.
• Email

Order Import

This plugin imports order data from Macy’s to Sellercloud in EDI 850 format. It ensures that the correct transactions are matched with the unique MacysCH_ISAID and senderID.

A custom order column called SALES_DIVISION is also saved, which can be used to further categorize orders.

To confirm the successful receipt of orders, the plugin generates an EDI 997 acknowledgment, which needs to be uploaded to the CH FTP. Make sure to set the job notes of the task to FTP.

Automate Order Import

To create a Scheduled Task that regularly imports orders from Macy’s to Sellercloud:

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 the Create Orders For Company menu and select the company you designated for this integration.
   2. Click the Plugin menu and select Macy’s via CH EDI850 OrderImport With 997 Duo Company Check plugin.
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 and leave a job note of the task – FTP.
10. Click Save on the top right.

Tracking Export

This plugin exports your order from Sellercloud to Macy’s in EDI 856 format. It organizes the exported data in a hierarchical structure: Shipment, Order, Packaging, and Item.

It’s important to note that both regular orders and parent orders are supported. Child orders will not be exported individually, but if their parent orders are exported, the child order’s items will be included in the parent order’s items. However, for a parent order to be exported, all child orders and their parents must be fully shipped.

When exporting the orders’ shipping details, if a shipping code cannot be matched, the plugin will default to sending UPSN. However, if the custom company setting MacysSendOTHRasDefaultShipCode is set to true, the plugin will send OTHR as the default shipping code instead.

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 orders from Sellercloud to Macy’s:

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. User ID: Enter your Email Address.
   2. Saved Search: Select the Saved Search you created.
   3. Export Via: Select Macys via CH EDI856 Order Export plugin.
7. In the Export Options section, set Export 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.

Invoice Export

This plugin exports invoices from Sellercloud to Macy’s 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 from Sellercloud to Macy’s:

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 Maceys via CH EDI810 Order Invoice Export plugin.
   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 Macy’s in EDI 846 format. 

Make sure to enable your products for Macy’s by setting their MACYSENABLED 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 MACYSENABLED column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the MACYSENABLED 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. The export will include the products you select with your Saved Search. 

For products that have the custom column named MacysCH_SafetyQty, the plugin will deduct the value specified in that column from the exported quantity.

Before you move on, create a Saved Search for products filtered by MACYSENABLED – True. Optionally, you can add more filters to the search.

Automate Inventory Export

To create a Scheduled Task that regularly exports inventory from Sellercloud to Integration:

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 Macys via CH EDI 846 Product Inventory Export Plugin.
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.

PDF Packing Slip

This plugin creates packing slips with information about your orders and the products they include. This plugin doesn’t require a scheduled task.

To set up the invoice plugin:

1. Go to the Company Settings of the company where you set up Macy’s Integration.
2. Click Toolbox and select Invoice Settings.
3. Click Per Channel Preferences.
4. Scroll down to Website > select Macy’s And Bloomingdale’s Packing Slip plugin.
5. Click Save.

Configure UPS Prepaid Labels for Macy’s orders in Shipbridge

Macy’s will require you to use a prepaid UPS account to ship out Macy’s orders. In order to have that properly set up, you will need to enable the MacysCH_ShippingRequiresThirdParty setting under the company’s Custom Company Settings page. This setting ensures that Shipbridge will not allow you to ship these orders with your own carrier account, and 3rd party billing will be enforced.

Prior to being able to ship, the configuration for the account itself has to be completed in the carrier portal. Learn more about how to add and verify a third-party account here – UPS.com-Verification Doc-PIN.

Next, proceed with the account configuration in Shipbridge.

1. Open Shipbridge and navigate to Menu > Options > Carriers > UPS.
2. Click on Configure Per-merchant Third Party Billing > Select your Macy’s designated Company > click on Address.
3. Populate the UPS Account number provided by Macy’s and fill out the required address information.
4. Make sure the dropdown at the bottom says Use with all channels.
5. Click Save.