Last modified by instigata on Tue, November 11, 2008 19:27
Source|Old Revisions  |  Back To Group

This is an old revision of the document!

Feel free to edit, add or remove any features to the list below.

Features would include

  • Supplier Managment
    • Add, Edit and Remove Suppliers
      • Contact info, supplier name, rep info, account number, lead times etc. . .
      • [Multiple Representatives]
      • [Custom field creation similar to product attributes]
    • Associate Suppliers with individual products
      • [Associate multiple suppliers with single products]
        • Allow each supplier to have it’s own product’s cost/price tier; Each product price and cost must be associated with a particular supplier. The Magento “cost” attribute should automatically reflect the primary cost/price (trigger via DB?).
        • Allow each supplier to have it’s own SKU code (to tie in to purchase orders) and also to assist with updating of pricelists. So supplier 1 has A code range of range of 1 - 10,000 ... supplier 2 has 10,001 - 20,000, etc.
  • [Inventory Management]
    • Set low levels per product for re-order or allow system to predict when stock should be re-order based on predicted sales/supplier lead time.
    • Alert when low levels are reached and allow products to be added to purchase order creation
      • Can be like Magento’s upgrade notification in admin section
      • Can be an email or text message
      • Can be RSS feed
      • Can be a Dashboard warning/alert/notification
      • Or all the above
    • Re-Order amounts based on previous sales periods (large/strange orders in previous period should be highlighted/ignored), user defined, current sales status or with feedback from 3rd party such as http://www.lokad.com/ (although I have not used this service myself...yet). Supplier lead times need to be considered.
    • Inventory adjustment reasons
    • Automatically start purchase order based on backorders
    • When an order is created on the site, have an e-mail automatically sent to the suppliers of the various products to check stock. Also have the products added to a checklist separated into each separate supplier ... and if the supplier replies that there is stock, check it off on the check list, so that at the end of the day, you can push a button, and it send the purchase orders to the various suppliers. (Useful for shops that don’t carry stock and order as they receive orders).
  • Purchase Order Tracking
    • Create supplier purchase order based on inventory levels and/or add new products manually to purchase order
      • Configurable PO numbering like sequential, manual, datetime, account number, sequential + rand(1,3) etc.
      • Dropdown Menu to allow the user to specify the type of delivery service they require from the supplier (normal, express, overnight, part-delivery, etc)
      • Custom Notes
      • Track purchase orders
        • Creation
        • Confirm PO received by supplier (1pixel img bug or otherwise)
        • Paid and awaiting goods (on a per item basis)
        • Received and awaiting payment (on a per item basis)
        • Received and Paid (on a per item basis)
      • Track item return/credit..due to being damaged on arrival etc
        • Returned and awaiting credit (on a per item basis)
        • Returned and credited (on a per item basis)
      • Cancel Purchase Order
    • [Submit purchase orders to supplier]
      • Printable sheet that can be faxed, mailed . . .
      • Electronic
        • Email
          • excel sheet
          • html layout
          • attached file (PDF or other)
        • Downloadable file
          • csv
          • xml
        • Api
          • Direct supplier tie in
          • Credit card processing
          • Bank Draft
          • Shipwire integration
        • Automatic e-mail based on templates
  • Product Management
    • Automatically import excel and pdf pricelists that are formatted differently by different suppliers (It must support more than 1 tab in a pricelist, and you do not have to change the format to suit Magento).
      • It must automatically add new products and estimate the Manufacturer name, and possibly category.
      • It must reference old pricelists so that you can check old prices.
      • It must update prices of products already in the system and must compare prices from different suppliers selling the same item,
        • as well as give a viewable tabulated comparison
        • and possibly some gaphs of price/profit relationships of the different suppliers with the same item compared to the current selling price.
      • It must decide on an optimal selling price according to set mark ups and different supplier pricing.
      • It must keep items disabled on the front end until you have confirmed them to be shown in the front end (This will be there so that you can first detect errors).
      • If it cannot link prices of same products from different manufacturers, perhaps due to different stock codes but similar descriptions or visa versa, it must give the option to manually link prices from different suppliers together.
    • Ability to view the RAW pricelist data and full original supplier pricelists via the website so it can accessed them anywhere. So basically, it needs to bring each newly uploaded pricelist into the database or something.
    • There must also be an option where I can tell the system that one of the pricelists I’m importing has a Lead Time and this must be shown on the site for the products originating from that pricelist.
    • If I import a pricelist and it updates items already there, it must not update descriptions that have been edited, but if the description is different to the one that was originally on there (This is where keeping older reference pricelists comes in handy), then it must alert me, as there might’ve been a change to the product. (Remember, it must compare the actual descriptions in the pricelists, not the description used on the website as this will be more in depth)
    • The system should also allow you to include regular expressions that will let you set up the import system to check for certain attributes so that the comparison system works efficiently.
    • It should also show me percent increases or decreases from previous pricing.

(This feature is a huge part of online e-commerce inventory management, and will assist in running a successful store).

Order/Supplier Management a. I get in touch with suppliers, and list a product hooked to that (or more than one supplier). b. Customer places an order (no payment yet) and the admin section shows I have received orders (by supplier). I click and an automated e-mail goes out to supplier. c. Supplier confirms availability and quantity. (by clicking on the e-mail) d. I receive confirmation of availability, and send payment request (with bank and paypal details) to customer. e. Once payment is received, I send out order to supplier with customer and product details. f. The supplier confirms shipment with tracking and final invoice details. (the tracking information goes to customer). g. Ideally an e-mail to customer after 3 weeks confirming receipt and request for referrals.

  • [Additional Features]
    • Reporting Integration
    • Approve orders and forward purchase orders through a cell phone.


Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs