EDI- ACE Hardware® Corporation

We suggest using direct Internet connection to ACE Hardware Corporation for submitting orders. Third party software is no longer required.

To begin using EDI with ACE Hardware Corporation, you will need your account number (store ID usually), user name (may be the same as the store number), and password (ACE Hardware Corporation electronic services department will supply this).

Contact: Should you need assistance, please contact the Ace Care Center at 800-777-6797. Monday – Friday: 6:00 a.m. to 10:00 p.m. CST or Saturday and Sunday: 7:00 a.m. to 7:00 p.m. CST email: rtsupport@acehardware.com.

Special Requirements

EDI settings for ACE Hardware Corporation, like most others, are found on the Branch Setup (Maintenance) form available from the Maintenance area's Database menu (choose Branches). It may be necessary to permit access to certain URLs through your company's firewall. The following domains should be permitted:

*.aceretailstores.com (web services for order submission)

*.goxroads.com (port 22) ftps (File Transfer Protocol Secure)

*.aceservices.com (port 10022) ftps (File Transfer Protocol Secure)

For more information about the specific addresses used, click here.

EDI Settings for ACE Hardware

Once the EDI option for ACE Hardware Corporation has been enabled by support, the next step in setup is done in the Branch Maintenance form (Main Menu > Maintenance > Database > Branches) on the EDI tab. This will need to be done for each store location that will use EDI with ACE Hardware. Every store location would have its own account and login. In order to save changes, you must choose Process (F12) from the Branch Maintenance form after completing any form and dialogs settings.

Main Menu > Maintenance > Database > Branches, EDI

Branch EDI Settings for ACE

A context menu linked to the menu marker icon Menu_Marker_Icon provides access to additional features and settings: Mapping Overrides, Automation, ACE Rewards, and ACE In Store Pick Up (under development).

EDI_Setup_MM

Begin by selecting "ACE" from the drop down control labeled "Settings for."

Account Number

The store number is provided by ACE Hardware Corporation. It must be entered as five (5) digits padded by zeroes (on the left) if necessary. For example, a store number of 4321 would be entered as "04321" instead.

Login

The "login" is used for electronic access and is the store number prefixed by the letters "ST," so given our last example, the login would be ST04321.

Password

This is the password provided by ACE Hardware Corporation for electronic access.

Warehouse Code

Not used.

Template Item

The template item is used for any new items added by EDI processing. For example, if you order an item from the vendor that you don't stock, the item may be added automatically upon receipt. The "template" provides the settings that the vendor would does not. Typically, these new items would need to be modified to update their group/section, or other aspects as needed.

Base Pathname

The base path name determines where data files being transmitted to or received from the vendor will be located. If your company has more than one location that will use EDI with ACE Hardware Corporation and EDI processing for both branches is being done from the same computer, you should set the branch ID in the path for each location's settings. For companies with their own server (not using our cloud hosting), the same directory should be created on the server for automated services processing.

C:\WSTieIn\ACE\1000

For our cloud hosted customers, a UNC (Universal Naming Convention) path name is supported. Some customers may have a mapped drive instead (this should continue to work if so).\\servername\SHARE\SharedFolders\ABCSupply\EDI\ACE

 

For automated operations with cloud hosting, you must also set the "Services Base Pathname" from the Automation dialog. This is the UNC path to the user's mapped drive location (same directory, different way of getting there). This is something that support or implementation personnel would set up for you.

Send Program

To enable sending and retrieval of data via the Internet (web), you must set the Send Program value to either DIRECT or the URL for submitting orders: https://oms5.aceretailstores.com/JSON/SubmitAceOrder (Subject to Change). For testing only, you can use DIRECTTEST (transmitted orders won't be processed).

Recv Program

The receive program should be set to DIRECT.

Upload Directory

Not required.

Download Directory

Not required.

Next, choose "Mapping Overrides" from the context menu associated with the menu marker Menu_Marker_Icon.

Main Menu > Maintenance > Database > Branches, EDI Tab (Menu Marker)

Mapping Overrides (ACE)

Set the "Submit PO" field's value to "POSendWeb." Change PO Update to "InvoicePOMatch." This second setting transmits your purchase order # to ACE so that they can include it in the invoice data when sent back to you. This allows the application to automatically update the proper Purchase Order(s) with the data. Choose "Accept" to close this form and then choose Process (F12) from the Branch Setup form to save all changes.

Capabilities

Please refer to the Vendor EDI transaction topic for additional information about processing the following EDI functions:

Send (Transmit) Purchase Orders

Receive Invoice Data (PO Update)

Receive Price Update Files (Hotsheets)

Catalog (Optional)

ACE Gift Cards

Barcode Load

Additional Capabilities with ACE Rewards™ (Not included with ACE EDI)*

ACE Rewards Member Sign-up

ACE Rewards Member Updates

ACE Rewards Member National Lookup

ACE Hardware Promotional Pricing

POS Data Transmission**

*ACE Rewards is an optional add-on available for ACE Hardware dealers who participate in the ACE Rewards loyalty program involving separate and additional setup and maintenance fees.

**Automated POS Data Transmission is suggested for 10 PM. ACE Hardware limits data transmission to certain times of day (they won't accept data between 3 AM and 5 AM CST).