Description
This report lists all of the SKUs (stock keeping units) in your Flexport catalog, as well as 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 for one SKU at a time. This report shows that same 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. 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 are all the SKUs that don't have a link to Amazon. If you do sell this particular SKU on Amazon, then click the URL for this row to go the inventory details page, and then add an alias for this SKU to Amazon. 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 |
| 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. |