Bulk Upload: Creating an ASN with an Excel Template

Seller Lab lets you create an Advance Shipment Notice (ASN) by uploading your SKUs and quantities using an Excel file, instead of adding them one by one in the UI.

Bulk Upload is the fastest way to create an ASN when you're shipping a large number of SKUs.

Quick overview

Starting a Bulk Upload:

Creating an ASN using Bulk Upload involves 2 main steps:

1. Download the ASN Template
Download the blank Excel template and complete the required information for the Partner SKUs you want to include in your shipment.

2. Upload the ASN
Upload the completed Excel file to Seller Lab. The file will be validated, and you can review and resolve any errors before creating the ASN.

Tip: Follow the screenshots and instructions under each step in order to complete the Bulk Upload successfully.

▶ Steps to starting a Bulk Upload :

Go to noon.com , From Fulfilled by noon click My ASN & Storage.
Click Create ASN, You will be directed to the Select SKUs step.

Select Upload an Excel, then Click Continue.

▶ (1) Downloading the ASN Template

On the Upload SKUs from a spreadsheet page: click ‘Download now’ to get the ASN Excel template.

2. The downloaded Excel worksheet contains ( 4 ) sheets:

Instructions : Guidance on completing and uploading the template.

Data Definitions : Required formats and validation rules for each field.
Recommendation List : Suggested SKUs and quantities based on low-stock items. This sheet may be empty if no low-stock items are identified.
Template : The sheet you need to complete. Enter your SKU and quantity details starting from row 11.

Note: The downloaded template is always a blank workbook. You do not need to wait for an “eligible lines” file to generate, even if you have a large catalog and you can start entering the data right away.

▶ What's Inside the Template ?

Each sheet in the workbook serves a different purpose. Here's what to expect from each one.

1. Instructions

The Instructions sheet provides a quick, numbered walkthrough of how to complete and upload the ASN template. Use it as a reference if you are completing the template for the first time or need a refresher.

2. Data Definitions

A reference table that explains each field in the worksheet, including where it is used, what it means, whether it is required, and any applicable rules or conditions. Use this sheet whenever you are unsure what to enter in a field or which format to use

3. Recommendation List

A read-only list of SKUs and suggested quantities based on an analysis of low-stock items. Use it as a reference when deciding which SKUs and quantities to include in your shipment.

You do not need to copy the recommendations into the Template sheet, and this list is not required to create an ASN. It may be empty if no low-stock items are identified.

4. Template

The sheet you actually fill in and upload. Headers are in row 9, and your Partner SKU rows start from row 10. It includes 6 columns:

Partner SKU : Your product's SKU identifier, as used in your own catalog.
Quantity : How many units of that Partner SKU you're sending.
Longest Side, Median Side, Shortest Side (cm), and Weight (kg) : Package dimensions, needed only for Partner SKUs that don't already have dimensions saved in the system.

Note: Don't rename the sheets, reorder the columns, or edit the column headers in row 9 — the upload is matched to this exact layout.

Important: Longest Side, Median Side, Shortest Side, and Weight are only required for Partner SKUs that don't already have dimensions stored in noon's system. If a Partner SKU already has dimensions on file, these fields are optional and any values you enter here will be ignored. Dimensions can only be updated through Seller Lab > Product dimensions.

▶ (2) Uploading Your Completed File

Once your template is complete, drag and drop the file into the upload area, or click Browse to select it from your computer.

Accepted formats: .xlsx or .xlsm
Maximum file size: 10 MB
Maximum number of Partner SKUs: 8,000
- Click Continue. Every row is validated before your ASN is created.

Congratulations✅🚀! You have successfully created your ASN using Bulk Upload.

▶ What If there are Errors ?

If any rows fail validation, you'll see a summary telling you how many rows need fixing, along with a description of the issue.

Click Error file (.xlsx) to download a report showing every row and column with an issue, along with a clear description of what needs to be fixed.

Some errors relate to the file itself, such as a missing Template sheet or no data rows, rather than to a specific row. These errors are listed separately.
The error report contains one row for each Partner SKU and may include multiple error descriptions for the same row.

Once all errors are resolved and your file passes validation:

Click Re-upload Corrected File to upload the updated Excel file.
Click Continue to move to Review ASN Creation.

Important: When you re-upload, include the entire file , every Partner SKU row, not just the ones that had errors. Each upload replaces the previous file completely, so rows left out of the corrected file won't be included in your ASN.

Note: Validation also checks for catalog-level issues, such as missing images or pricing, so you can resolve them here instead of discovering them later.

▶ How to Fix validation Errors ?

If your file doesn't pass validation, every issue is listed in the error report with the exact wording shown below. Find the message you see, and follow the fix. If a row lists more than one message, resolve all of them before re-uploading — and remember to re-upload the entire file as explained above, not just the corrected rows.

Excel file Problems

These stop the whole file from being processed — no rows are checked until they're resolved.

Message you'll see	How to fix it
The uploaded file is larger than 10 MB.	Reduce the file size — remove extra formatting, images, or unused sheets — and re-upload. This limit is about file size, not the number of SKUs.
The uploaded file is empty.	Make sure the file isn't blank before uploading. Re-download the template if needed and fill it in again.
Only .xlsx and .xlsm files are accepted.	Save or export the file as .xlsx or .xlsm — not .xls, .csv, or any other format — then re-upload.
The uploaded file could not be opened. Re-save it from Excel and try again.	Open the file in Excel, save a fresh copy, and upload that version.
The workbook has no "Template" sheet.	Don't rename or delete the Template sheet. Re-download the template if you're not sure it's intact.
The file has more than 8,000 rows. You can upload at most 8,000 SKUs in one file.	If you are using Excel to create an ASN, split the SKUs across multiple ASNs, with no more than 8,000 rows in each file.
The "Template" sheet has no data rows.	Add your SKU rows below the header row in the Template sheet, then save and re-upload.

▶ Column Problems

These also stop the whole file from being processed, since the upload is matched to the template's exact columns.

Message you'll see	How to fix it
This column appears more than once.	Remove the duplicate — each column header should appear only once.
This column has been renamed. Restore the original header.	Change the header back to the exact original text from the template (for example, keep "Quantity", not "Qty").
This column is missing from the sheet.	Add the missing column back, with its original header text, in its original position.
This column is not part of the template and must be removed.	Delete any column that isn't one of the six original ones: Partner SKU, Quantity, Longest Side (cm), Median Side (cm), Shortest Side (cm), Weight (kg).

Note: Don't reorder, rename, add, or remove columns in the Template sheet — the upload is matched to the exact template layout.

Note: If you’re using an older copy of the template with a column named "SKU," it’s automatically recognized as "Partner SKU" — no need to rename it.

▶ Partner SKU Problems

Message you'll see	How to fix it
Partner SKU is required.	Enter a Partner SKU for every row — don't leave the cell blank.
This partner SKU was saved as a number and Excel has already dropped some of its digits. Format the Partner SKU column as Text, type the partner SKU again, and re-upload.	Format the Partner SKU column as Text, retype the partner SKU, and re-upload.
Partner SKU must contain at least one letter or digit.	Use a Partner SKU made up of letters and/or numbers — not only symbols like dashes.
Partner SKU is longer than the maximum allowed length.	Shorten the Partner SKU to 50 characters or fewer (dashes, underscores, and spaces don't count toward the limit).
This partner SKU appears more than once in the file. Combine the rows into one.	Merge the duplicate rows into a single row per Partner SKU, with the combined quantity.
This partner SKU was not found in your catalog, or it is inactive.	Double-check the Partner SKU is typed correctly and that it's active in your noon catalog.
This partner SKU has no active barcode and cannot be shipped inbound.	Add an active barcode for this Partner SKU in your catalog before including it in an ASN.
This partner SKU has no product title in the catalog and cannot be shipped inbound.	Add a product title for this Partner SKU in your catalog.
This partner SKU has no product image in the catalog and cannot be shipped inbound.	Add a product image for this Partner SKU in your catalog. (Some sellers are exempt from this requirement.)
This item cannot be inbounded into FBN in this country.	This SKU has the storage type “Not Allowed” and is not eligible for FBN inbound shipments in this country. Remove it from the file, or contact Support if you believe this is incorrect.

▶ Quantity Problems

Message you'll see	How to fix it
Quantity is required.	Enter a quantity for every row.
Quantity must be a number.	Enter a plain number — no letters, symbols, or thousands separators.
Quantity must be a whole number.	Remove any decimals — quantities must be whole numbers.
Quantity must be greater than zero.	Enter a quantity of 1 or more — it can't be zero or negative.

▶ Dimension Problems

Longest Side (cm), Median Side (cm), Shortest Side (cm), and Weight (kg) each follow the same three checks, so the same three messages repeat for every column:

Message you'll see	How to fix it
Longest Side (cm) is required because we do not hold dimensions for this SKU.	Provide this dimension. This happens when it's the first time this SKU is being sent to an FBN warehouse, in which case all four fields are required.
Longest Side (cm) must be a number.	Enter a plain numeric value, with no letters or symbols.
Longest Side (cm) must be greater than zero.	Enter a value greater than zero.
Median Side (cm) is required because we do not hold dimensions for this SKU.	Provide this dimension. This happens when it's the first time this SKU is being sent to an FBN warehouse, in which case all four fields are required.
Median Side (cm) must be a number.	Enter a plain numeric value, with no letters or symbols.
Median Side (cm) must be greater than zero.	Enter a value greater than zero.
Shortest Side (cm) is required because we do not hold dimensions for this SKU.	Provide this dimension. This happens when it's the first time this SKU is being sent to an FBN warehouse, in which case all four fields are required.
Shortest Side (cm) must be a number.	Enter a plain numeric value, with no letters or symbols.
Shortest Side (cm) must be greater than zero.	Enter a value greater than zero.
Weight (kg) is required because we do not hold dimensions for this SKU.	Provide this dimension. This happens when it's the first time this SKU is being sent to an FBN warehouse, in which case all four fields are required.
Weight (kg) must be a number.	Enter a plain numeric value, with no letters or symbols.
Weight (kg) must be greater than zero.	Enter a value greater than zero.

Note: If your catalog already has all four dimensions saved for a SKU, these columns are optional — anything you enter is checked for format but otherwise ignored, since the saved measurement is used. Dimensions can only be updated through Seller Lab > Product dimensions, not through this template.

▶ Delivery-Method Eligibility Problems

These apply only when you're creating the ASN with Pickup as the delivery method.

Message you'll see	How to fix it
SKU is not eligible for Pickup because its size classification is Bulky.	Choose a different delivery method for this SKU, or remove it from this shipment.
SKU is not eligible for Pickup because its storage type is Temp. Control.	Choose a different delivery method for this SKU, or remove it from this shipment.
SKU is not eligible for Pickup because its storage type requires Installation.	Choose a different delivery method for this SKU, or remove it from this shipment.

Note: If a SKU has more than one eligibility issue, only the most relevant message is shown for that row.

Got more questions?