{"id":422,"date":"2024-04-29T17:37:10","date_gmt":"2024-04-29T17:37:10","guid":{"rendered":"https:\/\/help.kosmosesync.com\/?post_type=ht_kb&p=422"},"modified":"2024-10-07T16:51:10","modified_gmt":"2024-10-07T16:51:10","slug":"revel-and-shopify-weighted-inventory-order-sync","status":"publish","type":"ht_kb","link":"https:\/\/help.kosmosesync.com\/index.php\/knowledge-base\/revel-and-shopify-weighted-inventory-order-sync\/","title":{"rendered":"Revel and Shopify Weighted Inventory & Order Sync"},"content":{"rendered":"\n

#<\/a> Syncing weighted inventory and Orders from Revel to Shopify – Two-way inventory sync.<\/h2>\n\n\n\n

#<\/a> Great for Bulk food items, Butcher Shops, and Grocery Stores!<\/h3>\n\n\n\n
\n

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.<\/p>\n<\/blockquote>\n\n\n\n

\n

Note: Shopify also calculates weights in Kilograms or KG\u2019s.<\/p>\n<\/blockquote>\n\n\n\n

#<\/a> There are two options for eSync Actions you can use.<\/strong><\/h4>\n\n\n\n
    \n
  1. Send weighted inventory and move the decimal three places. For example, if inventory is 1.3 kg, Shopify will show 1300 Grams. <\/li>\n<\/ol>\n\n\n\n
      \n
    1. <\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      2. Send inventory in whole amounts and drop the decimal. For example, if Revel inventory is 1.3 KG\u2019s send to Shopify 1 KG\u2019s and drop the decimal point.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n
        \n
      1. <\/li>\n<\/ol>\n\n\n\n

        #<\/a> Below is an example of an item Sold by Weight in Revel.<\/h4>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \n

        You can also sync a Shopify Matrix item with a Revel Standard product or Bulk item as long as all the SKU\u2019s match!<\/p>\n<\/blockquote>\n\n\n\n

        See an example of a Shopify product – right-click to enlarge and open in a new tab.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n
        \n

        Since you have a simple product in Revel and a Matrix in Shopify, you\u2019ll need to create the product manually and make sure the SKU in Shopify matches your POS single product.<\/p>\n<\/blockquote>\n\n\n\n

        \n

        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).<\/p>\n<\/blockquote>\n\n\n\n

        {revel price} x {number you enter in<\/strong> shopify weight field} = {price you enter in<\/strong> shopify}\n<\/code><\/pre>\n\n\n\n
        See the article on \u2018How to trigger point of sale updates, for an integration.<\/a>\u2019<\/p>\n\n\n\n
        #<\/a> Sending Orders from Shopify that have weighted items to Revel POS<\/h3>\n\n\n\n
        \n
        The Shopify Shipping Weights field is used in the order that\u2019s sent to Revel.<\/p>\n<\/blockquote>\n\n\n\n
        \n
        Since Shopify displays Weights in kg\u2019s in the API you will need to do the same in Shipping and use kg\u2019s as your label for Shipping Weight. Each product will have to have a Shipping Weight that is sent to the Revel POS.<\/p>\n<\/blockquote>\n\n\n\n
        > If you want to deduct 0.33 qty in<\/strong> Revel for<\/strong> each item sold simply enter 0.33kg for<\/strong> the Shipping Weight in<\/strong> Shopify.\n> If you want to deduct 0.5 qty in<\/strong> Revel for<\/strong> each item sold simply enter 0.5kg for<\/strong> Shipping Weight in<\/strong> Shopify,\n<\/code><\/pre>\n\n\n\n
        \n
        Note: If you\u2019re POS is selling in LB\u2019s, then simply add your weights in KG\u2019s 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\u2019s in Shopify.<\/p>\n<\/blockquote>\n\n\n\n
        \n
        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.<\/p>\n<\/blockquote>\n\n\n\n
        See the 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<\/strong><\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \n
        After you RUN the TASK, Simply view your TASK Activity logs and Upload the Full log to a Support Ticket for further assistance.<\/p>\n<\/blockquote>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \n
        For Multi-Location, the Shopify order will need a location TAG created by (Zapiet) to designate where to send the order.  For single locations, enter the word ‘blank’ if you do not have tags for your Shopify orders.<\/p>\n<\/blockquote>\n\n\n\n
        \n
        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 \u2018blank\u2019 for the Order Action and designate the Revel location to send the order.<\/p>\n<\/blockquote>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \n
        To support this feature you can only use FLAT RATE SHIPPING<\/strong> and NON Weighted items will have to have a weight of \u20180\u2019 or zero. For example a Soap dish would need to have a weight of \u20180\u2019 zero and bulk item (chocolate protein) would have a weight of 22.5 lbs.<\/p>\n<\/blockquote>\n\n\n\n
        \n
        The Actions to create products for \u2018Send Standard items\u2019 and \u2018Send Matrix Items\u2019 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.<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
        # 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…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"ht-kb-category":[30,41],"ht-kb-tag":[],"class_list":["post-422","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-integrate-revel-systems-pos-shopify","ht_kb_category-integrate-shopify-with-revel-pos-systems"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/comments?post=422"}],"version-history":[{"count":8,"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/422\/revisions"}],"predecessor-version":[{"id":644,"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/422\/revisions\/644"}],"wp:attachment":[{"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/media?parent=422"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=422"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.kosmosesync.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}