There are several unresolved order statuses that may require attention during onboarding.

To prevent mass amounts of unresolved orders occurring during onboarding, it is a best practice to do the following:

  1. Integrate sales channels
  2. Uncheck “Inventory Update” in Settings > Company Info
  3. Pull in products (i.e. Build from Channel; spreadsheet)
  4. Deactivate sales channels

In order to clear out unresolved orders, please follow the below steps.

Missing Product Info

  • Go to the Orders module under this particular section, select your target orders and then click “Import/Export” followed by “Export Orders”
  • Configure export settings to include “Master SKU” and “Quantity”
  • Export the orders marked with “Missing Product Info” status
  • Determine if the products in the orders are missing Master SKUs or Listing SKUs

If you are missing Master SKUs:

  • Go to Products module 
  • Import Master SKUs via spreadsheet or Build from Channel

If you are missing Listing SKUs:

  • Go to Products module and click “Import Listing SKUs”, then download the import spreadsheet
  • Take the Master SKUs from the unresolved orders export and add them to this spreadsheet
  • Add a Listing SKU to the appropriate Master SKU
  • Re-upload via “Import Listing SKUs” button
  • Repeat per sales channel that requires Listing SKUs 

NOTE: if orders are stuck in “Awaiting 3PL Export”, the Listing SKUs likely need to be jolted. To do this manually in the UI: 

  • Click into each Master SKU
  • Go to “Listing SKUs”
  • Edit each Listing SKU to include a “.” at the end
  • Click Save
  • Click back into each Listing SKU and delete the “.”
  • Click Save

If you would like to update the Master SKU or Listing SKU one-by-one in the UI:

  • Click on the line item with the target order in the “Missing Product Info” category
  • Click on the red hyperlink at the bottom of the window under “Order Items”. This will say “Not found! Click to resolve…” or something similar.
  • Select “Yes – find existing product.” or “No – create new product.” and proceed with the associated next steps to assign the correct product to the SKU

Alternatively, you may cancel the orders outright.

Missing Fulfillment Source

To manually correct these errors in the UI, the you have two options:

Jolting the Warehouse

  • Select an unresolved order
  • Click on the order number
  • Click Processing
  • Click Save
  • Repeat until finished with all errors

Bulk Editing

  • Select all unresolved orders
  • Under the Order Fulfillment menu on the right-hand side, click in the box that says “Bulk Update”
  • Select “Fulfillment Type”
  • Edit the fulfillment details as desired
  • Click Update Selected Orders

Alternatively, you may cancel the orders outright.

Missing Stock Location

To resolve orders in the Missing Stock Location status, there are a couple options available via the UI and spreadsheet, respectively.

For inventory at your in-house warehouse that lacks a pick location in Skubana, that can be added in the UI by:

  • Go to the Inventory module and search for a Master SKU from the order in the “Missing Stock Location” status
  • Click on the Master SKU’s line (but not the SKU hyperlink) and look at the information that appears under “Stock Details”
  • Click “+ New Stock” and add in the required fields, including: Location, On-hand and Min. Level.
  • Click “Continue” and on the next screen you may either edit the Draw Rank (if necessary), or click “Save”
  • Go back to the Orders module and confirm that the order has been processed out of the “Missing Stock Location” status

Alternatively, you may manage this via spreadsheet by:

  • Go to the Orders module and select the orders in the “Missing Stock Location” status, then click “Import/Export”, and then “Export Orders”
  • Configure export settings to include Master SKU and Quantity
  • Export the orders marked with “Missing Stock Location” status. We suggest creating a Pivot table to identify orders that include the same Master SKUs and then sum the totals of the ordered Master SKUs. 
  • Go to the Inventory module and click on “Import Inventory”
  • Download the Inventory import spreadsheet per necessary warehouse and complete the spreadsheet’s required fields:
    o Paste the Master SKUs from the Pivot table into the “Master SKU” column
    o Paste the associated quantities from the Pivot table into the “On Hand Stock” column
    o Add ONE new (pick) “Location”
    o Set “Draw Rank” to “1”
    o Set “Active”, “Is Pickable” and “Is Receivable” to “TRUE”
    o Set “Locked Inventory” and “Location Min. Level” to “0” 
  • Re-upload the inventory via the “Import Inventory” button. Please note that occasionally Skubana will show an error for “missing” SKUs. To correct this, confirm within Skubana if that SKU requires additional “0”’s at the beginning of the SKU and repeat this till all orders are resolved.

Alternatively, you may cancel the orders outright.

Out of Stock

NOTE: Unresolved “Out of Stock” errors should be resolved by the user after resolving “Missing Stock Location” errors.

  • Go to the Orders module under this particular section, select your target orders and then click “Import/Export” followed by “Export Orders”
  • Configure export settings to include Master SKU and Quantity
  • Export the orders marked with “Out of Stock” status. We suggest creating a Pivot table to identify orders that include the same Master SKUs and then sum the totals of the ordered Master SKUs. 
  • Go to the Inventory module and click on “Import Inventory”
  • Download the Inventory import spreadsheet per necessary warehouse and complete the spreadsheet’s required fields:
    o Paste the Master SKUs from the Pivot table into the “Master SKU” column
    o Paste the associated quantities from the Pivot table into the “On Hand Stock” column
    o Set “Location” as the RECENTLY CREATED pick location from the “Missing Stock Location” solution
    o Set “Draw Rank” to “1”
    o Set “Active”, “Is Pickable” and “Is Receivable” to “TRUE”
    o Set “Locked Inventory” and “Location Min. Level” to “0”
    • Re-upload the inventory via the “Import Inventory” button
  • Re-upload the inventory via the “Import Inventory” button. Please note that occasionally Skubana will show an error for “missing” SKUs. To correct this, confirm within Skubana if that SKU requires additional “0”’s at the beginning of the SKU and repeat this till all orders are resolved.

Alternatively, you may cancel the orders outright.

Did this answer your question?