SellersApps Account Integration

Click here to learn how to integrate with SellersApps in our original interface.

Overview

In this article, you will learn how to link your SellersApps and Sellercloud accounts.


Integrate with SellersApps

Sellercloud integrates with SellersApps through sending and picking up files from FTP. 

  1. Create a new Export Mapping Profile.
  2. Enter Profile Name, select Profile Type Product and File type Excel.
  3. Attach Excel file with  the following Export Columns:
    EXPORT COLUMN NAME SELLERCLOUD FIELD DETAILS
    SKU bvc_Product_Properties.ProductID  ProductID

    Product ID Alpha

    Item Cost 

    bvc_Product.SiteCost    OR    bvc_Product.AverageCost It’s Average Cost or Site Cost depending on what you want to use as an Item Cost.

    Item Cost Alpha

    Internal Shipping Cost  bvc_Product.ShippingCost Normal

    Internal Shipping Cost Alpha

    MAP Price bvc_Product.MAPPrice Map Price

    Map Price Alpha

    Min Price  bvc_Product_Properties_Amazon.StopLossPrice Stop Loss Price (Amazon Properties)

    Min Price Stop Loss Price Alpha

    Max Price  bvc_Product_Properties_Amazon.MaxSellingPriceForAmazon Max Selling Price (Amazon Properties)

    Max Price Max Selling Price Alpha

    Strategy bvc_Product_Properties_UserDefined.STRATEGY Custom Columns

    Strategy Repricing Active Alpha

    Repricing Active bvc_Product_Properties_UserDefined.REPRICING_ACTIVE
    Integration bvc_Product_Properties_UserDefined.INTEGRATION
    Auto Apply Strategy bvc_Product_Properties_UserDefined.AUTO_APPLY_STRATEGY

    Export Mapping Tool Alpha

  4. Click Settings > Company Settings > select a company > Toolbox > Scheduled Tasks.
  5. From the New Task Type dropdown, select Export Products > Go. Set up a name for the tasks, start time, and run frequency.
  6. Select the correct User ID and Saved Search.
  7. Select Export Mapping Tool profile from the Export via dropdown.
  8. Enter the filename of the inventory file you are exporting.
    1.  Entering the placeholder #?QueuedJobID?# populates the filename with the queued job ID.
    2. Use {yyyy}{MM}{dd} to populate the filename with the date of file creation.
      For example, enter the filename as follows: PHI_ONHAND_{yyyy}{MM}{dd}\
    3. Use {MM}{dd}{yyyy}{HH}{mm}{ss} – where HH = hours, dd = day, mm = minutes, and ss = seconds – to populate the filename with the current date and time.
      For example, enter the filename as follows: PHI_ONHAND_{MM}{dd}{yyyy}{HH}{mm}{ss}
  9. Choose to export to FTP or Email.
  10. If exporting to FTP, enter FTP credentials.  See bottom of page if exporting to a VAN.
  11. If there are multiple folder/directories, enter the remote folder into which the file will be exported, with a forward slash / before the folder name.
  12. If exporting to email, enter the SMTP credentials or click Copy From Company Settings if those will be used.
  13. Enable Passive Mode if the connection cannot be made due to firewalls on your server.
  14. If the file does not import/Export and shows one of these error messages:
      • There is no file on FTP matching criteria to process – Add the forward slash before the directory name and retry
      • File name _____________________ doesn’t match file name __________________ – Add the forward slash before the file name and retry
      • Can’t log in – Check that the FTP credentials are correct
The FTP needs to be provided from the client.

Overview

In this article, you will learn how to link your SellersApps and Sellercloud accounts.


Integrate with SellersApps

Sellercloud integrates with SellersApps through sending and picking up files from FTP. 

  1. Create a new Export Mapping Profile.
  2. Enter Profile Name, select Profile Type Product and File type Excel.
  3. Attach Excel file with  the following Export Columns:
    EXPORT COLUMN NAME SELLERCLOUD FIELD DETAILS
    SKU bvc_Product_Properties.ProductID  ProductID

    SKU Product ID Delta

    Item Cost 

    bvc_Product.SiteCost    OR    bvc_Product.AverageCost It’s Average Cost or Site Cost depending on what you want to use as an Item Cost.

    Item Cost Delta

    Internal Shipping Cost  bvc_Product.ShippingCost Normal

    Internal Shipping Cost Delta

    MAP Price bvc_Product.MAPPrice Map Price

    MAP Price Delta

    Min Price  bvc_Product_Properties_Amazon.StopLossPrice Stop Loss Price (Amazon Properties)

    Min Price Delta

    Max Price  bvc_Product_Properties_Amazon.MaxSellingPriceForAmazon Max Selling Price (Amazon Properties)

    Max Price Delta

    Strategy bvc_Product_Properties_UserDefined.STRATEGY Custom Columns

    Custom Columns Delta

    Repricing Active bvc_Product_Properties_UserDefined.REPRICING_ACTIVE
    Integration bvc_Product_Properties_UserDefined.INTEGRATION
    Auto Apply Strategy bvc_Product_Properties_UserDefined.AUTO_APPLY_STRATEGY

    Export Mapping Tool Delta

  4. Go to Settings  > Scheduled Tasks > click Create New Scheduled Task.
  5. Select Task TypeTask NameCompany and Start Time.
  6. Click Create.
  7. Click Edit.
  8. Select the correct User ID and Saved Search.
  9. Select Export Mapping Tool profile from the Export via dropdown.
  10. Enter the File Name of the inventory file you are exporting:
    1. Entering the placeholder #?QueuedJobID?# populates the filename with the queued job ID.
    2. Use {yyyy}{MM}{dd} to populate the filename with the date of file creation.
      For example, enter the filename as follows: PHI_ONHAND_{yyyy}{MM}{dd}
    3. Use {MM}{dd}{yyyy}{HH}{mm}{ss} – where HH = hours, dd = day, mm = minutes, and ss = seconds – to populate the filename with the current date and time.
      For example, enter the filename as follows: PHI_ONHAND_{MM}{dd}{yyyy}{HH}{mm}{ss}
  11. Choose to export to FTP or Email.
  12. If exporting to FTP, enter FTP credentials. See bottom of the page if exporting to a VAN.
  13. If there are multiple folder/directories, enter the remote folder into which the file will be exported, with a forward slash / before the folder name.
  14. If exporting to email, enter the SMTP credentials or click Copy From Company Settings if those will be used.
  15. Enable Passive Mode if the connection cannot be made due to firewalls on your server.
  16. Click on Schedule Enabled > Save.
  17. If the file does not Import/Export and shows one of these error messages:
    • There is no file on FTP matching criteria to process – Add the forward slash before the directory name and retry
    • File name _____________________ doesn’t match file name __________________ – Add the forward slash before the file name and retry
    • Can’t log in – Check that the FTP credentials are correct
The FTP needs to be provided from the client.

Was this article helpful?

Related Articles