This article covers how to Import products through a spreadsheet when creating a shipping plan.
Import Products
Overview
When you create an inbound, the first screen will ask you to Select and add products. On this step, you need to add all the SKUs you are inbounding as a part of this shipping plan.
First, you must select Case-packed products or Individual products, depending on what you send in. You can only choose one of these options per inbound. See Case-Pack vs. Individual Product Packaging Guidelines for additional information on the differences.
Once you've selected your packing type, you can choose to search and add products or Import products. To import your products from a spreadsheet, click the Upload File button.
Filling the Template
After you click Upload File, you'll be prompted to download one of two .xlsx templates, depending on whether you are imported Case-packed products or Individual products. Here, you can click Download the template.
After you've finished filling the template, you will need to save it as either a .xlsx or .csv to upload. Depending on your spreadsheet editor, you may need to export the file to get it into the correct format. Some examples of how to do this are below.
If you are using Microsoft Excel, you can save the file and upload directly. You can also export this into a .csv file by going into File > Save As... and selecting CSV.
If you are using Numbers, you can go to File > Export To and select either Excel or CSV.
If you are using Google Sheets, you can go to File > Download and select either Microsoft Excel or Comma-separated values.
Case-Packed Products Template
In your template, you will see two tabs. The first tab, Case-Pack Upload Template, is the template you need to fill in.
The column definitions are in the table below and can also be found in the Instructions tab. In the Instructions tab, you will also find a template example.
|
Column |
Description |
| Merchant SKU (MSKU) |
A unique identifier for the product. If an MSKU is listed more than once, the file will show an error when processing. |
| Units per box |
The number of units in each box. Must be a whole number 1 or greater. |
|
Number of boxes |
The number of boxes in the shipment. Must be a whole number 1 or greater. |
| Box length (in) ** |
The length of each single-SKU box that will be shipped. Must be a positive number. |
| Box width (in) ** |
The width of each single-SKU box that will be shipped. Must be a positive number. |
| Box height (in) ** |
The height of each single-SKU box that will be shipped. Must be a positive number. |
| Box weight (lb) ** |
The weight of each single-SKU box that will be shipped. Must be a positive number. |
** Box dimensions and weights are only required if you are shipping small parcel delivery (SPD) on Flexport's rates.
Individual Products Template
This template is a simpler version of the Case-packed template above, with the two required columns below.
|
Column |
Description |
| Merchant SKU (MSKU) |
A unique identifier for the product. If an MSKU is listed more than once, the file will show an error when processing. |
| Quantity |
The number of these items to be included in the shipment. Must be a whole number 1 or greater. |
Uploading the Template
After filling in your template, you can drag or select the file to upload. If there are errors processing your file, you will be instructed on how to resolve them. Then, you should see a success toast and all your products added to your shipping plan!