Founded in 2000, eZCom Software is a leading provider of software as a service (SaaS) for EDI transactions, and managing orders from eCommerce stores and online marketplaces.
Using the Upload Carton Contents pack method allows you to pack your ASN by uploading your carton details. You will set certain matching criteria during the process, which will dictate what information you will need to provide. This will include how the data you upload matches to your order(s), to the item(s), and how you separate the information in your file.
After you’ve created your ASN (see tutorial titled “Creating an ASN”), open the document by clicking on the ASN number in your “Open ASN” folder. You’ll need to verify the “Packing Type” field is set to “Upload Carton Contents”. Next, click “Pack ASN”-doing so will pull up the “ASN Packing: Upload Carton Contents” window.
Once your Upload Carton Contents screen appears, you will need to indicate what matching criteria you will be using. You will need to choose “Order Match”, “Item Match” and “Field Separator”. You will also need to indicate if your upload file has Column Headers.
If you would like Lingo to remember your format choices, click on the blue “Remember Format” button. This will allow Lingo to remember your preferences and populate them whenever you use Upload Carton Contents as your packing method.
WARNING: choosing incorrect Shipment / Order / Item Matching options will result in incorrectly packed ASNs. Only choose options where all fields have unique values. For example, do not pick “Matching PO Number only” for Order Match if some Orders on the ASN have the same PO number. Nor should you pick an option like“Vendor Item Number” for Item Match if there are repeating Vendor Item Numbers on the same Order.
Options for Order Match
No matching needed, only 1 PO or all POs are the same: You may use this option if your ASN is a single order ASN; you may use this option on multi-order ASNs only if the orders contained on the ASN are identical and will be packed the same way.
Match by PO Document ID: The PO Document ID is not the same value as your PO Number. The PO Document ID is assigned by Lingo (while the PO number is assigned by your retailer). You may use this option if you are packing a single or multi-order ASN, and you are using the Document ID from the Purchase Order to identify the order(s) to be packed. The PO Document ID is contained in PO download files, referred to as the “Purchase Order Source ID”, as well as appearing in the URL when the PO is open:
Match by PO Number / Location: This option is best if you are using PO Numbers to identify your order, and are packing a multi-order ASN where two or more of the orders have the same PO number, but different location numbers.
Matching PO Number only: This option is ideal when you want to distinguish which order you are packing by identifying the PO Number. It works well for a multi-order ASN, when each order has a different PO number.
Options for Item Match
Match by PO Line Number
Match by UPC Code
Match by Vendor Item #
Match by Customer Item #
Options for Field Separator
Tab (this is what you should select if you copy/paste from Excel)
After selecting your matching criteria, you may click on the blue “View Format Details” button to see a description of the format your uploaded data will need to follow. Note that in addition to the required information, Lingo offers you the chance to upload your carton weight and tracking number using optional fields. On the next page you can find an example of the format details when:
- Order Match = Matching PO Number only
- Item Match = Match by UPC Code
- Field Separator = Tab.
Each Carton Identifier represents one carton that will be packed. If you have multiple items in the same carton, each item will use the same Carton Identifier. You may use any set of values for Carton Identifiers, as long as each carton has a unique identifier. Some examples of values you could use include: A,B,C or 1,2,3 or BIG,MED,SMALL. After packing, the Carton Identifier will appear in the “group code” field of the ASN.
If you are using the optional Tracking # and Weight fields, you may enter the information for each item, or for only one of the items in a specified carton. If you enter values for each item in the carton, and the information does not match the values you entered for the other items within the same carton, the ASN will not pack and you will receive an error message.
How it would look in an Excel file:
Paste your upload data into the space provided in the “ASN Packing: Upload Carton Contents” screen, then click the blue “Continue ASN Packing” to continue packing your ASN. If you wish to cancel your work and return to your ASN, click on “Cancel ASN Packing”.
When you click “Continue ASN Packing”, your ASN will refresh indicating the number of cartons that were packed.
You should always review ASN packing information for accuracy prior to sending it to your Trading Partner.
To check your pack, proceed to the “By Case” view of your ASN. Once on the “By Case” view, scroll to the lower portion of the ASN document. The “By Case” view displays your carton numbers (GS1-128 label numbers) and their contents. IMPORTANT: Your ASN cartons must perfectly reflect the way you’re packing your actual cartons.
For demonstration purposes, this example only displays the first carton in the By Case view:
You may now proceed with adding any additional information required on your ASN.
This concludes the Packing ASNs – Upload Carton Contents tutorial. The eZCom Support Team is happy to assist you in getting started packing your ASNs. You may reach us by calling our support line (877-765- 3564, option 2) or through the Help / Contact Us feature within your LINGO account.