Back

Chewy Inventory Upload - Manual File Upload in Portal

By: Karianne Muckle

Manual File Upload in the Portal

There are two ways to upload inventory files, with either the Chewy standard flat files or by creating a data map so that the Dsco platform can import files with your own structure.

NOTE: Chewy requires that you also enter information for the following fields for each item.

  • UPC
  • Warehouse Code
  • Warehouse Quantity

Template Formats

Use one of the following template formats to help you get your items uploaded into the Dsco portal.

  • Dsco Standard Catalog Template
    This option allows you to manage files for your account straight from the Dsco portal. The template includes mandatory Dsco fields as well as additional fields your trading partner may require.

 

    1. Download a copy of the Dsco Catalog Template by clicking here. To view expanded definitions of the Dsco Data Schema, please click here.
    2. Include at least 3 items that each have 11 units of positive quantity. If you don’t have these items and/or quantities on hand, you can load some test SKUS for testing purposes and change/remove the SKUs later.
      Important: After filling in the template, be sure to delete the colored instructional header rows to avoid getting errors in your upload results.
    3. Once you have filled out the template with your data, click the orange Guide Me button above to get a guided walkthrough and instructions on the rest of the upload process.
  • Custom Data Mapped Template</4>
    This option allows you to map your data to Dsco’s specifications and create a custom file by using the Data Mapper tool. For more information about how to use the Data Mapper tool, please refer to this article.
    1. Reach out to dscopartnersetup@commercehub.com to get access to the Data Mapper tool.
    2. Include at least 3 items that each have 11 units of positive quantity. If you don’t have these items and/or quantities on hand, you can load some test SKUS for testing purposes and change/remove the SKUs later.
    3. Once you’ve set up the data map, fill out your customized file and then click the orange Guide Me button above to get a guided walkthrough and instructions on the rest of the upload process.

Confirming Upload Results

Once you’ve filled out and uploaded the file format of your choice:

  1. Check the upload results in your Automation History to determine whether it was successful or contained any errors. Click the orange Guide Me button above to get a guided walkthrough and instructions on how to check upload results.
    Note: For more information about understanding error messages in the Dsco portal, please review this article.
  2. Once you have submitted a successful file, please click the VERIFY INVENTORY UPLOAD button below to proceed to the next step.

 

File Transaction History

A powerful feature in Dsco is the ability to view the history of any file processing in Dsco. This goes for all manual or automated uploads or downloads. You can use it now to see if the file you sent Dsco was properly loaded onto the platform. To check your automation history, select Automation in the main navigation and then select History, or just click here.

On this page, you will see a list of all the processes that have run on your account. On the left side are options to filter the list on the right. One of the most useful is the Did Work checkbox. Selecting this checkbox will filter the list to show only processes that actually performed some type of work importing inventory or exporting orders.

You may see the top process in the list has a Status of Queued, Running, or Finished. If you refresh the page, you may see the status change depending on the state of the process. Some processes may take a couple of minutes to complete if there are many records being processed. Once you see the Status is Finished you can see a summary of the Result of the process —- how many records were Successful, Failed or Ignored —- on the far right side. Click the Finished/Failed link and you will see the specific result of each record in the process. If they were not successful, the history will tell you exactly what failed and why. Contact onboarding support at dscopartnersetup@commercehub.com if you have questions about failures you see.

Inventory Upload Test

Once you have successfully added at least three items, all with a quantity of 11 or more, please click the button below and I will validate your inventory.