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.
These data feeds can be transmitted either via Flat Files (FTP/SFTP) or REST API.
DATA FEEDS SUPPORTED
- Sales Orders from NuORDER to ERP
- Product Data from ERP to NuORDER
- Customer Data from ERP to NuORDER
- Inventory Data from ERP to NuORDER
- Price Sheet Data from ERP to NuORDER
- Order Edits from ERP to NuORDER*
- Order Shipments from ERP to NuORDER*
- Order Creation from ERP to NuORDER*
A standard integration includes Sales Orders, Product Data, Customer Data, and Inventory Data feeds.
*Order Edits, Order Shipments, and Order Creation data feeds are typically considered a part of a "two-way orders integration" and may not not supported by all ERPs.
FUNCTIONALITY OF DATA FEEDS
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.
File formats: For most integrations, we can provide a fully customized order file per your specs. We also offer basic CSV/TXT formats OOB which can be configured without requiring development.
Product data is created from your style master and will include:
- 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, you can transmit these in separate Price Sheet Data feed.
Customer data is usually generated from your customer master and will include:
- Account names and codes
- Billing & shipping codes & addresses
- Payment terms
- Price Sheet and/or Default discount assignment
- 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 an optional Buyer Data Feed, but most brands handle this directly within NuORDER.
Inventory data includes the net available-to-sell quantities for immediate and/or future dates. Multiple warehouse locations, future dates & quantities (sometimes called "work in progress" or "available to promise"), and/or “replenishments” can be supported, if needed.
For items that have not yet been produced or 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 / UPDATES
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 shipment data will include:
- Tracking numbers
- Line items & quantities shipped
- Shipping carrier
Shipments will be identified by tracking number. Multiple and partial shipments are supported.
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 upload those records to NuORDER before they can be included on an order record.
Click to learn more about the specific methods of transfer:
Flat File Integration Documentation