Feature Overview: Product Sync

Product Sync is a feature designed to keep your Ecommerce store and Token of Trust aligned for the purpose of calculating and collecting Excise Taxes automatically from your customers.

Wordpress

Product Sync is now available for Wordpress!

Big Commerce

Below we use the following notation:

BigCommerce(string) : we use the value of the BigCommerce variable of the same name. So BigCommerce(variant.sku) for example means the sku value of the variant under consideration. 

option(label) : means the optional value for the label of the product variant under consideration. So for example if the Size for a variant was 12ml when we say option('Size')  we mean “12ml”.

Here are the rules we use to translate from BigCommerce into Token of Trust metadata

Token of Trust Field NameHow we arrive at a valueNotes
SKUBigCommerce(variant.sku)
Vape System TypeHere we map the product categories to a vape system type discretely. Any product category without a mapping is treated as a product exempt from excise taxes.
isExemptIf the product is in one of the mapped categories in Vape System Type (above) it is assumed NON-exempt otherwise it is exempt. Any categories added after initial implementation will be assumed Exempt unless or until they are mapped to a vapeSystemType (e.g. closedSingleUse, isOpen, closedCartridge)
name

The following values concatenated: 

BigCommerce('product.name') + ' - ' + option('Pack Count') + ' / ' +  option('Flavor') +' / ' + option('Nicotine') + ' / ' + option('Size')

Wholesale CostBigCommerce('product.cost_price')
Wholesale PriceBigCommerce('variant.calculated_price')
msrpBigCommerce('variant.calculated_price')
Retail PriceBigCommerce('variant.calculated_price')
packQty

We take the first number we see in the option(Pack Quantity). 

We do not consider any string values or numbers after the first. 

These are valid values for Size: 

  • “5 pack” = 5
  • “5 bottles” = 5
  • “6x6” = 6

These are INVALID:

  • “count 6”: because leads with string.
  • “ten pack”: because no number was included.
Volume in ml

We take the first number we see in the option('Size') * packQty. 

We do not consider any string values afterward.

These are valid values for Size: 

  • “12ml” = 12
  • “5 ML” = 5
  • “   6 milliliters” = 6

These are INVALID:

  • “ml 6”: because leads with string.
  • “zero ml”: because no number was included.
Has Nicotineoption('Nicotine'): returns true for numbers greater than 0 or if it’s a string other than ‘no’ or ‘false’.

Shopify

Product Sync is not available for Shopify.

Read more