CSV and MarketMan: Bulk Inventory Count Upload Template
Upload a CSV of counted inventory, validate every row, and write the verified counts back to MarketMan in one run.
What It Builds
This Spojit template starts from a Manual trigger so you can kick off a count whenever stocktake is done. A CSV connector node parses the uploaded file into rows, a Validation step checks each row for a recognised item and a numeric quantity, and a Loop writes the validated counts back through the MarketMan connector. Rows that fail validation are collected and reported so nothing silently disappears.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow with a manual trigger that takes an uploaded CSV of inventory counts. Parse the CSV into rows, then for each row validate that it has an item code and a numeric quantity. For every valid row, update that item's on-hand count in MarketMan. Collect any rows that fail validation and return a summary listing the rows updated and the rows skipped with the reason.
Connectors Used
- Manual trigger - you start each count run on demand.
- CSV - parses the uploaded count file into structured rows.
- Validation - confirms each row has an item code and a numeric quantity.
- MarketMan - writes the verified on-hand counts back to your inventory.
Customize It
Edit the prompt to match your CSV columns, for example sku and counted_qty, or to set counts for a specific location or storage area. You can also have it skip zero-quantity rows, or email the skipped-rows summary instead of returning it inline.
Tips
- Your MarketMan connection needs write access to inventory counts for the update step to succeed.
- Keep the MarketMan write step in Direct mode so each row maps to one exact action with no AI cost.
- Test with a short CSV first to confirm column names and item codes line up before running a full stocktake.