Open topic with navigation

Product Edit window

The Product Edit window allows the user to define a product's characteristics, control inventory and ordering levels; set receiving options; and review and utilize sales analytics.

Use the Product Edit window

1. Log In to the Data Center Application to display the Data Center ribbon menu.

   

2. Select Inventory Management > Product Maintenance from the main menu to display the Product Maintenance screen.

   

3. Complete one of the following procedures as appropriate to display the Product Edit window.

   • Click the Add Product button to create a new product record.
   • Check a product’s checkbox and click the Clone Product button to create a new product record based on the selected product.
   • Check a product’s checkbox and click the Edit Product button to modify an existing product record.

   

4. Complete the desired procedure(s) on the appropriate tab(s).

   Note: If necessary, click a tab to display its contents.

   • The Product Edit tab allows the user to define a product's characteristics and values.
   • The Vendor Product tab allows the user to manage a product's vendor product detail record and control the behavior of its Vendor Product Detail window.
   • The Sales Analysis tab allows the user to review an item's sales data and set its min/max values.
   • The Product History tab allows the user to review an item's inventory and transactional history.

Product Edit tab

The Product Edit tab allows the user to define a product's characteristics and values.

Use the Product Edit tab

1. Log In to the Data Center Application to display the Data Center ribbon menu.

   

2. Select Inventory Management > Product Maintenance from the main menu to display the Product Maintenance screen.

   

3. Complete one of the following procedures as appropriate to display the Product Edit window.

   • Click the Add Product button to create a new product record.
   • Check a product’s checkbox and click the Clone Product button to create a new product record based on the selected product.
   • Check a product’s checkbox and click the Edit Product button to modify an existing product record.

   

4. If needed, click the Product Edit tab to display the Product Edit tab.

   

5. Complete the desired procedure(s) with onscreen features.

   Product Info section	Complete the appropriate fields and settings:.
   Note: Required fields and settings are displayed with red borders. Active Check the checkbox to mark the item as active and make it available for search and selection in the Register application. Is Firearm Check the checkbox to mark the item as a firearm. Serialized Non-Firearm Check the checkbox to mark the item as a serial non-firearm and require a serial number to receive or sell it. Is Stock Item Check the checkbox to mark the item as a physical item that can be inventoried and sold. Product UPC Enter the product's UPC code. Manufacturer Ref # Enter the manufacturer’s stock number for the item. Receipt Description Enter a concise item description (30 characters maximum) to be shown on labels and customer receipts. Item Description Enter a lengthy item description (80 characters maximum) to be shown on information screens in the Register application. Note: If an item has been automatically added to the system by a vendor, a description beginning with "AUTO" displays in this field. Feel free to remove the "AUTO" and modify the description as needed. Register Lookup Description This field automatically populates for AcuSport items. The field may be left blank for Non-AcuSport items. Auto Replenishment Select Y (yes) to let the system automatically order the item to maintain inventory levels (as defined by the Min Level and Max Level values). Select N (no) to retain standard ordering procedures for this item. Note: The Auto Replenishment feature is available only to AcuSport Exchange retailers. Min/Max Type Select a min/max type (Suggested, Manual, or Automatic) to modify the product's Min/Max Type designation on the Inventory Level screen. Current Min Level Enter/edit a value to modify the product's Current Min value on the Inventory Level screen. If the item's inventory level drops below the minimum, the system can calculate the number of items needed to restock the item to the Max Level value. For example, after a big sale, an item having a Min Level of 3 and a Max Level of 10 has only 2 items remaining in inventory. The system recognizes that inventory is below the minimum level and calculates that 8 (10-2) need to be ordered to bring the item inventory to the maximum level. Note: If an item's Min Level is set to 0, the Auto Replenishment feature will not order it. If Auto Replenishment is activated for the item, the system automatically recognizes these shortages and orders items accordingly. Min/Max calculations are also used to generate suggested ordering quantities when manually creating a vendor-specific purchase order. Refer to Create a Vendor Purchase Order for more information. Current Max Level Enter/edit a value to modify the product's Current Max value on the Inventory Level screen. Suggested Min Level The field displays the product's Suggested Min value as shown on the Inventory Level screen. Suggested Max Level The field displays the product's Suggested Max value as shown on the Inventory Level screen. ID Age Enter the minimum age (in years) a customer must be to purchase the product. (If the product has no age requirement, leave the field blank.) Refer to Bulk Edit a Group of Products for information on setting this value for an entire group of products (i.e., firearms, ammunition, etc.). Retail Price Enter/edit the standard price for the item as needed. Note: If no price is entered, the item will ring up for $0.00 in the Register application. Last Cost Edit the last cost for the item as needed. Note: If the item is a firearm, this field may not be edited. Avg Cost Edit the average cost for the item as needed. Note: If the item is a firearm, this field may not be edited. QoH The field displays the product's quantity on hand. Adjust QoH Edit the quantity on hand for the item as needed. Note: The Adjust QoH field should not be used with firearms or serialized nonfirearm items. Note: If an item's QoH is a negative number, the Auto Replenishment feature will not order it. On Order The field displays the quantity of the product that is on order. Excluded On Order The field displays the quantity of the product that is on order but is not included in QoH calculations. Committed The field displays the quantity of the product that has been committed for use outside of inventory (i.e., reserved for a customer, designated a rental item, etc.).
   Product Tax Info section	Select the appropriate tax for the item from the drop-down field and click the Add Product Tax button to add a tax.
   Product Attribute Descriptor section	Select an attribute from the first Add/Edit Attribute Descriptor drop-down field, select a descriptor from the second Add/Edit Attribute Descriptor drop-down field, and click the Update A/D button to add the selected attribute/descriptor combination to the item.
   Product Image section	Click the Select Image button under the Quick Pick Image (or Register Lookup Image) field and select an image to accompany the item on the Quick Picks (or Register Lookup) screen.
   Web Info section	Check the Is Web checkbox to mark the item a web portal product and enter its web-specific price (if appropriate) in the Web Price field. (Uncheck the checkbox to remove the web portal designation.)
   Product Price Info section	Select a price type from the drop-down field, enter a price in the second field, and click the Add/Update Product Price button to add the price to the item.

   • Create and Maintain a Product

Vendor Product tab

The Vendor Product tab allows the user to manage a product's vendor product detail record and control the behavior of its Vendor Product Detail window.

Use the Vendor Product tab

1. Log In to the Data Center Application to display the Data Center ribbon menu.

   

2. Select Inventory Management > Product Maintenance from the main menu to display the Product Maintenance screen.

   

3. Complete one of the following procedures as appropriate to display the Product Edit window.

   • Click the Add Product button to create a new product record.
   • Check a product’s checkbox and click the Clone Product button to create a new product record based on the selected product.
   • Check a product’s checkbox and click the Edit Product button to modify an existing product record.

   

4. If needed, click the Vendor Product tab to display the Vendor Product tab.

   

5. Complete the desired procedure(s) with onscreen features.

   Disable Vendor Product Details Pop-up for this product checkbox	Check the checkbox to prevent the UPC's Vendor Product Details window from displaying in the future. Uncheck the checkbox to allow the window to display in the future.
   Add button	Click the Add button, populate the Vendor Product Detail window, and click the Submit button to create a vendor part number for the product
   Delete button	Select a Vendor Product Detail and click the Delete button to remove the record.

   • Add a Vendor Product Detail Record for this UPC
   • Delete a Vendor Product Detail Record for this UPC
   • Control the Behavior of this UPC's Vendor Product Detail Window

Sales Analysis tab

The Sales Analysis tab allows the user to review an item's sales data and set its min/max values.

Use the Sales Analysis tab

1. Log In to the Data Center Application to display the Data Center ribbon menu.

   

2. Select Inventory Management > Product Maintenance from the main menu to display the Product Maintenance screen.

   

3. Complete one of the following procedures as appropriate to display the Product Edit window.

   • Click the Add Product button to create a new product record.
   • Check a product’s checkbox and click the Clone Product button to create a new product record based on the selected product.
   • Check a product’s checkbox and click the Edit Product button to modify an existing product record.

   

4. If needed, click the Sales Analysis tab to display the Sales Analysis tab.

   

5. Complete the desired procedure(s) with onscreen features.

   Case UPC and Unit UPC fields	If the item is a unit UPC associated with a case UPC, the Case UPC field is displayed. The user may click the Case UPC field to display the case UPC's Sales Analysis tab. If the item is a case UPC associated with a unit UPC, the Unit UPC field is displayed. The user may click the Unit UPC field to display the unit UPC's Sales Analysis tab.
   Calculation Data section	The Calculation Data section includes the Estimated Weekly Sales (Units), Lead Time Demand, QoH, On Order, Excluded On Order, Retail Price, and Avg Cost fields. Some of these fields may be edited on the Product Edit tab.
   Lead Time (Days) field	The Lead Time (Days) field reflects the value displayed in the Lead Time Days field on the vendor's Vendor Information for screen. The user may temporarily adjust this value on this tab to display its effect on calculations, but it can only be permanently changed on the vendor's Vendor Information for screen. Refer to Manage Vendor Records for more information.
   MIN and MAX fields	The MIN and MAX fields reflect the item's current minimum and maximum values (respectively). They may be edited on this tab.
   Suggested Min and Suggested Max fields	The Suggested Min and Suggested Max fields reflect the suggested minimum and maximum values (respectively). The system calculates these values according to the item's lead time, lead time demand, safety stock percentage, relative weekly weights, and estimated weekly sales. Note: If an item does not have 8 weeks of sales data or the item was out of stock for more than 50% of the 8-week period, the suggested values will be "0." If the Lead Time Days field is not populated, the suggested values will be "N/A."
   Saw Tooth Graph section	The Saw Tooth Graph section presents a graphic representation of comparative inventory levels over the past year. This graph allows the user to identify how changes to min/max levels can help avoid overstock and out of stock situations.
   8-Week Sales Data section	The 8-Week Sales Data section includes the Weight, Sales Units, Sales Dollars, Days Out Of Stock, Weekly Average Sales (Units), Lost Sales (Units), Lost Sales (Dollars), COGS, GP%, and GP$ fields. Note: The Days Out Of Stock, Lost Sales (Units), and Lost Sales (Dollars) fields display values for items that go out of stock after the system software is updated. Values are not calculated for items that are or were out of stock prior to the update.
   Weekly Sales section	The Weekly Sales section presents a graphic representation of weekly sales over a 52-week period. The user may hover over a week's red diamond to display data from that week.

   • Display Case UPC or Unit UPC Data
   • Adjust Lead Time
   • Modify Min/Max Levels

Product History tab

The Product History tab allows the user to review an item's inventory and transactional history.

Use the Product History tab

1. Log In to the Data Center Application to display the Data Center ribbon menu.

   

2. Select Inventory Management > Product Maintenance from the main menu to display the Product Maintenance screen.

   

3. Complete one of the following procedures as appropriate to display the Product Edit window.

   • Click the Add Product button to create a new product record.
   • Check a product’s checkbox and click the Clone Product button to create a new product record based on the selected product.
   • Check a product’s checkbox and click the Edit Product button to modify an existing product record.

   

4. If needed, click the Product History tab to display the Product History tab.

   

5. Complete the desired procedure(s) with onscreen features.

   Date Range fields	Enter starting and ending dates in the Date Range fields to display only emails from the defined time frame.
   Submit button	Click the Submit button to activate the selected list restrictions (Date Range).
   Tabs	Click a tab to display the associated records.
   Grid Layout Controls	Complete the following to save a layout: Select the desired combination of filters, sorts, groupings, etc. Enter a name for the layout in the Default Grid Layout field. Note: Some screens allow the user to modify and save changes to the default (Default Grid Layout) layout, though most do not. Click the Save button beside the field to save the current layout under the name in the field. Select the desired layout from the Default Grid Layout drop-down to recall that layout. Note: Select the Default Grid Layout option to recall the default layout.
   Sort and Filter Reporting Screen Data	Enter a term (string of characters) in the Search field to display only records containing that term. Click the Clear Search (X) button to undo the Search field filter. Click the Clear All button to undo all filters. Click the Toggle Filters button to display filter controls at the tops of the columns. (Click again to hide the controls.) Click the Export to Excel (Table) button to export the data to an Excel file. Click the Column Chooser button to hide or display individual columns.