Import file with mutliple orders appears as only one order on the imports preview page

Import file with mutliple orders appears as only one order on the imports preview page

You may find instances where you receive an import file that has mutliple line items but when you preview the import it appears that there is only one order.  There are a few things that can cause this. The first is that there's no CRLF at the end of each order (carriage return line feed). Another little tidbit we found lately is below.


Is your FTP setup for ASCII or Auto transfer mode? If the sender's system is UNIX-based, text files are stored with LF delimiters (not CRLF, like non-UNIX systems). However, if you transfer in ASCII mode, your resulting file will have CRLF delimiters as you need.

If the FTP client that you're using allows you to set the Transfer mode to ASCII, Binary or Auto (based on file extension) please do the following. If yours is set to Binary, you'll want to change it to either ASCII or Auto -- and if you use Auto, you'll need to be sure that your program knows that files with .csv extension should be transferred in ASCII mode. (The list of file extensions is another setting you should be able to edit, somewhere in your FTP client program.)

    • Related Articles

    • OrderLogix Order Import V4 (Flat File and API) Exception List

      Module: Order Import V4 Topic: Exception List Version(s): Version 5.0 and up Editions: Standard, Commerce, Call Center The Import Process will throw an exception if there is an issue with the information submitted for an order. Below is a full list ...

    • WARNING: Duplicate order found in the import file. Order was not imported.

      Message: WARNING: Duplicate order found in the import file. Order was not imported.  Explanation: The order number that you have provided matches a web order number that is already in use. This logic prevents duplicate orders from being imported to ...

    • Credit Card BIN File Script Rule

      Module: Global Script Rules and Maintain Scripts Path: Company Data > Advertising > Global Script Rules Company Data > Advertising > Maintain Scripts > Edit Script > Rules tab Topic: Script Rule for Credit Card BIN File Version(s):  5.1 & up ...

    • Using Coupon Codes on Imports vs Manually Entered Orders

      Module: Advertising Path: Company Data -> Advertising -> Coupon Codes Topic: Import vs Manual Orders and Coupon Codes Version(s):   Editions:  Coupon codes on imported orders differ from coupon codes on manually entered orders in that they are ...

    • Order Import - Required Fields When Using Source Prices

      Using prices, shipping, and tax from the vendor where the order is originating from is recommended, especially when importing orders with Pre-Auths or Settled payment transactions. When using the vendor's prices, shipping, and tax, there are fields ...