There are times where you need to remove an item from your inventory. However, the Dsco platform doesn’t allow you to delete items from your inventory, especially if those items have already been ordered previously. The solution highlighted below will help you hide the items without actually deleting that item from your inventory. You can upload a series of CSV documents that can set the Status of the inventory to hidden.
Follow the steps below to hide unwanted items in your Dsco account.
Step 1: Log into your Dsco account. You can go to this link: https://app.dsco.io to get to the login page for your Dsco account.
Step 2: From the lefthand navigation bar, select INVENTORY.
Step 3: In the top righthand corner of the screen, select DOWNLOAD ALL RESULTS.
Step 4: Select the Comma option and then click the INVENTORY button. This will start the download of a spreadsheet of all of your inventory as it currently exists in Dsco.
Step 5: Once the file finishes downloading, open it for editing on your computer using Excel or another spreadsheet program.
You may need to go to the Downloads folder on your computer to do this. The file you will want to open uses this filename structure: Dsco_Inventory_YYYYMMDDSS.csv
When opened it should look something like the spreadsheet below:
Make sure you completely delete all unused columns from the report. Removing those extra columns helps ensure that only the data you're attempting to change is actually updated.
Step 6: Remove all data in the upc, ean, partner_sku, and partner_sku_map columns.
Step 7: Change the values in the quantity_available, warehouse_quantity_1(if populated), warehouse_quantity_2 (if populated), and warehouse_quantity_3 (if populated) to 0 for all items.
Step 8: Change the status column for all items to out-of-stock.
Make sure that you include the hyphens in out-of-stock if you don't the upload will fail.
The video below shows how to edit your Inventory Report. Make sure that you save the file as a .csv filetype.
Step 9: Save the file, go back to Dsco, and click WORKFLOWS and select INVENTORY.
Step 10: Click Upload File on the right-hand corner of the window
Step 11: Choose the Comma option. Click the Choose File button and then select the file that you just saved. Click the Upload button to start the upload.
Step 12: Select the Click Here to View Upload Progress button to check on the status of your file upload. The link will redirect you to the AUTOMATION HISTORY page in dsco. You can reach that page at any time by going to this link: https://app.dsco.io/automation/history
Step 13: Check the progress of the upload. The top row of the table on that page should be the upload process you just initiated. The Job Name is Dsco Catalog Upload.
When the Status of the job is Finished that means the file has been uploaded and the inventory has been updated. You may need to refresh the page multiple times to see the Status update to Finished.
You can also click on the Finished text to get directed to the logs page for that process. This can be helpful if there are failures that occurred during the process.
Head to the INVENTORY tab to review your changes. You will see that the items were updated to have 0 Quantity and are listed as out-of-stock.
Step 14: Back on your inventory report, now change the status values for all items to hidden, and save the document.
Step 15: Repeat steps 10-13 to upload the file into Dsco.
Once the file has finished processing you can view your inventory by clicking on the INVENTORY tab, and see that the items have been updated to have a hidden status.
This process is necessary to make sure that Dsco does not detect any UPCs, Partner SKUs, or other identifiers as duplicates when you attempt to create new inventory. Once the process is complete, you will be able to update/create inventory items using that old information and you will not have any failures. This process also removes the items from being viewable by your retailer.
If you have any questions don't hesitate to reach out to firstname.lastname@example.org or initiate a live chat and one of our support representatives will assist.