This is the fastest option for creating or updating a lot of SKUs very quickly. To create SKUs, simply download the Dsco Product Excel Template file, enter your SKU information in Excel, and then upload the file through the Dsco portal. To update existing SKUs, simply download your existing inventory, make changes, then upload the file through the Dsco portal. 

Creating New Inventory

Follow the instructions below to create your SKUs through the Dsco portal using a Dsco Excel file:

Step 1: Select the INVENTORY link at the top of the Dsco portal after logging in.

Step 2: Select the Upload File button at the top.

Step 3: Select one of the green buttons below Dsco Standard Templates to download the template files in Excel format.

For convenience, the links to the templates are provided below:

Once you've saved one of the template files to your computer you can open that file in Excel or your favorite spreadsheet program and populate it with your SKU information.

Using batch files with Dsco allows you to upload as many SKUs as you like at once. The Excel template has several rows at the top of the spreadsheet that provide details on what information is required for each field. For example, you should pay attention to the fields that have an orange background as they are required for the spreadsheet to process correctly in Dsco. 

Step 4: When you are happy with the details you've provided, save the Excel file and then go back to the Dsco portal where you can select the Choose File... button to select the Excel file you just updated.

Step 5: Select the Upload button.

As soon as you select the Upload button, Dsco will start processing the data found in the Excel file. 

Update Existing Inventory

Follow the steps below for updating existing inventory through the Dsco portal using a Dsco Excel file:

Step 1: Select the INVENTORY link at the top of the Dsco portal after logging in.

Step 2: Select the Download All Results button on the top right of the page.

Step 3: Select your preferred file format, then select one of the green buttons Inventory, Product or Catalog to download your inventory. Remember that all three green buttons download your item information, but Inventory provides the narrowest set of data and Catalog provides the widest set of data. For example, if you are updating just the quantity or the status, these are essential item details so the narrow Inventory download will contain that information. If you are updating non-essential details, such as warehouse location or handling cost, use the wider Catalog download so that these extra details are included in your downloaded file.

Step 4: Open the newly-downloaded Excel file and make your changes. When you are happy with the details you've provided, save the Excel file and then go back to the Dsco portal where you can select INVENTORY then the Upload File button:

Step 5: Select the Choose File button to select the Excel file you just updated, then click the green Upload button.

As soon as you select the Upload button, Dsco will start processing the data found in the Excel file:

Upload Process Logs

If you don't see your updates appear within the INVENTORY area of the Dsco portal within a couple of minutes, you may need to review the logs for the upload. You can review the logs for all of your jobs on the HISTORY tab under AUTOMATION (https://app.dsco.io/automation/history). Go here for more information on reviewing your job history.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.