I use an Excel file to track my Shopify inventory. Since Shopify isn't the only channel we sell through, how can I update the correct inventory in an Excel file after a Shopify order?
How can I update the correct inventory in a Microsoft Excel file after a Shopify order?
Hi
Try these Zap steps:
- Trigger: Shopify - New Paid Order
- Action: Looping - Create Loop from Line Items
- Used to handle line items in orders
- Map data points about the line items from step 1
- Action: Excel - Find Row
- Map data out from Step 2
- Action: Formatter >. Numbers > Perform Math Operation
- Use the existing Inventory for the Row found in Step 2
- Use the line item qty from Step 2
- Action: Excel - Update Row
- Map the Row ID from Step 2
- Map output from Step 4
Hi
I think it would help if you share a bit more about how your existing excel or gsheet is structured as every merchant has their own workflows. Do you list out the inventory by item and by channel in each column? Do you want a direct update of the inventory amount or do you want the cell to show the “deducted” inventory amount and do the calculation in the sheet?
Hi
We just wanted to see how everything is going with your Zap. Did everyone’s recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.