Skip to content

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

Export Item Removal List from ShipStation

  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" and save the file somewhere you can easily it on your computer

Prepare sanitized item removal .CSV

  1. Navigate to Weekly Aligni Item Removals - Google Drive

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

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

  4. Click "Make a copy"

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

  6. Click "Rename"

  7. Click this text field.

  8. Click this text field.

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

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

  11. Type "27" (for example)

  12. Click "OK"

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

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

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

  16. Click "WK ## FROM SHIPSTATION"

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

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

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

  20. Click "Rename"

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

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

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

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

  25. Select Cell "A1"

  26. Click "File"

  27. Click "Import"

  28. Click "Upload"

  29. Click "Browse"

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

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

  32. Select "Replace data at selected cell"

  33. Select "Import data"

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

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

  36. Click on the Pivot Table

  37. Select the "Edit" pop-up button

  38. Edit the filtered "BASE SKU" list

  39. Click "Clear" to deselect all SKUs

  40. Click "Select all"

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

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

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

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

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

  46. Click here to exit the Pivot table editor

  47. Click "File"

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

Removal items from inventory in Aligni

Up-Rev the Removal Batch Item

  1. Navigate to opulo.aligni.com

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

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

  4. Click "BATCH-0001"

  5. Click "New Revision"

  6. Disable "Copy part list from source revision"

  7. Click the "Revision Name" field.

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

  9. Click the Create button

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

  11. Click "Part List"

  12. Click "Import CSV"

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

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

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

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

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

  18. Perform the following two steps on this page:

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

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

  20. 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

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

  22. Click "Release this Revision"

  23. Click "Release Revision"

Make a 1pcs Build for the Removal Batch Item

  1. Click "New Build"

  2. Click "Create a single build"

  3. Click the "Title" field.

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

  5. Click the "Build Quantity" field.

  6. Type "1"

  7. Enable "DRILL-DOWN PARTLIST"

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

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

  10. Click "Create Build"

  11. Click "Allocate..."

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

  13. Click "Reserve Inventory..."

  14. Click "Reserve"

  15. Click "Parts"

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

  17. Disable "Add final assembly to inventory"

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

  19. Click "Finalize Build..."

  20. Click "Finalize Build"

  21. Click "Parts"

  22. Confirm all parts have been removed