Searching...

Net32 Account Intergration

Overview

Net32 is an online dental and medical supply marketplace that connects medical professionals with suppliers. The platform offers a wide range of items, including dental instruments, disposables, pharmaceuticals, and office supplies, and allows users to compare prices, read product reviews, and make secure online purchases.

The integration between Sellercloud and Net32 is established via API. The following plugins are currently available in Sellercloud:

    • JDS Net32 Inventory Product Export
    • JDS Net32 Get Charge Status Order Export
    • JDS Net32 API Order Import
    • JDS Net32 Tracking Order Export

You can contact 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 Net32 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.

Contact Net32 Technical Support, to request:

    • Net32 API Key
    • Net32_ShipFromAddress_ID
If you have more than one Net32 account, make sure to have separate companies in Sellercloud for each Net32 account with unique API keys.

Custom Company Settings

Create the following Custom Company Settings.

On the company created for the integration:

    • Net32APIKey – API key for the integration.
    • Net32_ShipFromAddress_ID – The address ID for the client from Net32’s system. Needs to be obtained from Net32.
    • Net32APITimeout – the timeout (in seconds) used after each fifth call to Net32. Defaults to 5.

Sellercloud Support

You must contact Sellercloud Support and request:

  1. To run the SQL script necessary for the Order Import Plugin on your server.
  2. To install the required Net32 Plugins on your server.
  3. The following Custom Product and Order Columns creation:

Custom Product Columns

    • Net32_Enabled – Optional column used to enable only specific products for Net32. Set to True for any products you want to send with the Inventory Export.
    • Net32SafetyQty – A Safety Quantity for products on Net32.

Custom Order Columns

    • ChargeRequestId – used to identify order payment requests.
    • Net32_PaymentCaptured – if a payment is processed, the value will be updated to True, after the API call.
    • Net32_PaymentMessage – Net32 payment message (incl. error messages), will be populated, if applicable.

Order Import

The JDS Net32 API Order Import plugin downloads pending orders data from Net32 to a table in Sellercloud. After that, it checks the pre-authorization of the payment:

    • If the pre-authorization is successful, it imports the orders as Fully Paid. 
    • If not, it will retry capturing the payment the next time the plugin runs and import the order only when the authorization is successful.
The plugin requires a table called Plugins.Orders_JSON_Queue_Net32 – contact Sellercloud Support to request the SQL installation.

Automate Order Import

To create a Scheduled Task that imports Net32 orders:

  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 Create Orders For Company and select the company designated for this integration.
    2. Click the Plugin menu and select JDS Net32 API 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.

Scheduled tasks need to be spaced out in half-hour intervals at a minimum since Net32 has API limits, and if two scheduled tasks are running at the same time, they will fail.

Tracking Export

The JDS Net32 Tracking Order Export plugin exports order tracking information from Sellercloud to Net32 and saves Charge Request IDs for each payment in the custom column ChargeRequestId.

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

    • Company – The company you created for the integration.
    • Ship Date Range – Last 7 Days.
    • Channel – Website
    • Shipping Status – FullyShipped
    • Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that exports order tracking:

  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 JDS Net32 Tracking Order Export.
    4. 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.

Scheduled tasks need to be spaced out in half-hour intervals at a minimum since Net32 has API limits, and if two scheduled tasks are running at the same time, they will fail.

Charge Status Export

The JDS NET32 Get Charge Status Order Export plugin retrieves order payment statuses from Net32 to Sellercloud and lists the output in 2 columns:

    • Net32_PaymentCaptured – indicates if a payment is processed successfully, or not.
    • Net32_PaymentMessage – payment message (incl. error messages) will be populated, if applicable.

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

    • Company – The company you created for the integration.
    • Shipping Status – FullyShipped
    • Channel – Website
    • CC_CHARGEREQUESTID – Custom Column created by our Sellercloud Support. Select Is Not Null to include only shipped orders. 
    • CC_NET32_PAYMENT CAPTURED – Custom Column created by our Sellercloud Support. Select Is Null to export only unpaid orders.

Automate Charge Status Export

To create a Scheduled Task that exports orders charged statuses:

  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 JDS NET32 Get Charge Status Order Export.
    4. Check This Is Invoice 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.

Scheduled tasks need to be spaced out in half-hour intervals at a minimum since Net32 has API limits, and if two scheduled tasks are running at the same time, they will fail.

Inventory Export

The JDS Net32 Inventory Product Export plugin exports inventory data from Sellercloud to Net32. 

Optionally, you can enable only specific products for Net32 by setting their Net32_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 Net32_Enabled column, and Save.
    • For multiple products in bulk: follow the steps to Bulk Update Products and use the Net32_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 Net32_Enabled – True. You can add more filters to the search, such as Company and Active Status.

Automate Inventory Export

To create a Scheduled Task that exports inventory:

  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 JDS Net32 Inventory Product 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.

Scheduled tasks need to be spaced out in half-hour intervals at a minimum since Net32 has API limits, and if two scheduled tasks are running at the same time, they will fail.

 

Was this article helpful?

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