Description
This report lists all of the SKUs (stock keeping units) in your Flexport catalog, as well as their dimensions (length, width, height), weight, and units of measurement (for both weight and dimensions). Additionally, it shows how many aliases (links or connections to specific products/listings) they have to your connected integrations. Learn more about SKU Aliases.
This same information is visible on the inventory details page (go to Inventory and choose a specific SKU), but that only shows the aliases and product details for one SKU at a time. This report provides a comprehensive view of SKU details and alias information at a glance for all of your SKUs.
Purpose
Use this report after you connect a new integration to your Flexport organization to verify that the new product catalog has fully synced with your existing catalog, including dimensions (length, width, height), weight, and units of measurement. From here, you can fix any catalog sync errors so that future inbounds and orders work as expected.
For example, choose an integration column like 'Amazon' and use your spreadsheet tool (Excel, Numbers, Google Sheets, etc.) to filter for 'Amazon' is <<blank>>. The rows represent all the SKUs that don't have a link to Amazon. Additionally, review the dimensions and weight details to ensure they are accurate and complete for each SKU. If you do sell this particular SKU on Amazon, click the URL for this row to go to the inventory details page, and then add an alias for this SKU to Amazon or update its dimensions and weight if needed. Learn more in the Checking & Fixing SKU Mismatches article.
The above process of fixing missing aliases in your catalog is easier to do for just SKUs in your catalog that have available inventory (a relatively small set of SKUs) rather than for your entire catalog (a large set of SKUs). For this case, use the Products - Available SKUs With Alias Counts report, which is the same as this report but only includes SKUs with available inventory in Flexport.
Documentation
|
Column |
Description |
| DSKU |
Flexport SKU (stock keeping unit). Uniquely identifies the SKU within Flexport Starts with D and is 11 characters long. |
| URL |
Link to view the SKU in Flexport Seller Portal |
| MSKU |
Marketplace SKU value of the product. This was imported from the integration, or manually updated in Flexport Seller Portal. |
| NAME |
Name of the product |
|
WEIGHT |
Weight of the the product |
|
WEIGHTUNIT |
Unit of measurement for the weight of the product (e.g., grams, kilograms, pounds). |
|
LENGTH |
The length of the product in the specified unit of measurement. |
|
HEIGHT |
The height of the product in the specified unit of measurement. |
|
WIDTH |
The width of the product in the specified unit of measurement. |
|
LENGTHUNIT |
Unit of measurement for the dimensions of the product (e.g., centimeters, inches). |
| ON_HAND_QUANTITY |
Quantity of units Flexport has in our network for this particular DSKU. Includes units available for sale plus unavailable units unavailable. |
| AVAILABLE_FOR_SALE_QTY |
Quantity of units Flexport has in our network for this particular DSKU. Only units that are available for sale. |
| {{ INTEGRATION_NAME }} |
This can be multiple columns, like a pivot table. Each column is one integration that is active on your Flexport organization (visible at Channels). The value for this column and row is how many aliases this DSKU has for this integration. To see exactly which products/listings the SKU is connected to, go to the inventory details page (click the URL for this row) and under 'Aliases' click on the integration name. |