Overview
Chewy, Inc. is an American online retailer of pet food and other pet-related products. Sellercloud connects to Chewy through DSCO’s platform by utilizing custom-built API plugins. You will need to obtain an API Token, Supplier Account ID, API Username, and Warehouse Supplier Code from DSCO for this account integration.
Prerequisites
To successfully connect your Chewy account, you will need to connect to DSCO via the below plugins:
- DSCO API v3 Order Import
- DSCO API v3 Tracking Order Export
- DSCO API v3 Inventory Export
- DSCO API v3 Invoice Export
Reach out to the Sellercloud support team to have these plugins installed on your server. You will need to have your Chewy account connected to your DSCO account prior to initializing the setup in Sellercloud.
Integrate with Chewy through DSCO
To configure your Chewy account in Sellercloud, you will first need to contact DSCO to receive your Token, Supplier Account ID, API Username, and Warehouse Supplier Code. To get a Warehouse Supplier code, you must set up a warehouse in DSCO.
- Connect with a DSCO Integrations team member and log into your DSCO account.
- Click CONNECTING: Step 1 and continue through the onboarding and testing processes.
The Warehouse Supplier Code is chosen by you during the onboarding process. It can be created on your Warehouse Manager page in the DSCO portal.
Following the plugin installation, it is necessary that you create channel-specific custom columns in Sellercloud. You can reach out to our Support team to have them created for you on the backend. For example, a Chewy_Enabled custom product column can have True or False values. This will allow you to filter and work with specific products that you will sell on Chewy and exclude all others.
Next, you will need to create the following custom settings under the company in which the integration will be set up. To create the relevant custom company settings, navigate to Settings > Company > Toolbox > Custom settings.
Refer to the tables below for a definition of each setting:
| SETTING NAME | DESCRIPTION |
| ORDER-RELATED COMPANY SETTINGS | |
| DSCO_Token (required) | The API token used to connect. Can be requested from the DSCO support. |
| DSCO_SupplierId (required) | Your Supplier ID – provided by DSCO |
| DSCO_SupplierName (required) | Your Supplier Name – provided by DSCO |
| DSCO_ExportSsccCode (optional) | True or False, if true, exports the SSCC code with the tracking |
| DSCO_IntegrationName (optional) | Can be set as a Sellercloud channel name; The order source will appear as the set channel name |
| DSCO_MarkOrdersUnpaid (optional) | True or False; If true, sets the order as “unpaid” |
| DSCO_LockShippingMethod (optional) | True or False; If true, does not allow shipping methods on orders to be changed |
| DSCO_IncludeWarehouseCodesInOrderImport (optional) | True or False; If true, sets the “Ship From” warehouse with the order import; Checks setting “DSCO_WarehouseCodes” for the codes |
| DSCO_WarehouseCodes (optional) | List of Sellercloud WarehouseIDs and DSCO warehouse codes (connected by a hyphen), separated by a comma. for example: 144-MyDSCO Warehouse, 145-My OtherWH. |
| DSCO_ShippingRequiresThirdPartyBilling (optional) | True or False; If true the order ShippingRequiresThirdParty will be set to true |
| DSCO_AllowShippingUSPS (optional) | True or False, if true, and DSCO_ShippingRequiresThirdPartyBilling is True, and the order’s carrier is USPS, we will NOT set ShippingRequiresThirdParty to “true” |
| DSCO_AllowShippingUPS (optional) | True or False, if true, and DSCO_ShippingRequiresThirdPartyBilling is True, and the order’s carrier is UPS, we will NOT set ShippingRequiresThirdParty to “true” |
| DSCO_CreatePayments (optional) | Defaults to true if missing. Determines if an order payment will be imported or not based on the setting value for the order channel (defaults to Website but can be changed by using company setting DSCO_IntegrationName). |
| DSCO_StandardWarehouseCode (optional) | DSCO’s standard Warehouse code exported with the tracking |
| DSCO_IncludeWarehouseCodeInTracking (optional) | True or False, if true, sends the DSCO standard warehouse code from the custom setting “DSCO_StandardWarehouseCode” |
| DSCO_SendOnePackagePerKitParent (optional) | True or False, if true, each kit parent will be in a separate package |
| DSCO_SendKitParentOnly (optional) | True or False, if true, only sends the parent SKU with the tracking without the components |
| DSCO_SendShipFromInfo (optional) | True or False, if true, sends Ship from information with the tracking export |
| DSCO_SendPackageWeight (optional) | True or False, if true, sends the package weights with the tracking export |
| DSCO_SendInvoiceDate (optional) | True or False, if true, sends the Invoice date |
| DSCO_SendCurrencyCode (optional) | True or False, if true, sends the exported order’s currency code |
| DSCO_NetTermDays (optional) | Numeric only; sends NetTermDays with the invoice export |
| DSCO_NetTermType (optional) | Exported when DSCO_NetTermDays exists and isn’t 0 |
| DSCO_SendShipToInfo (optional) | True or False, if true, sends the “ShipTo” information with the invoice export |
| DSCO_SendSubtotal (optional) | True or False, if true, enables exporting order line subtotal with the invoice export |
| SETTING NAME | DESCRIPTION |
| CUSTOM PRODUCT COLUMNS | |
| DSCOItemID (required) | If empty, the SKU will be skipped in the update unless the custom setting DSCO_DontSendItemID is set to true. |
| DSCOSafetyQty (required) | If populated, Sellercloud will subtract the safety quantity from the total quantity of the product when sending inventory to Chewy. |
| DSCOIsDiscontinued (required) | True or False, defaults to False; When set to true, exports the item with a Discontinued status. |
| DSCOEXPECTEDDELIVERYDATE (optional) | Used when company setting DSCOUseExpectedDeliveryDate is enabled. Exports a date that’s a week ahead when missing or disabled. |
| DSCOCost (optional) | Sent when the company setting DSCOSendCost is set to true. |
| DSCOPartnerSKU (optional) | If this column exists and is populated, sends as partner SKU. |
| PRODUCT AND INVENTORY CUSTOM COMPANY SETTINGS | |
| Consider replenishable products (optional) | True or False, defaults to False; If true, works with Replenishable qty |
| Replenishable qty (optional) | Qty that will be exported if available qty is 0 or less; Only works if “Consider Replenishable Products” is set to True |
| DSCOUseExpectedDeliveryDate (optional) | True or False, defaults to False; When set to true, exports custom column DSCOEXPECTEDDELIVERYDATE. If missing or disabled, the exported date will be a week ahead |
| DSCO_WarehouseCodes (optional) | List of Sellercloud WarehouseIDs and DSCO warehouse codes (connected by a hyphen), separated by a comma. Example: Sellercloud warehouseID-DSCOWarehouseCode, 123-Lakewood, 245-BostonWH |
| DSCO_WarehouseCode (required) | DSCO warehouse code used by default when DSCO_WarehouseCodes has no value |
| DSCO_DontSendItemID (optional) | True or False, defaults to false. When set to true, inventory updates will not include ItemID and DSCO will match to the SKU instead |
| DSCOSendCost (optional) | True or False, defaults to false. When set to true, sends custom column DSCOCost |
| DSCO_SendDiscontinued (optional) | True or False, defaults to false. When set to true, sends custom column DSCOIsDiscontinued. |
| DSCO_SendUPC (optional) | True or False, defaults to false. When true, sends UPC with the inventory export. |
Populate the API credentials and Warehouse Code you have obtained from the DSCO support team in the designated custom company settings.
Next, you must create a scheduled task for each plugin type. Create and set up Saved Searches for the Order Export and Product Export task types and assign them accordingly. Learn more about saved searches here.
Automate Order Import, Tracking, and Inventory Export
In order to ensure a seamless integration, you will need to automate the order imports, tracking, and invoice exports, along with the inventory updates. To do that, you will need to create scheduled tasks for each plugin type.
Automate Order Import
Navigate to your desired company > Scheduled Tasks > Press the green + icon at the right bottom corner to Create New Scheduled Task. A pop-up will appear. Follow these steps to create a scheduled task that regularly imports orders:
- Choose the Task Type (Import Orders), Task Name, Company, and Start Time. The start time includes a calendar date and time. You can select both values from the Calendar and Time View pop-ups. Enter the information required > Create.
- Go to the Details panel > Create Orders For Company > Choose the company from the drop-down menu and select the appropriate DSCO API v3 Order Import plugin.
- Navigate to the Import Options and choose None from the drop-down.
- Specify the task frequency. Schedule the task to recur at your desired intervals.
The frequency of the tasks should range between thirty minutes to an hour to ensure optimal performance.
- Click on the Toggle button to enable the task.
Automate Tracking and Invoice Export
Navigate to your desired company > Scheduled Tasks > Press the green + icon at the right bottom corner to Create New Scheduled Task. You will need to create two separate Order Export tasks for each of these transactions. This task type requires a saved search for orders. Learn more about creating saved searches here.
Follow these steps to create scheduled tasks that regularly export orders:
- Choose the Task Type (Export Orders), Task Name, Company, and Start Time. The start time includes a calendar date and time. You can select both values from the Calendar and Time View pop-ups. Enter the information required > Create.
- Go to Details panel > User ID > Select the ID of the account where the Saved searches were created.
- From the drop-down menu > Select the respective searches for the task.
- Go to Export via > Select the appropriate plugin/s from the drop-down menu.
- Enable the settings This Is Tracking Export for the Tracking Export task
and This Is Invoice Export for the Invoice Export task.
- Go to the Export Options and choose None from the drop-down.
- Specify the task frequency. Schedule the task to recur at your desired intervals.
The frequency of the tasks should range between thirty minutes to an hour to ensure optimal performance.
- Click on the Toggle button to enable the task.
Automate Inventory Export
You can export the inventory of selected products and send it to Chewy. If you have the custom DSCOItemID column populated, that value will be sent instead of Sellercloud’s Product ID. If DSCOSafetyQty is available, that Safety Quantity will be subtracted from the available inventory. This task type requires a saved search for products. Learn more about creating saved searches here. Optionally, if you don’t sell all of your products on Chewy, you can filter by specific custom columns based on your preference.
Follow these steps to create a scheduled task that regularly exports inventory:
- Choose the Task Type (Export Products), Task Name, Company, and Start Time. The start time includes a calendar date and time. You can select both values from the Calendar and Time View pop-ups. Enter the information required > Create.
- Go to Details panel > User ID > Select the ID of the account where the Saved search was created.
- From the drop-down menu > Select the respective search for the task.
- Go to Export via > Select the DSCO API v3 Inventory Export plugin from the drop-down menu.
- Navigate to the Export Options and choose None from the drop-down.
- Specify the task frequency. Schedule the task to recur at your desired intervals.
The frequency of the tasks should range between thirty minutes to an hour to ensure optimal performance.
- Click on the Toggle button to enable the task.
Note: All DSCO scheduled tasks of type Export should be set to Export to > None since they’ll be using a direct server-to-server connection via API.
Cancel a Chewy Order
You can only cancel an order before it is marked Ship Confirmed. If it is already Ship Confirmed, you must issue a refund.
To cancel an order:
Navigate to Orders > Manage Orders > Open an order > Actions menu > Set Cancelled Internally.