Workflows · E-commerce · Opening soon
Workflows for e-commerce and retail
Payouts, stock and SKUs, from your Shopify, Amazon and store exports.
Match two lists
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Inventory reconciliationEach SKU: agrees, over, short, or only on one sideSee the workflow Template
- VLOOKUP between two sheetsLook up product price and category from a Products sheet for each row in an Orders sheet, using exported Excel files.See the workflow Built by the agent
- Match Stripe payouts to QuickBooks depositsMatch Stripe payouts to QuickBooks deposits each Monday and flag anything missing, short, duplicate, or extra.See the workflow Built by the agent
- POS sales reconciliationMatch daily POS sales by payment type to card payouts and cash counts from Square exports.See the workflow Built by the agent
- Match Shopify payouts to QuickBooks depositsMatch Shopify payouts to QuickBooks deposits, and flag fees, refunds, missing deposits, short deposits, duplicates, and over deposits.See the workflow Built by the agent
- Amazon FBA inventory reconciliationReconcile FBA shipment contents and inventory adjustments from Amazon Seller Central. Show agreed, short, and damaged units for claims.See the workflow Built by the agent
- GA4 vs Shopify revenue gapCompare daily GA4 revenue with Shopify orders, match the dates, and flag days where one side is more than 5% higher.See the workflow Built by the agent
- Match Amazon settlements to QuickBooksMatch Amazon settlements to QuickBooks deposits, break out fees, refunds, and reserve holds, and flag missing, short, or duplicate payouts.See the workflow Built by the agent
- Match Etsy payouts to QuickBooksMatch Etsy payout exports to QuickBooks deposits, then mark each row as Agrees or show what is off.See the workflow Built by the agent
- Match Shopify payouts to XeroMatch Shopify payouts to Xero bank lines by date and amount, then flag mismatches and missing rows.See the workflow Built by the agent
- Match Stripe payouts to NetSuite depositsReconcile Stripe payouts to NetSuite deposits each week, match by payout id and amount, and flag differences.See the workflow Built by the agent
- Match Stripe payouts to Xero bank depositsMatch Stripe payouts to Xero bank deposits by amount and date, and flag payouts that never landed in the bank feed.See the workflow Built by the agent
- Match WooCommerce orders to Stripe chargesCheck WooCommerce orders against Stripe charges by amount, with status notes for matches, differences, and missing charges.See the workflow Built by the agent
- Shopify vs ShipBob inventoryCompare Shopify inventory to ShipBob warehouse counts by SKU and see every mismatch with a status and difference.See the workflow Built by the agent
- Supplier invoice price vs PO priceCompare supplier invoice lines to purchase order rates from NetSuite exports and flag over-rate, duplicate, or match status.See the workflow Built by the agent
Age and chase
Age what is open, and get the list of who to chase, sorted by how late it is.
- Inventory agingEach product's stock split by how long ago it arrived: 0-30, 31-60, 61-90 and over 90 daysSee the workflow Template
- Purchase order trackingTrack open purchase orders by supplier, see what is ordered, received, outstanding, and which orders are late from a NetSuite export.See the workflow Built by the agent
- Maintenance work orders overdueList open maintenance work orders past due with asset, technician, due date, and days overdue from an Excel export.See the workflow Built by the agent
Track and forecast
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template
- Funnel analysisHow many people reach each step of your funnel, in order, and where they drop offSee the workflow Template
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Demand forecast by SKUForecast next month’s demand for each SKU from your Shopify order line export using recent monthly averages and trend.See the workflow Built by the agent
- ABC analysisRank Shopify SKU revenue into A, B, and C tiers from an export, using yearly revenue and an 80/15 split.See the workflow Built by the agent
- Dead stock reportList SKUs with stock on hand, no sales in 90 days, and tied-up inventory value from Shopify product and order exports.See the workflow Built by the agent
- Sell-through rateEach product's units received, units sold, what is left and its sell-through rateSee the workflow Template
- Repeat purchase rateEach month's new customers and the share who ordered again within 90 daysSee the workflow Template
- Cycle count varianceCompare cycle count results to inventory balances by item and location, and calculate unit and value variance.See the workflow Built by the agent
- Safety stock by SKUCalculate safety stock and reorder point for each SKU from Shopify exports and supplier lead times.See the workflow Built by the agent
- Average order value by channelCalculate average order value by sales channel and month from your exported Shopify orders, using paid orders only.See the workflow Built by the agent
- Churn rateEach month: customers at the start, how many were lost, and the churn rateSee the workflow Template
- Stockout reportList the SKUs that ran out of stock in the last 30 days, how long they were out, and the sales you likely missed.See the workflow Built by the agent
- Inventory shrinkage by locationCompare expected stock to counted stock by store from Lightspeed exports, then show shrinkage units, value, and rate.See the workflow Built by the agent
- Inventory valuation reportValue inventory on hand by item and warehouse at average cost, then total it by category from your NetSuite export.See the workflow Built by the agent
- Shopify sales by productBuild weekly Shopify sales by product from orders and refunds exports. See gross sales, discounts, refunds, net sales, and status by SKU.See the workflow Built by the agent
- Cart abandonment rateCalculate cart abandonment rate from a Shopify analytics export by day and device, using checkouts started and orders completed.See the workflow Built by the agent
- Economic nexus by stateTotal sales and orders by state over the last 12 months, compare them to nexus thresholds, and flag each state from a Shopify export.See the workflow Built by the agent
- Product return rateCalculate return rate by product and reason from Shopify exports, using closed returns only.See the workflow Built by the agent
- Shopify inventory reportBuild a Shopify inventory report with on hand, last 4 weeks of sales, and weeks of cover for each product and location.See the workflow Built by the agent
- Amazon sales by ASINSummarize your Amazon sales report by ASIN and month, with units, revenue, refunds and fees from an export file.See the workflow Built by the agent
- Repeat customer rateUse your Shopify orders export to count monthly customers, repeat customers, and repeat customer rate by month.See the workflow Built by the agent
- Sales tax by stateCreate a sales tax report from your Shopify orders by state and month, with taxable sales, tax collected, and undercollection flags.See the workflow Built by the agent
- Effective labor rateCalculate effective labor rate by service advisor and technician from a Tekmetric repair orders export.See the workflow Built by the agent
- Days of supply by SKUCalculate days of supply for each SKU from Shopify products and orders exports using stock on hand and average daily sales.See the workflow Built by the agent
- Refund rate by productCalculate refund rate by product from Shopify orders and refunds exports for the last 90 days, sorted highest first.See the workflow Built by the agent
- Supplier lead time analysisCalculate average and worst lead time by supplier from NetSuite purchase orders and item receipts.See the workflow Built by the agent
- Backorder reportCreate a backorder report from a NetSuite sales order export. Group orders by item and customer, with quantity backordered and days waiting.See the workflow Built by the agent
- Shopify customer cohortsGroup Shopify customers by first order month and show how many order again in each of the next 12 months.See the workflow Built by the agent
- Gross margin by productWork out gross margin by product from Shopify exports. Use order and product files to calculate net sales, cost, and margin percent.See the workflow Built by the agent
- Donor retention rateCalculate donor retention rate by year from a Bloomerang donations export, using prior-year donors and next-year returns.See the workflow Built by the agent
- Best sellers by monthBuild a best selling products report from your Shopify Orders export. Rank the top products by units and revenue each month.See the workflow Built by the agent
- Bundle analysisFind which products are most often bought together in Shopify orders, then list the product pairs that appear in at least 2 orders.See the workflow Built by the agent
- Discount code performanceCompare discount codes by orders, revenue, discount given and average order value from a Shopify orders export.See the workflow Built by the agent
- Landed cost by SKUAllocate freight, duty, and fees from Shopify exports by SKU value, and see landed cost per unit with clear status flags.See the workflow Built by the agent
- Shopify discount codes reportBuild a Shopify discount report from your orders export. See orders, revenue, discount total, and average order value by code.See the workflow Built by the agent
- Shopify returns by productBuild a Shopify returns report by SKU with return reason and return rate from exported orders and returns files.See the workflow Built by the agent
Calculate
Schedules, commissions, costing and margins, worked out the same way from every new export.
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Inventory turnover and days on handEach product's turnover and days of stock on hand, month by monthSee the workflow Template
- Economic order quantityCalculate economic order quantity for each item from a NetSuite item cost and demand export.See the workflow Built by the agent
- SKU rationalizationFind SKUs to cut in Shopify exports. See last-year revenue, units sold, revenue share, gross margin, and a simple status.See the workflow Built by the agent
- Customer lifetime valueExport Shopify orders and calculate customer lifetime value per customer from spend, orders, first and last order date, and average order value.See the workflow Built by the agent
- Affiliate commissionsCalculate affiliate commissions by affiliate and month from Shopify orders, using referral codes, rate tables, and order subtotal.See the workflow Built by the agent
- Supplier on-time deliveryCalculate each supplier’s on-time delivery rate from exported NetSuite purchase orders and item receipts.See the workflow Built by the agent
- Product profitability after feesWork out profit per product after COGS, discounts, shipping and payment fees from Shopify exports.See the workflow Built by the agent
- Reorder pointsCalculate reorder point per SKU from Shopify order and settings exports, then flag what to reorder now.See the workflow Built by the agent
- Slow moving inventoryFind items with stock on hand, units sold in the last 90 days, and tied up inventory value from NetSuite exports.See the workflow Built by the agent
- GMROI by categoryCalculate GMROI by category from Shopify sales and inventory exports, using gross margin dollars over average inventory at cost.See the workflow Built by the agent
- Influencer campaign ROIMatch influencer payouts to discount code sales from Shopify exports, then calculate ROI for each influencer.See the workflow Built by the agent
- Open to buy by categoryWork out open to buy by category for next month from sales plan, inventory on hand, and open purchase orders exported from Shopify.See the workflow Built by the agent
- Shipping cost per orderCalculate average shipping cost per order by carrier, service, and destination zone from your ShipStation shipment export.See the workflow Built by the agent
- Order fulfillment timeCalculate order fulfillment time from ShipStation exports by day and warehouse, with shipment counts, average days to ship, and status.See the workflow Built by the agent
- Etsy sales by listingSummarize Etsy sales by listing and month from an orders export, with orders, revenue, and fees.See the workflow Built by the agent
- Weeks of cover by storeCalculate weeks of cover for each product at each store from Lightspeed stock and sales exports.See the workflow Built by the agent
- Blended ROAS across Google and Meta AdsCombine Google Ads and Meta Ads exports with Shopify orders to see weekly blended ROAS, with duplicate rows flagged first.See the workflow Built by the agent
- Sales by day of week and hourShow sales by day of week and hour of day from your Square export, so you can spot your busiest times.See the workflow Built by the agent
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.