Mastering PrestaShop Inventory: How to Track Manual Stock Adjustments and Cash Sales

At Migrate My Shop, we understand that the backbone of any thriving e-commerce business, especially one powered by PrestaShop, is impeccable inventory management. While the platform offers robust tools for tracking sales and stock, real-world scenarios – like cash sales, in-person pickups, or unexpected adjustments – can sometimes lead to manual workarounds that inadvertently create discrepancies. A recent query on the PrestaShop forum perfectly illustrated this common merchant dilemma, offering invaluable insights into how the community tackles these challenges.

The Real-World Inventory Challenge: Untracked Cash Sales and Manual Adjustments

The forum thread, initiated by a merchant under the alias "MightyMouseofGod," painted a familiar picture for many small business owners. The user confessed to manually decreasing stock levels for cash sales without formally creating orders within PrestaShop. This practice, while seemingly quick at the moment, led to a significant problem: a lack of records for specific products sold and an inability to reconcile cash received with actual inventory movements. The merchant also highlighted a frustration with PrestaShop's manual order creation process, where selecting "Collect in person - 0" still incurred a shipping cost, further complicating efforts to properly log these offline transactions.

This scenario underscores a critical pain point: how to maintain accurate inventory and sales records when transactions occur outside the standard online checkout flow. The merchant's initial thought was to query the database directly to find manually adjusted stock, indicating a common assumption that such granular data might only be accessible through technical means. While direct database interaction is possible for advanced users, PrestaShop often provides more accessible solutions within its Back Office.

Maintaining accurate inventory isn't just about knowing what you have; it's crucial for preventing overselling, optimizing reordering, and ensuring your financial records align with your physical stock. For businesses considering a future migration, clean and accurate data is paramount, making this a foundational aspect of e-commerce health.

Leveraging PrestaShop's Built-in Power: Solutions Beyond Database Queries

The PrestaShop community, specifically user "ecommerce16," quickly stepped in with practical, accessible solutions that didn't require complex database queries. This demonstrated the power of leveraging PrestaShop's built-in features and adopting sound operational practices.

1. Streamlining Manual Order Creation for Cash Sales

The core issue of untracked cash sales can be resolved by consistently creating manual orders within PrestaShop. Here's how to address the shipping cost dilemma:

• Custom Carrier for In-Person Pickup: Create a dedicated carrier (e.g., "Pick up in Store," "Local Collection") and set its shipping cost to €0. When creating a manual order, simply select this carrier. This is a clean, permanent solution.
  • Navigate to Shipping > Carriers.
  • Click "Add new carrier."
  • Define the carrier name, transit time, and set shipping costs to 0 for all zones/ranges.
  • Ensure it's active and available for your customers (or specifically for manual orders).
• Cart Rules for Free Shipping: For more flexibility or if the custom carrier isn't ideal, create a cart rule that grants free shipping. Crucially, make this rule private by not publishing its code, using it only for your manual orders.
  • Go to Catalog > Discounts > Cart Rules.
  • Click "Add new cart rule."
  • Set conditions (e.g., a specific customer group for manual orders, or a unique code).
  • Under "Actions," select "Free shipping."
  • Ensure the code is not publicly visible if you only intend it for internal use.
• "Cash Sale Customer" Account: To avoid needing individual customer details for every cash sale, create a generic customer account (e.g., "Cash Sale Customer," "Walk-in Client"). All anonymous cash sales can then be recorded under this single account, providing a consolidated record of these transactions.
  • Go to Customers > Customers.
  • Click "Add new customer."
  • Fill in generic details (e.g., "Cash Sale," "Customer").
  • Use this account when creating manual orders for cash transactions.

2. The Direct Answer: Locating Manual Stock Adjustments

To address the original question about finding manually decreased stock levels, PrestaShop offers a dedicated section in the Back Office:

• Navigate to Catalog > Stock > Movements.

This powerful section provides a comprehensive log of all stock movements, including:

• Date and Time: When the movement occurred.
• Product and Product Attribute: Which specific item was affected.
• Quantity: How much stock was added or removed.
• Employee: Who performed the action (if logged in).
• Movement Type: Crucially, this indicates if it was a manual adjustment, an order, a return, etc. You can filter by "Manual adjustment" to pinpoint the exact changes you're looking for.
• Reason: If a reason was provided during the manual adjustment.

By filtering this view, you can easily identify all instances where stock was manually decreased, along with the date and quantity. This eliminates the need for complex database queries and provides a clear audit trail.

Reconciling Past Discrepancies and Moving Forward

For past sales where exact product details are lost, as in MightyMouseofGod's case, a perfect reconciliation might be challenging. However, by using the "Stock Movements" log and comparing it with your cash receipts and current inventory, you can make a reasonable correction. The key is to establish a robust process moving forward.

Best Practices for Impeccable Inventory Management:

• Log Every Transaction: Whether online or offline, ensure every sale, return, or adjustment is recorded in PrestaShop. Consistency is key.
• Regular Stock Audits: Periodically compare your physical stock with your PrestaShop inventory levels. This helps catch discrepancies early.
• Utilize PrestaShop's Features: Explore modules for Point of Sale (POS) if you frequently handle in-person sales, which can integrate directly with your PrestaShop inventory.
• Train Your Team: Ensure anyone handling stock or sales understands the correct procedures for recording transactions in PrestaShop.

The Migrate My Shop Perspective: Why Data Accuracy Matters

As e-commerce migration experts, we cannot stress enough the importance of accurate, well-maintained data. When it comes time to upgrade your PrestaShop store or migrate to a newer version or even a different platform, clean inventory and order data significantly reduces the complexity, cost, and risk of the migration process. Discrepancies in stock can lead to lost sales, customer dissatisfaction, and major headaches during data transfer.

By adopting these straightforward PrestaShop Back Office practices, you not only solve immediate inventory challenges but also build a foundation for a more efficient, profitable, and future-proof e-commerce operation. Don't let manual workarounds undermine your data integrity; leverage PrestaShop's power to keep your inventory in perfect sync.