Inventory Allpack

Inventory Allpack is a complete view of all products (SKUs) in your warehouse. It allows you to view, search, edit, and export detailed inventory information for all products in one place, including available, on hold, damaged, and shipped quantities.

Why use Inventory Allpack?

Complete Inventory View

See all your products in a single view with complete inventory information, quantities, and statuses.

Advanced Search

Search products by SKU, UPC, ProductID, account, description, or Distribution Center using advanced filters.

Centralized Management

Edit product information directly from the list, including dimensions, weight, costs, and more.

Data Export

Export complete or filtered product list to Excel or CSV for external analysis or reports.

Quantity Information

See available quantities (QtyGood), on hold (QtyHold), damaged (QtyHurt), and shipped (QtyShipped) for each product.

Distribution Center Filtering

Filter products by Distribution Center to see inventory specific to each location.

Access Inventory Allpack

You can access Inventory Allpack from:

1. Admin Menu: Navigate to Inventory > All SKUs
2. Directly: Access /Inventory_Allpacklist.php

Permissions

This view requires administrator permissions or specific Inventory permissions. If you don’t see the option in the menu, verify your permissions with the system administrator.

Information shown

The Inventory Allpack view shows complete information for each product:

Basic product information

• ProductID: Unique product ID
• Sku: Product SKU code
• ProductIDWH: Product ID in the warehouse
• Description: Product description (may include additional information like [OTP] for One-Time-Product products)
• BinNumber: Bin number associated with the product
• Upc: Product UPC code
• DistributionCenter: Distribution center where the product is located

Inventory information

• UnitsInStock: Total units in stock
• QtyGood: Available quantity (good)
• QtyHold: Quantity on hold (reserved for orders)
• QtyHurt: Damaged quantity
• QtyShipped: Shipped quantity (calculated from orders with status 9)

Physical information

• Weight: Product weight
• Length: Product length
• Height: Product height
• Width: Product width
• case_qty: Quantity per case

Financial information

• Cost: Product cost
• Retail: Retail sale price
• QuantityPerUnit: Quantity per unit

Additional information

• CategoryID: Product category
• package_type: Package type
• ReorderLevel: Reorder level
• Discontinued: If the product is discontinued (N = No, Y = Yes)
• DateCreation: Creation date
• DateLastUpdate: Last update date
• ClientOpt1, ClientOpt2, ClientOpt3: Optional custom client fields
• manufacturer: Manufacturer
• category: Category
• model_num: Model number
• tags: Tags
• serial_num: Serial number
• Harmonization: Harmonization code

Search products

You can search products using different methods:

Basic search

1. Access search

   At the top of the table, you’ll find basic search fields.

2. Enter search criteria

   You can search by:

   • SKU: Product SKU code
   • UPC: UPC code
   • ProductID: Product ID
   • Description: Product description or text

3. Apply additional filters (optional)

   You can filter by:

   • Account ID: Specific account
   • Distribution Center: Specific distribution center

4. Execute search

   Click Search or press Enter to apply filters.

Advanced search

Advanced search allows you to combine multiple criteria:

1. Access advanced search

   Click the Advanced Search button or link on the page.

2. Configure criteria

   Select fields, operators, and values for each search criterion.

3. Combine criteria

   Use logical operators (AND, OR) to combine multiple criteria.

4. Execute search

   Click Search to apply advanced filters.

Edit a product

You can edit product information directly from Inventory Allpack:

1. Search for the product

   Use search filters to find the product you want to edit.

2. Click edit

   Click the edit button (pencil icon) in the product row.

3. Modify fields

   Update any field you need to change. Editable fields include:

   • Dimensions (Length, Width, Height)
   • Weight
   • Cost and Retail (Cost and price)
   • Description
   • And other fields according to your permissions

4. Validate data

   Make sure that:

   • Weight, Length, Height, and Width are greater than 0
   • Numeric values are valid

5. Save changes

   Click Update or Save to save changes. After saving, you’ll be redirected to the list with the product filtered.

Dimension Validation

Dimensions (Weight, Length, Height, Width) must be greater than 0. The system will validate these values before allowing you to save changes.

Export data

You can export the product list to Excel or CSV:

1. Apply filters (optional)

   If you want to export only certain products, apply search filters first.

2. Select export type

   Click the export button and select:

   • Excel (Complete): Exports all products from the main Distribution Center
   • Excel (Partial): Exports only products that match applied filters

3. Download the file

   The file will download automatically with the name “inventory” and corresponding extension (.xls or .csv).

4. Open the file

   Open the downloaded file in Excel or your preferred spreadsheet application.

Exported fields

The exported file includes:

• Product ID
• SKU
• Description
• UPC
• Weight
• In Warehouse (UnitsInStock)
• Available (QtyGood)
• Hold (QtyHold)
• Hurt (QtyHurt)
• Distribution Center Name
• Company Name (Account)

Filter by Distribution Center

You can filter products by Distribution Center:

1. Access filters

   In advanced or basic search, look for the Distribution Center field.

2. Select Distribution Center

   Select the specific Distribution Center you want to see, or leave blank to see all.

3. Apply filter

   Click Search to apply the filter.

Distribution Center

Products can be associated with Distribution Center = 1 (main) or other Distribution Centers. You can filter to see only products from a specific center or exclude the main one.

View detailed information

To see complete information for a product:

1. Search for the product

   Use filters to find the product you want to see.

2. Click view

   Click the view button (eye icon) or on the product SKU.

3. Review information

   A detailed view will be shown with all product information, including:

   • Basic information
   • Inventory quantities
   • Dimensions and weight
   • Financial information
   • Creation and update dates
   • Custom fields

Best practices

Use filters to find products

Take advantage of basic and advanced search to find products quickly instead of scrolling through the entire list.

Export regularly

Export inventory list regularly to maintain backups and external analysis of your data.

Verify quantities

Regularly review quantities (QtyGood, QtyHold, QtyHurt) to ensure inventory is accurate.

Keep dimensions updated

Make sure dimensions (Length, Width, Height) and Weight are correct for accurate shipping and Packaging calculations.

Review discontinued products

Filter by discontinued products (Discontinued = Y) periodically to keep your catalog updated.

Use custom fields

Take advantage of ClientOpt1, ClientOpt2, ClientOpt3 fields for additional business-specific information.

Validate before editing

Verify that values you enter are correct before saving, especially dimensions and quantities.

Filter by Distribution Center

When working with multiple Distribution Centers, use filters to see only relevant products.

Troubleshooting

I can’t see all products

Problem: The list doesn’t show all expected products.

Solution:

• Verify you don’t have filters applied. Click Reset to clear all filters
• Check that Distribution Center filter isn’t restricting results
• Verify products aren’t marked as Discontinued if you’re filtering for active products
• Confirm you have permissions to view products from all accounts

Export doesn’t work

Problem: Export file doesn’t download or is empty.

Solution:

• Verify there are products matching applied filters
• Make sure your browser allows downloads
• Try exporting without filters first to verify functionality works
• Review server write permissions if problem persists

I can’t edit a product

Problem: Edit button doesn’t appear or I can’t save changes.

Solution:

• Verify you have edit permissions for Inventory Allpack
• Make sure the product isn’t locked by another user
• Check that all required fields are complete
• Verify dimensions and weight are greater than 0
• Confirm numeric values are valid (no special characters)

Quantities don’t match

Problem: Shown quantities (QtyGood, QtyHold, etc.) don’t match expected.

Solution:

• QtyShipped is calculated from orders with status 9. Verify orders are in correct status
• Check there are no orders in process affecting QtyHold
• Verify inventory corrections have been processed correctly
• Consider running an inventory count if discrepancies are large

Search doesn’t find products

Problem: Search doesn’t return expected results.

Solution:

• Verify you’re using the correct criterion (SKU vs UPC vs ProductID)
• Make sure there are no extra spaces in the search term
• Try partial search using LIKE operator (add % at beginning or end)
• Check that additional filters (Account, Distribution Center) aren’t restricting too much
• Try searching without filters first to verify the product exists

Custom fields don’t appear

Problem: ClientOpt1, ClientOpt2, ClientOpt3 fields don’t show or are empty.

Solution:

• These fields are optional and may be empty if not configured
• Verify fields are enabled in your account configuration
• Check that products have values in these fields in the database
• Consider using the edit view to add values to these fields if necessary

Related

• Catalog Management - Product catalog management
• Warehouse Overview - Warehouse overview
• Bin Management - Bin management where products are stored
• Corrections (Recounts) - Inventory corrections that affect quantities
• Editing Bins - Editing bins associated with products