Recommended flow schedules for e-commerce Integration Apps

This article provides the recommended flow schedules for Integration Apps. For information on how to schedule flows, see Schedule data flows.

1. Orders

   eCommerce Application Order to NetSuite Order Add

   • The recommended approach is to run this flow every 15-60 minutes.

   eCommerce Application Customer to NetSuite Customer Add/Update

   • The recommended approach is to run this flow every 15-60 minutes.
     

     Note: Celigo integration app for marketplaces import the customer information to NetSuite each time the Order Import flow runs.

   NetSuite Order to eCommerce Application Order Add

   • The recommended approach is to run this flow every 15-60 minutes.

   Fulfillment

   NetSuite Fulfillment to eCommerce Application Fulfillment/Shipment Add

   • Celigo recommends a tailored approach to the activity of your fulfillment team. If they mark orders as shipped throughout the business day, schedule this flow to run every hour. If they wait for the end of the day to mass update the item fulfillments as 'shipped', run this twice a day.
   • Marketplaces: The recommended approach is to run this flow every two hours or at lower frequencies.

   Billing

   NetSuite Order to NetSuite Cash Sale/Invoice Add

   • For Webstores: If the payment has already been captured at the time of placing the order, run this twice a day. However, if the payment is to be captured after fulfillment, run this in frequencies of 1-4 hours, depending on your business needs.
   • For Marketplaces: Since the actual payments are managed by the eCommerce Application, run this flow once or twice a day.

    NetSuite Billing to eCommerce Application Billing/Invoice Add

   • You will be using this flow if you capture the payment against the order after fulfillment has occurred. Have this run in 1-4 hour frequencies.
     

     Note: Certain use cases may necessitate the flow to run every 15-30 minutes.

   • Please consider the frequencies of your refunds/cancellations before you schedule this. Refunds cannot occur unless an invoice/billing record is created in the eCommerce Application.

   Inventory

   Before reviewing the suggested frequencies, please consider:

   • How frequently do you go low quantity/out of stock. For example, twice a day ranging through once a month.
   • How frequently do you add items and corresponding quantities in NetSuite.

   NetSuite Inventory to eCommerce Application Add/Update

   • Ensure that the 'Always sync Inventory levels for the entire catalog' field is unchecked.
   • This flow runs on a delta functionality which would allow it to run more frequently if you have a lower number of products (less than 1000) and have higher stock levels.
   • In cases where there is a higher number of products and order volumes (leading to more items having updated quantities) run this flow every 1-4 hours.

   Product

   • Adjust the schedule for this flow based on the frequency of the catalog updates that you make.

     Example: If you make changes against the title or description of a product once a day, you should run it 2-4 times a day as long as your catalog is under 1000 items. Similarly, if your catalog contains 20,000+ items, run it less frequently.

   • Webstores: Price list changes are considered part of the product flow.
   • Marketplaces: Product data is less likely to change multiple times a day or week, however, pricing updates can be more frequent, schedule them to your best judgment based on the data above. Once a day would suffice for a product, whereas 2-4 times a day would work well for the price updates.