Refurbed Account Integration

Overview

Refurbed is an Austrian-based online marketplace that sells refurbished electronic devices, such as smartphones, laptops, and tablets. Their platform ensures products undergo a thorough inspection and restoration process before being sold.

Integrating Refurbed into your Sellercloud account allows you to seamlessly import orders, upload tracking information, and ensure your Refurbed store is always up-to-date with the latest inventory data. The integration works through API, transmitting information between the two services via plugins and Scheduled Tasks.

If necessary, you can contact Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

---

Prerequisites

Before you can integrate Refurbed with Sellercloud, complete the following requirements.

Sellercloud Support

Open a ticket with Sellercloud Support and request the following plugins be installed on your server:

• Refurbed API Order Import – Imports orders from Refurbed to Sellercloud.
• Refurbed API Order Tracking Export – Exports tracking information to Refurbed.
• Refurbed Inventory Export – Exports inventory to Refurbed.

Custom Company Settings

Create the following Custom Company Settings on the company created for the integration:

• Refurbed API Key – Your unique API key for establishing the connection. Contact their support team for assistance with generating it.
• Refurbed API URL – Set to https://api.refurbed.com.
• Refurbed API orders index – Leave the value field of this setting blank. The setting will auto-update with the ID of the latest imported order. You can delete the value to re-import orders, as the plugin will only import orders after this index.
• (Optional) Refurbed Warehouse IDs – A list of Warehouse IDs from which the Inventory Export plugin will export product quantities to Refurbed.
• (Optional) Refurbed Send Pricing – Choose whether to send pricing to be updated on Refurbed. You can set it to True or False, and it defaults to True.

Custom Product Columns

Create the following Custom Product Columns:

• REFURBED_MERCHANT_SKU – Sellercloud matches products on Refurbed to the value in this column. If it fails, then it tries to match the SKU (ProductID). Set the Data Type to String. 
• REFURBED_DE_PRICE – Sets the product’s price on Refurbed. Set the Data Type to Decimal. 
• REFURBED_MIN_PRICE – Sets the product’s minimum price on Refurbed. Set the Data Type to Decimal. 
• REFURBED_TAX – Sets the product’s tax type. The value can be GROSS or MARGINAL. Set the Data Type to String.
• REFURBED_SAFETY_QTY – A Safety Quantity for products on Refurbed. Set the Data Type to Integer. 
• (Optional) Refurbed_Enabled – Optional column used to enable only specific products for Refurbed. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.

Custom Order Columns

Create the following Custom Order Columns:

• Refurbed_SettlementBaseCommission – The base commission amount on the Refurbed settlement. Set the Data Type to Decimal. 
• Refurbed_SettlementPayoutCommission – The payout commission associated with the Refurbed settlement. Set the Data Type to Decimal. 
• Refurbed_SettlementTotalCommission – The total commission amount on the Refurbed settlement. Set the Data Type to Decimal. 
• RefurbedUserEmail – The email address associated with the Refurbed user. Set the Data Type to String.
• RefurbedTransactionID – The ID of a transaction on Refurbed. Set the Data Type to String.

---

Order Import

This plugin imports order data from Refurbed to Sellercloud.

Automate Order Import

To create a Scheduled Task that imports orders:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Import Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The newly created Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click Create Orders For Company and select the company designated for this integration.
   2. Click the Plugin menu and select Refurbed API Order Import.
6. In the Import Options panel, set Import From to None.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
   
9. Click Save.

---

Tracking Export

This plugin exports tracking from Sellercloud to Refurbed.

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Status – InProcess Or Completed
• Shipping Status – FullyShipped
• Payment Status – Charged
• Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that exports order tracking:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Export Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. On the Scheduled Task page, click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your ID.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Refurbed API Order Tracking Export.
   4. Check This Is Tracking Export.
6. In the Export Options panel, set Export To to None.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable toggle button.
   
9. Click Save.

---

Inventory Export

This plugin exports inventory quantities and prices from Sellercloud to Refurbed.

Optionally, you can enable only specific products for Refurbed by setting their Refurbed_Enabled Custom Column for Products to True:

• For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the Refurbed_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the Refurbed_Enabled column – set it to True for all products you want to enable.

Unlike core integrations, plugin integrations don’t require products to be in the company with the scheduled tasks. The export will include the products you select with your Saved Search.

Next, create a Saved Search for products filtered by Refurbed_Enabled – True. Optionally, you can add more filters to the search to further narrow the export.

Automate Inventory Export

To create a Scheduled Task that exports inventory:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Export Products.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. On the Scheduled Task page, click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your ID.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Refurbed Inventory Export.
6. In the Export Options panel, set Export To to None.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable toggle button.
   
9. Click Save.

---