Macy’s Account Integration

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.

In Sellercloud, integrating Macy’s with your account is done through plugins in one of two ways:

  • Direct via EDI and plugins
  • CommerceHub EDI integration via plugins

Integrate directly with EDI and plugins

The direct integration method for Macy’s works with plugins that import and export via a VAN (Value-Added Network). If you don’t have one set up, you can request a VAN from Sellercloud by following the instructions provided here.
Note: You should first obtain the ISA ID and Qualifier from Macy’s.

Custom Company Settings:

  • ISAControlNumber
  • GSControlNumber
  • STControlNumber
  • Macys_CustomerQualifier
  • Macys_CustomerISAID
  • Macys_Qualifier
  • Macys_ISAID_846
  • Macys_ISAID_820
  • MacysRemittanceEmailTo
  • MacysVendorID
  • Macys_CustomerQualifier
  • Macys_CustomerISAID
  • Macys_ISAID
  • Macys_Qualifier
  • MacysVendorName
  • MacysVendorDunsNumber

Integrate Bloomingdale’s

Needed settings:

  • Bloomingdales_ISAID
  • Bloomingdales_ISAID_820
  • Macys_CompanyForOrders
  • Bloomingdales_CompanyForOrders
  • Order custom column: Source

Set up scheduled tasks

  • 846— Inventory
  • 850/820— Orders and remittance. A 997 will be generated and sent back
  • 856— Tracking export
  • 810— Invoice export

Note: Testing needs to be done for each of the above transactions


Integrate through CommerceHub

There are five plugins needed to integrate Sellercloud with Macy’s through CommerceHub.

PLUGIN DESCRIPTION
EDI 850 Order Import With 997
  • Creates orders using the EDI 850 standard
  • Matches transactions with Macy’s CommerceHub ISA ID
  • This matches order items with products based on UPC. Make sure the products have their UPC’s filled out
  • Creates and EDI 997 acknowledgment
  • Saves custom order column SALES_DIVISION 
  • If the company setting UseUPCFromCustomColumn is set to True, we will use the UPC from custom product column MacysCH_UPC to match the products
EDI 856 Order Export
  • Creates an EDI export following the 856 format
  • Utilizes product UPCs
  • Exports 3 types of mapping
    • UPSN_SE for Second-Day Air
    • UPSN_CG for Ground
    • UPSN_ND for Next Day Air
    • Plus: UNSP if no other type is found
  • Works with normal orders and Parent SKU orders. Child SKU orders will not be exported. However, if the parent is exported, the Child order’s items will be added to the Parent order. The Parent and Child items must all be shipped to export the Parent order
  • Follows a Hierarchical structure of Shipment > Order > Packaging > Item
  • If the custom company setting UseUPCFromCustomColumn is set to True, we will check if the product has the custom column for UPC – MacysCH_UPC and use it instead
  • If we can’t match this shipping code we send UPSN. If Company Setting  MacysSendOTHRasDefaultShipCode is set to True, we will send OTHR
EDI 810 Order Invoice Export If the custom Company Setting UseUPCFromCustomColumn is set to True, we will check if the product has the custom column for UPC – MacysCH_UPC and use it instead
EDI 846 Product Inventory Export
  • Products exported MUST have a UPC
  • If the custom Company Setting UseUPCFromCustomColumn is set to True, we will check if the product has the custom column for UPC – MacysCH_UPC and use it instead
  • If the products have the custom column MacysCH_SafetyQty, the value on it will be deducted from the exported Qty
Macy’s And Bloomingdale’s Packing Slip
  • Exports invoices for Macy’s and Bloomingdale’s
  • Requires Macy’s 850 Order and 820 Remittance Import or EDI 850 OrderImport with 997 to import:
    • RESERVATION_NUMBER
    • REGISTRY_NUMBER
    • SOURCE_CODE
    • RETURNS_CODE
  • Order number is Channel Order #. PO Number is Channel Order # (2)
  • Different channel addresses will display depending on the order’s source code
  • Different returns messages will display depending on the returns code
  • Orders will be skipped if the reservation number is null

 

 

Was this article helpful?

Related Articles