Feedvisor Account Integration

Overview

Feedvisor is an online platform that provides algorithmic repricing and business intelligence solutions. Their primary goal is to empower online retailers by leveraging AI technology to automate and optimize their pricing and selling strategies. The integration between Sellercloud and Feedvisor is established via API, ultimately achieving better results and profitability on e-commerce marketplaces.

Prerequisites

To integrate your Feedvisor account, you must configure and connect the Feedvisor Product Export plugin to their API.

In order to achieve this:

1. Contact Feedvisor Technical Support, to register as a Feedvisor API client and specify which storefronts you want to be able to access using the API. 
2. After registering, you will be provided with a set of credentials:

• • Client Id
  • Client Secret

These are the two strings that identify you as a Feedvisor customer and will be used to authenticate your permission to access their API.

Integrate with Feedvisor

Contact Support Support to request:

1.  To install the Feedvisor Product Export plugin to your server.
2. Create the following Custom product columns:
   1. FLOOR_PRICE – Indicates the lowest price at which you are willing to sell your product:
      • If the product isn’t a Shadow, the exported value will be from the custom column FLOOR_PRICE.
      • If the product is a Shadow, the plugin uses the value from the Parent’s product custom field FLOOR_PRICE and if:
        • The product’s country code is not US, and it differs from the parent’s; a 20% markup will apply. The result will be multiplied by the company’s conversion rate in Sellercloud, and the end value will be displayed.
        • The country code is US, or the currency code of the shadow and parent products match, no additional calculations will apply.
   2. CEILING_PRICE – Indicates the maximum price at which you want to sell your product.
      • If the product isn’t a shadow, the exported value will be from the custom column CEILING_PRICE.
      • If the product is a shadow, the plugin uses the value from the Parent custom column CEILING_PRICE and if:
        • The country code of the product is not US, and it differs from the parent’s, a 15% markup will apply. The result will be multiplied by the company’s conversion rate in Sellercloud, and the end value will be displayed.
        • The country code is US, or the currency code of the shadow and parent products match, no additional calculations will apply.
   3. REPRICE – Indicates if the product should be repriced, or not. If the Floor or Ceiling price is 0, the Reprice field will export as FALSE, regardless of the custom column value. In case the product is a Shadow, the value will be pulled from the Parent SKU.

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 “FeedvisorAPIKey” into the Setting Name field.
5. Enter the Feedvisor API key from the prerequisite steps into the Setting Value field.
6. Click Save.

When utilized, the Feedvisor Product Export plugin matches the criteria for Feedvisor’s format and exports the following data:

• SKU – ProductID in Sellercloud.
• Amazon Seller SKU – Amazon Merchant SKU in Sellercloud.
• ASIN – ASIN in Sellercloud.
• Cost ($) – SiteCost in Sellercloud.
• Amazon Fee (%) – Commission Percentage in Sellercloud.
• Shipping Cost ($) – ShippingCost in Sellercloud.
• Floor Price – a custom column (see above).
• Ceiling Price – a custom column (see above).
• Reprice – a custom column (see above).
• Available Quantity – Inventory Available Qty in Sellercloud.
• Listed Price on Amazon – Amazon Price in Sellercloud.

Automate Product Export

To ensure seamless integration, you must automate the data transfer by creating a Scheduled Task for your plugin.

Create a Scheduled Task

In order to export data of selected products and send it regularly to Feedvisor, create a scheduled task:

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 Date.
   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 Export Via menu and select Feedvisor Product 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.