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
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.
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. 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. |