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. The integration between Sellercloud and Michaels is established via the following custom-built API plugins:

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

You can contact Sellercloud Support to request the installation of the above plugins, or to explore additional customizations of this integration. 

To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

Prerequisites

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

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.

Obtain a Michaels API key by going to your active Michaels Developer Account.

Custom Company Settings 

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

  • MichaelsAPIKey – Required setting. The API token used to connect your Michaels account with Sellercloud. Visit this link to obtain your Michaels API key.
  • MichaelsUseProduction – Optional setting. Set it as False to use Michaels’ sandbox environment. If the setting doesn’t exist, or if set to True, the integration will be established with Michaels’ production environment.
  • MichaelsCommissionPercent – Optional setting with a decimal value. Add a value to apply a commission percentage on your Michaels orders.
  • MichaelsDefaultFixedQty – Optional setting. Add a value representing the Michaels default quantity for the specific company, if the product inventory level is 0.
  • MichaelsEnablePriceUpdates – Optional setting, which must be set to True to export price updates. 

Sellercloud Support

You must contact Sellercloud Support and request:

  1. To install the required plugins on your server.
  2. The following Custom Product Columns creation:

Custom Product Columns

  • MichaelsEnabled – Optional column with True or False values. Set to True to filter and work with specific products that you will sell on Michaels and exclude all others.
  • MichaelsSKU – Optional column. 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 – Optional column. If populated, Sellercloud will subtract the safety quantity from the total quantity of the product when sending inventory to Michaels.
  • MichaelsFixedQty – Optional column. If the MichaelsFixedQty value is greater than 0, then it will be exported as available quantity.
  • MichaelsPrice – Optional column for Michaels-specific product price. This column functions only if the custom company setting MichaelsEnablePriceUpdates is set to True. If MichaelsPrice is set to 0, or doesn’t exist and MichaelsEnablePriceUpdates is set to True, the product’s Site Price will be exported to Michaels.

Order Import

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

Automate 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. To Create New Schedule Task:
    1. Select Import Orders as Task Type.
    2. Insert a Task Name.
    3. Select a Company.
    4. Set 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 hyperlink.
  5. Click the Edit button on the top right.
  6. In the Details panel:
    1. Select a company from the Create Orders For Company dropdown menu.
    2. From the Plugin dropdown menu select Michaels API Order Import.
  7. In the Import Options panel, set Import From to None.
  8. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General panel, click the Enable button.
  10. Save your changes.

Tracking Export

This plugin exports tracking information to Michaels on a regular basis. Orders without tracking information should not be included in this export.

This task type requires a saved search for orders filtered by:

  • Company – The company you created for the integration.
  • Order Status In Process or Completed.
  • Shipping Status FullyShipped
  • Tracking Uploaded – No
  • Optionally, you can filter by Payment Status and add more filters based on your preference.

Automate Tracking Export

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 to Create New Scheduled Task.
  3. Complete as follows:
    1. Select Export Orders for Task Type.
    2. Add a Task Name.
    3. Select the Company.
    4. Set 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 hyperlink.
  5. Click the Edit button on the top right.
  6. In the Details panel:
    1. Select your ID from the User ID dropdown menu.
    2. Choose 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 panel, 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 panel, click the Enable toggle button.
  10. Click Save on the top right.

Inventory Export

With this plugin, 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 value is available, that Safety Quantity will be subtracted from the available inventory.

Custom setting MichaelsEnablePriceUpdates needs to be activated to send price updates with the Inventory Export. If the custom product column MichaelsPrice is set to 0, or doesn’t exist, the product’s default price will be exported to Michaels.

This task type requires a Saved Search for products. If you don’t sell all of your products on Michaels, you have the option to filter by custom column MichaelsEnabled. You can also add more filters based on your preference.

Automate Inventory Export

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. Add a Task Name.
    3. Select a Company.
    4. Set 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 panel:
    1. Select your User ID.
    2. Choose the Saved Search you created earlier.
    3. Click the Export Via menu and select Michaels API Inventory Export.
  7. In the Export Options panel, 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 panel, click the Enable button.
  10. Save your changes.

 

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support