Available 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 appply 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 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 this option is unavailable at your Shopify store, please contact support@stock-sync.com our support team for assistance with enabling it.

3. Quantity Rules

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

4. Track inventory by Shopify

When a product's inventory is tracked in Shopify, the available inventory quantity 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. 

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

6. Overwrite existing quantity

For example:

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

Then the updated quantity = 15

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

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

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

10. Deduct Quantity from a column within a feed file 

For example:

If have 2 columns for quantity. One column is for quantity and another column is for sold quantity. If want 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, should put the sold quantity column's index e.g col3, and in the field mapping of quantity put the quantity column.