Michaels Account Integration

Overview

Michaels is an American arts and crafts retail chain and online store selling various arts and crafts supplies, including paints, yarn, frames, beads, and more. Sellercloud connects to Michaels by utilizing custom-built API plugins.

Prerequisites

To integrate your Michaels account, you must configure and connect these plugins to their API:

• Michaels API Inventory Export
• Michaels API Order Tracking Export
• Michaels API Order Import

Follow these steps:

1. Reach out to the Sellercloud Support team to have the plugins installed on your server. 
2. Obtain a Michaels API key. You can visit this link to Michaels to create and access the API key.

Integrate with Michaels

Following the plugin installation, it is recommended to create channel-specific custom product columns. You can reach out to our Support team to have them created for you on the backend. For example, a MichaelsEnabled custom column can have True or False values. This will allow you to filter and work with specific products that you will sell on Michaels and exclude all others.  Refer to the table below for a definition of each setting:

Next, you must create a custom company setting under the designated company and grant Sellercloud API access. To do that: 

1. Navigate to Settings > Companies > Manage Companies > click the Company.
2. Click Toolbox > Custom Settings.
3. In the Custom Settings section, click the Add New Custom Setting + icon.
   
4. Enter “MichaelsAPIKey” into the Setting Name field.
5. Enter the Michaels API key from the prerequisite steps in the previous section into the Setting Value field.
6. Click Save.
   

Automate Order Import, Tracking, and Inventory Export

To ensure a seamless integration, you must automate the data transfer by creating scheduled tasks for each plugin type.

Create a Scheduled Task for Order Import

Follow these steps to create a scheduled task that regularly 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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the Create Orders For Company menu and select the company.
   2. Click the Plugin menu and select Michaels API Order Import.
7. In the Import Options section, set Import From to None.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable button.
10. Click Save on the top right.
    

Create a Scheduled Task for Tracking Export

Tracking information will be sent to Michaels on a regular basis once an order is marked as shipped. Orders without tracking information should not be included in this export.

This task type requires a saved search for orders. Learn more about creating saved searches here. When creating your saved search, it is recommended to filter by Company, Order Status: In Process or Completed, and Delivery Status: Shipped. Optionally, you can also filter by Payment Status and add more filters based on your preference.

Next, follow these steps to create a scheduled task that regularly exports order tracking to 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 Export Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click Create.
4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   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 Michaels API Order Tracking Export.
   4. Check the This Is Tracking Export box.
7. In the Export Options section, set Export To to None.
8. 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.
9. In the General section, click the Enable toggle button.
10. Click Save on the top right.

Create a Scheduled Task for Inventory Export

You can export the inventory of selected products and send it to Michaels. If you have a custom MichaelsSKU column available, it will be sent instead of Sellercloud’s Product ID. If MichaelsSafetyQty 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 Michaels, you can filter by the custom column created earlier, called MichaelsEnabled. You can also add more filters based on your preference.

Follow these steps to create a scheduled task that regularly exports inventory to 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 Export Products.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click Create.
4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the Saved Search menu and select the saved search you created earlier.
   2. Click the Export Via menu and select Michaels API Inventory Export.
7. In the Export Options section, set Export To to None.
8. 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.
9. In the General section, click the Enable button.
10. Click Save on the top right.