Skip to content

Removing Non-Serialized Items from Opulo Managed Inventory per Production Batch

  1. Navigate to https://ship13.shipstation.com/home and login

  2. Click "Shipments"

  3. Expand the "Batches" drop-down menu and select "Open"

  4. Click "WK27" (or the given production week # you are working with)

  5. Click "Export Orders"

  6. Click "Export order line items"

  7. Click the "Weekly Non-Serialized Item Removal" field.

  8. Click "Export"

  9. Navigate to tab "Weekly Aligni Item Removals - Google Drive"

  10. Make a copy of "WK ## NON-SERIALIZED ITEM REMOVAL"

  11. Right-click "WK ## NON-SERIALIZED ITEM REMOVAL"

  12. Click "Make a copy"

  13. Right-click "Copy of WK ## NON-SERIALIZED ITEM REMOVAL"

  14. Click "Rename"

  15. Click this text field.

  16. Click this text field.

  17. Type "[[Backspace]]" to delete "Copy of " from the front of the filename

  18. Replace ## with the given production lot's week number

  19. Type "27" (for example)

  20. Click "OK"

  21. Double-click "WK 27 NON-SERIALIZED ITEM REMOVAL" and Open the File

  22. Right-click "WK ## FROM SHIPSTATION"

  23. Click "Rename" on the first tab of the Workbook

  24. Click "WK ## FROM SHIPSTATION"

  25. Replace ## with the production lot's given week number – "27" in this case

  26. Click "WK ## NON SERIALIZED ITEMS TO REMOVE"

  27. Right-click "WK ## NON SERIALIZED ITEMS TO REMOVE"

  28. Click "Rename"

  29. Click "WK ## NON SERIALIZED ITEMS TO REMOVE"

  30. Replace ## with the production lot's given week number – "27" in this case

  31. Click "WK 27 FROM SHIPSTATION" to exit the renaming pop-up window

  32. Navigate to the "WK## FROM SHIPSTATION" tab

  33. Select Cell "A1"

  34. Click "File"

  35. Click "Import"

  36. Click "Upload"

  37. Click "Browse"

  38. In your computer's file explorer, navigate to and select the .CSV file you previously exported from ShipStation

  39. Click "Create new spreadsheet" and expand the drop-down menu

  40. Select "Replace data at selected cell"

  41. Select "Import data"

  42. Confirm all data imported correctly from the top to bottom

  43. Switch to the "WK ## NON SERIALIZED ITEMS TO REMOVE" tab

  44. Click on the Pivot Table

  45. Select the "Edit" pop-up button

  46. Edit the filtered "BASE SKU" list

  47. Click "Clear" to deselect all SKUs

  48. Click "Select all"

  49. Click "(Blanks)" to remove items without SKU numbers

  50. In the Filtered List search bar, type "sku-00"

  51. Click "SKU-0002" to filter LumenPnP units from the list

  52. Repeat this step, as needed, to remove any of the following items:

    • Replacement Motherboards
    • Control Boxes
  53. Click "OK"

  54. Click here to exit the Pivot table editor

  55. Click "File"

  56. Select "Download" from the File drop-down menu before selecting "Comma Separated Values (.csv)"

  57. Navigate to opulo.aligni.com

  58. Click on the search button in the top-right of the UI

  59. Type "Batch-0001" in the search bar's text field

  60. Click "BATCH-0001"

  61. Click "New Revision"

  62. Disable "Copy part list from source revision"

  63. Click the "Revision Name" field.

  64. Type "WK#27" (the given week number of the production lot you are working with)

  65. Click the Create button

  66. Click the BOM tab's drop-down menu.

  67. Click "Part List"

  68. Click "Import CSV"

  69. Click "Drag a file here to upload, or choose a file from your computer"

  70. From your computer's file explorer, navigate to and select the .CSV previously downloaded from Google Sheets

  71. Map Part Number to "Column 1 (BASE SKU)"

  72. Map QUANTITY to "Column 2 (SUM of Item - Qty)"

  73. Click "Match Parts & Move to Step 3"

  74. Perform the following two steps on this page:

    1. Select the "Add to working partlist" import option
    2. Click "Import Parts"

  75. You will be returned to the BOM (Part List) view

  76. Remove any errant items by clicking the "Red X" in the Actions column of the Part list

    • It's important to remove any items from this list that may have already been previously removed from inventory – sometimes replacement parts shipped fast can be guilty of this

  77. Click "Yes" to remove anything that shouldn't be accounted for

  78. Click "Release this Revision"

  79. Click "Release Revision"

  80. Click "New Build"

  81. Click "Create a single build"

  82. Click the "Title" field.

  83. Type "Build for non-serialized goods made during WK #27" (27 for example)

  84. Click the "Build Quantity" field.

  85. Type "1"

  86. Enable "DRILL-DOWN PARTLIST"

  87. Click the "Expected Reservation Date" field and set it to the day the production lot began

  88. Click the "Expected Completion Date" field and set it to the date the production lot is scheduled to be completed

  89. Click "Create Build"

  90. Click "Allocate..."

  91. Click "Allocate" from the pop-up window

  92. Click "Reserve Inventory..."

  93. Click "Reserve"

  94. Click "Parts"

  95. Confirm all material has been properly reserved before navigating to the "Finalize" tab

  96. Disable "Add final assembly to inventory"

  97. Pick "Computed Price ($####.##)" as selected "Record Cost As" option

  98. Click "Finalize Build..."

  99. Click "Finalize Build"

  100. Click "Parts"

  101. Confirm all parts have been removed