Virventures Account Integration

Overview

VirVentures is an online retail platform that offers a wide range of products across various categories, including electronics, home goods, toys, and sporting goods. The site provides a diverse selection of items from numerous brands, aiming to deliver competitive prices and a convenient shopping experience.

Integrating VirVentures into your Sellercloud account allows you to seamlessly import orders, upload tracking and invoice information, and ensure your listings are always up-to-date with the latest inventory data. The integration works through EDI documents, transmitting information between the two services via plugins and Scheduled Tasks.

If necessary, you can open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.
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 VirVentures with Sellercloud, 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.

VirVentures Support

You must contact VirVentures for your FTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins.

Sellercloud Support

Open a ticket with Sellercloud Support and request the following plugins be installed on your server:

  • Virventures Order Import 850 with 997 EDI – Imports orders from VirVentures to Sellercloud in EDI 850 format and sends acknowledgement back in EDI 997.
  • Virventures Order Export 855 EDI – Sends order acknowledgment to VirVentures in EDI 855 format.
  • Virventures Invoice Export 810 EDI – Exports invoices to VirVentures in EDI 810 format.
  • Virventures Inventory Export 846 EDI – Exports inventory to VirVentures in EDI 846 format.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

  • STControlNumber
  • GSControlNumber
  • ISAControlNumber
ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The tracking and inventory exports will increment this number accordingly as jobs are processed. If the settings already exist and have values in them, do not edit them.

On the company created for the integration:

  • Virventures_Customer_ISAID – Your ISA ID. Enter a unique phone number that you don’t use for any other EDI integration.
  • Virventures_CustomerQualifier – Your Qualifier. Set to ZZ.
  • Virventures_ISAID – VirVentures’s ISA ID. Typically, it’s VIRVENTURES. Contact VirVentures for the value of this setting.
  • Virventures_Qualifier – VirVentures’s Qualifier. Typically, it’s ZZ. Contact VirVentures for the value of this setting.
  • (Optional) createOrdersForCompanyID – Used by the Virventures Order Import 850 with 997 EDI. Enter the company ID where the order will be created if it differs from the job company. Set the Data Type to Integer.
  • (Optional) Virventures_ShippingRequiresThirdPartyBilling – This is an optional but recommended setting, which is enabled by default if you don’t create it. With this setting, orders will be imported with Third-Party Shipping required. To disable this setting, create it and set it to False. Set the Data Type to Boolean.

Product Custom Columns

Create the following Product Custom Columns:

  • Virventures_SKU – The product’s SKU at VirVentures. Set the Data Type to String.
  • (Optional) Virventures_Enabled – Enable only specific products for VirVentures. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.

Order Import

The Virventures Order Import 850 with 997 EDI plugin imports order data from VirVentures to Sellercloud in EDI 850 format and exports functional acknowledgment in EDI 997 format.

Automate Order Import

To create a Scheduled Task that imports orders:

  1. Go 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. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click Create Orders For Company and select the company designated for this integration.
    2. Click the Plugin menu and select Virventures Order Import EDI 850 with 997.
  6. In the Import Options panel, set Import From to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable button.
  9. Click Save.


Order Acknowledgment

The Virventures Order Export 855 EDI plugin sends order acknowledgment to VirVentures in EDI 855 format and marks orders as acknowledged after export.

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

  • Company – The company you created for the integration
  • Order Status – InProcess Or Completed
  • Payment Status – Charged
  • Exported – Not Exported
  • Order Ack (Accept) – No

Automate Order Acknowledgment

To create a Scheduled Task that sends order acknowledgment:

  1. Go 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. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Virventures Order Export EDI 855.
    4. Check Mark Orders As Exported.
    5. Check This is Order Ack (Accept).
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.


Invoice Export

The Virventures Invoice Export 810 EDI plugin exports invoices from Sellercloud to VirVentures in EDI 810 format.

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

  • Company – The company you created for the integration
  • Shipping Status – Fully Shipped
  • Order Status – InProcess Or Completed
  • Invoice Uploaded – No
  • Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that exports invoices:

  1. Go 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. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Virventures InvoiceExport EDI 810.
    4. Check This Is Invoice Export.
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.


Inventory Export

The Virventures Inventory Export 846 EDI plugin exports inventory from Sellercloud to VirVentures in EDI 846 format. 

Optionally, you can enable only specific products for VirVentures by setting their Virventures_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 Virventures_Enabled column, and Save.
  • For multiple products in bulk: Follow the steps to Bulk Update Products and use the Virventures_Enabled column – set it to True for all products you want to enable.

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

Next, create a Saved Search for products filtered by VIRVENTURES_Enabled True. Optionally, you can add more filters to the search to narrow down the export further.

Automate Inventory Export

To create a Scheduled Task that exports inventory:

  1. Go 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. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Virventures Inventory Export EDI 846.
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save


Was this article helpful?

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