Quantity Field

Available on: ✔️ Add ✔️ Update ✔️ Export

By mapping to multiple columns, the total sum of the columns will be updated as the Quantity.When the quantity column contains values like "50 in stock", Stock Sync reads the numeric value and ignores other characters. No quantity rules are required for this.

All settings below are available under the Smart Settings of the Quantity field. There are a few settings for this field:

1. Location

List of inventory locations available in the store. It can be used to update products to a specific location only. Stock Sync supports multiple locations, but each feed updates to a single location.

For example: If the products in the feed should be updated at the location Paris, select Paris from the dropdown.

2. Auto add stock to location if not there (✔️ Update)

By default, Stock Sync automatically adds product stock to a location even if the product was not previously stocked there.
If disabled, Stock Sync will not add the product to a location where it was not stocked.

For example: If product A in the feed is not stocked at location London, it will be added to London with the quantity from the feed (if this option is enabled).

If inventory is managed by a fulfillment service, stock cannot be automatically added to another location.

3. Quantity Selection

By default, Stock Sync uses Available Quantity.
You may change this to On Hand Quantity, and updates will follow the selected option.
Refer here for more details: 📘 How does On Hand Quantity and Available Quantity work?

4. Quantity Rules

There are multiple types of Quantity Rules available.

Quantity rules are applied from top to bottom. The lower rule overrides the above rule when its condition is met.Example: If feed quantities are 9, 6, and 4 Rules: qty > 5 = 10, qty > 7 = 15 Result in store: 15, 10, 4

Condition (If)	Value	Quantity	Result Showing
Equal	HIGH	`10`	Products with "HIGH" in the name always show a quantity of 10. This marks them as special or priority items.
< Less Than	5	`0`	Quantities below 5 display as 0, which helps prevent selling out-of-stock products.
< Less Than	300	`-col("Qty2")`	Quantities less than 300 will use Qty1 minus Qty2 (For example, Column1: Qty1 = 5, Column2: Qty2 = 3, so display 2).
< Less Than	0	`*col("unitqty")`	Negative quantities multiply by unit quantity to get a positive number (For example, -5 × 3 = 15).
<= Less than or Equal	30	`5`	Products with 30 units or fewer display as 5. This makes small stocks easy to notice.
> Greater Than	10	`15`	Products with more than 10 units display as 15, which is useful for bulk deals or promotions.
>= Greater than or Equal	20	`50`	Products with 20 or more units display as 50, showing high stock for bulk visibility.
Start With	Incoming	`0`	Any product name starting with "Incoming" displays as 0, so these aren’t available for sale.
End With	delivered	`0`	Any product name ending with "delivered" displays as 0, keeping fulfilled orders out of available stock.
Range	20-50	`20`	Quantities from 20 to 50 display as 20, which helps group these products together.
Advanced	raw_quantity == 'disponible' && current_quantity <= 0	`1`	For the column of quantity with text value of disponible in the feed and the current_quantity from the shopify store is less than 0 or equal to 0, then display as 1.
With Formula		`+ 10`	Iincrease by 10 upon the value from the feed file for each product to allow for buffer or restocking.
Empty		`0`	Any empty inventory field displays as 0, keeping data clean.
Match Any		`15`	Using "Match Any" sets all product quantities to 15, perfect for demos or testing.
Match Any		`/col("low")`	Divide the "qty column" by the "low column".

5. Inventory Tracked by Shopify

When inventory tracking is enabled in Shopify, the inventory quantity at a location updates automatically when transfers are received.

The Track Inventory option is enabled by default in Add and Update feeds.

For example: To track quantity for a product option in Shopify, enable the "Track Quantity" setting. This will turn on quantity tracking for products if it was previously disabled in Shopify.

6. Low Stock Alert

Set the low stock threshold here and enable notifications under:
Preferences → Notifications → Low Stock Alert.
You will receive notifications through email on products that have low stock levels.

For example: If set to 5, Stock Sync will send an email notification when stock is 5 or below.

7. Overwrite existing quantity

The store quantity will be replaced with the quantity from the feed.

Example: Store quantity = 20 | Feed quantity = 15 → Updated quantity = 15

8. Add/Deduct with existing quantity

This option adds the feed quantity to the existing store quantity.

Disable the Out of Stock (OOS) strategy in Advanced Settings if you want to sum up duplicate SKUs in your feed file.

Example: Store quantity = 20 | Feed quantity = 15 → Updated quantity = 35

9. Only deduct from the existing quantity

This option deducts the feed quantity from the existing store quantity.
It is not enabled by default.

Example: Store quantity = 20 | Feed quantity = 15 → Updated quantity = 5

10. Set existing quantity in store to 0 before updating

This option clears the existing quantity first, then applies the total quantity from the feed (useful for duplicate SKUs).
To enable this option, the Add/Deduct with existing quantity option must also be enabled.

Example: Store quantity = 20 | Feed quantity = 15 | Duplicate SKU quantity = 10 → Updated quantity = 25

Updated on: 12/02/2026

Was this article helpful?

Thank you!