Retrieving and Removing Serial Numbers

Here's how you retrieve serial numbers into an Excel file and remove them from Solid Commerce.

To learn how to enable or add serial numbers, see Enabling Serial Number Functionality and Adding Serial Numbers to Items.

 

Downloadable Template for Retrieving Serial Numbers
A template for retrieving serial numbers into Excel is attached to the bottom of this article.

 

What we'll cover:

  1. Retrieving Serial Numbers for Specific Products into an Excel File
  2. Retrieving All Serial Numbers from a Warehouse Into an Excel File
  3. Removing Serial Numbers from Solid Commerce
  4. Related Articles
  5. Downloadable Template for Retrieving Serial Numbers

 

Retrieving Serial Numbers for Specific Products Into an Excel File

1) Open the template attached to this article.

  • You can also use your own file, just be sure to include these minimum required columns: results, warehouse id, warehouse name, and serial number.

2) Enter their Warehouse IDs into the warehouse id column.

  • Provide each Warehouse ID only once, even if it has multiple serial numbers assigned to it.

3) Provide a warehouse name for each Warehouse ID.

inventory_management_retrieving_specific_serial_numbers_excel_v2.png

 

4) Click on the Retrieve Serial Number button in the Solid Commerce menu. Enter your Solid Commerce credentials.

5) Select the Retrieve serial number for existing warehouse ID radio button.

6) Click the Continue button.

inventory_management_retrieving_specific_serial_numbers_excel_pop-up.png

 

During the retrieval, if any product has multiple serial numbers, its Warehouse ID will automatically populate onto additional rows. Each row will include one serial number.

inventory_management_retrieving_specific_serial_numbers_excel_results.png

 

Retrieving All Serial Numbers from a Warehouse Into an Excel File

1) Open the template attached to this article.

  • You can also use your own file, just be sure to include these minimum required columns: results, warehouse id, warehouse name, and serial number.

2) Ensure all the cells below the column headers are empty.

inventory_management_retrieving_all_serial_numbers_excel_v2.png 

 

3) Click on the Retrieve Serial Number button in the Solid Commerce menu. Enter your Solid Commerce credentials.

4) Select Retrieve serial number from a specific vendor or warehouse list.

5) Click the Continue button.

inventory_management_retrieving_all_serial_numbers_excel_pop-up.png 

 

All items with serial numbers will automatically be retrieved into your spreadsheet. Items that do not have serial numbers assigned to them will not be retrieved.

 

Removing Serial Numbers from Solid Commerce

Serial numbers must be removed through our user interface. At this time, there is no way to remove serial numbers through a spreadsheet.

If you made a mistake entering a serial number, remove it before adding the correct serial.

To remove a serial number:

1) Find your product in its Warehouse or Vendor Inventory List.

2) Hover over the rectangular Serial Numbers icon on the right-hand side of the Serial Number Tracking cell.

3) Click on the manage serial numbers button in the pop-up.

inventory_management_manage_serial_numbers_button_ui.png 

 

4) Check the box to the left of the serial number you want to remove.

5) Click the Delete button.

inventory_management_serial_numbers_delete_button_ui.png
 

 

Related Articles

 

Back to top

Downloadable Template for Retrieving Serial Numbers

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.