Products & Items Management in Cash Flow Inventory: Documentation

Cash Flow Inventory’s Products & Items Management module is engineered to provide an industry-leading catalog and stock administration experience. It seamlessly balances enterprise-grade capabilities—such as batch/serial control, multi-unit support, and AI-powered imports—with intuitive workflows.

This module empowers businesses, whether retail, wholesale, manufacturing, e-commerce, or hybrid, to efficiently manage thousands of SKUs.

Key Benefits

1. Scalable: Supports up to 500,000 items and 100 locations, accommodating businesses of all sizes.
2. Configurable: Feature toggles allow customization to match SKU complexity, ensuring flexibility.
3. Integrated: Native connectors link to major sales channels, ERPs, and shipping partners for seamless operations.
4. Actionable: Real-time insights through dedicated tabs (To Order, Stockouts, Deadstocks) enable proactive inventory management.

1. Product Page Layout

The Products section, accessible via the main navigation under Inventory, serves as the central hub for product and inventory management. It features eight distinct tabs, each designed for a specific purpose:

Tab	Purpose
Categories	Define and organize hierarchical product categories
Items	Manage core product records
Variants	Edit and bulk-manage variant SKUs
To Order	Actionable reorder list based on safety stock and ROP
Stockouts	Identify variants with zero stock across all locations
Deadstocks	Monitor aging variants with no sales in a configurable period
Import	Bulk upload data via a wizard with AI auto-mapping
Export	Extract data with auto-split and archive features

Common Features Across Tabs

1. Search & Filters: Multi-criteria search with saved views for quick data retrieval.
2. Action Bar: Includes shortcuts like “Add new,” bulk actions, and export options.

Insights

1. Navigation: The left sidebar highlights Inventory > Products, with sub-options like Adjustments, Transactions, and Transfer visible.
2. Tabs: All eight tabs are displayed horizontally be
3. low the “PRODUCTS” title, with “Items” and “Categories” active in different screenshots .
4. Header: Features the “CF” logo, account name (“Demo Name”), and action buttons like “+ New”.

---

2. Global Settings & Configuration

Accessible via Settings →Business, this section allows users to activate or customize features to tailor the module to their business needs:

Setting	Description	Default
Enable Variants	Activates multi-attribute variant matrix	OFF
Enable Multiple Units	Supports secondary units and automatic conversions	OFF
Enable Measurements	Adds fields for weight, dimensions (L×W×H), and volume	OFF
Enable Batch Tracking	Enables batch/lot selection on stock receipt and opening balance	OFF
Enable Serial Tracking	Requires unique serial input for each unit	OFF
Enable Stock Intelligence	Displays ROP and Safety Stock per location	OFF
Enable Tiered Pricing	Activates Tier 1 & Tier 2 wholesale pricing panels	OFF
Enable Tax Classes	Adds purchase and sales tax class dropdowns	ON
Business Type	Physical, E-Commerce, or Hybrid (controls media field visibility)	Hybrid

Insights

1. Variants: The “Variants” column in the Items tab and Variants count in Categories indicate this feature is enabled.
2. Stock Intelligence: “Reorder Qty” in the Items tab suggests this is active.
3. Tiered Pricing: “Wholesale Min Qty” and “Wholesale Price” columns imply this is enabled.
4. Multiple Units: Only “Each” is shown in the Units column, suggesting this is disabled.

---

3. Tab Details & Actions

Each tab provides specialized tools for inventory management, with detailed functionalities as follows:

1. Categories

1. Purpose: Manage hierarchical catalog structures.
2. Columns: Serial Number (SN), Category, Image, Variants, Stock, Purchase Value, Retail Value, Wholesale Value, Wholesale Value2.
3. Actions: Inline edit, delete, activate/inactivate via a dropdown menu (three dots).
4. Bulk Actions: Activate, deactivate, or delete selected categories.
5. Insights:
   • Categories like “Home Decor” (Variants: 4, Stock: 1040) and “Jeans” (Variants: 2, Stock: 420) are listed.
   • Filter options include “Category” and “Type” dropdowns, with an “Add new” button.

2. Items

1. Purpose: Comprehensive view of all product records.
2. Columns: Action, Image, Item Title, SKU, Units, Stock Qty, Reorder Qty, Purchase Price, Stock Value, Sales Price, Wholesale Min Qty, Wholesale Price; or Checkbox, Image, Name, Variants, Stock, Last Updated, Status, Actions.
3. Inline Edit: Edit price, tax, discount, or status directly in the table.
4. Bulk Actions: Activate, deactivate, delete, or export selected items.

3. Variants

1. Purpose: Fine-grained control over product variants.
2. Columns: Parent SKU, Attributes, Variant SKU, Location Stocks, Prices, Status.
3. Inline Edit: Modify price, discount, or tax class.
4. Bulk Actions: Activate, deactivate, delete, or export selected variants.

4. To Order

1. Purpose: Proactive reorder list based on safety stock and ROP.
2. Filters: Customize by location or supplier lead time.
3. Columns: Variant, Location, Current Stock, ROP, Suggested Order Qty.
4. Actions: Create purchase orders for single or multiple items.

5. Stockouts

1. Purpose: Immediate visibility into out-of-stock products.
2. Columns: Variant, Location, Last Restock Date.
3. Actions: Quickly create purchase orders to replenish stock.

6. Deadstocks

1. Purpose: Manage slow-moving or obsolete inventory.
2. Columns: Variant, Location, Last Sale Date, Days Idle.
3. Actions: Archive items or apply discount campaigns.

7. Import

1. Purpose: Streamline data entry with a five-step wizard enhanced by AI.
2. Steps:
   1. Upload and preview data file.
   2. AI auto-maps columns.
   3. Adjust and validate mappings.
   4. Correct errors inline.
   5. Execute bulk import.
3. Supported Formats: XLSX, CSV, TXT, PDF.
4. Insights: An “AI-Powered Import” popup with a “Go to import” button appears across screenshots.

8. Export

1. Purpose: Extract product data for analysis or backup.
2. Features:
   • Export all or filtered datasets.
   • Auto-splits datasets exceeding 5,000 rows, packaged in a ZIP file.

---

4. Add/Edit Item Workflow

Adding or editing items is a two-step process designed for efficiency and detail:

Step 1: Core Details & Media

1. Fields:
   • Item Name & SKU: Text inputs; SKU can be auto-generated.
   • Brand: Dropdown or free-text entry.
   • Category: Multi-select tree picker for hierarchical placement.
   • Supplier: Autocomplete with supplier ID display.
   • Flags: Checkboxes for Raw Material, Backorder, Non-Purchasable.
   • Measurements: Numeric inputs with unit dropdowns (weight, L×W×H, volume).
   • Descriptions: WYSIWYG editors for short/long descriptions (visibility based on Business Type).
   • Tags: Tokenized input with suggestions.
   • Media: Drag-and-drop uploads or URL fetch (E-Commerce only).
   • Attachments: Multiple file uploads with previews.
2. Feature Toggles: Enable Variants, Multiple Units, Batch Tracking, Serial Tracking, Stock Intelligence to expand the form.

Step 2: Pricing, Stock & Variant Details

1. Sections:
   • Variant Matrix: Manage attributes and generate combinations with a filterable preview.
   • Units of Measure: Define secondary units, conversion rates, and price differencing.
   • Purchase Pricing: Set cost price, tax class, and tax percentage.
   • Sales Pricing: Configure base price, up to two tiers of wholesale pricing, discount, and sales tax classes.
   • Per-Variant Overrides: Upload images, set stock per location, assign batch/serial numbers, define ROP and Safety Stock.
   • Remarks: Free-text notes with a character counter.
2. Actions: Save & Continue, Save & Close, Discard Changes.

Insights

1. The “Add new” button in the Items and Categories tabs initiates this workflow.
2. The “Image” column aligns with media uploads, though currently empty.

---

5. In-Context Item Creation

1. Access: Available from Purchase Orders, Sales Orders, or Stock Adjustments.
2. Modal: Combines Steps 1 and 2 into a streamlined form.
3. Lean Mode: Hides non-essential fields for rapid entry.
4. Variants: Add variants individually if enabled.

---

6. Bulk Operations & AI Import

Bulk Import

1. Limits: Up to 5,000 rows per file; larger files auto-split.
2. AI Mapping: Supports XLSX, CSV, TXT, PDF, JSON; learns from repeated imports for accuracy.
3. Error Handling: Inline correction panel and exportable error list.
4. Insights: The “AI-Powered Import” popup promotes this feature, linking to the Import tab.

Bulk Export

1. Features: Export all or selected data, auto-split for large datasets (>5,000 rows), packaged in ZIP files.
2. Automation: Schedule exports via API for regular backups.

---

7. Conditional Logic & Feature Toggles

The module adapts dynamically based on:

1. Global Settings: Toggles show/hide relevant fields (e.g., Batch Tracking OFF hides batch fields).
2. Business Type: Physical hides media fields; Hybrid/E-Commerce shows them.
3. Item-Level Toggles: Enabling features during creation expands the form (e.g., Variants adds matrix).

Examples

1. Measurements OFF: No dimension fields in tables.
2. Batch Tracking OFF: No batch fields visible.
3. Stock Intelligence ON: Reorder Qty column appears.

---

8. Best Practices & Performance Tips

1. Modular Enablement: Activate only necessary features to maintain performance (e.g., Batch Tracking).
2. Template Savings: Save AI import mappings for consistent supplier data (prompted by “AI-Powered Import” popup).
3. Scheduled Exports: Use API for automated data backups.
4. Variant Strategy: Limit to three attributes for optimal matrix performance.
5. Stock Thresholds: Set realistic ROP and Safety Stock to balance inventory.

---

9. Advanced Scenarios

1. Serialized Lot Recall: Trace serial numbers to purchase dates and supplier batches (requires Serial Tracking ON).
2. Multi-Warehouse Transfers: Leverage the WMS module for inter-location stock moves.
3. E-Commerce Sync Rules: Configure sync frequency and field mappings for online stores (Image column suggests e-commerce readiness).

---

10. FAQs & Troubleshooting

1. Q: What happens if a product is imported twice?
   • A: Duplicates are detected by SKU; users can update or skip the record.
2. Q: How can I mass deactivate old SKUs?
   • A: Select items in the Deadstocks tab and use the Archive bulk action.
3. Q: Why aren’t batch fields showing?
   • A: Ensure Batch Tracking is enabled in Settings → Products and item toggles.

---

Conclusion

The Products & Items Management module of Cash Flow Inventory delivers a robust, scalable, and intuitive solution for modern inventory needs. With features like AI-powered imports, detailed stock insights (e.g., Reorder Qty), and a customizable interface (e.g., branded logo), it supports businesses managing up to 500,000 items across 100 locations. This documentation provides a comprehensive guide to its functionalities, workflows, and best practices, ensuring users can optimize their inventory management effectively.