Dad’s Printing / Commerce / System 01 of 06
2021Recorded work
Partner
Marketplace orders into production
Carry each purchase, product choice and artwork reference into work the production team can use.
- Noah’s contribution
- Noah changed the scenario mappings, demonstrated multi-item order handling, and explained the handoff to the team.
- Historical stage
- Historical implementation note and sample order tests; multichannel hub described retrospectively.
- Part of the business
- Dad’s Printing overview ↗
- Etsy
- WooCommerce
- Asana
- Make / Integromat
- Google Sheets
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.
- Automatic Etsy intake
Bring marketplace purchases and their transaction/item context into the central store. - Manual eBay intake
The B2C handover retains manual eBay entry and artwork exceptions. - WooCommerce order hub
Keep storefront/order references, customer choices and the shared production handoff together. - Persistent product crosswalk
Retain commerce/CRM product IDs and match a product with its variant when one exists. - Product relationship present?
Use the catalog mapping before sending product data into the downstream order. - Reuse the mapped product
Carry the known product or product/variant relationship into the order. - Create missing product relationship
The described create-if-missing branch repairs a newly introduced CRM product. - Aggregate each line item
Keep variation labels, personalization and customer graphic links with the matching product. - Related Asana production task
Carry item context and folder links with reciprocal production and commerce IDs. - Primary listing-image attachment
In the earlier direct route, attach the downloaded image when retrieval succeeds. - Earlier direct Etsy-to-Asana version
Create the task directly with readable item context and optional listing-image attachment.
Key records
The information
that carries forward.
| Record | Information | Purpose |
|---|---|---|
| Marketplace purchase | Order reference, transactions, quantities, product variations and personalization. | Preserve what the customer selected across a multi-item order. |
| Production task | Readable item details, customer graphic links and primary listing image. | Give production staff a working record with product context. |
| Order crosswalk | Existing storefront/order relationships in a sheet. | Support an existing-order check and connect records between tools. |
Inside the system / 01
The business handoff
An Etsy order for a personalized product is a small production specification. The team needs more than the purchaser’s name and shipping address: it needs to know which item each variation belongs to, which personalization was requested and where to find the customer’s graphic. That becomes harder when one purchase contains several products with different options.
The directly attributed handoff note says the scenario was set up to move both single-item and multiple-item orders into Asana using the team’s supplied format. Noah’s changes added the line-item information dynamically, including personalization, variations and links to customer graphics. This is a specific integration contribution within an existing production operation, rather than evidence that he created the entire business process.
Inside the system / 02
Transforming the order into a task
In the recorded walkthrough, Noah selects a multi-item order and labels the resulting task as a test. He explains two layers of collection: variation names and values are assembled into readable lines, then the individual transactions are aggregated into the task’s description. A color or size therefore stays attached to the relevant purchase detail rather than being flattened into an unexplained value.
The task also receives the primary image from the marketplace listing. The described sequence downloads that image, creates the task and adds the image as an attachment when the download succeeds. This image supplies product context; it is not the customer’s print-ready artwork. The implementation note makes the same distinction by recording customer graphic links separately from the attached listing image.
The readable description is itself part of the handoff design. Noah explains where an additional transaction field could be inserted and how names, values and line breaks are assembled. That makes the task format maintainable by the team: a new information requirement can be added to the mapped description rather than becoming a separate manual message. The source does not prove that every possible product option was covered, but it does show the mechanism used for the options in the sample.
Inside the system / 03
The WooCommerce branch
The same walkthrough covers Etsy-to-WooCommerce work. An existing order is initially not created again because it is already represented in the sheet. Noah then uses a modified sample for the demonstration and shows the WooCommerce record, describing corrected line-item, billing and shipping mappings. These are useful sample checks of the configured behavior, not a reconciliation of every historical order.
Noah explains that the direct Etsy-to-Asana route could become redundant once Etsy-to-WooCommerce was resolved. A later named Dad’s Printing account describes several commerce platforms feeding one WooCommerce store connected to production. These are stages toward a common order hub; the exact transition dates remain open.
Inside the system / 04
Delivery scope and unfinished work
The handoff was prepared around a holiday selling period. Noah concentrated on required fields first. Automatic customer-image downloads and conversion of shared links to direct-download links remained optional work requiring example links. Graphic links traveled with the order; complete automatic collection of customer files was not established.
The walkthrough also raises a board-scope question: the scenario appears to add products without a sock-specific filter, and Noah asks whether the board has become universal. He proposes consistent SKUs as a cleaner way to connect Etsy and WooCommerce products, with catalog cleanup required first. Neither discussion establishes a completed filter policy or finished SKU-matching redesign. The outcome supported here is a configured, explained handoff with sample order checks and clear follow-up decisions; no measured time saving or fulfillment-error reduction is available.
Catalog and marketplace routing
Map the product once.
Keep its identity through the handoff.
Catalog maintenance had to account for people creating new CRM products instead of reusing existing entries. Noah describes adding a create-if-missing branch so the order workflow could recover the product relationship. Another walkthrough explains matching a product alone when no variant exists, or matching the product and variant together when it does.
The mapping sheet was an integration contract. Deleting an apparently spare column could redirect positional mappings, so changes needed to preserve those references. A proposed Shopify catalog transfer would write the new Shopify identifiers beside the WooCommerce identifiers; the recording does not establish that migration as complete.
A related architecture discussion recommends bringing Etsy, Shopify and direct-site orders into WooCommerce before a shared artwork-sheet process. Storefront metadata would preserve the source while a persistent catalog crosswalk handled product identity. The common downstream scenario had historical successful runs, but source-routing changes and a regressed folder hyperlink still needed repair.
Bulk catalog maintenance used a controlled work queue. Noah adapted a teammate’s category-update scenario with a completed-row flag so a stopped batch could resume without selecting every finished row again. The demonstration catches a wrong store connection and missing category mappings; part of the final cleanup remains off-record, so it does not establish a fully reconciled catalog.
The B2C handover distinguishes automatic Etsy intake from manual eBay entry into the central store, with manual artwork exceptions retained. Downstream records carry folder links, aggregated line-item text and reciprocal production IDs. A thirty-minute polling interval with a thirty-five-minute lookback provides overlap for delayed events; the narrated design still does not prove concurrency or replay safety.
A separate product-gallery test provides a narrower success: Noah improves a teammate’s workaround with array aggregation, corrects an output that repeated the images and demonstrates a new WooCommerce test product containing the intended two images. That is a component test, rather than a completed mass-publishing rollout.
Within Dad’s Printing