Inventory Program?

Discussion in 'Mac Basics and Help' started by Trilsk, Apr 19, 2006.

  1. Trilsk macrumors newbie

    Joined:
    Apr 16, 2006
    #1
    Hiya,
    So I'm getting my MacBook Pro in May, and my parents recently took me into their Wine Distribution business here in Central Oregon. My job will be invoicing orders, computer technical support, and managing all incoming / outgoing stock. Now, I'm wondering if there is a program(s) that can do the following...

    • Allow some sort of an item number based system. Showing current on hand and possibly more details. Such as past history regarding sales, and average unites sold per month
    • Allow me to view our cost, retail, case cost, case quanity, and case discounts for frequent buyers.
    • Would allow me to punch in a certain type of wine, and view similar year wines, grapes, vineyards etc. so that I could pull up similar product that I determine through my own needs.
    • Would show all incoming shipments (when I punch them in of course), and see when wines arrived, and left on our trucks.

    I realize this is going to be a fairly serious inventory program, but I don't want any sort of stock miscounts when I'm dealing with cases of $10 to $100 bottles of wine. Any recommendations are greatly appreciated.

    Thanks.
     
  2. SmurfBoxMasta macrumors 65816

    SmurfBoxMasta

    Joined:
    Nov 24, 2005
    Location:
    I'm only really here at night.
    #2
    What you need is a Retail POS (Point of Sale) program w/ inventory, sales, purchasing, and database modules. THere are alot of them out there, it just depends on the level of complexity & scalability you want/need. There are several Mac-only apps, but many many more for Windblows. The best ones are based on either SQL or Filemaker. Or you could custom build your own with FileMakerPro, but that takes some serious, heavy duty work and a very steep learning curve !

    Google = friend yours :)
     
  3. discoforce macrumors 6502a

    discoforce

    Joined:
    Jan 27, 2004
    Location:
    Vermont, USA
    #3
    Yeah that kind of cross-referencing would require database software. I really like FileMaker, but it does take some learning to get something customized (though it comes with a few templates that would probably work for you).
     
  4. webcookie macrumors member

    Joined:
    Feb 23, 2006
    Location:
    Brava Centauri
    #4
    Google for POS systems. I know there are a few out there for Mac. I looked them up when I was trying to persuade my dad to change our store to all Mac and get rid of those horrid old Versyss systems.
     
  5. ahunter3 macrumors 6502

    Joined:
    Oct 15, 2003
    #5
  6. robcostin macrumors newbie

    Joined:
    May 6, 2006
    Location:
    San Francisco
    #6
    try BrighterShop

    Our database product might meet your needs. It's called BrighterShop; it's a FileMaker database that handles POS, ordering, inventory tracking, and customer contacts. It's built with small independent businesses in mind. Very mac-friendly.

    http://www.brighterdata.com

    Feel free to contact me if you have questions.

    rob@brighterdata.com
     

Share This Page