The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.
TypeScript clickhousemysqlnextjsopen-sourceplanetscaleprismatailwindcsstinybirdtypescriptupstashvercel
import { createId } from "@/lib/api/create-id";
import { includeTags } from "@/lib/api/links/include-tags";
import { getNormalizedEmail } from "@/lib/email/normalize-email";
import { generateRandomName } from "@/lib/names";
import { prisma } from "@/lib/prisma";
import { getClickEvent, recordLead } from "@/lib/tinybird";
import { sendWorkspaceWebhook } from "@/lib/webhook/publish";
import { transformLeadEventData } from "@/lib/webhook/transform";
import { leadEventSchemaTB } from "@/lib/zod/schemas/leads";
import { nanoid } from "@dub/utils";
import { waitUntil } from "@vercel/functions";
import { queueGoogleAdsConversionUpload } from "../google-ads/upload-conversion";
import { ShopifyError } from "./error";
import { ShopifyOrder } from "./schema";
export async function createShopifyLead({
order,
clickId,
workspaceId,
}: {
order: ShopifyOrder;
clickId: string;
workspaceId: string;
}) {
const { customer: orderCustomer } = order;
const customerId = createId({ prefix: "cus_" });
/*
if orderCustomer is undefined (guest checkout):
- use the customerId as the externalId
- generate random name + email
*/
const externalId = orderCustomer?.id?.toString() || customerId; // need to convert to string because Shopify customer ID is a number
const name = orderCustomer
? `${orderCustomer.first_name} ${orderCustomer.last_name}`.trim()
: generateRandomName();
const email = orderCustomer?.email;
// find click
const clickData = await getClickEvent({ clickId });
if (!clickData) {
throw new ShopifyError("Click event not found. Skipping the order...");
}
if (clickData.workspace_id !== workspaceId) {
throw new ShopifyError(
"Click event not found in the workspace. Skipping the order...",
);
}
const { link_id: linkId, country, timestamp } = clickData;
const clickedLink = await prisma.link.findUnique({
where: {
id: linkId,
},
select: {
id: true,
disabledAt: true,
},
});
if (!clickedLink) {
throw new ShopifyError(
"Link not found in your workspace. Skipping the order...",
);
}
if (clickedLink.disabledAt) {
throw new ShopifyError("Link is disabled. Skipping the order...");
}
// create customer
const customer = await prisma.customer.create({
data: {
id: customerId,
externalId,
name,
email,
normalizedEmail: getNormalizedEmail(email),
projectId: workspaceId,
clickedAt: new Date(timestamp + "Z"),
clickId,
linkId,
country,
},
});
const leadEvent = {
id: nanoid(16),
name: "Account created",
};
const leadData = leadEventSchemaTB.parse({
...clickData,
workspace_id: clickData.workspace_id || customer.projectId, // in case for some reason the click event doesn't have workspace_id
event_id: leadEvent.id,
event_name: leadEvent.name,
customer_id: customer.id,
});
const [_lead, link, workspace] = await Promise.all([
// record lead
recordLead(leadData),
// update link leads count + lastLeadAt date
prisma.link.update({
where: {
id: linkId,
},
data: {
leads: {
increment: 1,
},
lastLeadAt: new Date(),
},
include: includeTags,
}),
// update workspace usage
prisma.project.update({
where: {
id: workspaceId,
},
data: {
usage: {
increment: 1,
},
},
}),
]);
waitUntil(
Promise.allSettled([
sendWorkspaceWebhook({
trigger: "lead.created",
workspace,
data: transformLeadEventData({
...clickData,
eventName: leadEvent.name,
link,
customer,
metadata: null,
}),
}),
queueGoogleAdsConversionUpload({
workspaceId: workspace.id,
eventType: "lead",
eventId: leadData.event_id,
eventName: leadData.event_name,
conversionDateTime: new Date().toISOString(),
conversionCount: 1,
click: {
id: clickData.click_id,
url: clickData.url,
},
}),
]),
);
return {
leadData,
};
}