StreetPricer Account Integration

Overview 

StreetPricer is an Amazon, eBay, and Walmart Marketplace repricing tool that allows you to set optimal pricing based on your competitors and their rate of selling.

StreetPricer can help you grow your business and save time on manual price checking and revision. You can choose to reprice products competitively or opt for higher profits if the market opportunity arises.

Prerequisites 

You need to have an account with StreetPricer and obtain a template file from them for the Mapping you will create in Sellercloud for this integration.

Open a ticket to Sellercloud Support to request an FTP.

Next, create a Product Export Mapping Profile and a Saved View in order to configure a Scheduled Task.

Create Mapping Profiles

Create a mapping profile using the obtained template via our Export Mapping Tool. Contact StreetPricer to obtain the template mentioned in the Prerequisites.

1. Navigate to Settings > Mapping Tools > Manage Export Mapping Profiles.
2. Click the blue Actions icon in the bottom right corner > Create.
3. On the creation wizard pop-up, fill in the required fields:
   1. Profile Name – for example, StreetPricer Product Export.
   2. Profile type – set it to Product.
   3. Export File Type – set to Excel.
   4. Check Export File with Headers.
4. Click Template File. Find and select the downloaded template from your device.
5. Click Add.

Map Product Export Profile Fields

Based on the template file you obtain from StreetPricer, you can map their columns to the appropriate Sellercloud fields. This way, Sellercloud can export the necessary information in the correct format, and you won’t need to manually reformat any data. Below is a sample list of such columns:

1. Navigate to Settings > Mapping Tools > Manage Export Mapping Profiles.
2. Open the StreetPricer Product Export Profile.
3. Click Edit.
4. Map the following fields:
   1. SKU – map it to bvc_Product.ID
   2. Brand – map it to bvc_Product.BrandName
   3. COG – map it to bvc_Product.AverageCost
   4. Min – map it to bvc_Product_Properties_Amazon.MinSellingPriceForAmazon
   5. Max – map it to bvc_Product_Properties_Amazon.MaxSellingPriceForAmazon
   6. MAP – map it to bvc_Product.MAPPrice
   7. ShipCost – map it to bvc_Product.ShippingCost
   8. MPN – map it to bvc_Product_properties_eBay.MPN.SendToEby
   9. UPC – map it to bvc_Product_Properties_Amazon.UPC
   10. ASIN – map it to bvc_Product.ASIN

Product Export

You can configure the updates to StreetPricer to run automatically with a Product Export Task.

First, create a Saved View with the following custom filters: Walmart Marketplace Statuses: Enabled,  Amazon Statuses: Enabled, and other applicable channels. Optionally, you can add any other filters that will further customize the SKU list.

Automate Product Export

To create a Scheduled Task that regularly exports product information from Sellercloud to Streetpricer:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click on the green + icon to create a new Scheduled Task.
3. In the creation wizard pop-up, fill in:
   1. Company.
   2. Task Type – set to Export Products.
   3. Task Name – for example, StreetPricer Product Export.
   4. Start Date – this is the date when the task will run automatically for the first time. However, If you enable the task at a later day, this date will be ignored.
4. Click Create.

Next, go to the Scheduled task to finish the configuration and click Edit.

1. In the Frequency Panel, you can set the task start time and recurrence.
2. In the Details Panel:
   1. User ID – Select your username.
   2. Saved Search – Select the Product Saved Search you created. 
   3. Export Via – select Export Mapping Profile: StreetPricer Product Export.
3. In the Export Options Panel:
   1. Export to: Select FTP.
   2. Fill in the FTP credentials.
   3. Enable Use Secure FTP.
4. In the General panel, click the toggle button to enable the task.
5. Click Save.