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 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.
On Hand quantity can have the same meaning, regardless of what system it is from. Only the Quantity can be mapped, while the On Hand quantity cannot be updated from Shopify.
There are a few settings for this field, which are:
List of inventory locations available in store. It can 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, click on the dropdown and select the location Paris.
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.
If this option is unavailable at your Shopify store, please contact support@stock-sync.com our support team for assistance with enabling it.
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.
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 = 15
Result in store: 15, 10, 4
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 feed.
For example: To enable the Track Quantity in the product option in Shopify, this option needs to be enabled.
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.
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
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
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
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
By 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.
On Hand quantity can have the same meaning, regardless of what system it is from. Only the Quantity can be mapped, while the On Hand quantity cannot be updated from Shopify.
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 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, 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.
If this option is unavailable at your Shopify store, please contact support@stock-sync.com our support team for assistance with enabling it.
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 = 15
Result in store: 15, 10, 4
| Condition (If) | Value | Quantity | Result Showing |
|---|---|---|---|
| < Less Than | 5 | 0 | All quantities <Less than 5 will display as 0 |
| < Less Than | 300 | -col("Qty2") | All quantities <Less than 300 will deduct the quantity from Qty column to Qty2. Ensure your feed file includes two separate quantity columns to apply this rule. For example: If have 2 columns for quantity. One column is for Qty and another column is for Qty2. If want to update the store product's quantity as Qty (5) - Qty2 (3) = 2. It will be updated product quantity as 2. |
| < Less Than | 0 | *col("unitqty") | All quantities <Less than 0 will multiply with the quantity from qty column to unitqty. Ensure your feed file includes two separate quantity columns to apply this rule. For example: If have 2 columns for quantity. One column is for qty and another column is for unitqty. If want to update the store product's quantity as qty (5) multiply unitqty (3) = 15. It will be updated product quantity as 15. |
| > Greater Than | 10 | 15 | All products with > Greater than 10 quantities will be displayed as 15 |
| <= Less than or Equal | 30 | 5 | All products with <= Less than or equal 30 will be displayed as 5 |
| >= Greater than or Equal | 20 | 50 | All products with >= Greater than or Equal 20 will be displayed as 50 |
| Equal | HIGH | 10 | Products described in words such as HIGH is Equal to 10 |
| Start With | Incoming | 0 | " Incoming 11 July" can be read as Start With Incoming to be displayed as 0 |
| End With | delivered | 0 | " ... delivered" can be read as End With delivered to be displayed as 0 |
| Range | 20-50 | 20 | Any quantity Range between 20 and 50 will be displayed as 20 |
| Advanced | quantity<50 | current_quantity | All the product quantities with < Less than 50 from the feed file will be displayed as the store quantity |
| With Formula | - | 10 | Quantity With formula +10 will be added to the current quantity. Quantity refers to quantity from the feed file Current quantity refers to quantity from the Shopify Store. |
| Empty | - | 0 | You can set the Empty column to 0 |
| Match Any | - | 15 | Set all products to be displayed as 15 with Match Any |
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 feed.
For example: To enable the Track Quantity in the product option in Shopify, this option needs to be enabled.
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: 18/12/2024
Thank you!