Migrate from Perfect Books to Zoho CRM

Perfect Books customers contain both company and person data in a single record. We split this into a Zoho Account for the company entity and a Zoho Contact for the individual. Company name and domain map to Account.Name and Account.Website; individual name and email map to Contact.First_Name, Contact.Last_Name, and Contact.Email. The Account gets created first; the Contact references it via Account Name lookup.

Perfect Books product records (books) map to Zoho CRM Products. Fields like product name, SKU, unit price, and description carry over directly. The Products module serves as the catalog. If Perfect Books tracks inventory quantity, that maps to the Stock On Hand field in Zoho Products. Products are then linked to Potentials via Potentials > Products.

Authors in Perfect Books are people but not customers. We migrate them as Contacts with a custom pick-list field Author_Role__c set to 'Author'. The author's name, email, and bio map to the corresponding Contact fields. Authors linked to multiple books get multiple Product-Author junction records created as Zoho Contacts linked via a custom lookup.

Publishers in Perfect Books are organizational entities. We map them directly to Zoho Accounts with the publisher name, website, and address fields matching the source. Publisher can also be added as a custom lookup field on the Product record to preserve the direct relationship.

Perfect Books sales orders map to Zoho Potentials (Deals). The order total becomes the Potential Amount, the order date maps to the Close Date, and the order status (pending, completed, cancelled) maps to the StageName pick-list. If orders have a status like 'Shipped', we map that to a Zoho stage called 'Closed Won' and preserve the original status as a custom field.

Invoices in Perfect Books are transactional documents. We link the original invoice record as a custom field (Original_Invoice_Number__c) on the Zoho Potential that generated it. If Zoho Invoices module is in use, we map invoice number, amount, date, and status directly. Otherwise, invoices are preserved as a custom field on the associated deal.

ISBN is a critical field for book records with no native equivalent in Zoho CRM Products. We create a custom single-line text field ISBN__c on the Products module. ISBN-13 and ISBN-10 are stored together in the same field with a hyphen separator. The field is indexed for search.

Book genre in Perfect Books maps to a custom pick-list field Genre__c on the Products module. We extract unique genre values from Perfect Books during the audit phase, create the pick-list options, and map each product's genre value directly. If Perfect Books uses multi-select genres, we split them into separate comma-separated values within the pick-list.

Publication date migrates as a custom date field Publication_Date__c on Products. We store the raw date from Perfect Books as a Zoho Date field, which enables report filtering by publication year and sorting by release date. Original date formatting is preserved in a text backup field for audit purposes.

Notes attached to book records or customer records in Perfect Books migrate to Zoho CRM Notes on the matching Account or Contact. Timestamps and note authors are preserved where the source exports them. If Perfect Books records represent activities (calls, follow-ups), we map them to Zoho Tasks with Type, Subject, and Due Date.

Perfect Books owner IDs resolve to Zoho CRM users by email address match. We query Zoho Users, build the email lookup table, and update Owner_Id on every record. Any Perfect Books owner with no matching Zoho user email is flagged as an exception — your team either creates the Zoho user first or reassigns those records to a fallback owner before migration runs.

File attachments on Perfect Books records (book cover images, author photos, order PDFs) are downloaded and re-uploaded as Zoho CRM Attachments linked to the equivalent Products, Accounts, or Contacts record. Zoho's file size limit is 25 MB per attachment. Files exceeding this limit are flagged for manual review.