Michaels Account Integration

Overview

Michaels is a U.S. retailer that specializes in arts and crafts supplies, offering products for a wide range of creative hobbies, from painting and sewing to home décor and seasonal items. It caters to DIY enthusiasts, providing tools, materials, and inspiration for various craft projects and creative needs.

Integrating Michaels into your Sellercloud account allows you to seamlessly import orders, upload tracking information, and ensure your Michaels 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 open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

---

Prerequisites

Before you can integrate with Michaels, complete the following requirements.

First, obtain a Michaels API key from your active Michaels Developer Account.

Sellercloud Support

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

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

Custom Company Settings 

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

• MichaelsAPIKey – Enter an API token from your Michaels Developer Account to connect your Michaels account to Sellercloud.
• (Optional) MichaelsUseProduction – Set it to False to use Michaels’ sandbox environment. If the setting doesn’t exist or is set to True, the integration will be established with Michaels’ production environment.
• (Optional) MichaelsCommissionPercent – Add a decimal value to apply a commission percentage to your Michaels orders.
• (Optional) MichaelsDefaultFixedQty – This only applies to Replenishable Products. For these products:
  • If MichaelsFixedQty > 0, send that as available qty.
  • If MichaelsFixedQty = 0, check if MichaelsDefaultFixedQty > 0, and send that as the available qty.
  • If both = 0, send the actual available qty.
• (Optional) MichaelsEnablePriceUpdates – Set to True to export price updates.
• (Optional) MichaelsDontImportTax – Set to True to import tax amounts.

Custom Product Columns

Create the following Custom Product Columns:

• MichaelsSKU – If populated, the value will be used instead of the default Sellercloud SKU when mapping products. The MichaelsSKU needs to match the value of the Seller SKU on the Michaels listing.
• MichaelsSafetyQty – Set a Safety Quantity to subtract from the actual available quantity when sending inventory to Michaels.
• (Optional) MichaelsEnabled – Enable only specific products for Michaels. Set to True for any products you want to send with the Inventory Export plugin.
• (Optional) MichaelsFixedQty – Send a fixed inventory quantity for a product.
• (Optional) MichaelsPrice – This column works only if the Custom Company Setting MichaelsEnablePriceUpdates is set to True. If the MichaelsPrice is 0 or doesn’t exist and MichaelsEnablePriceUpdates is set to True, the product’s Site Price will be sent instead.

---

Order Import

The Michaels API Order Import plugin imports orders with a PENDING_CONFIRMATION status on Michaels and sends a confirmation when an order is successfully imported by changing its status to READY_TO_SHIP. 

Automate Order Import

To create a Scheduled Task that imports orders from Michaels:

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. On the Scheduled Task page, 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 Michaels 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

The Michaels API Order Tracking Export plugin exports tracking information to Michaels. It will skip any orders that don’t have a Carrier or tracking information.

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 email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Michaels 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 from Sellercloud to Michaels.

It will also export price updates if you set the MichaelsEnablePriceUpdates Custom Company Setting to True. If the Custom Product Column MichaelsPrice is 0 or doesn’t exist, the product’s Site Price will be used instead.

If your products have a value in the MichaelsSKU column, it will be sent instead of the Sellercloud SKU (ProductID). If a MichaelsSafetyQty value is available, that Safety Quantity will be subtracted from the available inventory.

Optionally, you can enable only specific products for Integration by setting their MichaelsEnabled Custom Product Column to True:

• For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the MichaelsEnabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the MichaelsEnabled 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 MichaelsEnabled – True. Optionally, you can add more filters to the search to narrow down the export further.

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 email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Michaels API 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.

---