Shopify - "Find In Store" Inventory Display

Shopify does not support displaying per location inventory directly on product pages but Accumula makes it possible.  With "Find In Store" enabled, the inventory quantity and fulfillment methods from each of your store locations are sent to Shopify so that they can be displayed on your product pages.  The per location inventory availability for each Variant is saved to a Metafield attached to the Shopify Variant. The metafield details make "Find In Store" functionality possible right within Shopify.  Metafields can also improve complex fulfillment solutions like Instore/Curbside Pickup. This can work together with Accumula's Safety Stock feature to reduce oversells and scale location inventory to hundreds of locations. 

You can learn more about Metafields in Shopify's manual.

How to Get Started

Your template developer can customize your template to display per store inventory for variants.  They can display the actual inventory quantity or add simple logic to display "Available" or 'Out of Stock" based on the quantity.

Your developer can find more resources about Metafield's in Shopify's developer documention.

Accumula Metafields v2 

To power a true omnichannel experience, Accumula integrates location, fulfillment, and inventory to metafields. Accumula sends metafield values as single JSON string with per location info for

• available_in_store - Available in Store qty, decimal - In Store Safety Stock applied

• available_to_ship - Available to Ship qty, decimal - Shipping Safety Stock applied

• ship_from - boolean, True if location is configured to fulfill shipments.

• pickup_in_store - boolean, if location is configured in for In-store Pickup

• pickup_at_curbside - boolean, if location is configured in for Curbside Pickup

• location_name - string, the location name

• location_address - string, the location address

• location_latlong - string, the location's latitude, the location's longitude

To view Variant Metafield data in your Shopify account, go to the Variant Detail screen of any Variant and add metafields.json to the URL (ie.  https://yourstore.myshopify.com/admin/products/8223312518/variants/27359124998/metafields.json)

Here is a v2 Variant Inventory Metafield Sample:

{"metafields":
[{"id":13331173507153,"namespace":"accumula","key":"fulfillment_inventory","value":"{\"locations\":{\"boston,_state_street\":{\"available_in_store\":17.00,\"available_to_ship\":17.00,\"ship_from\":true,\"pickup_in_store\":true,\"pickup_at_curbside\":true,\"location_name\":\"Boston, State Street\",\"location_address\":\"434 Newbury Street, Boston, MA 02116\",\"location_latlong\":\"42.3480559, -71.0911421\"},

\"chicago\":{\"available_in_store\":4.00,\"available_to_ship\":4.00,\"ship_from\":true,\"pickup_in_store\":true,\"pickup_at_curbside\":true,\"location_name\":\"Chicago\",\"location_address\":\"10 Clark Street, Chicago, IL 60654\",\"location_latlong\":\"41.882217, -87.6311829\"},

\"new_york\":{\"available_in_store\":0.00,\"available_to_ship\":0.00,\"ship_from\":true,\"pickup_in_store\":true,\"pickup_at_curbside\":true,\"location_name\":\"New York\",\"location_address\":\"527 Madison Ave, New York, NY 10016\",\"location_latlong\":\"40.7600589, -73.9734802\"},

\"san_francisco\":{\"available_in_store\":36.00,\"available_to_ship\":36.00,\"ship_from\":true,\"pickup_in_store\":true,\"pickup_at_curbside\":true,\"location_name\":\"San Francisco\",\"location_address\":\"365 Market Street, San Francisco, CA 94103\",\"location_latlong\":\"37.791471, -122.397869\"}}}

Legacy Metafields Formatting

In Q3 2020, Accumula released a new format for inventory metafields. Here is a v1 Variant Inventory Metafield Sample for the same data as above:

{"id":12603480539217,"namespace":"Channels","key":"bostonstatestreet_inventory","value":17,"value_type":"integer","description":"Boston, State Street","owner_id":32142018969681,"created_at":"2020-04-27T08:25:25-07:00","updated_at":"2020-09-09T09:12:53-07:00","owner_resource":"variant"},

{"id":12603480473681,"namespace":"Channels","key":"chicago_inventory","value":4,"value_type":"integer","description":"Chicago","owner_id":32142018969681,"created_at":"2020-04-27T08:25:25-07:00","updated_at":"2020-08-13T15:06:33-07:00","owner_resource":"variant"},

{"id":12603480571985,"namespace":"Channels","key":"newyork_inventory","value":0,"value_type":"integer","description":"New York","owner_id":32142018969681,"created_at":"2020-04-27T08:25:25-07:00","updated_at":"2020-09-08T20:12:58-07:00","owner_resource":"variant"},

{"id":12603480604753,"namespace":"Channels","key":"online_inventory","value":5,"value_type":"integer","description":"Online","owner_id":32142018969681,"created_at":"2020-04-27T08:25:25-07:00","updated_at":"2020-06-30T11:59:36-07:00","owner_resource":"variant"},

{"id":12603480506449,"namespace":"Channels","key":"sanfrancisco_inventory","value":36,"value_type":"integer","description":"San Francisco","owner_id":32142018969681,"created_at":"2020-04-27T08:25:25-07:00","updated_at":"2020-09-10T12:03:54-07:00","owner_resource":"variant"}]}

Examples

For examples of this feature in action, check out a product detail page on Deadstock.ca and click on "View In-Store Availability".