List of available worksheets

This topic describes all of the worksheets available in Central Manager.

The following worksheets are available in Central Manager:

Worksheet #	Worksheet title and description	# worksheets created	Editable fields
251	Update Inventory - Item Prices Use this worksheet to update item prices and sale prices (on the item's Pricing tab) for specified stores. It is recommended if the stores you are managing with Central Manager have different pricing information for items. Note: You can export the items to an Excel spreadsheet, make the changes in Excel, and then import the spreadsheet back into Central Manager.	One per store	Price Price A, B, C MSRP Sale Price Sale Start Date Sale End Date Lower Bound Upper Bound Buydown Price Buydown Quantity
252	Update Matrix Items Prices Use this worksheet to update matrix item component prices and sale prices (on the item's Pricing tab) for specified stores. It is recommended if the stores you are managing with Central Manager have different pricing and cost information for matrix items.	One per store	Price Price A, B, C MSRP Sale Price Sale Start Date Sale End Date Lower Bound Upper Bound Buydown Price Buydown Quantity
261	Download Items Use this worksheet to add new items, and all item properties, to the specified stores. You can also use this worksheet to update existing items and item properties, excluding quantity. Note: This worksheet does not override the store item quantities.	One per store	None
303	Change Item Ordering Info Use this worksheet to update ordering information for specified stores. Note: This worksheet is designed to update ordering information for all stores. You can modify the worksheet so it only updates ordering information for specific stores. However, you cannot use the worksheet to enter different ordering information per store.	One	Min. Order Cost Reorder MPQ Purchase Tax
304	Change Item Price (Regular) Use this worksheet to update item prices for specified stores. It is recommended if the stores you are managing with Central Manager have the same item pricing.	One	New Price
308	Change Item Restocking Info Use this worksheet to update restocking information for the specified stores.	One worksheet, or one per store	One worksheet: Reorder Point Restock Level New Reorder Point New Restock Level One per store: Reorder Point Restock Level New Reorder Point New Restock Level
320	Adjust Item Sales Tax Use this worksheet to adjust item sales tax for specified stores.	One per store	Sales Tax
321	Change Item Block Sales Use this worksheet to block sales for the selected items in the selected stores. You can block sales based on a schedule and start/end date.	One	Block Sales Type Block Sales Reason Block Sales Schedule Block Sales Start Date Block Sales End Date
322	Change Item Discounts Use this worksheet to change discounts for the selected items in the selected stores.	One	New Quantity Discount
330	Inventory Transfer Use this worksheet to initiate inventory transfers between stores. After you initiate an inventory transfer in Central Manager, a transfer out is created in the source store where it must be released, shipped, and committed in Store Manager. When the transfer out is committed, a transfer in is created in the destination store that must be released, received, and committed in Store Manager. The worksheet status in Central Manager will be In Process until the transfer in is committed in the destination store.	One	Quantity Transfer
340	PO Planner Use this worksheet to initiate purchase orders for stores. After you initiate a purchase order in Central Manager, the purchase order(s) are created at the applicable store(s), where they must be released in Store Manager.	One per store	Order Number Item Description Quantity; Price Extended Purchase Tax
351	Update Inventory - Item Prices Cost (Regular) Use this worksheet to update item prices for specified stores. It is recommended if the stores you are managing with Central Manager have the same pricing and cost information for items. Note: You can export the items to an Excel spreadsheet, make the changes in Excel, and then import the spreadsheet back into Central Manager.	One	Price Price A, B, C MSRP Sale Price Sale Start Date Sale End Date Lower Bound Upper Bound Buydown Price Buydown Quantity
501	Request Full Inventory Count Use this worksheet to request store quantities and synchronize them to the Central Manager database for the purpose of adjusting quantities in Central Manager to match the quantities in the stores. This worksheet is typically run after stores complete their physical inventory counts. When Worksheet 501 has finished processing you can use Task 190 to reconcile store quantities with the quantities in the Central Manager database.	One	None