The Price & Quantity file allows you to upload modifications to your current inventory if you don't want to supply all the fields that the Inventory Loader or the larger inventory files require. The Price & Quantity file is the smallest format with the fastest processing time.
You can download the latest version of the file from the Inventory File Templates help page.
It is also possible to update price and quantity information using the Inventory Loader or product-specific inventory files. Use larger inventory files only in the following situations:
Please choose ‘Price & Quantity file’ as file type from drop down when uploading Price & Quantity file. Price and Quantity file is always treated as Partial Update.
This upload file must be populated with the sku field, as well as at least one of the following additional fields that you are choosing to modify: the price field or the quantity field.
*Please set ‘standard-price-points’ as well when changing ‘price’, otherwise, point will be initialized and set to 0 automatically.
*Please set ‘handling-time’ as well when changing ‘quantity’, otherwise, handling-time will be initialized and set to 1 automatically.
The best and fastest way to indicate that a product is out of stock is to use a Price & Quantity File feed to set the quantity to zero. When you restock the product under the same SKU, use a product-specific inventory file or an Inventory Loader file feed to set the quantity to your on-hand quantity.
We do not recommend deleting SKUs that are temporarily out of stock. You should use a product-specific inventory file or an Inventory Loader file feed to explicitly delete the SKU only if you do not plan to restock the product in the future.