Verishop Account Integration

Overview

Verishop is an online marketplace that offers a curated selection of fashion, beauty, home decor, and other lifestyle products from a variety of brands. The marketplace features products from a wide range of brands, from established luxury labels to up-and-coming independent designers. Verishop also has its own private label brand, which includes clothing, accessories, and home goods.

You can integrate Verishop through Mirakl, which is an e-commerce and dropshipping platform that uses an API solution to help website retailers partner with third-party sellers in order to grow their online offerings and expand their market reach.

Integrating Verishop allows you to sell on their platform through Sellercloud. This integration works by transmitting information between the two services via API. The following plugins are currently available in Sellercloud:

• Order Import – Imports orders from Verishop to Sellercloud.
• Tracking Export  – Exports tracking information to Verishop.
• Inventory Export – Updates inventory on Verishop.
• RMA Import – Imports RMAs to Sellercloud.

If necessary, you can contact Sellercloud Support to request additional customizations or other plugins for this integration. Note that these customizations are billable, and you will be provided a quote.

Prerequisites

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

Custom Company Settings

Create the following Custom Company Settings:

• Mirakl_Integration_Name – This setting’s value will be added to the custom order column MIRAKL_CHANNEL to show which specific Mirakl channel the order was placed on – in this case, Verishop US.
• Mirakl_API_URL – URL for the channel.
• Mirakl_API_Key – Your Mirakl authentication key. On Mirakl, you can find it by clicking your email address in the top right corner and selecting API Key.
• MiraklOAuthTokenId – Used as an alternative to Mirakl_API_Key. Create it as an empty company setting and get a token from the scheduled task.
• Mirakl_Always_Accept_Orders – Optional, can be True or False. Determines if orders with pending acceptance will be accepted even if there’s not enough inventory on hand to fulfill them. If the setting is missing, the plugin considers it as False.
• Mirakl_Get_Only_Recent_Orders – True or False. Determines if the plugin will only get orders modified in the past 10 days. Skip creating the setting or set it to False for initial order import. Then set to True to speed up the plugin and avoid reaching API limits.
• Mirakl_Shop_IDs – Optional setting. A comma-separated list of Mirakl shop IDs (i.e., ‘2000,2774’). If missing, the plugin will only import orders from the first shop associated with the Mirakl user. Note that you can only have one Mirakl integration per company in Sellercloud. The only exception is that you can have Best Buy and one more marketplace under the same company. This setting should not exceed two IDs.
• Mirakl_Order_Statuses – Optional setting. Only orders with the order statuses listed here (comma-separated) will be imported. If missing, orders with a status of WAITING_ACCEPTANCE, PAYMENT_COLLECTED, SHIPPING, SHIPPED, RECEIVED, and CLOSED will be imported.
• Mirakl_Shipping_Method – Optional. Shipping method set to imported order.
• RunPostOrderPluginAfterOrderCreation – Optional, defaults to False. Set to True to run a post-order plugin once an order is created/updated.
• Mirakl_Manufacturer_Warranty – Defaults to 0.
• Mirakl_Warehouse_IDs – A comma-separated list of warehouse IDs to export inventory from. Works with both the Basic and the Advanced Safety Quantity workflows.
• Mirakl_Enable_Advanced_Safety_Qty – Defaults to False. Enables the Advanced Safety Quantity workflow.
• MIRAKL_UseAdvancedKitProjecting – Defaults to False. When True, independent kits get an estimated sellable quantity if there are no items assembled. All component kits get items out of independent kits when projecting.
• Mirakl_Inventory_Percent – Decimal value (ex. “80”, meaning 80%), defaults to 100%. Used with the Advanced Safety Qy workflow.
• MiraklEnableExportOfferStateNew – Defaults to False. Enables the use of product custom column MIRAKL_EXPORT_OFFER_STATE_NEW.
• Mirakl_Offer_TaxCode – Optional string, if present, then the plugin will export each offer with the relevant product-tax-code. Example value: P0000000.
• MiraklDefaultReplenishableQty – This value is exported as the inventory for replenishable products if MiraklUseDefaultReplenishableQty is enabled on the product level.

Sellercloud Support

You must contact Sellercloud Support and request:

1. To install the Mirakl plugins on your server.
2. The following custom product and order columns:

Custom Product Columns

• Verishop_Enabled – Type Boolean. Set to True to enable a product for Verishop. While not required in order for the plugin to work, it can help distinguish which products are listed, and you can use it as a filter for the Inventory Export Saved Search.
• MIRAKL_SKU – Type String. It can be used to add the Mirakl product ID if it’s not the same as the Sellercloud SKU.
• MIRAKL_PRICE – Type Decimal. The product price that will be included in the Inventory Export to Mirakl.
• MIRAKL_AVAILABLE_STARTED – Type DateTime. Start date of the active offer.
• MIRAKL_AVAILABLE_ENDED – Type DateTime. End date of the active offer.
• MIRAKL_SHOP_IDS – Type String. Used only if the company setting Mirakl_Shop_IDs is populated. A comma-separated list of Mirakl shop IDs for which product price, inventory, and availability dates should be updated, e.g., ‘2000,2774’.
• MIRAKL_DISCOUNT_PRICE – Type Decimal, optional setting.
• MIRAKL_DISCOUNT_AVAILABLE_STARTED – Type DateTime, optional.
• MIRAKL_DISCOUNT_AVAILABLE_ENDED – Type DateTime, optional.
• MIRAKL_SAFETY_QTY – A Safety Quantity for products on Verishop.
• MIRAKL_MANUFACTURER_WARRANTY – Type Integer.
• MIRAKL_MANUFACTURER_WARRANTY_USE_DEFAULT – Type Boolean, defaults to False. If disabled, will export warranty from the product custom column. Otherwise, from the company setting.
• MIRAKL_LOGISTIC_CLASS – Type String with an optional selected value. If in use, add a drop-down with no multiple selections, with values: LETTER, SMALL, MED, LARGE, HEAVY, LTL.
  • Verishop logistic class values (relevant description in brackets): s (Standard), os (OverSize / Hazmat)
• MIRAKL_DESCRIPTION – Type String with an optional selected value.
• MIRAKL_INTERNAL_DESCRIPTION – Type String with an optional selected value.
• MIRAKL_PRICE_ADDITIONAL_INFO – Type String with an optional selected value.
• MIRAKL_OFFER_STATE – Type String, dropdown, defaults to 11 (NEW) when missing or has an invalid Mirakl_Integration_Name.
• MIRAKL_EXPORT_OFFER_STATE_NEW – Type Boolean, defaults to False. Required and used only when the company setting MiraklEnableExportOfferStateNew is enabled. When enabled, the plugin will export the default offer state code (NEW) instead of the selected MIRAKL_OFFER_STATE.
• MiraklMaxQtyEnabled – Type Boolean, enables Max qty.
• MiraklMaxQty – Type Integer, used if Max qty is enabled on the product level
• MiraklMaxQtyUseDefault – Type Boolean, set to True to use the Max qty set on the company level instead of the product-level one.
• Mirakl_Offer_TaxCode – Optional String; if present, then the plugin will export each offer with the relevant product-tax-code. Example value: P0000000.
• MiraklReplenishableQtyToSend – Type Integer, used if Replenishable is enabled on product-level properties.
• MiraklUseDefaultReplenishableQty – Type Boolean, set to True to use the Replenishable Quantity set on the company level instead of the product-level one.
• Mirakl_MinQtyAlert – Type Integer, optional, defaults to 1.

Custom Order Columns

• MIRAKL_CHANNEL – Type String. Used by the Order Import plugin to save the relevant order channel. Allows searching for orders from each channel.
• MIRAKL_SHOP_ID – Type Integer. Populates the Mirakl shop ID if the custom company setting Mirakl_Shop_IDs is not empty or missing.

Order Import

This plugin downloads Verishop orders through the API and imports them as Website orders in Sellercloud. Orders will be created with the email customer_id@integrationName.com. For example, 12345@verishop.com.

The plugin will send order acceptance to Mirakl if all your ordered items have enough inventory to fulfill the order. Orders will be set as canceled on Sellercloud and Mirakl if an item has insufficient inventory.

Note the following important details describing how the plugin interacts with orders with different statuses:

• Only orders with Mirakl status WAITING_ACCEPTANCE, SHIPPING, PAYMENT_COLLECTED, SHIPPED, RECEIVED, and CLOSED will be imported, and others will be skipped. 
• Orders with the status SHIPPED, RECEIVED, and CLOSED will be imported as completed. 
• Orders with the status SHIPPED and RECEIVED will be marked as fully shipped, while CLOSED ones will be marked as shipped only if they have a tracking number or a carrier name.
• Orders with the status WAITING_ACCEPTANCE are downloaded with empty addresses. After acceptance, Mirakl sends them again with the status SHIPPING, and addresses are added to the relevant orders by the plugin.
• After an order that’s pending acceptance is created in Sellercloud, the plugin will check the custom company setting Mirakl_Always_Accept_Orders. If True, the order will be automatically accepted. If False, an acceptance is sent to Mirakl only if there’s sufficient product inventory to fulfill the whole order. Otherwise, it will be rejected, and the Sellercloud status will be changed to Cancelled.

Automate Order Import

To create a Scheduled Task that regularly imports orders from Verishop to Sellercloud:

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 you designated for this integration.
   2. Click the Plugin menu and select Mirakl 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.

Tracking Export

This plugin exports the shipping carrier and tracking number, then marks the order as shipped on Mirakl.

Tracking confirmation is saved to the order action documents as a TrackingUpload_PreShip. If it’s successful, the plugin will skip tracking updates for this order and will try sending a shipping confirmation.

Shipping confirmation is saved to the order action documents as a TrackingUpload. If it’s successful, the plugin will skip sending it again.

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

• Company – Choose the Verishop Company
• Order Status – InProcess Or Completed
• Shipping Status – FullyShipped
• Payment Status – Charged
• Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that regularly exports order tracking from Sellercloud to Verishop:

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 Mirakl Order Tracking Export.
   4. Check Mark Orders As Exported.
   5. Check This Is Tracking Export.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

Inventory Export

This plugin exports available inventory, prices, and offer start and end dates from Sellercloud to Verishop.

Products are matched by Mirakl SKU (either Sellercloud product ID or custom column Mirakl_SKU, matched to Mirakl SKU under Settings, not the one in the summary on top).

Here are some key details:

• The price is set in the custom column MIRAKL_PRICE.
• The description is the product’s name in Sellercloud.
• The offer start and end dates are set in the custom columns MIRAKL_AVAILABLE_STARTED and MIRAKL_AVAILABLE_ENDED.
• Do not update more than 60,000 products per hour, or you will reach the limit of 60 API calls per hour.

Safety Quantity Workflows

There are two Safety Quantity workflows that function as follows:

• The Basic Safety Qty workflow, when Mirakl_Enable_Advanced_Safety_Qty is missing or False.
  • Aggregate inventory from all sellable warehouses or from the specified ones (if Mirakl_Warehouse_IDs is not empty) – MIRAKL_SAFETY_QTY custom column.
• The Advanced Safety Qty workflow, when Mirakl_Enable_Advanced_Safety_Qty is True. This workflow uses custom columns and product fields found on the Amazon Product Properties Page. It is a custom inventory calculation imbedded in the Mirakl plugin that follows these rules:
  • Quantity to Export = (Total Available Quantity * Mirakl_Inventory_Percent) – Amazon Safety Qty
  • Quantity = Aggregate inventory from all sellable warehouses or from the specified ones (if Mirakl_Warehouse_IDs is not empty)
  • Amazon Safety Qty = Amazon safety qty, either on the product or company level, depending on Use Company Default.
  • If a product has the MiraklMaxQtyEnabled column set to True, and the quantity to export is greater than the Amazon Max Qty value, then the latter will be exported.

The Basic and Advanced Safety Qty workflows will never export negative values. In such a case, they will export 0 instead.

Prepare Products

Make sure to enable your products for Verishop by setting their Verishop_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 Verishop_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the Verishop_Enabled column – set it to True for all products you want to enable.

Before you move on, create a Saved Search for products filtered by Verishop_Enabled – True. Optionally, you can add more filters to the search.

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

Automate Inventory Export

To create a Scheduled Task that regularly exports inventory from Sellercloud to Verishop:

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 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 Mirakl Inventory Export Plugin.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

RMA Import

This plugin downloads completed refunds from Mirakl and creates them in Sellercloud. Orders that are in process and with a closed full refund will be marked as completed. 

Automate RMA Import

To create a Scheduled Task that regularly imports refunds from Verishop to Sellercloud:

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 RMA.
   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, click the Plugin menu and select Mirakl RMA 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.