Inventory Management

//Inventory Management
Inventory Management 2018-02-13T22:03:32+00:00

Manage your products and inventory, synchronize stock with web sites, automate purchasing and receiving, and much more. The Order Manager has inventory covered: from managing kits and assemblies to multi-level pricing and quantity discounts.

At the core of the inventory management capabilities of the Stone Edge Order Manager is your product catalog. The program offers tremendous flexibility for maintaining your product catalog, pricing and more. Editing products, importing and exporting products, and keeping your stock levels synchronized across multiple sales channels has never been easier.

Product Data

The Order Manager has a comprehensive table structure for storing and maintaining your product catalog. Most shopping cart systems store product information relevant to showcasing your wares in a sales environment. The Order Manager goes a step further by including product fields relevant to managing orders, shipping & fulfillment, purchasing, and so on.

Typical product data includes:

  • Basic product information (SKU, name, description, etc.)
  • Drop-shipping and fulfillment information
  • Supplier and purchasing data
  • Reorder points and reorder quantities for creating purchase orders
  • Pricing information
  • Warehouse, packing and shipping data
  • Lists of Attributes/Options (e.g. color, size, style, etc.)
  • Alternate barcodes and SKUs
  • Cross-sell items
  • Kits (products that are sold as combinations of other products)
  • Assemblies (items that are built up from or broken down from other items)
  • Image and display information
  • User-definable custom fields
  • Notes

Quantity On Hand Sync

Inventory tracking is a critical task for most retailers and one of the more impressive features of the Order Manager is to sync your stock levels across all of your sales channels automatically.  The Order Manager includes the tools you need to make inventory tracking easy and accurate.

  • Track the Quantity on Hand (QOH) for all or selected items
  • Track QOH at the attribute/option level (each combination of color, size, style, etc.)
  • Automatically update QOH in your on-line stores
  • Use the same inventory for multiple Web stores, phone/mail orders and POS orders

Product Pricing Options

Price Levels

The Order Manager supports up to 10 different price levels.  You can create price levels by simply giving one of the 10 levels a name that will identify that price group (Retail, Web, Wholesale, Member, etc).  Each price level can have a regular price and a sale price.  Existing customers can get a price level assigned to their customer record so that they will automatically be given a specific price on future orders.  Customers can also receive pricing automatically based on cost-plus or percent-off price calculation.

Quantity Pricing

Quantity pricing can be setup for any one of your price levels.  Quantity pricing allows you to discount the price of a product based on the quantity of that product that should be ordered.  For example: a customer buying 1 to 5 widgets would pay the normal price of $9.95 a piece.  If they purchased between 6 to10 widgets the price would decrease to $8.95 a piece.

Editing & Maintaining Your Product Catalog

There are several ways to edit products:

  • Individually at the View Inventory screen
  • In a spreadsheet-like layout
    • Display all or selected products
    • Select the fields that you want to view and edit
    • Enter your changes into the spreadsheet
  • With the Global Editor
    • Select the field that you want to change
    • Enter the new value to put into the field
    • Select the products that you want to change
    • Change all of the selected records with one button click
  • Bulk-edit prices for all or selected products
    • Increase or decrease prices by a percentage or fixed amount
    • Markup prices by a percentage or fixed amount from their cost
    • Set a price level to a different level plus or minus a percentage or fixed amount
  • Import changes from a comma- or tab-delimited text file
  • Import changes from a Microsoft Access database
  • Import changes directly from your shopping carts*

Purchasing & Receiving

Automatically create and send purchase orders to vendors based on reorder points and reorder quantities, target quantities or historical sales data.

The Order Manager includes a feature-rich purchase order system that handles both restocking and drop ship POs. The purchase order system is designed for use in the real-world, where changes can occur throughout the purchasing process; what you order may change, what you receive may not be what you originally ordered, and a shipment that you receive may include items from multiple purchase orders. The purchase order system distinguishes between expected and actual records to handle the discrepancies in purchasing and receiving that most merchants come across.

Creating Purchase Orders

  • Each product can have one or more suppliers, one of which is designated as the primary supplier for that product.
  • In addition to your SKUs (unique part numbers), each supplier can have their own SKUs, costs and purchasing rules for each product.
  • Set reorder points and reorder quantities on a product-by-product basis.
  • Generate purchase orders automatically based on reorder points and reorder quantities, or order enough for a given number of days based on sales during a specified period.
  • Automatically send purchase orders by email or fax.

Receiving Inventory

  • Receive inventory against multiple purchase orders from the same vendor.
  • Scan barcoded items into stock with a barcode scanner.
  • Print barcode labels for newly received items.
  • Enter invoices from your vendors and reconcile them against your POs.
  • Export vendor invoices to QuickBooks for payment.

Supplier Management

You can enter as many Suppliers as you need.

  • Enter each supplier’s company and Web site information, your account #, etc.
  • Enter each supplier’s options for stocking and drop ship purchase orders
    • Purchase orders can be emailed, printed or faxed
    • Emailed drop ship POs can include a .pdf file of your packing slip
  • Click a button to send an email to a supplier or add a note to their records
  • Each product can have one or more suppliers
    • One supplier will be designated the “primary” supplier for that item
    • Enter each supplier’s SKU, barcode, cost, purchasing rules, etc.
  • Suppliers can also be imported from text files