Follow

Data Feeds Overview

If you have already opted into integrating your ERP with NuORDER or considering integration down the road, it is important to understand what information flows between the two systems. This dialogue is referred to as a data feed.

 

DATA FEEDS SUPPORTED

  1. Sales Orders from NuORDER to ERP
  2. Product Data from ERP to NuORDER
  3. Customer Data from ERP to NuORDER
  4. Inventory Data from ERP to NuORDER
  5. Price Sheet Data from ERP to NuORDER

  6. Order Edits from ERP to NuORDER*
  7. Order Shipments from ERP to NuORDER*
  8. Order Creation from ERP to NuORDER* 

A standard integration includes “Sales Orders,” “Product Data,” “Customer Data,” and “Inventory Data” feeds.

Note: The “Order Edits,” “Order Shipments,” and “Order Creation” data feeds are typically considered a part of two way integrations and are not supported by all ERPs.

 

FUNCTIONALITY OF DATA FEEDS

SALES ORDERS

Orders will be pulled based on status (APPROVED, PENDING, and/or REVIEW) in NuORDER to create new sales orders within the ERP. After orders are pulled they will be marked as PROCESSED status in NuORDER.

Order schema can include any data available on the products, customer, or fields captured on the order during submission.

PRODUCT DATA

Product data is created from your style master and will include:

  • Attributes
  • Descriptions
  • Sizes
  • UPCs
  • Default pricing (per currency)

Products in NuORDER are defined by the unique combination of the key fields Season, Style Number & Color. Additional custom fields can be supported at the product or size level.

If additional pricing levels are needed, client can transmit in separate Price Sheet Data feed.

CUSTOMER DATA

Customer data is usually generated from your customer master and will include:

  • Account names and codes
  • Billing & shipping codes & addresses
  • Payment terms
  • Warehouse
  • Price Sheet
  • Discount
  • Customer Group assignments

Customers (“companies”) in NuORDER are defined by the key field Company Code. Custom fields can only be supported at the company level.

Note: Buyer contacts (name & email address) can be integrated if needed via Buyer Data Feed, but most brands handle this directly within NuORDER.

INVENTORY DATA

Inventory data includes the net available-to-sell quantities for immediate and/or future dates. Multiple warehouse locations, future “work in progress” dates, and/or “replenishments” can be supported, if needed.

For items that should have unlimited quantity available in NuORDER, you can either specify prebook items and their associated prebook dates within the inventory feed, or apply rules in the NuORDER app based on product attributes (e.g. Season).

PRICE SHEET DATA

Price Sheets will be used to support more granular pricing levels within a currency. For example, if a category of customers have product price points that differ from your other customers dealing in the same currency.

A price sheet will include a list of all items and the associated price, and whether the item is active for that particular price price sheet.

Products omitted from a price sheet will display the default price from the product data.

Customers not assigned to a price sheet will receive the default wholesale and retail prices from the product data.

ORDER EDITS

Changes to existing orders can include:

  • Adding ERP order number
  • Price changes
  • Date changes
  • Status changes
  • Adding/canceling line items
  • Changing quantities
  • Modifying custom fields
  • Canceling orders

Orders will be identified by NuORDER’s order number which is a key field. You can provide an External ID (e.g. ERP order number) as a secondary identifier.

To accept an order edit from ERP, the customer record and all line items must exist in NuORDER. If any of the records are not found, you will need to sync those records to NuORDER before the order can be included on an order record.

ORDER SHIPMENTS

Order shipment data will include:

  • Tracking numbers
  • Line items & quantities shipped
  • Shipping carrier
  • Date

Shipments will be identified by tracking number and multiple shipments are supported.

ORDER CREATION

Orders will be identified by NuORDER’s order number. You can specify this value for order creation or NuORDER will generate one. You can also choose to provide an External ID (e.g. ERP Order Number) as a secondary identifier.

To accept a new order from your ERP, the customer record and all line items must exist in NuORDER. If any of the records are not found, you will need to sync those records to NuORDER before they can be included on an order record.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk