Skip to main content
Solved

Import Scenario Skipping Records

  • November 25, 2024
  • 1 reply
  • 30 views
ainscorpwill

I am working on an Import Scenario that takes an exported Shopify Order and bulk create Sales Orders along with all the line items in the same order.

But my Import Scenario is skipping import every other order (Img below), for example 1st order processed, 2nd order error, 3rd order processed, 4th order error...so on.

Because of Shopify’s exported format, if an order has more than 1 product, it’s recorded in an additional line (e.g. first order has 3 products, so it has 3 lines of records) with the same order number.  

I am able to import the orders with correct line items for the orders that did not run into error, does anyone know what could be cause this? 

Img - Import by Scenario (With errors)

 

 

Img - Import Scenario
 



many thanks

Best answer by Nilkanth Dipak

Hi ​@ainscorpwill,

 

  • Reproduce the issue by using the same data that is causing the issue when you create a Sales Order from the screen.
  • Identify the exact point where the dialog box appears. This could happen due to validations, warnings, or system logic triggered by the data.
  • Find the Dialog Box Trigger by trace the execution flow to find where the dialog box is being invoked.
  • Pass Dialog Box Messages in the Import Scenario:
  • When importing data, Acumatica provides the ability to handle dialog boxes by simulating user interaction (e.g., sending a "Yes" or "OK" response).
  • Ensure your import scenario is configured to pass the required dialog box message.
  • Add the necessary dialog response step to your import scenario. For example:
  • If the system prompts for "Confirm Update" or "Do you want to continue?", configure the scenario to respond automatically.
  • Use the "Dialog Answer" field in the import scenario to specify the response ("Yes", "No", or "OK").
  • Re-run the import scenario with the dialog message handling added.

hope, it helps!

View original
Did this topic help you find an answer to your question?

1 reply

Nilkanth Dipak
Semi-Pro I
Forum|alt.badge.img+10
  • Nilkanth Dipak
  • Semi-Pro I
  • 406 replies
  • Answer
  • November 25, 2024

Hi ​@ainscorpwill,

 

  • Reproduce the issue by using the same data that is causing the issue when you create a Sales Order from the screen.
  • Identify the exact point where the dialog box appears. This could happen due to validations, warnings, or system logic triggered by the data.
  • Find the Dialog Box Trigger by trace the execution flow to find where the dialog box is being invoked.
  • Pass Dialog Box Messages in the Import Scenario:
  • When importing data, Acumatica provides the ability to handle dialog boxes by simulating user interaction (e.g., sending a "Yes" or "OK" response).
  • Ensure your import scenario is configured to pass the required dialog box message.
  • Add the necessary dialog response step to your import scenario. For example:
  • If the system prompts for "Confirm Update" or "Do you want to continue?", configure the scenario to respond automatically.
  • Use the "Dialog Answer" field in the import scenario to specify the response ("Yes", "No", or "OK").
  • Re-run the import scenario with the dialog message handling added.

hope, it helps!

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
ainscorpwill
2 people like this
  • Chris Hackett
    Chris Hackett
  • ainscorpwill
    ainscorpwill

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved