The Part List displays all customer part numbers for a customer. From this page you can drill into specific products, print product labels, or export the list as a .csv file. You can also sort the list on-screen, search for specific products, or filter the list by inventory metric.
Column Headings
The following columns are displayed:
- SKU# - Customer Part # from Customer Part # Maintenance in Eclipse
- Distributor SKU# - Eclipse Product ID
- Product Description - Eclipse Product Description
- Inventory Status - Moving, Slow, or Frozen. The Inventory Status uses an Inventory Turns Ratio (ITR) to rank your part numbers for a rolling 12-month period. For more about this setting, click here.
- Lifecycle Status - Eclipse Product Status
- Turns - Days to use the inventory on-hand at the current inventory turns ratio. For more information on this calculation, click here.
- Min - the Minimum from Customer Part # Maintenance in Eclipse
- Max - the Maximum from Customer Part # Maintenance in Eclipse
- Suggested Min -
- Suggested Max -
- Suggested Savings -
- Location - the customer warehouse location from Customer Part # Maintenance in Eclipse
- Last Count Date - the date of the last time the item was counted
- Last Ordered Date - the date of the most recent invoice for this product
- Last Delivery Date - the date of the most recent receipt for this product
- Open Order Qty - the quantity currently open on a sales order
- On Hand - quantity on-hand for this customer
- Price Per Each - real-time price per each for this customer from Eclipse
- Availability - for non-consignment, this is the quantity available at their home branch. For consignment, this is the consigned inventory amount as displayed in Eclipse Location Maintenance
- Product Image - if there is an image associated to this product in Eclipse, it will display here
- Ship-To - the Entity ID
Product Detail
Clicking on a row will open the Product Detail page. The Product Detail page displays specific information on the selected product.
The Product Detail Page displays the following information:
- Product image (if exists)
- Product description
- Distributor Sku# - Internal Eclipse product ID
- UPC number
- Catalog number
- Pack quantity
- Qty on Order (for this customer)
- Last Ordered date - Ship Date of the most recent Invoice
- Current price
- Current availability
- Turns
Note: If this is a consignment customer, the availability comes from Product Location Maintenance in Eclipse
The following information can be edited by an employee or customer, if authorized. Changes made here will update Eclipse.
- Sku# - Customer Part #
- Product location
- Min / Max
- On-hand - if the on-hands are changed, StockRoom Web creates an Inventory Adjustment transaction that will be viewable in product history
Suggested Min / Max
As products are used, suggested/min max calculations are performed. The suggested min/max uses a basic calculation method or an advanced method. For more information on those settings, click here.
To accept the suggestion, click on the checkmark below the Min and Max. The Min and Max will be updated to those values. Click Save on the top right to save the settings. Changes made here will update Eclipse.
Label Printing - Single Product
You can print a product label from the Product Detail Page. We currently support Avery Label # 5436. These are 1x3 labels, 5 to a sheet. Click Print in the top right corner.
Select the label settings:
Total Count: The number of labels to print
Label Type: there are two label format options: Part Number and Product.
Part Number - uses the customer part number for the barcode
Product - uses the internal product ID for the barcode
Barcode Type: there are two barcode options: Code128 and QR Code
Code 128: standard barcode
QR Code: standard QR code
Include Logo: toggle on to include your logo on the label. More information about logos is located here.
Label Printing - Multiple
To print multiple labels, check the box next to each product you want to print a label for, and click Print. To select all products on the page, check the box next to Sku#.
Note: If you want to select all products across all pages, don't check any boxes and just click Print.
Exporting the Part List
You can export the Part List in a .csv format. The export can be run immediately and downloaded, or scheduled to send via email.
Adding Products
Within the Part List Page, create a new Customer Part# by using the Add Product button.
In order to access this, a distributor employee must be authorized to edit customer part #'s. For a customer employee, the customer or contact mut be authorized to edit customer part #'s, and the Product Download setting cannot be None. More information about these settings can be found here.
Once you click Add Product, the products you are authorized to search will display with the following information:
Product Image: if available
Distributor Sku#: Eclipse Product ID
Product Description: Eclipse Product Description
UPC: Primary UPC
Cat#: Catalog #
You can sort a column by clicking the up or down arrows next to a column heading.
You can also search for a product in the search box by using the Eclipse Product ID, description or keywords. When using Eclipse Product ID, you must include a period in front of the ID.
Once you find the product, click on the product row to launch the Product Detail Page.
Enter in the following information as needed:
1. Sku# - Customer Part #
2. Location
3. Min
4. Max
5. Onhand - only enter in an on-hand quantity for a non-consignment customer.
6. Click Create to save the product. This updates the Eclipse Customer Part Number screen in Eclipse.
Delete a Customer Part Number
If authorized, you can delete a customer part number from the Product Detail screen. You will see a pop-up to confirm you want to delete this part number. Click Yes to continue. This will also remove the item in Eclipse from the Customer Part Number screen.
Note: This will remove the customer on-hands for a non-consignment customer. For a consignment customer, you must return the material with a return consignment transfer in Eclipse.
You will see a Success message after the item has been successfully deleted.
Comments
Please sign in to leave a comment.