Inventory
How Do I Add a New Product?
Step-by-step guide for adding a new product to Pharmacy Inventory in SiCompounding.
Overview
Pharmacy Inventory refers to the stock of medications, supplies, and other pharmaceutical products that a pharmacy maintains for sale or internal use. Inventory includes both salable and non-salable items such as expired or recalled products.
Effective inventory management is critical to:
- Ensure uninterrupted medication availability
- Optimize pharmacy operations
- Maintain regulatory compliance
- Control costs and reduce waste
This guide explains how to add a new product to inventory using SiCompounding.
Step-by-Step Instructions
1. Open SiCompounding
- Click the FileMaker Pro icon to open FileMaker.
- When FileMaker opens, locate the large menu bar on the left.
- Click SiCompounding (near the top).
2. Access the Pharmacy Dashboard
- From the icons across the middle of the window, click Pharmacy.
- The Pharmacy Dashboard opens.
3. Open Inventory
- In the blue sidebar menu on the left, click Inventory.
- The Inventory Dashboard opens.
Inventory Dashboard Overview
Top Menu Options
- Receive Devices
- Drug Database
- + New Product
- Reports
- Search
- Lookup (Barcode)
< Go Back- Help
- Notifications (Bell)
Inventory Process Buttons (Middle Row)
- Item Search
- New Item
- Lot / Batch Search
- Purchase Orders
- New Order
- Maintenance
- Price Comparison
- Top Usage
- Top Sales
- Manufacturers
- Vendors
Inventory Filter Buttons
Clicking a filter displays matching inventory records:
- New Products
- Pending Verifications
- Cost Changed
- COA / AF Missing
- Low Stock
- In Quarantine
- Expiring Soon
- Expired In Stock
- Pending Receiving
Start Adding a New Product
There are two ways to begin:
- New Item button (middle row)
- + New Product button (top menu)
Recommended Method
Click + New Product.
Select Product Category
The New Product window opens. Select the appropriate category.
Common Categories
- Bulk / Raw Materials | Chemical APIs (most common)
- Human Prescription Drug
- Human OTC / Supplements
- Veterinary Prescription Drug
- Veterinary OTC / Supplements
- Clinical Trial Drug
- Compounding Supply
- Prescription Supply
- Pharmacy Supply
⚠️ If a drug can be used for both humans and animals, select Human Prescription Drug.
Product Information
Required fields are marked in red
Core Product Fields
- Product Name
- Strength (required for tablets/capsules used in compounding logs)
- Strength Units
- Manufacturer
- NDC / Identifier
- UPC Box
- UPC Unit
- CAS Number
Drug Classification
- Drug Type (dropdown)
- DEA Schedule (dropdown)
- RX Norm (link to drug)
- Dosage Form (search list)
- Dosage Unit (dropdown)
- Pharmacopeia (dropdown)
Drug Attributes
- Is Opioid? Yes | No
- Inventory by Item? Yes | No
- Route of Administration
- Therapeutic Class
Purchase Package Information
- Purchase Unit (dropdown)
- Quantity in Purchase Unit
- Package Description (note style)
Unit Information
Required
- Package Type
- Quantity In
Optional
- Dosage Unit
- Unit Description
- Shape
- Color
- Imprint
Cost Information
- Cost per Unit
- For Resale Yes | No
- Sales Taxable Yes | No
- Prescriber Portal Yes | No
- Institution Portal Yes | No
- Send Payment Link Yes | No
If Applicable
- Is for Rent Yes | No
- Sales Force Product Yes | No
- Fill on ScriptPro Yes | No
Sales Price Information
- Margin %
- Sold by Package Yes | No
Pricing Levels
- Purchase Unit: Sales Price & AWP
- Package: Sales Price & AWP
- Dosage Unit: Sales Price & AWP
Fees
- Dispense Fee
- Hazardous Fee
Drug Demographics
- Is Sterile Yes | No
- Multidose Yes | No
- Hazardous Yes | No
- Has Flavor Option Yes | No
- Medical Justification Required Yes | No
- Is Patient Specific Yes | No
- Create Compounding Yes | No
- Is Central Fill Yes | No
- Central Pharmacy (Institution dropdown)
Product Categories
Select all that apply:
- API (Active Pharmaceutical Ingredient)
- Base
- Diluent
- Excipient
- IV Admixture
- TPN
- Vitamin Mixture
Safety & Notification Options
- Easy-Open Caps
- Safety Caps
- Do Not Send Refill Notifications
Powder & Conversion Data
(Appears when API, Diluent, or Excipient is selected)
- Powder Density
- Powder Displacement
- Capsule Weight
- Salt Conversion
Inventory Management
- Default Storage Area
- Storage Temperature
- Storage Humidity
- Rack Position
- Count Inventory by:
- Dosage Unit
- Unit Package
Lot Control
- Batch Lot Number Control Enabled | Disabled
- Lot Number Prefix
- Next Serial Number
Quality Assurance
- Require Certificate of Analysis Yes | No
- Require Activity Factor Yes | No
- Override Prescription Pre-Verification Yes | No
- Age Restriction Yes | No
Labels
- Name as Ingredient
- Name for 1x1 Label
- Ingredients for Small Label
- Equivalent Brand Name
- Name for Prescription
- Additional SIG Labeling
Auxiliary Labels
Click Edit to select labels.
Capsule Packaging Statistics
- This product is used in Capsules
- Use Stats in all Batches
Click + Capsule to define:
- Capsule Size
- Pack Stat
Suppository Statistics
- This product is used in Suppositories
- Use Stats in all Batches
Click + Mold to define mold size.
Troche Statistics
- This product is used in Troches
- Use Stats in all Batches
Click + Mold to define mold size.
TPN Information
- This product is used in TPNs
- TPN Product Type
- Strength
- Units per ml
Nutrient Data
- Acetate
- Calcium
- Chloride
- Magnesium
- Nitrogen
- Potassium
- Phosphate
- Protein
- Sodium
- Carbohydrates
- Fat
- Total Calories
Finalize
Choose one:
- Save and Complete Later
- Submit for Drug Verification
Completion
This completes the step-by-step guide for Adding a New Product to Pharmacy Inventory.