Hi there, I'm new so please point me another place if this isn't the best place to ask questions, was looking to kick the tire on something I've been working on related to netsuite inventory. My company is a small homegoods mfg in Nor-Cal using the tech stack of Netsuite-Celigo-Shopify that I recently started work for as a Netsuite Admin. They've been very inventory constrained especially in Nov-Dec. Today, Celigo syncs from Netsuite to Shopify using Quantity Available. I've been working on a proposal for creating "buffer-stock" which would essentially be [Quantity Available] - [New Buffer Stock Field]. This quantity would be sync'd to Shopify via Celigo I went and make a spreadsheet looking at the frequency of times an item was backordered over the last year and assigned a quartile so as to assign anywhere from (1-4 units in buffer). My questions were: • Are there any blind spots I am not seeing? The biggest risk I am aware of is the potential lost sales. • I am looking at using the column [Store Pickup Buffers Stock] as [New Buffer Stock Field]. I know this field can be toggled to have a maximum on the item locations, is there a better column anyone would recommend?

2. It is generally not a good idea to use a standard field for something other than its intended purpose. Not saying it won't work in this case, but I would consider another other solution. For instance a custom record if you want to keep different buffer stocks across your item collection.

Noted on the standard field The issue is that demand is higher than ability to supply. We use one location for all e-commerce. Other locations do brick and mortar sales. We frequently have backorders where the e-commerce fulfillment location has an order but because the inventory count is off in this location. The company wants to still fulfill those orders and in many cases they will have the brick and mortar stores send products back to source for fulfillment. I want to add the buffer stock concept especially during high periods of demand so that Shopify POS shows (1-4) units less than actually available so it goes out of stock online sooner and this buffer stock is there to fulfill these kinds of orders.

Yeah lots of different ways to do this. What I've done in the past is: • Blanket minus 2 • Calculated field based on the velocity of the product. For example, if an item sells 20 units per hour compared to another that only sells 1 per hour, then a complex formula could output some buffer qty per item (or item/location combo too) • No used saved searches, but used NetSuite rest apis that ran suiteql queries that had very complex calcs Really whatever works for your business

dm me!!!

Thanks @Tyler Lamparter I figured this was definitely a case of many ways to approach. My method of (1-4) divied up into quartiles based off frequency of back-orders seemed like a simple enough rule. How did you approach 0s and negative numbers. If Netsuite says Qty Available is 1, and Buffer Stock is 3, Would you let it sync to -2 to Shopify POS or would you add some greater than 0 rule?

I put 0 as the floor because most systems won't accept a negative value