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.
Branch EDI Settings for ACE
A context menu linked to the menu marker icon provides access to additional features and settings: Mapping Overrides, Automation, ACE Rewards, and ACE In Store Pick Up (under development).
Begin by selecting "ACE" from the drop down control labeled "Settings for."
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.
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.
This is the password provided by ACE Hardware Corporation for electronic access.
Warehouse Code
Not used.
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.
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.
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).
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 .
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)
•Barcode Load
Additional Capabilities with ACE Rewards™ (Not included with ACE EDI)*
•ACE Rewards Member National Lookup
•ACE Hardware Promotional Pricing
*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).