Stock & Profits Price Manager

Features:

• CSV Import of Stock Data
  Easily import stock entries via CSV. Each row represents a stock addition with product SKU, quantity, purchase price, and more.
• CSV Export of Stock Records
  Export stock data into clean CSV files for reporting, auditing, or third-party processing.
• Profit Report Calculation
  Automatically calculates profit based on the difference between purchase and selling prices for each product.
• Add Stock via Product Page
  Add new stock entries directly from the Magento admin product edit page with quantity and cost input.
• View Stock History per Product
  Detailed listing of all stock entries per product, including purchase prices, timestamps, and quantities.
• Automatic Quantity Updates
  Real-time quantity recalculation based on all stock entries — no manual updates required.
• Dynamic Price Calculation
  Automatically updates the product's selling price using a configurable markup formula: $sellPrice = $cost + ($cost * (markup / 100))
  Example: 28.75 = 25 + (25 * 15%)

Benefits:

• Improved Inventory Accuracy: Ensure stock levels reflect actual availability through automatic updates from stock records.
• Better Profit Tracking: Get detailed insights into product-level profitability using real purchase and sales price data.
• Streamlined Stock Management: Add stock directly from the product page and manage records efficiently using CSV import/export.
• Dynamic Pricing Strategy: Automatically calculate selling prices with configurable markup, reducing manual pricing effort.
• Simplified Auditing: Exportable records and detailed history logs support easier internal audits and business analysis.
• Designed for Resellers: Tailored specifically for businesses that resell supplier goods and manage a single warehouse/store view.

Use Case:

Let’s say you're a small electronics reseller with 800 SKUs. You receive regular shipments from different suppliers with varying prices. With this module:

• You can import a CSV containing SKU, quantity, and purchase price for every new delivery.
• As sales happen, the module calculates profit based on the actual purchase cost.
• You can easily export stock and profit reports for accounting purposes.
• Selling prices can automatically adjust based on a preset markup percentage.

This is ideal for any merchant running a single Magento store view that wants better visibility and control over their stock and profit margins.

How Does It Work:

1. Stock Entry via Product or Import: Admins can add new stock entries from the Magento product edit form or by uploading a CSV file.
2. Real-Time Quantity Calculation: Total stock quantity is updated based on the sum of stock entries -- no need for manual quantity adjustments.
3. Dynamic Pricing Engine: Magento automatically updates the product’s final price using a formula that includes the purchase price and your defined markup.
4. Profit Analysis: Each sale tracks the difference between the purchase and selling price, storing this as profit per item, per order, and in sales summaries.
5. Admin Reports & Exports: Easily view and export current stock, historical data, and profit reports from the admin panel.

Account & Pricing

No account is required to use this extension. All features are available upon installation, and no additional service or subscription fees apply.