The Inventory Updater Tool is designed to streamline the process of updating inventory details for both primary products and their associated variants. Leveraging the simplicity of a CSV file filled with SKUs, it ensures a smooth integration of data. What sets this tool apart is its versatility, with its ability to support multiple functions, all of which are determined by the specific values within the fields of the CSV file.
Article Contents
This support article contains several sections which can be accessed quickly by clicking the appropriate link below:
- Preparing Your CSV File & Available Fields and Values
- Uploading Your CSV File to Your Store Tools
- Examples of CSV Files to Control Inventory Actions
Preparing Your CSV File & Available Fields and Values
The following fields and values may be used in your file:
- sku – This field is required and is the item SKU or variant SKU.
- stock – This optional field should contain the in-stock quantity you want to be assigned to the item or variant.
- Numbers must be between 0 and 999999999.
- Negative numbers will result in an error.
- low-stock – This optional field should contain the low stock value you want to be assigned to the item.
- Numbers must be between 0 and 999999999.
- Negative numbers will result in an error.
- tracking – This optional field sets how inventory should be tracked on the item.
- If inventory is not currently set to be tracked on a product you can use this field with one of the following values to enable inventory tracking:
- p or product as a value will set the inventory to be tracked on the product level.
- v or variant as a value will set the inventory to be tracked on the variant level.
- If inventory is currently enabled on either the product or variant level and you want to disable inventory tracking, you can do so using the following value in this field:
- n or none will disable inventory tracking on the item.
- If inventory is not currently set to be tracked on a product you can use this field with one of the following values to enable inventory tracking:
- visible – This optional field should contain one of the variables below to set whether or not the product is visible and searchable:
- n, no, false, or 0 = the item will be set to not be visible or searchable
- y, yes, true, or 1 = the item will be set to be visible and searchable
- purchasability – This optional field should contain one of the variables below to set whether or not the product is able to be purchased:
- a, available, in stock, or in-stock = the item will be set to purchasabled, disabled, out of stock, or out-of-stock = the item will be set to not purchasablep, preorder, or pre-order = the item will be set to pre-order
- minimum_order_quantity – This optional field should contain the minimum purchase amount value you want to be assigned to the item
- Numbers must be between 0 and 999999999.
- Negative numbers will result in an error.
- maximum_order_quantity – This optional field should contain the maximum purchase quantity value you want to be assigned to the item
- Numbers must be between 0 and 999999999.
- Negative numbers will result in an error.
Uploading Your CSV File to Your Store Tools
Upload your CSV file containing your updates and click Next. Make sure your file has a header row containing at least the SKU field.
Map the fields in your CSV and click Next.
By default, Your Store Tools will email you when your import is complete. If you choose to receive this notification, verify your email address is correct before clicking Submit.
Once the upload is complete, you will receive a notification in the notification center and an email if you selected that option.
Examples of CSV Files to Control Inventory Actions
Various types of inventory updates can be done via this tool, here are some examples using CSV files.
Turn Inventory Tracking On for an Item Without an Inventory Quantity
- Will enable inventory tracking on the product level
- Will set stock and low stock levels to 0
- Will mark the item or variant as out-of-stock on the item page
Turn Inventory Tracking Off for an Item With or Without Inventory Quantity
- Will disable inventory tracking on the product completely
- WIll mark the item or variant as in-stock on the item page
Adjust Inventory for Products and Variants Already Set to Track Inventory
- Will update in stock quantity to the specified value
- Tracking value is not needed for products that already have it enabled. If tracking is NOT enabled, see the other example below.
Adjust Inventory for Products and Variants Not Already Set to Track Inventory
- Will turn on inventory tracking on either the product or variant level
- Will update in stock quantity to the specified value
- tracking field must be set to enable inventory tracking. If you are unsure whether or not inventory tracking is enabled for the items you’re updating, it’s recommended to include this field and the value.
Adjust Inventory and Low Stock Value for Products and Variants Already Set to Track Inventory
- Will update in stock quantity to the specified value
- Will update the low stock quantity to the specified value
- tracking value is not needed for products that already have it enabled. If tracking is NOT enabled, see the other example below.
Adjust Inventory and Low Stock Value for Products and Variants Not Already Set to Track Inventory
- Will turn on inventory tracking on either the product or variant level
- Will update in stock quantity to the specified value
- Will update the low stock quantity to the specified value
- tracking field must be set to enable inventory tracking. If you are unsure whether or not inventory tracking is enabled for the items you’re updating, it’s recommended to include this field and the value.
Did you find an error or need additional support? Contact us at support@yourstorewizards.com to let us know!