top

 

 

 

 

 

 

 

 

 

UPC Authorization Error Resolution

Items must be authorized to your distributorship and the stores you service before pricing is sent to Walmart.  Authorizations are normally done through seasonal Modular updates or upon a retailer's request to the corporate MillerCoors VMP Analyst.  

Occasionally though, errors, such as authorization to sell an item you do not carry or authorization for an item you do carry, but for which no item catalog price is in effect, will hold up the authorization from reaching Walmart stores. This can result in deliveries being refused at the back door.

To view and resolve errors before they cause problems, Park City Group provides the UPC Authorization Error Resolution tool.  This tool alerts you when errors are present by displaying a red exclamation point beside the option on the main menu.  

Two categories are shown in the Error Resolution screen:  Proposals and Errors.  

Proposals list your requests for de-authorization of specific item/store assignments.  De-authorizations are performed when a "swap" replacement item is not available.  They must be accepted or rejected by the corporate VMP Analyst before taking effect.  For more information, see the Propose a De-Authorization section below.

Errors are specific to your item catalog, such as no active item matching the authorization or no price in effect. To view details, mouse over an error.  Some errors can be resolved from this screen, while others require resolution within your catalog.

Review Errors

Swap an Item

Propose a De-Authorization

Resolve VMP-1008  Distributor Item/UPC is not set up in PCG Item Catalog

Resolve VMP-1010  The authorized Item/UPC has no cost set up in PCG

 

Review Errors

Use these steps to display authorization errors and de-authorization proposal results.

 

 

From the Item & Cost tab, in the Vendor Managed Pricing section:

  1. Click UPC Authorization Error Resolution.

Any outstanding Proposals display at the top.  Un-check the Hide Rejections if desired to display rejected proposals.  

Authorization Errors display at the bottom.  These list item/store errors that require resolution before pricing can be sent to Walmart.

Columns:

Product Code - Authorized item's UPC.

Item Description - Authorized item.

Store - Location in which the item is authorized.  

Mouse over a store to see its assigned Cost Zone.

Auth Type - How the item/store was authorized. If desired, click to open the Distributor Item Information Lookup screen and view details.

Errors - Mouse over an error to view the cause.  Only VMP-1008 and VMP-1010 errors are click-able links.

De-Auth - Propose to resolve the error by de-authorizing the item from your distributor/store setup.  Proposals waiting for MillerCoors approval display in the top section.

Swap - Replace the item with another carried by your distributorship.

Reason - Text field for listing the reason for a de-authorization or swap.

Mouse over Errors to display the details.  Errors for items you do not carry can be resolved using the Swap and De-Authorization steps below

____________________________________________________________

(Top)

 

Swap an Item

If you do not carry an authorized item, you may be able to "swap" it with a replacement item.  Errors that can be resolved with a swap show a drop-down in the Swap column.  Swaps can be made at the distributor's discretion, but are limited to "like" items.

For example, a 24-pack can placement might be swapped for 30- or 36-pack cans, and vice versa. And 18-pack bottles might be swapped for 20- or 24-pack bottles.

Note:  The replacement item cannot be one already authorized to your distributorship/store.  Swap items are chosen from an approved substitution list.

 

 

To swap one item for another:

  1. Select a replacement item from the Swap drop-down to the right.  

  2. Enter a Reason for the swap, up to 60 characters.  For example, "Do not carry item."

  3. Continue working with other errors as desired.  Click Save when complete.  (Changes are not locked in until saved.)

____________________________________________________________

(Top)

 

Propose a De-Authorization

If you do not carry an item and a swap item is not available, you can request that the item be de-authorized from your distributorship/stores.  This must be accepted or rejected by the corporate VMP Analyst before taking effect.  

 

 

To de-authorize an item from a distributor/store assignment:

  1. Click the De-Auth box beside the item/store in error.

  2. Enter a Reason for the de-authorization, up to 60 characters.  For example, "Do not carry item."

  3. Continue working with other errors as desired.  Click Save when complete.  (Changes are not locked in until saved.)

Once a de-authorization is saved, it is automatically submitted as a proposal to the corporate VMP Analyst for approval.  The proposal will display at the top with a Status of Pending the next time you open this screen.  

If you change your mind while the proposal is Pending, you can click the X to delete the proposal.  

If the VMP Analyst rejects your request:

The proposal displays with a Status of Rejected, and the item/store in error is returned to the Error list.  (Un-check Hide Rejected and mouse-over the Status to view the reason behind a rejection.)

If the VMP Analyst approves your request:

The proposal no longer appears and the error is removed from the screen.

____________________________________________________________

(Top)

 

Resolve VMP-1008

Distributor Item/UPC is not set up in PCG Item Catalog

Use these steps to resolve errors for items to which you've been authorized, but are not yet set up in your item catalog.  

 

Note:  After resolution, the error will continue to display until the next nightly maintenance cycle runs.

  1. Use the columns in the list to identify the item, store, and authorization type.

  2. Click the VMP-1008 error to be resolved.

The Master Item Look Up View screen opens in a new tab or window.  The sellable UPC for the missing item is preselected.

  1. Unless a different package configuration is desired, click Proceed.

Otherwise select a different configuration from the family tree or use the search and Choose feature to make adjustments.

  1. Enter your Item Number and click Save and Proceed to begin adding Costs.

We recommend leaving the Description "as is."  If desired, you can enter Additional Supplier Item Information for your internal records.  However, this additional information is not sent to Walmart.  Field Definitions.

  1. Select the applicable Cost Zones.  

  2. Enter costs for the item.  Note that Walmart receives the Net Cost only. This is calculated when you click Validate.

Base Cost.  The cost without an allowance.

Allowance.  Any amount-off that's part of your normal pricing structure. (Optional.  Walmart receives the calculated Net Cost only.)

Effective Date.  If different from today's date.

Do NOT enter an End Date for everyday costs.  Old costs end when new costs begin.  Every item must have a "regular" cost without an end date.

  1. Click Validate and correct any errors.

  2. Click Save and Proceed to move to the Offer screen.

Or to add costs for different Cost Zones, change the Next Step bar to Manage Costs & Retails and click Save and Proceed.

  1. Items are automatically offered to and accepted by Walmart.  Do NOT check Rescind.

If you have other PCG retailer partnerships, select the Offer box by the retailers to be authorized.

  1. Click Save.

The Manage Multiple Costs & Retails for Single Item re-displays.  

  1. Click Back to close the "spawned" tab or browser window.

Or you can choose to add more costs as needed and click Save and Proceed. The item has already been offered, so just click Save from that screen and then click Back.

____________________________________________________________

(Top)

 

Resolve VMP-1010

The authorized Item/UPC has no cost set up in PCG

Use these steps to resolve errors for items that do not have a cost in effect for the Cost Zone in which the store is authorized.

 

 

Note:  After resolution, the error will continue to display until the next nightly maintenance cycle runs.

  1. Use the columns in the list to identify the item, store, and authorization type.

  2. Click the VMP-1010 error to be resolved.

The Manage Multiple Costs & Retails for Single Itemscreen opens in a new tab or window.  

  1. Select the applicable Cost Zone.  

  2. Enter a cost for the item.  Note that Walmart receives the Net Cost only. This is calculated when you click Validate.

Base Cost.  The cost without an allowance.

Allowance.  Any amount-off that's part of your normal pricing structure. (Optional.  Walmart receives the calculated Net Cost only.)

Effective Date.  If different from today's date.

Do NOT enter an End Date for everyday costs.  Old costs end when new costs begin.

  1. Click Validate and correct any errors.

  2. Click Save then Close.  The "spawned" session ends and you can return to the previous tab or window.

____________________________________________________________

(Top)

Updated 3/20/2012

 

Click for Video Training