Uploading Product Pricing Data from Microsoft Excel

The system uploads only rows with changes (where the key fields appear in bold) in the New Price, New Cost (non-inventory products only), New MSRP, and New Eff. Date columns.

If you changed the new effective date, the system inserts a new row in the product price table. This action is comparable to entering a new row in the product price table for the price by inventory business unit with a new effective date. When the effective date of the spreadsheet row is unchanged, but you have altered the price, the current row in the product price table is updated.

Note:

Keep in mind that at download the New Eff. Date column is populated with the Product Cost Effective Date you selected on the Product Price Maintenance page. Because the minimum new effective date allowed for upload is the current date plus one day, selecting the current date as the Product Cost Effective Date requires that you change the new effective date for all rows you want to upload.

Uploading Modified Product Price Data

Click the Upload Prices button on the price maintenance toolbar.

Field or Control	Description
	The prices are uploaded into the PeopleSoft system. If the row is applied successfully, the status in the row Status column changes to Uploaded. If the row is not applied successfully, the status in the Status column changes to Failed. Correct the errors for the row and click the Upload Prices button.