Inventory Quantity Field

Modified on Mon, 20 Mar 2023 at 05:35 PM

Available on: 
✔️ Add ✔️ Update ✔️
By mapping to multiple columns, the total sum of the columns will be updated as the Quantity.

There are a few settings for this field which are:

1. Quantity Rules

There are a few types of Quantity Rules that you can choose from. You can see the example below: 

Condition (If)



Result Showing

< Less Than



All quantities <Less than 5 will display as 0

> Greater Than



All products with > Greater than 10 quantities will be displayed as 15




Products described in words such as HIGH is = Equal to 10

Start With



"Incoming 11 July" can be read as Start With Incoming to be displayed as 0

End With



"... delivered" can be read as End With delivered to be displayed as 0




Any quantity Range between 20 and 50 will be displayed as 20




All the product quantities with < Less than 50 from the feed file will be displayed as the store quantity

With Formula



Quantity With formula +10 will be added to the current quantity Quantity refer to quantity from the feed file                                           

Current quantity refers to quantity from Shopify Store




You can set the Empty column to 0

Match Any



Set all products to be displayed as 15 with Match Any

2. Location

List of inventory locations available in store. Used to update products to a specific location only. Stock Sync does not support multiple locations. Each feed updates to a single location.

For example:

If the products of the feed is to be updated on a location Paris which is not the Primary location, click on the dropdown and select the location Paris.

3. Track quantity by Shopify

When a product's inventory is tracked in Shopify, the inventory quantity that's available at a location is updated automatically when receiving a transfer that includes the product.

For example:

To enable the Track Quantity in the product option in Shopify, this option needs to be enabled.

4. Low Stock Alert

Determine the low stock level here and turn on the notification in the preference tab. Preferences -> Notifications -> Low Stock Alert You will receive notifications through email on products that are low stock levels.

For example:

If you set the level as 5. When the process is completed, Stock Sync will send a email notification of products which has stock 5 or below.

5. Overwrite existing quantity

The quantity in store is overwritten with the quantity that is available in the feed.
For example:

If the store quantity = 20
And the feed quantity = 15

Then the updated quantity = 15

6. Add/Deduct with existing quantity 

This option will sum up the quantity from the feed with the quantity in the store.

For example:

If the store quantity = 20
And the feed quantity = 15

Then the updated quantity = 35

7. Only deduct from the existing quantity

By selecting this option, you can only deduct from the current quantity. By default, this option is not selected and it will not deduct. 

For example:

If the store quantity = 20
And the feed quantity = 15

Then the updated quantity = 5

8. Set existing quantity in store to 0 before updating 

This option is used to sum up the quantity of duplicate SKUs that is present in the feed and overwrite the quantity in store. To enable this option, the sum up with the existing quantity option needs to be enabled. 

For example:

If the store quantity = 20
And the feed quantity = 15
Duplicate SKU quantity = 10

Then the updated quantity = 25

9. Deduct Quantity from a column within a feed file 

For example:

If you have 2 columns for quantity. One column is for quantity and another column is for sold quantity. So you would like to update the store product's quantity as quantity (5) - sold quantity (3) = 2. It will be updated product quantity as 2. 

In this field, you should put the sold quantity column's index e.g col3, and in the field mapping of quantity put the quantity column.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article