EDI- Do it Best® Corporation

To begin using EDI with Do it Best, you will need your account number (store ID usually), login/user name, and password (Do it Best Corp. EDI member support supplies this information). Our Support or Implementation departments will assist with enabling these features and setup.

Contact: Should you need assistance, you can contact Do it Best EDI Support via email at edimembersupport@doitbest.com.

Do it Best - Setup

Do it Best - Mapping Overrides

Do it Best - Automation

For communication, we connect to the following address which will need to be permitted through any firewall or security software your company may operate:

edi3.doitbestcorp.com (port 10021) FTPS

Feature Summary

The following list includes the current (as of 10/20/2014) functionality of EDI with Do it Best Corporation:

✓Standard transmission sends an order to the vendor electronically that may optionally include your current (retail) pricing for the items. These prices are used to update the Do it Best® on-line system when included.

We also support a number of alternate PO formats:

✓Refill Orders

✓CF1W (Warehouse) and CF1D (Direct) Claims

✓Updating IMCS

✓Deleting IMCS

✓Send Personal Advance Rebates (PAR)

✓Send a Purchase Order "Call For" (pick up at the warehouse)

✓Send a Purchase Order with UPS to store, Regular, 2nd Day, or Overnight

✓Send a Purchase Order "Drop Ship" to a customer either Regular, 2nd Day, or Overnight

  • Automated Claims

    CF1 claims can be created and maintained when using our enhanced returns feature. This allows claims to be sent in bulk with weekly purchase orders (see above).

  • Receive File Maintenance and Catalog Updates

    File Maintenance data is used to keep inventory items and catalog records up-to-date. The software supports automatic item additions via EDI when Do it Best Corp. flags items as new IMCS items. We support both classic and vision costs. Price sensitivity codes are also supported and shown in the catalog and catalog tabs found in folders. The following File Maintenance overrides are available (Mapping Overrides can be changed from the Branch Setup form's EDI tab using the menu marker):

    Companies who are setting up EDI initially should select whichever "NEW" option meets their needs. The difference between "classic" and "vision" costs is that "classic" cost has a higher cost and larger year-end rebate whereas "vision" has a lower cost and lower year-end rebate.

  • Receive Price Updates and Sale Flyer Updates

    The software can retrieve weekly price updates either with or without the retail price (if retail is not included, market cost is updated). Mapping Overrides are used to change this setting if needed. The "Cost Update" selection would be used in cases where you only want to update cost pricing and not retail prices with updates.

  • Receive Promotions for Sales and Shows

    Promotions can be imported into Price Updates to create Sale pricing. Use the Vendor EDI Promotions option for ordering promotional merchandise. Promotions are displayed in the vendor catalog as well.

  • Receive Updates for Warehouse Quantities in the Catalog (also available as an automatic nightly update)

  • Multiple Warehouse Support for multi-branch companies

  • Receive a complete Catalog Load

  • Send Point of Sale daily transactions (data) to Do it Best (also available as an automated nightly process)

  • Retail Inventory Feed

    This "automatic inventory data send" function runs once per day at approximately 6 PM (EST) and sends Do it Best information regarding changes to your inventory during the day. Changes to the following inventory (item) settings trigger an update for that item: discontinued, Suggested Retail, On-hand, On Order, Location Code (the primary or zero (0) code only), and the Store Retail (Level 0) price. The retain inventory feed is enabled by an EDI parameter that must be enabled with support assistance.

  • Receive a file containing Do it Best product classifications

    Classifications can be used for item selection and purchase order builds (also available as an automatic nightly update).

  • Barcode Load - We can request and process a file loading barcodes for Do it Best items

  • Direct Ship

    Direct Ship Do it Best invoices can be imported into Payables via EDI processing.

For additional documentation regarding general EDI processing (submitting orders, retrieving data, etc.), please see the Vendor EDI topic.