Chewy Account Integration

Created September 21, 2020
Updated date January 26, 2023
Author Patricia H.
Category Chewy
Views: 2853
0

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.

It is recommended to have a company designated for this integration where the company settings and relevant scheduled tasks would be set up.

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.

DSCO may require you to perform testing before you could go into production with the integration. This involves completing test orders, invoices, and inventory uploads according to the DSCO-provided test plan. If you would like a dedicated representative to complete the testing for your account and ensure that the setup is configured accordingly, we recommend opting in for Premium Support.

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:

Order-related Company Settings

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

Product-related Company Settings and Custom Columns

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 taskand 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.

Note that this action will only cancel the order on Sellercloud and not on DSCO.

Tagged: Chewy

Was this article helpful?

Yes No

Need Support?

Can't find the answer you're looking for?

Contact Support