Revel and Shopify Weighted Inventory and Orders Sync

Syncing weighted inventory and Orders from Revel to Shopify - Two way inventory sync.

Great for Bulk food items, Butcher Shops and Grocery Stores!

Since Shopify does not support decimals for inventory (for example, 2.1 lbs) we then will need to modify or move the decimal in order for Shopify to accept the whole inventory value.

Note: Shopify also calculates weights in Kilograms or KG’s.

There are two options or eSync Actions you can use.

1. Send weighted inventory and move the decimal 3 places. Example, if inventory is 1.3 KG’s Shopify will show 1300 Grams.
2. Send inventory in whole amounts and drop the decimal. Example, if Revel inventory is 1.3 KG’s send to Shopify 1 KG’s and drop the decimal point.

Below is an example of an item Sold by Weight in Revel.

You can also sync a Shopify Matrix item with a Revel Standard product or Bulk item as long as all the SKU’s match!

See example Shopify product - right click to enlarge and open in a new tab.

Since you have a simple product in Revel and a Matrix in Shopify, you’ll need to create the product manually and make sure the SKU in Shopify matches your POS single product.

Also, calculate the price based on your Revel Price. If your price is $5.45 in Revel, then .1 Grams = .545 (.1 x 5.45 = .545 and rounding will occur with Shopify).

{revel price} x {number you enter in shopify weight field} = {price you enter in shopify}

See article on ‘How to trigger point of sale updates, for an integration.’

Sending Orders from Shopify that have weighted items to Revel POS

The Shopify Shipping Weights field is used in the order that’s sent to Revel.

Since Shopify displays Weights in kg’s in the API you will need to do the same in Shipping and use kg’s as your label for Shipping Weight. Each product will have to have a Shipping Weight that is sent to the Revel POS.

> If you want to deduct 0.33 qty in Revel for each item sold simply enter 0.33kg for the Shipping Weight in Shopify.
> If you want to deduct 0.5 qty in Revel for each item sold simply enter 0.5kg for Shipping Weight in Shopify,

Note: If you’re POS is selling in LB’s, then simply add your weights in KG’s for your orders and make sure lbs are set with the label KG. If you have 2.5 lbs, set the weight to 2.5 kg’s in Shopify.

Use the Orders Actions labeled with Send Weighted Orders to Revel. Creating the order in the POS will also trigger Revel inventory update for each individual line item SKU. Creating the order thus creates a two way inventory sync.

See example weighted orders Action below. You will also need to add the TAG Action into the same TASK once you have configured your Actions for use

After you RUN the TASK, Simply view your TASK Activity logs and Upload the Full log to a Support Ticket for further assistance.

For Multi-Location, the Shopify order will need a location TAG created by (Zapiet) to designate where to send the order.

If the Shopify order does not have a designated location using the Zapiet tag feature and is a result of a 3rd party plug-in (not Zapiet), then simply create another Order Action and new TAG Action for this circumstance and label the tag configuration area as ‘blank’ for the Order Action and designate the Revel location to send the order.

To support this feature you can only use FLAT RATE SHIPPING and NON Weighted items will have to have a weight of ‘0’ or zero. For example a Soap dish would need to have a weight of ‘0’ zero and bulk item (chocolate protein) would have a weight of 22.5 lbs.

The Actions to create products for ‘Send Standard items’ and ‘Send Matrix Items’ can be use to SEED your data online, but cannot be used at this time for scheduled updates. If you turn on your schedules the new updates will overwrite (remove) your variants created on Shopify manually and revert them back to match your Revel POS item. We are working on a future release so please contact support for more information.

Also, see the following help article for list of Activit Log messages.

Note: The time stamp for creating products in Revel is different from the time stamp to update inventory in Revel.

See video example on Bulk Migration of Items and Inventory from your POS to your Shopping Cart

If you’d like to purchase a support package, you can do so here.

If you have further questions, please post a ticket in our Help Desk