Go to Products List, click Bulk Stock Update.
Step 1 — Filter & Download the File Template
1. Use the filters to choose which products to include:
Sales Channel: Choose a specific sales channel/account to update only that channel’s products. If All Channels is selected (default), the downloaded file includes all products — including those not yet added to any channel.
Product Status: Choose to include All, Active, or Inactive products.
Channel Accounts: Choose a specific account or all accounts based on the channel selected
Click Download to generate the Excel template for your selected filters. Then, click Download when the file is ready.
Notes: It will automatically split every 1,000 SKUs into separate files for easier handling.
It’s strongly recommended to download the latest file each time before performing an update, to ensure you are using the most up-to-date template and the latest product data.
Step 2 — Update Stock in Excel and Upload
Open the downloaded Excel file(s) and update the stock values on 'New Stock' and 'New Reserved Stock' (optional).
*Important:
Do not use Excel formulas
Do not amend the header (row 1) and other data
The value input in the 'New Stock' will overwrite the current stock quantity in Zetpy — it is not an adjustment or addition
Save your file and click Choose a File to upload your file.
Step 3 — Check Update Result
After you upload the file, it will start validating the data (usually takes a few seconds).
Possible outcomes:
All valid — If every row passes validation, the update completes successfully.
Partial success — If some rows contain invalid values or headers, valid rows will still be updated while invalid rows are skipped.
Failed — If the file template or value input is invalid (eg, a formula is added), no rows will be updated until the errors are fixed.
What you should do when:
Updated successfully: Refresh the page and view the updated stock directly in the Product List page. Then, click Choose File on Step 2 to upload the next file if necessary.
Updated partially:
A summary of total rows processed, successfully updated, and skipped.
A list of error details (e.g., Row 8: New Stock must be an integer).
An option to download the error report containing all rows that failed validation.
A reminder to always download the latest file format before re-uploading.
If you have any issues or questions, please drop us an email at support@zetpy.com