Dad’s Printing / Commerce / System 02 of 06
2021Recorded work
Partner
From sales inquiry to paid production order
Move a business customer’s inquiry through sales and payment into a production order with the right artwork.
- Noah’s contribution
- Noah describes setting up sales routing, linked CRM records, payment-triggered order creation and status mediation; he separately demonstrates a variant-mapping fix.
- Historical stage
- Detailed retrospective walkthrough with contextual Dad’s Printing attribution; separate historical Monday mapping tests.
- Part of the business
- Dad’s Printing overview ↗
- Pipedrive
- Square
- WooCommerce
- Asana
- Google Drive
- Google Sheets
- Make / Integromat
Inside this system
The workflow
The handoffs
inside the work.
Follow the main path and its branches. Select a step for context; the account below explains what was built, tested or planned.
- Website sales inquiry
Collect order quantity, product requirements, contact details and uploaded artwork. - Route by order quantity
Route by quantity or value, including the applicable round-robin sales range. - Self-service purchase link
Provide the customer with the appropriate purchase route. - Related CRM records
Maintain organization, person and deal as linked Pipedrive entities. - Deal-specific artwork folder
Store artwork in Drive and retain its folder link on the deal. - Salesperson develops the deal
Use the requirements, artwork and recorded communication to progress the opportunity. - Square payment event
Match the payment email to the deal and move the deal to invoice paid. - Paid-deal products
Translate the accepted deal’s products and quantities into commerce items. - WooCommerce order
Keep the paid order and its customer-facing status in the commerce system. - Asana production task
Expose internal production stages and shared order references to the team. - Cross-system status sheet
Retain order/task IDs, statuses and update times to mediate the latest change. - Product and variant crosswalk
Translate CRM products and variants into commerce identifiers. - Existing order reference?
Check the paid deal’s commerce reference before creating an additional order. - Validate products and fulfillment
Require product information and shipping details, with a local-pickup exception. - Skip duplicate order creation
An existing WooCommerce ID prevents another order from being created.
Key records
The information
that carries forward.
| Record | Information | Purpose |
|---|---|---|
| Organization, person and deal | Separate business, contact and opportunity records. | Allow one company to have multiple sales opportunities without losing the contact relationship. |
| Deal artwork folder | Customer artwork and instructions, linked from the deal. | Keep sales and production referring to the same materials. |
| Paid production order | Mapped products, quantities and the paid-deal context. | Make accepted work actionable in commerce and production tracking. |
| Synchronization row | Commerce/task identifiers, statuses and update times. | Mediate state changes and relate the records across tools. |
Inside the system / 01
A sales record becomes a production commitment
A historical CRM walkthrough shows a custom-apparel and face-mask inquiry moving through sales into production. Its attribution to Dad’s Printing is contextual: the client is unnamed, although the business and product context closely match the named accounts.
The inquiry starts with a website form. Quantity determines the sales path: requests can go to salespeople with different responsibilities, while the smallest orders can receive a self-service purchase link. Routing reflects the work needed to close the request.
Inside the system / 02
Separate relationships, shared context
The described intake creates three Pipedrive entities: an organization, a person and a deal. This keeps a company distinct from its contact and allows the same company to place more than one order. The deal holds the product requirements and uploaded artwork so the salesperson has context for the conversation.
Messages use fields from the inquiry, and sent communication is recorded against the deal. A separate scenario puts uploaded artwork in a deal-specific Google Drive folder and links that folder back to the CRM. The arrangement gives sales and production a shared place to find the artwork. Another message asks the customer about fulfillment preference, including shipping or local collection. These are concrete information handoffs, not a claim that every later artwork revision was managed automatically.
Inside the system / 03
Payment releases the order
In this recorded version, Square supplies invoicing and payment processing. A payment with an email matching a Pipedrive deal moves the deal to invoice paid. That stage triggers a scenario that takes the deal’s products and creates a WooCommerce order, matching CRM products to commerce items. WooCommerce then feeds the order into Asana, where the production team can work from a board of stages instead of opening individual commerce orders.
Product choices and the artwork relationship need to survive the transition from sales opportunity to production commitment. Email is the described payment-matching key. Alternate payer addresses and ambiguous matches were not tested in this walkthrough.
Inside the system / 04
Different views of progress
Noah describes a two-way status relationship between Asana and WooCommerce, prioritizing the system with the most recent update. He explicitly discusses the risk of update loops and says an external sheet mediates changes. The recording supports explaining the mechanism and the engineering concern; it does not prove safe behavior under simultaneous edits or repeated events.
The production board can be more detailed than the customer-facing status. A third-party production step may matter to staff without being a useful customer label. This Pipedrive, Square and Asana account is distinct from the periods described with Monday or Zoho.
Inside the system / 05
Mapping and test discipline
A separate January 2022 handoff demonstrates a focused Pipedrive-to-Monday fix. Noah adds a deal-specific fetch so a known test deal can be rerun, resolves a variant name from the returned collection using its variant ID, and leaves the field empty when no variant exists. He also aggregates multiple pinned notes before item creation to avoid that collection producing several Monday items. A narrated mixed-product test shows products with and without variants.
Another short diagnosis explains that dropdown numeric IDs are local to each platform: copying a Pipedrive option ID into Monday does not establish an equivalent value. Matching labels or an explicit translation is required. These focused records show practical implementation and correction work. They do not establish a complete CRM migration audit, universal duplicate prevention or ownership of every component in the surrounding sales operation.
B2B order lifecycle
Carry the sales context
into the production record.
A longer team-training walkthrough follows a B2B inquiry from a Zoho form into linked Pipedrive person, organization and deal records. Routing uses order quantity or value, with a round-robin branch for the applicable sales range. Product-specific responses and activity notes make the handoff visible.
The next stages connect a deal folder, Square payment confirmation and a paid-deal path into WooCommerce. The order path checks for an existing order reference, requires product information and validates shipping details with a local-pickup exception. A sheet crosswalk maps products and variants; variable-length line items are collected into the order.
The production handoff adds reciprocal WooCommerce and Asana identifiers, links the related records and carries notes with their author and time. Stable IDs keep the relationship usable when a task or folder is renamed. The walkthrough also explains an unsynced flag, timestamp comparison and equivalent-status mapping in a shared order sheet.
Noah explains much of the automation as his work while crediting team contributions. A completed historical scenario run is visible, alongside payment-formatting and repeated-error-note defects. This version’s barcode scan-to-complete step was explicitly unfinished; other periods and the wider team account remain separate.
Within Dad’s Printing