Sherweb Integration: Linking Products to Sherweb
For the integration to update a product's cost, it needs to recognize that the product is something you purchase from Sherweb. It does this by matching the Sherweb product SKU to information on your Rev.io product.
Where to Put the Sherweb SKU
Every product in Sherweb has a SKU, for example SWHE19R01. To link a Rev.io product to Sherweb, that same code must be on the product in one of the following fields depending on whether the product is already linked to Sherweb.
| Product Status | Where to Enter the Sherweb SKU |
|---|---|
| Already has Sherweb listed as a vendor | The SKU/USOC field on the Sherweb vendor line on the Purchasing tab. |
| Not yet linked to Sherweb | The Manufacturer Part Number field (recommended) or the External SKU field. |
To find the Sherweb SKU, open the Sherweb partner portal, navigate to a customer's Subscriptions, and look in the SKU column.
Matching Rules
- Capitalization and spaces do not matter. SWHE19R01, swhe19r01, and the same code with extra spaces all match correctly.
- The full code must match. A partial code will not link a product.
- Products that do not match are left unchanged. The integration only touches products that match a Sherweb SKU.
How Costs Are Stored
The integration always stores costs as a monthly amount, regardless of how Sherweb bills the subscription. Monthly subscriptions show their cost exactly as Sherweb charges them. Yearly and multi-year subscriptions are divided down to a monthly figure. For example, a subscription billed at $1,020.00 per year is stored as $85.00 per month. This monthly cost remains accurate all year, so your margins and reports are always current regardless of when the subscription renews.
Note that the monthly cost shown on a yearly product will not match the larger once-a-year amount on your Sherweb invoice. This is expected as it is the same cost expressed on a consistent monthly basis.
Why a Cost Sometimes Does Not Update
If a product's cost did not update, the most common reasons are:
- The Sherweb SKU is not on the product, or does not match exactly. Confirm the SKU is entered in the correct field and matches the value in the Sherweb Partner Portal.
- The Currency Filter set during configuration does not match the currency Sherweb bills you in. If the currency is mismatched, no costs will update.
- The Sherweb cost has not changed since the last sync. The integration only writes an update when the cost is different from what is already on the product.