Order and Fulfillment Sync for Enhanced eCommerce Management

Order and Fulfillment Sync ensures accurate order data between NetSuite and your eCommerce platform, improving operational efficiency.

·2 min read·View Oracle Docs

Order and Fulfillment Sync provides a mechanism to validate that sales orders are accurately represented in NetSuite according to marketplace or cart data. This process is crucial in maintaining data integrity during order processing.

What Should Match During Sync?

To ensure that sync is functioning properly, confirm that the following values match between NetSuite and the marketplace or cart:

  • Tax Total: Ensure the tax total in NetSuite is the same as in the marketplace or cart.
  • Order Total: Verify that the order total corresponds with the amount shown on the marketplace order.
  • Line Items: Check that the items in the NetSuite order match those listed on the marketplace.
  • Quantities: Confirm the quantities of each line item align between both systems.
  • Mapped Fields: Ensure that all mapped order, item, and customer fields are populated correctly, including tokenized credit card information.
  • Shipment and Payment Methods: If you have mapped these in the NetSuite Connector, they should populate correctly in the order.

Adjusting Mappings

If any modifications have been made to mapping configurations, it's important to update the order in NetSuite to reflect these changes. Use orders that show an Order Posted, Pending Fulfillment status for testing. Note that updating orders marked as Complete will revert their status back to Pending Approval or Pending Fulfillment, prompting the NetSuite Connector to re-sync the order.

How to Update a Pending Order:

  1. Log in to app.farapp.com.
  2. Choose the connector and relevant account.
  3. Navigate to Data Flows > Orders.
  4. Search for the order by entering the order ID in the Search field and press Enter.
  5. Click the Action menu (pencil icon) next to the order and select Update Order in NetSuite.

After mapping changes, remember to set the order cutoff date in the Import Orders Created After field located on the Order Settings page (Settings > Orders). This ensures that only eligible orders are pulled based on your specified cutoff date and time.

Setting the Order Cutoff Date

To manage how orders are synchronized effectively, follow these steps to set the cutoff date:

Steps to Set the Order Cutoff Date:

  1. Log in to app.farapp.com.
  2. Select your appropriate connector and account.
  3. Navigate to Settings > Orders.
  4. Click on Advanced Options.
  5. Click into the Import Orders Created After field and select your start date.
  6. Choose the time in five-minute increments for when you want to begin importing orders.
  7. Click Save to confirm your settings.

Once the cutoff date is activated, NetSuite Connector will import all orders up to your specified cutoff date and time.

Frequently Asked Questions (4)

Does the Order and Fulfillment Sync feature apply to both standard NetSuite and WMS?
The article specifies that the Order and Fulfillment Sync is designed for eCommerce platform integration with NetSuite. It does not explicitly mention WMS, so it's unclear if it applies to that system.
What permissions are required to update a pending order in NetSuite?
The article does not specify the exact permissions needed to update a pending order, but it implies that users need access to the NetSuite Connector via app.farapp.com and permission to navigate Data Flows and update orders.
How does adjusting mappings affect existing orders?
Adjusting mappings and updating an order in NetSuite can change its status back to Pending Approval or Pending Fulfillment for re-sync by the NetSuite Connector if the order was marked as Complete.
Is there a process to ensure orders created before a certain date are not imported?
Yes, the order cutoff date can be set in the Import Orders Created After field on the Order Settings page to ensure only eligible orders created after the specified date and time are imported.
Source: Order and Fulfillment Sync Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Commerce

View all Commerce articles →