{ "backupType": "design-print-client-data", "version": "2026-07-02", "site": "https://www.designandprint.studio", "source": "manual-client-data", "createdAt": "2026-07-04T13:53:31.526Z", "adminPages": { "workflow": "https://www.designandprint.studio/workflow", "quoteAdmin": "https://www.designandprint.studio/_functions/quoteAdmin", "quotes": "https://www.designandprint.studio/_functions/recentQuotes", "invoices": "https://www.designandprint.studio/_functions/recentInvoices", "clients": "https://www.designandprint.studio/_functions/clientSetup", "suppliers": "https://www.designandprint.studio/_functions/supplierSetup", "products": "https://www.designandprint.studio/_functions/productSetup" }, "summary": [ { "collection": "WorkflowJobs", "ok": true, "count": 23, "error": "" }, { "collection": "Quotes", "ok": true, "count": 2, "error": "" }, { "collection": "ArtworkProofs", "ok": false, "count": 0, "error": "WDE0025: The ArtworkProofs collection does not exist." }, { "collection": "ClientArtworkProofs", "ok": true, "count": 2, "error": "" }, { "collection": "ClientProofs", "ok": false, "count": 0, "error": "WDE0025: The ClientProofs collection does not exist." }, { "collection": "Proofs", "ok": false, "count": 0, "error": "WDE0025: The Proofs collection does not exist." }, { "collection": "ProofApprovals", "ok": false, "count": 0, "error": "WDE0025: The ProofApprovals collection does not exist." }, { "collection": "ArtworkApprovals", "ok": false, "count": 0, "error": "WDE0025: The ArtworkApprovals collection does not exist." }, { "collection": "ClientArtwork", "ok": false, "count": 0, "error": "WDE0025: The ClientArtwork collection does not exist." }, { "collection": "ArtworkPortal", "ok": false, "count": 0, "error": "WDE0025: The ArtworkPortal collection does not exist." }, { "collection": "ArtworkJobs", "ok": false, "count": 0, "error": "WDE0025: The ArtworkJobs collection does not exist." }, { "collection": "Approvals", "ok": false, "count": 0, "error": "WDE0025: The Approvals collection does not exist." } ], "collections": { "WorkflowJobs": { "ok": true, "collection": "WorkflowJobs", "count": 23, "items": [ { "sellPrice": 20, "reference": "COD1000 | COD1001", "workflowStageDates": { "artwork": "2026-07-04T13:49:24.259Z", "invoice sent": "2026-07-04T13:47:40.174Z" }, "updatedAt": "2026-07-04T13:49:38.771Z", "quantity": 1, "quoteNumber": "COD1000", "linkUrl": "https://www.designandprint.studio/_functions/invoice?token=mr6f2v55dgv1v002or&admin=dp-workflow-private-2026", "sourceType": "invoice", "invoiceNumber": "COD1001", "artworkAdminUrl": "/_functions/artworkAdmin?admin=dp-workflow-private-2026&token=mr6f2v55dgv1v002or", "artworkUrl": "", "_id": "d38c0e1f-ded7-4ac6-b718-913b739c7ef1", "_owner": "be7add83-5ade-43f7-98b1-317c96a8ea58", "jobDescription": "Codex live workflow test - please archive after verification.", "_createdDate": "2026-07-04T13:47:40.232Z", "_updatedDate": "2026-07-04T13:49:38.978Z", "workflowStatus": "artwork", "quoteToken": "mr6esgibhw6j8hewyv", "totalAmount": 24, "clientEmail": "hello@designandprint.studio", "vatAmount": 4, "companyName": "Codex Live Test", "status": "artwork", "sourceCollection": "WorkflowJobs", "sortOrder": 1, "workflowHistory": [ { "date": "2026-07-04T13:47:40.174Z", "status": "invoice sent" }, { "date": "2026-07-04T13:49:24.259Z", "status": "artwork" } ], "createdAt": "2026-07-04T13:47:40.175Z", "quoteUrl": "/_functions/quote?token=mr6esgibhw6j8hewyv", "clientName": "Design Print Studio Test", "shippingAddress": "As client address", "quoteStatus": "", "title": "Business Cards", "sourceId": "c5eb94c3-b1c0-41f5-b3d6-32b5dd6684a8", "invoiceUrl": "https://www.designandprint.studio/_functions/invoice?token=mr6f2v55dgv1v002or&admin=dp-workflow-private-2026", "purchaseOrderReference": "", "invoiceStatus": "Paid" }, { "sellPrice": 20, "quickBooksSyncAt": "2026-07-04T13:49:26.367Z", "updatedAt": "2026-07-04T13:49:23.709Z", "quantity": 1, "quoteNumber": "COD1000", "sourceType": "invoice-record", "invoiceNumber": "COD1001", "postageAmount": 0, "quickBooksSyncError": "", "invoiceTotal": 24, "lineItems": [ { "quantity": 1, "costTotal": 10, "profitMargin": 50, "description": "450gsm, double sided, full colour, matt laminated", "total": 24, "profitAmount": 10, "markupPercent": 100, "version": "", "vatAmount": 4, "turnaround": "3-5 working days", "supplierName": "Tradeprint", "subtotal": 20, "itemName": "Business Cards", "costUnit": 10, "unitPrice": 20, "vatRate": 20 } ], "invoiceLinesJson": "[{\"quantity\":1,\"costTotal\":10,\"profitMargin\":50,\"description\":\"450gsm, double sided, full colour, matt laminated\",\"total\":24,\"profitAmount\":10,\"markupPercent\":100,\"version\":\"\",\"vatAmount\":4,\"turnaround\":\"3-5 working days\",\"supplierName\":\"Tradeprint\",\"subtotal\":20,\"itemName\":\"Business Cards\",\"costUnit\":10,\"unitPrice\":20,\"vatRate\":20}]", "paidAt": "2026-07-04T13:49:23.709Z", "quickBooksSalesReceiptNumber": "", "paymentStatus": "Paid", "_id": "c5eb94c3-b1c0-41f5-b3d6-32b5dd6684a8", "_owner": "be7add83-5ade-43f7-98b1-317c96a8ea58", "jobDescription": "Codex live workflow test - please archive after verification.", "_createdDate": "2026-07-04T13:47:38.963Z", "postageTotalAmount": 0, "bacsUrl": "https://www.designandprint.studio/_functions/invoiceBacs?token=mr6f2v55dgv1v002or", "clientPhone": "0161 442 4439", "_updatedDate": "2026-07-04T13:49:26.564Z", "workflowStatus": "artwork", "quickBooksSalesReceiptId": "", "quoteToken": "mr6esgibhw6j8hewyv", "totalAmount": 24, "clientEmail": "hello@designandprint.studio", "vatAmount": 4, "companyName": "Codex Live Test", "postageVatAmount": 0, "clientAddress": "Dale House\r\nTiviot Dale\r\nStockport\r\nSK1 1TA", "createdAt": "2026-07-04T13:47:38.904Z", "quickBooksSyncStatus": "not_configured", "paymentLink": "", "clientName": "Design Print Studio Test", "subtotalAmount": 20, "shippingAddress": "As client address", "paymentDate": "2026-07-04T13:49:23.709Z", "invoiceToken": "mr6f2v55dgv1v002or", "title": "COD1001", "jobTitle": "Business Cards", "vatRate": "mixed", "taxableSubtotalAmount": 20, "invoiceUrl": "https://www.designandprint.studio/_functions/invoice?token=mr6f2v55dgv1v002or", "zeroRatedSubtotalAmount": 0, "purchaseOrderReference": "", "invoiceStatus": "Paid" }, { "sellPrice": 20, "reference": "COD1000 | COD1001", "workflowStageDates": { "quote accepted": "2026-07-04T13:47:39.723Z", "quote sent": "2026-07-04T13:39:33.545Z" }, "updatedAt": "2026-07-04T13:49:37.988Z", "quantity": 1, "quoteNumber": "COD1000", "linkUrl": "https://www.designandprint.studio/_functions/invoice?token=mr6f2v55dgv1v002or&admin=dp-workflow-private-2026", "sourceType": "quote", "invoiceNumber": "COD1001", "artworkAdminUrl": "/_functions/artworkAdmin?admin=dp-workflow-private-2026&token=mr6f2v55dgv1v002or", "artworkUrl": "", "_id": "37033f80-8251-41e3-b722-9fd9707ee6f2", "_owner": "fde79797-5dbe-4720-8212-adc3883d2c33", "jobDescription": "Codex live workflow test - please archive after verification.", "_createdDate": "2026-07-04T13:39:33.600Z", "_updatedDate": "2026-07-04T13:49:38.224Z", "workflowStatus": "quote accepted", "quoteToken": "mr6esgibhw6j8hewyv", "totalAmount": 24, "clientEmail": "hello@designandprint.studio", "vatAmount": 4, "companyName": "Codex Live Test", "status": "quote accepted", "sourceCollection": "Quotes", "sortOrder": 1, "workflowHistory": [ { "date": "2026-07-04T13:39:33.545Z", "status": "quote sent" }, { "date": "2026-07-04T13:47:39.723Z", "status": "quote accepted" } ], "createdAt": "2026-07-04T13:39:33.546Z", "quoteUrl": "https://www.designandprint.studio/_functions/quote?token=mr6esgibhw6j8hewyv", "clientName": "Design Print Studio Test", "shippingAddress": "As client address", "quoteStatus": "Accepted", "title": "Business Cards", "sourceId": "fe26d2e6-7074-46d0-986f-3183e791d019", "invoiceUrl": "https://www.designandprint.studio/_functions/invoice?token=mr6f2v55dgv1v002or&admin=dp-workflow-private-2026", "purchaseOrderReference": "", "invoiceStatus": "" }, { "sellPrice": 40, "reference": "AGA1000", "workflowStageDates": { "quote sent": "2026-07-03T19:47:50.993Z" }, "updatedAt": "2026-07-04T13:49:38.395Z", "quantity": 2, "quoteNumber": "AGA1000", "linkUrl": "https://www.designandprint.studio/_functions/quote?token=mr5cgv97sgtegl46ff", "sourceType": "quote", "invoiceNumber": "", "artworkAdminUrl": "", "artworkUrl": "", "_id": "d4e817b0-cf89-40b1-b866-334c55ea6d4c", "_owner": "643c0648-2e4f-4546-8752-59acf0fb51e3", "jobDescription": "Live workflow test quote - Business Cards", "_createdDate": "2026-07-03T19:47:51.050Z", "_updatedDate": "2026-07-04T13:49:38.600Z", "workflowStatus": "quote sent", "quoteToken": "mr5cgv97sgtegl46ff", "totalAmount": 48, "clientEmail": "dan@agaujewellery.com", "vatAmount": 8, "companyName": "AgaU Jewellery", "status": "quote sent", "sourceCollection": "Quotes", "sortOrder": 1, "workflowHistory": [ { "date": "2026-07-03T19:47:50.993Z", "status": "quote sent" } ], "createdAt": "2026-07-03T19:47:50.993Z", "quoteUrl": "https://www.designandprint.studio/_functions/quote?token=mr5cgv97sgtegl46ff", "clientName": "Dan", "shippingAddress": "As client address", "quoteStatus": "Sent", "title": "Business Cards", "sourceId": "8f4becbf-edbb-4efb-9e31-bd71bd22b6f8", "invoiceUrl": "", "purchaseOrderReference": "", "invoiceStatus": "" }, { "updatedAt": "2026-07-03T10:08:55.288Z", "sourceType": "product-directory", "_id": "d538cf93-3d71-480c-8628-2ee390477298", "_createdDate": "2026-07-03T10:08:55.341Z", "productDetails": "Single sided, 250gsm", "_updatedDate": "2026-07-03T10:08:55.341Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T10:08:55.288Z", "productName": "Flyers A5", "productTurnaround": "5-7", "title": "Product: Flyers A5", "productSupplierName": "Tradeprint" }, { "updatedAt": "2026-07-03T10:08:36.836Z", "sourceType": "product-directory", "_id": "c30e3522-f183-48ea-a83c-0b4c01b077a5", "_createdDate": "2026-07-03T10:08:36.890Z", "productDetails": "Single sided, 130gsm", "_updatedDate": "2026-07-03T10:08:36.890Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T10:08:36.836Z", "productName": "Flyers A5", "productTurnaround": "5-7", "title": "Product: Flyers A5", "productSupplierName": "Tradeprint" }, { "updatedAt": "2026-07-03T10:08:26.595Z", "sourceType": "product-directory", "_id": "ee27914c-29d1-4a02-9a88-8760a3cf5ec0", "_createdDate": "2026-07-03T10:08:26.671Z", "productDetails": "Single sided, 170gsm", "_updatedDate": "2026-07-03T10:08:26.671Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T10:08:26.595Z", "productName": "Flyers A5", "productTurnaround": "5-7", "title": "Product: Flyers A5", "productSupplierName": "Tradeprint" }, { "updatedAt": "2026-07-03T10:07:34.775Z", "sourceType": "product-directory", "_id": "c1160830-d989-45b3-9efd-f8c00ef7eee3", "_createdDate": "2026-07-03T10:07:34.832Z", "productDetails": "450gsm, double sided, full colour, matt laminated, SPOT UV", "_updatedDate": "2026-07-03T10:07:34.832Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T10:07:34.775Z", "productName": "Business Cards", "productTurnaround": "5-7 WD", "title": "Product: Business Cards", "productSupplierName": "Tradeprint" }, { "updatedAt": "2026-07-03T10:07:09.697Z", "sourceType": "product-directory", "_id": "af50bb01-2484-4073-9bc4-c5bc6d14ea23", "_createdDate": "2026-07-03T10:06:25.094Z", "productDetails": "450gsm, double sided, full colour, STANDARD no lamination", "_updatedDate": "2026-07-03T10:07:09.965Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T10:06:25.029Z", "productName": "Business Cards", "productTurnaround": "5-7 WD", "title": "Product: Business Cards", "productSupplierName": "Tradeprint" }, { "updatedAt": "2026-07-03T09:42:45.356Z", "sourceType": "supplier-directory", "_id": "98518960-2818-4d41-9c37-eb309084a5a1", "_createdDate": "2026-07-03T09:42:45.459Z", "_updatedDate": "2026-07-03T09:42:45.459Z", "workflowStatus": "archive", "supplierWebsite": "https://www.tradeprint.co.uk/", "supplierSpecialists": "Everything", "supplierPhone": "", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T09:42:45.356Z", "supplierName": "Tradeprint", "title": "Supplier: Tradeprint", "supplierContact": "0330 024 0020", "supplierAddress": "Tradeprint\r\n2 Fulton Road\r\nDundee\r\nDD2 4SW" }, { "updatedAt": "2026-07-03T09:39:02.593Z", "sourceType": "client-directory", "_id": "79c11464-f790-4904-957b-c2d2ec8354cd", "_createdDate": "2026-07-03T09:39:02.650Z", "clientPhone": "01617061315", "_updatedDate": "2026-07-03T09:39:02.650Z", "workflowStatus": "archive", "clientEmail": "dan@calderbankgarbett.co.uk", "companyName": "TEST Business Ltd", "clientAddress": "Dale House\r\nSK11TA", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-03T09:39:02.593Z", "clientName": "Dan", "shippingAddress": "Howden Close", "title": "Client: TEST Business Ltd" }, { "updatedAt": "2026-07-03T10:07:03.172Z", "sourceType": "product-directory", "_id": "53f256ca-43b6-44b3-8c60-722696130d9a", "_createdDate": "2026-07-01T19:50:05.127Z", "productDetails": "450gsm, double sided, full colour, gloss laminated", "_updatedDate": "2026-07-03T10:07:03.459Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-01T19:50:05.048Z", "productName": "Business Cards", "productTurnaround": "5-7 WD", "title": "Product: Business Cards", "productSupplierName": "Tradeprint" }, { "updatedAt": "2026-07-03T10:06:57.907Z", "sourceType": "product-directory", "_id": "29a569f7-3e5c-436d-83ec-ae215bfb8d46", "_createdDate": "2026-07-01T19:49:47.240Z", "productDetails": "450gsm, double sided, full colour, matt laminated", "_updatedDate": "2026-07-03T10:06:58.189Z", "workflowStatus": "archive", "status": "archive", "sortOrder": 0, "createdAt": "2026-07-01T19:49:47.186Z", "productName": "Business Cards", "productTurnaround": "5-7 WD", "title": "Product: Business Cards", "productSupplierName": "Tradeprint" }, { "sellPrice": "", "reference": "", "updatedAt": "2026-06-30T21:08:44.793Z", "quantity": "", "quoteNumber": "", "sourceType": "artwork", "invoiceNumber": "", "artworkUrl": "https://static.wixstatic.com/media/8c1009_f23a590ab1944f43b897ad942885daab~mv2.jpg", "_id": "667e3781-6056-4e08-8503-1b5b04d1126f", "_owner": "74d4a91f-8d4b-4e7c-af5f-72bef6abc006", "jobDescription": "", "_createdDate": "2026-06-30T21:08:44.882Z", "_updatedDate": "2026-06-30T21:08:44.882Z", "workflowStatus": "pre print", "totalAmount": "", "vatAmount": "", "companyName": "", "status": "pre print", "sourceCollection": "ClientArtworkProofs", "sortOrder": 2, "createdAt": "2026-06-30T21:08:44.793Z", "clientName": "", "quoteStatus": "Approved - Reorder Requested", "title": "Test ONE", "sourceId": "d42527bf-3fbf-4af7-a142-1457c0751f52", "invoiceStatus": "" }, { "sellPrice": "", "reference": "", "workflowStageDates": { "archive": "2026-06-30T22:42:38.671Z" }, "updatedAt": "2026-06-30T22:42:38.671Z", "quantity": "", "quoteNumber": "", "sourceType": "artwork", "invoiceNumber": "", "previousStatus": "transit", "artworkUrl": "https://static.wixstatic.com/media/8c1009_f23a590ab1944f43b897ad942885daab~mv2.jpg", "_id": "419d6daf-9c83-41d2-935d-50a8ceb85908", "_owner": "3c032249-8905-4dfb-b461-db766fd4f64e", "jobDescription": "", "_createdDate": "2026-06-30T21:08:44.646Z", "_updatedDate": "2026-06-30T22:42:38.856Z", "workflowStatus": "archive", "totalAmount": "", "vatAmount": "", "companyName": "", "status": "archive", "sourceCollection": "ClientArtworkProofs", "sortOrder": 2, "workflowHistory": [ { "date": "2026-06-30T22:42:38.671Z", "status": "archive" } ], "createdAt": "2026-06-30T21:08:44.594Z", "clientName": "", "quoteStatus": "Approved - Reorder Requested", "title": "Test ONE", "sourceId": "d42527bf-3fbf-4af7-a142-1457c0751f52", "invoiceStatus": "" }, { "sellPrice": "", "reference": "", "updatedAt": "2026-06-30T21:08:44.574Z", "quantity": "", "quoteNumber": "", "sourceType": "artwork", "invoiceNumber": "", "artworkUrl": "https://static.wixstatic.com/media/8c1009_19aa43836b0d4716a4fc59112bb99b8a~mv2.webp", "_id": "ba5b3264-3956-417b-a74b-05a35ddc4a64", "_owner": "74d4a91f-8d4b-4e7c-af5f-72bef6abc006", "jobDescription": "", "_createdDate": "2026-06-30T21:08:44.630Z", "_updatedDate": "2026-06-30T21:08:44.630Z", "workflowStatus": "pre print", "totalAmount": "", "vatAmount": "", "companyName": "", "status": "pre print", "sourceCollection": "ClientArtworkProofs", "sortOrder": 1, "createdAt": "2026-06-30T21:08:44.574Z", "clientName": "", "quoteStatus": "Approved", "title": "Test three", "sourceId": "d56046b1-f48e-4d2b-9d41-5840406fffbd", "invoiceStatus": "" }, { "sellPrice": "", "reference": "", "workflowStageDates": { "pre print": "2026-06-30T22:21:07.398Z" }, "updatedAt": "2026-07-04T13:49:39.520Z", "quantity": "", "quoteNumber": "", "linkUrl": "", "sourceType": "artwork", "invoiceNumber": "", "artworkAdminUrl": "", "artworkUrl": "https://static.wixstatic.com/media/8c1009_f23a590ab1944f43b897ad942885daab~mv2.jpg", "_id": "948879b6-729c-4961-9f97-60f28b5d817d", "_owner": "ab6df79a-950e-441d-8a99-43e6bb3ca9c6", "jobDescription": "", "_createdDate": "2026-06-30T21:08:44.459Z", "_updatedDate": "2026-07-04T13:49:39.724Z", "workflowStatus": "pre print", "quoteToken": "", "totalAmount": "", "clientEmail": "hello@agaujewellery.com", "vatAmount": "", "companyName": "", "status": "pre print", "sourceCollection": "ClientArtworkProofs", "sortOrder": 2, "workflowHistory": [ { "date": "2026-06-30T22:21:07.398Z", "status": "pre print" } ], "createdAt": "2026-06-30T21:08:44.404Z", "quoteUrl": "", "clientName": "", "shippingAddress": "", "quoteStatus": "Approved - Reorder Requested", "workflowItems": "Test ONE", "title": "Test ONE", "jobTitle": "Test ONE", "sourceId": "d42527bf-3fbf-4af7-a142-1457c0751f52", "invoiceUrl": "", "purchaseOrderReference": "", "invoiceStatus": "" }, { "sellPrice": "", "reference": "", "workflowStageDates": { "archive": "2026-07-03T09:34:22.514Z" }, "updatedAt": "2026-07-03T09:34:22.514Z", "quantity": "", "quoteNumber": "", "sourceType": "artwork", "invoiceNumber": "", "previousStatus": "pre print", "artworkUrl": "https://static.wixstatic.com/media/8c1009_19aa43836b0d4716a4fc59112bb99b8a~mv2.webp", "_id": "16d5bec0-5f8c-4c9a-8b0b-5f6dfda0f2ab", "_owner": "3c032249-8905-4dfb-b461-db766fd4f64e", "jobDescription": "", "_createdDate": "2026-06-30T21:08:44.420Z", "_updatedDate": "2026-07-03T09:34:22.721Z", "workflowStatus": "archive", "totalAmount": "", "vatAmount": "", "companyName": "", "status": "archive", "sourceCollection": "ClientArtworkProofs", "sortOrder": 1, "workflowHistory": [ { "date": "2026-07-03T09:34:22.514Z", "status": "archive" } ], "createdAt": "2026-06-30T21:08:44.358Z", "clientName": "", "quoteStatus": "Approved", "title": "Test three", "sourceId": "d56046b1-f48e-4d2b-9d41-5840406fffbd", "invoiceStatus": "" }, { "sellPrice": "", "reference": "", "workflowStageDates": { "pre print": "2026-06-30T22:21:07.035Z" }, "updatedAt": "2026-07-04T13:49:39.153Z", "quantity": "", "quoteNumber": "", "linkUrl": "", "sourceType": "artwork", "invoiceNumber": "", "artworkAdminUrl": "", "artworkUrl": "https://static.wixstatic.com/media/8c1009_19aa43836b0d4716a4fc59112bb99b8a~mv2.webp", "_id": "60e80b2b-dc6a-45d6-8326-07e849b9d321", "_owner": "ab6df79a-950e-441d-8a99-43e6bb3ca9c6", "jobDescription": "", "_createdDate": "2026-06-30T21:08:44.225Z", "_updatedDate": "2026-07-04T13:49:39.351Z", "workflowStatus": "pre print", "quoteToken": "", "totalAmount": "", "clientEmail": "hello@agaujewellery.com", "vatAmount": "", "companyName": "", "status": "pre print", "sourceCollection": "ClientArtworkProofs", "sortOrder": 1, "workflowHistory": [ { "date": "2026-06-30T22:21:07.035Z", "status": "pre print" } ], "createdAt": "2026-06-30T21:08:44.158Z", "quoteUrl": "", "clientName": "", "shippingAddress": "", "quoteStatus": "Approved", "workflowItems": "Test three", "title": "Test three", "jobTitle": "Test three", "sourceId": "d56046b1-f48e-4d2b-9d41-5840406fffbd", "invoiceUrl": "", "purchaseOrderReference": "", "invoiceStatus": "" }, { "reference": "ART-1041", "updatedAt": "2026-06-30T20:22:49.083Z", "_id": "1f882094-3bc3-4148-b067-b76e1f976f47", "_owner": "0191ccfa-ea54-4af9-9749-a246ff0eac06", "_createdDate": "2026-06-30T19:43:56.028Z", "_updatedDate": "2026-06-30T20:22:49.309Z", "workflowStatus": "invoice sent", "status": "invoice sent", "sortOrder": 40, "createdAt": "2026-06-30T19:43:55.976Z", "clientName": "Nova Retail Ltd", "title": "Poster artwork pack" }, { "reference": "INV-2026-038", "updatedAt": "2026-06-30T20:36:33.948Z", "_id": "9f7b4137-a73d-4118-911d-1091ed75b952", "_owner": "0191ccfa-ea54-4af9-9749-a246ff0eac06", "_createdDate": "2026-06-30T19:43:55.811Z", "_updatedDate": "2026-06-30T20:36:34.164Z", "workflowStatus": "quote sent", "status": "quote sent", "sortOrder": 30, "createdAt": "2026-06-30T19:43:55.742Z", "clientName": "Stockport Studio", "title": "A-board and shop stickers" }, { "reference": "Q-2026-039", "updatedAt": "2026-06-30T20:28:47.251Z", "_id": "05581627-22d9-46ad-b62e-ae4242e04026", "_owner": "0191ccfa-ea54-4af9-9749-a246ff0eac06", "_createdDate": "2026-06-30T19:43:55.578Z", "_updatedDate": "2026-06-30T20:28:47.464Z", "workflowStatus": "artwork", "status": "artwork", "sortOrder": 20, "createdAt": "2026-06-30T19:43:55.516Z", "clientName": "Luma Interiors", "title": "Reception wall graphics" }, { "reference": "Q-2026-041", "updatedAt": "2026-06-30T20:27:39.310Z", "_id": "f9138192-097c-4658-a3eb-17803b28d29c", "_owner": "0191ccfa-ea54-4af9-9749-a246ff0eac06", "_createdDate": "2026-06-30T19:43:55.234Z", "_updatedDate": "2026-06-30T20:27:39.519Z", "workflowStatus": "on proof", "status": "on proof", "sortOrder": 10, "createdAt": "2026-06-30T19:43:55.077Z", "clientName": "Nova Retail Ltd", "title": "Window vinyl and launch posters" } ] }, "Quotes": { "ok": true, "collection": "Quotes", "count": 2, "items": [ { "sellPrice": 20, "quoteLinesJson": "[{\"supplierName\":\"Tradeprint\",\"itemName\":\"Business Cards\",\"description\":\"450gsm, double sided, full colour, matt laminated\",\"version\":\"\",\"turnaround\":\"3-5 working days\",\"quantity\":1,\"costUnit\":10,\"markupPercent\":100,\"unitPrice\":20,\"subtotal\":20,\"vatRate\":20,\"vatAmount\":4,\"total\":24,\"costTotal\":10,\"profitAmount\":10,\"profitMargin\":50}]", "acceptedVatAmount": 4, "updatedAt": "2026-07-04T13:39:33.225Z", "quantity": 1, "quoteNumber": "COD1000", "invoiceNumber": "COD1001", "postageAmount": 0, "acceptedPostageAmount": 0, "lineItems": [ { "quantity": 1, "costTotal": 10, "profitMargin": 50, "description": "450gsm, double sided, full colour, matt laminated", "total": 24, "profitAmount": 10, "markupPercent": 100, "version": "", "vatAmount": 4, "turnaround": "3-5 working days", "supplierName": "Tradeprint", "subtotal": 20, "itemName": "Business Cards", "costUnit": 10, "unitPrice": 20, "vatRate": 20 } ], "profitMargin": 50, "_id": "fe26d2e6-7074-46d0-986f-3183e791d019", "_owner": "fde79797-5dbe-4720-8212-adc3883d2c33", "jobDescription": "Codex live workflow test - please archive after verification.", "_createdDate": "2026-07-04T13:39:33.286Z", "validUntil": "2026-07-11", "postageTotalAmount": 0, "acceptedAt": "2026-07-04T13:47:39.139Z", "clientPhone": "0161 442 4439", "internalPricingJson": "[{\"supplierName\":\"Tradeprint\",\"itemName\":\"Business Cards\",\"description\":\"450gsm, double sided, full colour, matt laminated\",\"version\":\"\",\"turnaround\":\"3-5 working days\",\"quantity\":1,\"costUnit\":10,\"costTotal\":10,\"markupPercent\":100,\"unitPrice\":20,\"subtotal\":20,\"profitAmount\":10,\"profitMargin\":50}]", "_updatedDate": "2026-07-04T13:47:39.469Z", "workflowStatus": "quote accepted", "profitAmount": 10, "acceptedTotalAmount": 24, "quoteToken": "mr6esgibhw6j8hewyv", "totalAmount": 24, "paymentTerms": "Full payment is required before any work is commenced unless otherwise agreed.", "clientEmail": "hello@designandprint.studio", "vatAmount": 4, "acceptedSubtotalAmount": 20, "companyName": "Codex Live Test", "postageVatAmount": 0, "acceptedLineItems": [ { "quantity": 1, "costTotal": 10, "profitMargin": 50, "description": "450gsm, double sided, full colour, matt laminated", "total": 24, "profitAmount": 10, "markupPercent": 100, "version": "", "vatAmount": 4, "turnaround": "3-5 working days", "supplierName": "Tradeprint", "subtotal": 20, "itemName": "Business Cards", "costUnit": 10, "unitPrice": 20, "vatRate": 20 } ], "clientAddress": "Dale House\r\nTiviot Dale\r\nStockport\r\nSK1 1TA", "acceptedPostageVatAmount": 0, "status": "Accepted", "createdAt": "2026-07-04T13:39:33.225Z", "quoteUrl": "https://www.designandprint.studio/_functions/quote?token=mr6esgibhw6j8hewyv", "declineUrl": "https://www.designandprint.studio/_functions/quoteDecline?token=mr6esgibhw6j8hewyv", "costPrice": 10, "clientName": "Design Print Studio Test", "subtotalAmount": 20, "shippingAddress": "As client address", "invoiceToken": "mr6f2v55dgv1v002or", "quoteDate": "2026-07-04", "title": "COD1000", "acceptedLineItemsJson": "[{\"quantity\":1,\"costTotal\":10,\"profitMargin\":50,\"description\":\"450gsm, double sided, full colour, matt laminated\",\"total\":24,\"profitAmount\":10,\"markupPercent\":100,\"version\":\"\",\"vatAmount\":4,\"turnaround\":\"3-5 working days\",\"supplierName\":\"Tradeprint\",\"subtotal\":20,\"itemName\":\"Business Cards\",\"costUnit\":10,\"unitPrice\":20,\"vatRate\":20}]", "quotePdfUrl": "https://www.designandprint.studio/_functions/quotePdf?token=mr6esgibhw6j8hewyv", "jobTitle": "Business Cards", "vatRate": "mixed", "taxableSubtotalAmount": 20, "acceptUrl": "https://www.designandprint.studio/_functions/quoteAccept?token=mr6esgibhw6j8hewyv", "invoiceUrl": "https://www.designandprint.studio/_functions/invoice?token=mr6f2v55dgv1v002or", "zeroRatedSubtotalAmount": 0, "purchaseOrderReference": "" }, { "sellPrice": 40, "quoteLinesJson": "[{\"supplierName\":\"Tradeprint\",\"itemName\":\"Business Cards\",\"description\":\"450gsm, double sided, full colour, matt laminated\",\"version\":\"\",\"turnaround\":\"3-5 working days\",\"quantity\":2,\"costUnit\":10,\"markupPercent\":100,\"unitPrice\":20,\"subtotal\":40,\"vatRate\":20,\"vatAmount\":8,\"total\":48,\"costTotal\":20,\"profitAmount\":20,\"profitMargin\":50}]", "updatedAt": "2026-07-03T19:47:50.522Z", "quantity": 2, "quoteNumber": "AGA1000", "postageAmount": 0, "lineItems": [ { "quantity": 2, "costTotal": 20, "profitMargin": 50, "description": "450gsm, double sided, full colour, matt laminated", "total": 48, "profitAmount": 20, "markupPercent": 100, "version": "", "vatAmount": 8, "turnaround": "3-5 working days", "supplierName": "Tradeprint", "subtotal": 40, "itemName": "Business Cards", "costUnit": 10, "unitPrice": 20, "vatRate": 20 } ], "profitMargin": 50, "_id": "8f4becbf-edbb-4efb-9e31-bd71bd22b6f8", "_owner": "22ed8f00-c802-4c3e-b887-cd3d11e3a680", "jobDescription": "Live workflow test quote - Business Cards", "_createdDate": "2026-07-03T19:46:46.969Z", "validUntil": "2026-07-10", "postageTotalAmount": 0, "clientPhone": "", "internalPricingJson": "[{\"supplierName\":\"Tradeprint\",\"itemName\":\"Business Cards\",\"description\":\"450gsm, double sided, full colour, matt laminated\",\"version\":\"\",\"turnaround\":\"3-5 working days\",\"quantity\":2,\"costUnit\":10,\"costTotal\":20,\"markupPercent\":100,\"unitPrice\":20,\"subtotal\":40,\"profitAmount\":20,\"profitMargin\":50}]", "_updatedDate": "2026-07-03T19:47:50.727Z", "workflowStatus": "quote sent", "profitAmount": 20, "quoteToken": "mr5cgv97sgtegl46ff", "totalAmount": 48, "paymentTerms": "Full payment is required before any work is commenced unless otherwise agreed.", "clientEmail": "dan@agaujewellery.com", "vatAmount": 8, "companyName": "AgaU Jewellery", "postageVatAmount": 0, "clientAddress": "Test quote for live workflow check", "status": "Sent", "createdAt": "2026-07-03T19:46:46.915Z", "quoteUrl": "https://www.designandprint.studio/_functions/quote?token=mr5cgv97sgtegl46ff", "declineUrl": "https://www.designandprint.studio/_functions/quoteDecline?token=mr5cgv97sgtegl46ff", "costPrice": 20, "clientName": "Dan", "subtotalAmount": 40, "shippingAddress": "As client address", "quoteDate": "2026-07-03", "title": "AGA1000", "quotePdfUrl": "https://www.designandprint.studio/_functions/quotePdf?token=mr5cgv97sgtegl46ff", "jobTitle": "Business Cards", "vatRate": "mixed", "taxableSubtotalAmount": 40, "acceptUrl": "https://www.designandprint.studio/_functions/quoteAccept?token=mr5cgv97sgtegl46ff", "zeroRatedSubtotalAmount": 0 } ] }, "ArtworkProofs": { "ok": false, "collection": "ArtworkProofs", "count": 0, "items": [], "error": "WDE0025: The ArtworkProofs collection does not exist." }, "ClientArtworkProofs": { "ok": true, "collection": "ClientArtworkProofs", "count": 2, "items": [ { "productionCompletedAt": null, "_publishDate": "2026-06-29T18:42:48.218Z", "projectName": "Test three", "lastUpdated": "2026-06-29T20:08:54.005Z", "_id": "d56046b1-f48e-4d2b-9d41-5840406fffbd", "_draftDate": null, "_owner": "8c100943-7a50-491c-a3a5-32da8951a9a1", "_createdDate": "2026-06-29T18:43:47.447Z", "productionStage": "production", "_updatedDate": "2026-06-30T13:23:03.120Z", "proofImage": "wix:image://v1/8c1009_19aa43836b0d4716a4fc59112bb99b8a~mv2.webp/colorful-overlapping-elevate-text-white-background-vibrant-graphic-featuring-word-spelled-.webp#originWidth=800&originHeight=340", "approvedAt": "2026-06-29T20:08:54.005Z", "clientComment": "Approved by: TEST REPLY\nSignature: data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA4QAAAEECAYAAABwYfrKAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAADhKADAAQAAAABAAABBAAAAABeOjstAAAf2ElEQV", "version": "4", "clientEmail": "hello@agaujewellery.com", "status": "Approved", "_publishStatus": "PUBLISHED", "dueDate": "2026-06-30", "productionNotes": "", "productionUpdatedAt": "2026-06-30T13:23:02.789Z", "proofTitle": "Elevate" }, { "productionCompletedAt": null, "productionJobType": "Reorder quote", "_publishDate": "2026-06-29T13:49:47.541Z", "projectName": "Test ONE", "productionQuantity": "1", "lastUpdated": "2026-06-29T21:07:46.022Z", "_id": "d42527bf-3fbf-4af7-a142-1457c0751f52", "_draftDate": null, "_owner": "8c100943-7a50-491c-a3a5-32da8951a9a1", "_createdDate": "2026-06-29T13:50:11.393Z", "productionStage": "new", "_updatedDate": "2026-06-30T13:23:19.471Z", "proofImage": "wix:image://v1/8c1009_f23a590ab1944f43b897ad942885daab~mv2.jpg/Tri%20Fold%20Flyers%20A4.jpg#originWidth=1748&originHeight=2480", "approvedAt": "2026-06-29T20:18:29.046Z", "clientComment": "Approved by: dan\nSignature: data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA4QAAAEECAYAAABwYfrKAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAADhKADAAQAAAABAAABBAAAAABeOjstAAAkd0lEQV\n\nReorder quote requested on 29/06/2026.\nQuantity: 1\nNotes: Quote requested from artwork archive for 1.", "version": "g", "clientEmail": "hello@agaujewellery.com", "productionAddedAt": "2026-06-29T21:07:46.033Z", "status": "Approved - Reorder Requested", "_publishStatus": "PUBLISHED", "productionNotes": "Quote requested from artwork archive for 1.", "productionUpdatedAt": "2026-06-30T13:23:19.260Z", "proofTitle": "g" } ] }, "ClientProofs": { "ok": false, "collection": "ClientProofs", "count": 0, "items": [], "error": "WDE0025: The ClientProofs collection does not exist." }, "Proofs": { "ok": false, "collection": "Proofs", "count": 0, "items": [], "error": "WDE0025: The Proofs collection does not exist." }, "ProofApprovals": { "ok": false, "collection": "ProofApprovals", "count": 0, "items": [], "error": "WDE0025: The ProofApprovals collection does not exist." }, "ArtworkApprovals": { "ok": false, "collection": "ArtworkApprovals", "count": 0, "items": [], "error": "WDE0025: The ArtworkApprovals collection does not exist." }, "ClientArtwork": { "ok": false, "collection": "ClientArtwork", "count": 0, "items": [], "error": "WDE0025: The ClientArtwork collection does not exist." }, "ArtworkPortal": { "ok": false, "collection": "ArtworkPortal", "count": 0, "items": [], "error": "WDE0025: The ArtworkPortal collection does not exist." }, "ArtworkJobs": { "ok": false, "collection": "ArtworkJobs", "count": 0, "items": [], "error": "WDE0025: The ArtworkJobs collection does not exist." }, "Approvals": { "ok": false, "collection": "Approvals", "count": 0, "items": [], "error": "WDE0025: The Approvals collection does not exist." } } }