VMP - Batch Exports

Batch Exports

Use this screen to review authorization and pricing exports sent to the VMP retailer. It lists what was sent and when, as well as any errors that occurred. A Resend option is available to resubmit the batch, and is used to either resubmit erred records after correction or to resend batches that were error free but not received by the retailer.

Note: Different columns appear for authorization records and pricing records.

Export Note: Resending a batch generates an SSMIA 888 authorization or a VMP 879 pricing export (based on the original batch type).

Follow these steps:

From the Vendor Managed Pricing tab, under Research:

Click Batch Exports
Enter criteria to display the desired batch. Two methods are available:
- Enter Batch ID. Quickly display a specific export.
  1. Enter the Batch ID.
  2. Choose to show the export only if it contained one or more errors (Errors Only) or choose All to display the export regardless of errors.
  3. Click Proceed to display the batch.
- Batch ID Search. Search for exports based on the Sent Date and Export Type.
  1. Enter the Sent Date. This displays all exports sent on or after that date. The default is seven days prior to today.
  2. Select the Export Type. Authorization exports only, Pricing only, or All exports.
  3. Choose to show only exports that contained one or more errors (Errors Only) or All exports, regardless of whether they had errors.
  4. Click Find.
  5. Select the Batch to display.
Review the exports. If errors exist, work with the VMP Authorization Provider to correct.
1. Please note that the columns vary between Authorization exports and Pricing exports. Use the tables below as a guide.
2. Authorization record columns
3. Pricing record columns
To resubmit a batch, display the export using the steps above and click Resend. Click Yes to confirm.

Resend can be used in two ways:
- If errors were found in the batch, clicking Resend submits only the records that had errors.
- If no errors were present, but the retailer did not receive the export, clicking Resend submits the entire batch.

____________________________________________________________

(Top)

Authorization record columns

Field Name	Description
Distributor	Distributor authorized to the item within the store.
Store	Retailer store ID and store name in which the distributor / item is authorized.
UPC	Sell-unit UPC of authorized item.
Item Description	Description of authorized item.
Status	Authorization status. AC - Authorized in store. DA - De-authorized in store.
Effective Date	Date item is authorized in the store.
Received Date	Date authorization received by the retailer.
Error Message	Errors reported by the retailer's system. Blank if no errors found.

(Top)

Pricing record columns

Field Name	Description
Distributor	Distributor whose pricing was submitted.
Store	Retailer store ID and store name.
UPC	Sell-unit UPC associated with pricing.
Item Description	Description of item.
PTR	Price to Retailer. The distributor's cost to the retailer.
PTC	Price to Consumer. The retailer's selling price to the consumer.
Status	Batch export status. New - Ready to send. Sent - Sent to the retailer. Skipped - Old price. Not sent because a newer price took effect before the batch send date. Replaced - Sent once, but replaced by an earlier price. For example, today is 7/5. We send a price today effective 8/1. Tomorrow we receive and send a cost change effective 7/21. Because the retailer can only hold one future price, the 7/21 price overrides the 8/1 price. The 8/1 price is marked Replaced. Once the date is greater than 7/21, we resend the 8/1 price. Resend - Queued for re-submission to the retailer. (Similar to New.) Archived - Indicates that the cost was sent to Walmart but the cost was resent for some reason. Possible causes: -- Someone used the resend option -- A margin was changed resulting in a new PTC for the same cost.
Eff. Date	Date price begins.
Received Date	Date export received by retailer.
Error Message	Errors reported by the retailer's system. Blank if no errors found.

(Top)

Updated 5/10/2011