Order file upload

With order file upload, a user can submit orders to M3 by uploading a file containing a list of items and quantities that the user wants to buy.

The file that contains items that a user wishes to order can either be an Excel file or a text file with either tab or comma field delimiter. The file should contain item IDs and the quantities to order for the respective items.

The item IDs given in the file can either be customer specific item IDs or the item IDs used by the merchant (general item IDs). For each item in the order file, it must be indicated by a code (or a flag) whether the item ID is customer-specific or whether it is the general item ID. This way, Infor e-Commerce knows how to process the item ID in a consistent way.

The user browses the computer and selects the file that is to be uploaded as an Infor e-Commerce order. Before the file is uploaded to the Infor e-Commerce server, the file size and an estimated upload time is indicated. The user can now choose one of the following two upload scenarios.

  • Synchronous upload – This scenario is typically used for small orders. The user will add valid items to the shopping cart and proceed with the normal ordering. The number of items that can be placed on the shopping cart is defined in Application Setup > Application Details > MaxItemsOnOrderFormUpdate in Business Center. By default, the value is 100. If the number of items exceeds the value defined in MaxItemsOnOrderFormUpdate, asynchronous upload will take place.

  • Asynchronous upload –This scenario is used for large orders. Items will be sent directly to M3 BE once the user clicks Submit Order in Shipping Details page. The user can choose to initiate the upload process and then leave the order upload page. The user is then able to go to other pages in Infor e-Commerce. In the asynchronous upload scenario, the user will receive an email once the order has been successfully placed in M3 BE.

For Order File Upload to work, 'OrderFiles' folder should be in the correct location as indicated in the OrderFileFolder parameter under the application property group Ordering.

Note: The file path value of the OrderFileFolder field should have slashes instead of back slashes. For example, the value of the OrderFileFolder field should be "C:/OrderFiles" instead of "C:\OrderFiles."