Circles.png

  until the 2018 eoStar User Forum and Technology Conference (August 13-16)
Click here for details

EDI Send Pricing Documents (832/879) (UFF)

From Wiki-eostar.com
Jump to: navigation, search

This menu option is used to send pricing documents to EDI Trading Partners in a universal file format UFF. This menu option requires the Miller Plugin and EDI Plugin.

Supported Document Types

eoStar supports several of the most common Miller EDI pricing and promotion documents:

Num Document Support Notes
878 Auth / De-Auth Manual Generally an email from the retailer chain
879 Pricing Supported Only front line pricing
889 Promotions Supported Only net pricing after promotions
832 Catalog Supported Used only as required by specific chains
824 Acknowledgement Manual Generally an email from the retailer chain
888 Deletion Unsupported Optional file is supplanted by updated 879/889/832 files
885 Full File Unsupported Outside the scope of Miller's current projects
EDI>Send Pricing Documents (832/879)


How To Set Up Pricing and Promo Documents

Initial Setup

  1. Create a trading partner for the customer chain that will receive pricing information if one does not already exist.
    (EDI > Trading Partners)

  2. Attach the customer(s) to the trading partner.
    (Records > Customer > Records > Assignments panel > "EDI Partner")

  3. Group customers to satisfy what is called "Looping Scenario 2" or "Price Zones" retailer requirements. It usually doesn't matter what value you put in the Outlet Code box as long as it is the same for all customers that will get the same pricing and different for any customers that have different pricing. Distributors often use Outlet Code "1" for most customers. (See Looping Structure)
    (Records > Customer > Records > Assignments panel > "Outlet code")

  4. Set the trading partner to send pricing and promotions.
    (EDI > Trading Partners > EDI Settings panel > "Send pricing/promotion documents (832, 879)")

  5. Restrict time frame of future promotions that are eligible for export. By default, any prices in your system that are scheduled to start within the next 365 days will be sent, but you may wish to limit this further.
    (EDI > Trading Partners > APS Settings panel)

  6. Some chains (notably Target) don’t understand promo end dates, so there is an optional configuration to slightly alter their file format.
    (EDI > Trading Partners > APS Settings panel > “Trading partner does not use promo end dates” and “Generate export in minimal mode”)

  7. Ensure all promotion sections have deal numbers. Since this number is arbitrary, if not already using deal numbers for other purposes, they can be set to "1" for all promos.
    (Records > Product > Promotion > Standard Promos > Sections panel > “Deal #”)

  8. Ensure that there are no duplicate item maps in SRS. This will generate errors when you attempt to send the pricing documents, so you may simply wait until you sending them and see what conflicts exist. Duplicates may be found by navigating to (Reporting -> ION Reports -> Item List) and making sure "SRS product key" is checked in your Item Information panel.
    (Records > Product > Records > SRS Panel)

  9. Ensure that all UPCs for products that will be included in pricing documents are valid. UPCs must be exactly 12 digits long and must not contain spaces or other non-numeric characters.
    (Records > Product > Records > ID panel)

Filtering products

You will want to filter which products you send to your trading partner, since they don’t want to see your entire catalog. There are a few choices:

  1. Only active products that the customer(s) can buy will be sent. This respects territory restrictions, black lists, liquor license limitations, and authorized item lists.
    (Most distributors use Authorized Item lists to limit pricing documents)

  2. Besides that, you can restrict the pricing document to exclusively submit a specific set of brands using "APS."

    1. In each brand that you wish to include, check the "Export this brand to APS" checkbox.
      (Records > Product > Brands > "Export this brand to APS")

    2. In the Trading Partner, specify that you only wish to send APS brands.
      (EDI > Trading Partners > EDI Settings panel > "This trading partner uses APS for pricing info")

  3. As a final filter, you can explicitly include items directly on the trading partner. Only the listed items will be eligible for exports even if they meet all other criteria.
    (EDI > Trading Partners > Price/Promo Docs panel "Supplemental product filter")

How To Send EDI Pricing Documents

Configure promos to export
  1. Go to EDI > Send Pricing Documents (832/879).
  2. Select the trading partner you would like to export.
  3. Click Configure promos to export to filter promotions. You will see a grid of all promo sections that apply to customers in this trading partner. Note that if you have multiple different Outlet Codes in use (see Step 3 of the setup), each Outlet Code will have its own list of all promo sections.
    • "Exclude" checkbox: Marks a promotion that MillerCoors will not pass on to customer.
    • "Export as EDLP" checkbox: Marks a promotion as Every Day Low Price.
    • "Preferred?" options: Used only for Minimal Mode trading partners. Select “Yes” for all promo sections you would consider a typical promo that Target would receive. You may wish to exclude very high minimum quantity sections so that only those promotions included would be those that are a realistically common discount. All promo sections should be either Yes or No before clicking post. Ideally, none should be left as “Not set.”
    • Note that you may select multiple rows and use the “Mark selected lines as” box at the bottom then click the “Mark” link to make bulk updates.
  4. Click one of the command buttons: Load Current Prices for 879, Load Current Promotions for 889, or Load Item Catalog for 832.
  5. Verify pricing displayed in the grid is appropriate.
  6. Click the command button Export Pricing Data.


Please note that the first export will be much larger than subsequent pricing documents. After the first, all files will be "differentials" that only include new or changed information. In the event that your testing requires you to resubmit a full pricing document again, please contact support to reset the trading partner’s pricing exports.


How To Re-Export Pricing Documents

  1. Go to EDI > Send Pricing Documents (832/879).
  2. Click the command button Show History/Re-Export.
  3. Select the desired date / time of previous export.
  4. Review the data for any errors.
  5. Click the command button Export Pricing Data.


  • Please note that prior exports may be erased using Mark this export as bad to cause new pricing documents to include any changes previously exported in the bad file. This is necessary because any corrections made to UPCs, looping, etc. would not be corrected in a re-export of a file (sent exactly as it was sent before) nor included in a new file (sending only new information since the last export). Corrected exports require that the incorrect export first be marked as "bad" before loading new pricing/promotions and submitting again, especially during the testing phase with OpenText/GXS.

Looping Structure for submitting EDI 879

When dealing with multiple customers and it isn't necessary or desirable to send identical pricing information multiple times, "looping" (generating data for an outlet code to have it "loop" back to regenerate the next outlets worth of data) can be beneficial. This method can reduce file size and contents.

Assign an outlet code
  1. Specify you outlet code: This will act as a grouping mechanism, allowing you to created associates between each customer account a trading partner.
  2. Navigate to Customer Records > Assignments panel and manually assign your accounts an outlet code of 1 or 2 if your trading partner does not specify the expected value. Any accounts sharing an outlet code will receive the pricing structure set up in step 4.
  3. Click the Configure promos to export link in the Export price/promos documents panel
  4. After grouping your accounts by an outlet code, include or exclude accounts from promos for each group
  5. Click Post. The result posts the relevant pricing information per outlet code.

Additional Notes

The following represent some common setup issues with producing pricing and promotion files.

  • Any duplicate items mapped in SRS must be addressed. The UI does not allow users to "double-map" a product.
  • When using GTIN fields in the product records for reporting, set them back to blank.
  • All UPC fields for each relevant product must be given case, pack, and unit UPCs. Each must be exactly 12 digits long, including the check digit.
    • For kegs and other products without UPCs, the recommendation is to prefix the product number with 4 and as many zeros as needed to reach 12 digits with a check digit.
      (Ex. Item 1234 would become UPC 400000012346.)
    • The Rutherford and Associates support staff have scripts available to convert 11 digit UPCs to 12 digits and to fill in keg UPCs as necessary.
  • Any promotions keyed at promotion price, where the promoted amount is greater than the frontline (creating a negative discount) needs to be addressed.
  • When a new file is sent it will send adjustments to correct the previous file. During testing, you may need to send a completely new file. If this is the case please contact eoStar support.

Known specific customer requirements

Different retail chains have specific requirements for pricing and promotion documents that are consistent for all distributors. While this cannot be a complete list, the following settings are currently known to be mandatory.

Target

  • "Outlet Code" required on customer records for looping, may be any arbitrary number
  • "Trading partner does not use promo end dates" in trading partner APS panel
  • Version 14.11.24 or higher must be used for successful transmission to Target.

Safeway

  • "Outlet Code" required on customer records for looping, may be any arbitrary number

7-Eleven

  • "Outlet Code" will match 7-Eleven's "Pattern"