McPond eCommerce Software

 // home / products / pumpernickel / foodstuffs  ::products::  ::services::  ::contact::  ::links:: 

Links
Foodstuffs EAN|net NZ UBL ebXML xCBL JAXB Java a NZ perspective
Screen Shots
Main page PO Downloaded PO XML

Questions or Comments? Advice for me or from me? Please email me - David McNeill


B2B eCommerce Exchange - Foodstuffs

PumperNickel implements a full connector from Prophet to Foodstuffs b2b Exchange.  This allows retrieval of purchase orders, and sending of acknowledgements, advanced shipping notices and invoices.  The benefit of using PumperNickel over manually retrieving orders from the Foodstuffs web interface, or by post, are faster, more reliable order entry, less work in manual keying, and quicker order processing time. The more line items per order, and the greater the number of orders, the bigger the savings.

PumperNickel takes care of retrieving the order via ftp, converting into Prophet format and importing to Prophet. It keeps track of order status and progression through Prophet. An acknowledgement message is sent back to the exchange as soon as it has the order has successfully been retrieved.  An advanced shipping  notice is sent to the exchange once the order has been prepared. This is normally done when the order picking is complete, and any changes to the order from out of stock have been applied.  Once a Prophet invoice exists for the order, an invoice can be sent to the exchange.

PumperNickel can process order retrievals automatically, on a scheduled basis.  Triggers can advise you of new orders, or you may integrate them into your normal order control process, by reviewing order status reports and printing picking slips.  Advanced shipping notices can be manually initiated, or triggered when an order is completed and invoiced. Invoices can also be automated, sending when an invoice is posted.

To get started on Foodstuffs Exchange, you need the following items:

  • Trading relationship with Foodstuffs (Auckland, Wellington or Christchurch)
  • Registration on Foodstuffs web-based system to familiarise with concepts, process manual transactions
  • Access codes for exchange
  • A period in testing mode
  • Data synchronisation for stock and customer master files with cross matching of codes
  • A broadband internet connection at your office
  • PumperNickel installed and connected to your Prophet system
  • Prophet OLE DB driver module
  • A staff member to co-ordinate and control data and process functions

Foodstuffs have extensive documentation on connecting to the exchange and the steps needed for a successful implementation. Foodstuffs are also moving on to the next step of ecommerce integration, using EAN|net to store and synchronise product master file data. When they have completed their pilot and resolved issues we will add a connector from PumperNickel to EAN|net. Suppliers (Prophet users) should be members of EAN, and keep abreast of developments in this area. The "exchange" is the front end computer system that processes orders and other XML documents, and converts them into formats that the individual Foodstuffs company systems can recognise. It provides a single point of access and common format for all Foodstuffs companies.

The Foodstuffs module for PumperNickel is available now. Price is $3,000.

This is a sample Purchase Order document from the Exchange. PumperNickel takes this order and matches the codes to Prophet customer codes, matches stock codes by bar code, and brings the order into Prophet.  It can perform other transformations, such as sorting the stock lines, or applying other business rules prior to importing. The look and feel of the PumperNickel screens has been aligned with the look of the Foodstuffs web site, to provide familiarity and theme.  Try the links on the left to see what several PumperNickel screens look like.

<PURCHASE_ORDER partner="FOODSTUFFS" 
                   transaction="PURCHASEORDER" 
                   version="1.40" 
                   timestamp="2004-06-23T12:12:14">
  <CUSTOMER>
    <COMPANY>
      <ID>Pak N Save Chatham Islands</ID>
      <STREET_ADDRESS>
        <ADDRESS1/>
        <ADDRESS2/>
        <ADDRESS3/>
      </STREET_ADDRESS>
      <PHONE/>
      <EMAIL/>
      <SUPPLIER_REF>PSCHAT</SUPPLIER_REF>
      <CUSTOMER_REF>557244</CUSTOMER_REF>
      <EAN_PREFIX>123</EAN_PREFIX>
    </COMPANY>
  </CUSTOMER>
  <SUPPLIER>
    <COMPANY>
      <ID>Green Supplies</ID>
      <STREET_ADDRESS>
        <ADDRESS1/>
        <ADDRESS2/>
        <ADDRESS3/>
      </STREET_ADDRESS>
      <PHONE/>
      <SUPPLIER_REF/>
      <CUSTOMER_REF>4243</CUSTOMER_REF>
      <EAN_PREFIX>9416919</EAN_PREFIX>
    </COMPANY>
  </SUPPLIER>
  <ORDER_HEADER>
    <ORDER_NUM>00717</ORDER_NUM>
    <ORDER_DATE>2004-06-23T12:12:15</ORDER_DATE>
    <BUYER>Jim</BUYER>
    <SUPPLIER_CONTACT/>
    <BILL_TO>
      <COMPANY>
        <ID>Head Office</ID>
        <EAN_PREFIX>789</EAN_PREFIX>
      </COMPANY>
    </BILL_TO>
    <CURRENCY>NZD</CURRENCY>
    <DISCOUNT_METHOD/>
    <SPECIAL_INSTRUCTIONS>This is a zoomy order</SPECIAL_INSTRUCTIONS>
    <PRICE_BEFORE_DISCOUNT>38.08</PRICE_BEFORE_DISCOUNT>
    <TOTAL_DISCOUNT>0.00</TOTAL_DISCOUNT>
    <PRICE_BEFORE_GST>38.08</PRICE_BEFORE_GST>
  </ORDER_HEADER>
  <CONTROL>
    <LINES_ORDERED>1</LINES_ORDERED>
    <TOTAL_QTY_ORDERED>4</TOTAL_QTY_ORDERED>
  </CONTROL>
  <LINES>
    <ORDER_LINE>
      <CUSTOMER_PRODUCT>3032225</CUSTOMER_PRODUCT>
      <SUPPLIER_PRODUCT>JDLG20</SUPPLIER_PRODUCT>
      <PRODUCT_ID/>
      <PRODUCT_DESC>Green Grumpkins</PRODUCT_DESC>
      <QTY_ORDERED>4</QTY_ORDERED>
      <UNIT_OF_MEASURE code="Retail Unit">1</UNIT_OF_MEASURE>
      <QTY_IN_CARTON>1</QTY_IN_CARTON>
      <PRICING_DETAIL>
        <PRICE_BEFORE_DISCOUNT>9.5200</PRICE_BEFORE_DISCOUNT>
        <PRICE>9.5200</PRICE>
        <UNIT_OF_MEASURE code="Retail Unit">1</UNIT_OF_MEASURE>
        <DISCOUNT>false</DISCOUNT>
        <DISCOUNT_LIST/>
        <LINE_PRICE>38.0800</LINE_PRICE>
      </PRICING_DETAIL>
      <SUPPLIER_UNIT_CODE Local="true"/>
      <SUPPLIER_DESC Local="true"/>
    </ORDER_LINE>
  </LINES>
</PURCHASE_ORDER>
Notes
 Comment by User
We have saved a lot of time by integrating invoices electronically. We used to spend half the month entering invoices, and always be behind. Now we can focus on customer satisfaction, rather than administration.
 Comment by Margaret
Aligning product data forced us to tidy up our stock and bar codes. We knew it needed doing, ecommerce provided the incentive to get this overdue task completed.
 Comment by Admin
It was such a relief to get this software up and running. Our accounts team were straining at the volume of invoices to deal with. Now PumperNickel is loading 80% of them, we have more time for checking and follow up.

shareright © 2004 McNeill Computers Limited 
NZS.com : New Zealand Web Directory and Search Engine thanks wave for hosting this site!