Articles on: Matching Column

Quantity Field

Available on: ✔️ Add ✔️ Update ✔️ ExportBy mapping to multiple columns, the total sum of the columns will be updated as the Quantity.When the quantity column consist of 50 in stock as value, it will read the quantity and ignored the other characters. No need to apply quantity rules for this.

There are a few settings for this field, which are:

1. Location

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

For example: If the products of the feed is to be updated on a location Paris, click on the dropdown and select the location Paris.

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

By default, Stock Sync will auto add product stock to a location even if the product was not stocked in that location. Disabling it, Stock Sync would not add the product to the location where it was not stocked.

For example: If product A in the feed is not stocked on the location London. By default, product A will be added to location London with the quantity from the feed.

If your stock inventory is located in a fulfillment service, then it cannot automatically add stock to another location.

3. Quantity Selection

By default, Stock Sync will automatically select using Quantity. If you would like to change the option to On Hand Quantity, you can do so, and the stock update will occur based on the On Hand Quantity. Please check here for more information about how it works.

4. Quantity Rules

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

For the quantity rules, it will be applied from top to bottom, with the bottom rule overriding it, if the condition is met.In the feed file, the quantities are 9, 6, and 4. The rules applied are as follows: qty > 5 = 10, qty > 7 = 15Result 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	quantity<50	`current_quantity`	For quantities less than 50 in the feed, the current quantity from the Shopify store will be used.
With Formula		`current_quantity + 10`	Inventory will increase by 10 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.

5. Track inventory by Shopify

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

Track inventory option has been enabled by default in the add and update feed.

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

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 have 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.

7. Overwrite existing quantity

The quantity in store is overwritten with the quantity in the feed.

For example: If the store quantity = 20 | And the feed quantity = 15 | Then the updated quantity = 15

8. Add/Deduct with existing quantity

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

Disable Out of Stock Strategy on Step 4, to sum up duplicate SKUs in your feed file.

For example: If the store quantity = 20 | And the feed quantity = 15 | Then the updated quantity = 35

9. 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

10. 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

Updated on: 11/07/2025

Was this article helpful?

Thank you!