Use Listings to connect multiple versions of the same item. Listing level details such as size/volume (CBM) and weight can also be adjusted in this section.
Note: to combine stock and/or sales history of two separate items for forecasting & replenishment purposes, use the 'Combine Sales/Stock' functionality instead. This includes transitional items (new variant replacing an old variant) and brand new items that otherwise have no sales history to reference for forecasting.
There are many cases where you might have different Listings for the same Variant:
- Same variant across multiple platforms: If you are connecting multiple stores to Inventory Planner, you can use the Combined Warehouses feature to aggregate the sales and stock information from multiple locations into one view for forecasting purpose. The same Listing from each store must be linked together to display as one Variant in the Combined Warehouse view.
- Multiple versions of the same variant: If you sell the same variant in two different ways, you may need to link these Listings together to display as a single Variant.
For example: many users who connect with Amazon FBA have one Listing for Amazon Prime Members and a separate Listing for regular Amazon customers. Both Listings are attached to the same Variant.
Combine Listings (Automatically)
Inventory Planner attempts to link together Listings automatically based on matching product information (eg. matching by barcode, ASIN, or SKU). If there is a disconnect, the automatic logic will be disrupted.
- Go to Catalog > Listings.
- Check if Listings have been automatically detected and combined.
If Listings were not automatically detected, contact the IP customer support team if there is a straightforward rule that can be applied in this case to automatically link together Listings for your account.
Combine Listings (Manually)
If there is no straightforward rule to link together Listings (or if you prefer to track Listings manually), you can enable "Manual" mode to add additional listings. Manual linking also allows users to assign a Master SKU. The 'Master SKU' can be added as a column or filter in the Replenishment and Reporting tabs.
* Note: Enabling "Manual" linking for a variant disables the automatic detection of Listings in the future. Switch back to "Auto" anytime.
When to use this feature
If the same variant on different platforms uses different SKUs, then use the 'manual linking' feature to combine information for 'all warehouse' or 'combined warehouse' use. For example, 'SKU-amazon' and 'SKU-shopify' can be linked so that all information shows together for reporting and ordering.
When not to use this feature
If you use the same SKU, barcode, title or ASIN across platforms, Inventory Planner can automatically match up this information. 'Manual linking' would only need to be used if this information does not match across platforms.
If you are looking to apply the sales history of an old or existing variant to a new variant that will replace it, use the 'Combine Sales/Stock' functionality.
Assign Master SKU
- Go to Catalog > Listings.
- Search the Variant, and change the connection from 'Auto' to 'Manual'.
- By changing to 'Manual', a Master SKU must be identified.
- Select 'Save Changes'.
- Select the "+" button to add a new Listing.
- Search for the missing Listing.
- Save Changes to complete the action and see the new listing added.
Listings can also be viewed and managed throughout Inventory Planner by selecting the Details Icon (the "i" button) for the item > More > then the Listings tab;
Follow the same instructions as above in Catalog to manually link together Listings from within the Details icon.
Import Combined Listings
Use the Import function to manually combine listings in bulk. View instructions on How to Import Data into Inventory Planner, or view step-by-step instructions below.
- From Replenishment or Catalog-Listings, select Import > 'Combine Listings'. Note: You will need to import a CSV for each connection (eg. one import for Amazon, one import for Shopify, etc).
- The import will need two columns with column titles: The Master SKU you are assigning, and the SKU from your connected platform. As an alternative to your platform's SKU, you can use the product title, barcode, or ASIN.
- Connect your CSV by clicking on the option to 'click to select', or you can drag the CSV into the import section.
We also offer the ability to download a template CSV, should you require this.
- Use the dropdown options for each field to make sure the correct information is matched. Use the field 'Listing connection' to indicate which platform uses the SKUs in your spreadsheet. If you are importing SKU information that corresponds to Shopify, select Shopify in this dropdown.
- Finally, click Import.
- You will then see the results of your import including information successfully imported and any errors with details.
- Click on 'Download all errors as CSV' to see issues that need to be corrected. The number in the 'Line' column indicates the row in your spreadsheet where the error occurred.
- Repeat the process with each connection where Listings need to be combined. After the next import, the Listings from each connection will be matched using the Master SKU you have assigned.