Method Community

 

Changing a customer to a lead

Last post 09-18-2012 4:18 PM by Anonymous. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-18-2012 12:41 PM

    Changing a customer to a lead

    Prior to using Method we added leads directly to Quickbooks as a job under a customer, there are no transactions related to a job entered as a lead in Quickbooks 

    Is it possible to change the customer to a lead in Method?

  • 09-18-2012 1:00 PM In reply to

    Re: Changing a customer to a lead


    Sorry to be more precise

     

    Is it possible to change a job to a lead and have the lead still associate with the customer

  • 09-18-2012 4:18 PM In reply to

    Re: Changing a customer to a lead

    Answer

    NeilSmellie:
    Is it possible to change a job to a lead and have the lead still associate with the customer

    The process to convert a customer to a lead is not automatic and would require a fair amount of exporting/importing and editing your lists in excel to acheive this.  The most important thing to be aware of is that any customer:jobs with transactions will not be deleted from QuickBooks - this action is not allowed.

    Here's an overview of the process:

    1. First export the customer table using our import/export tool from CustomizeIntegration Tools.  
    2. You'll want to take all the records with ParentFullName field filled in and move them to a new excel file (calling it leads), keeping the same layout.
    3. In the new excel file clean up the all the columns you're not using and delete columns like RecordID, IsLeadStatus, EntityType, LeadConvertedDate, etc.  You'll want to have just the contact information for the record in your clean leads file.  Keep the ParentFullName and ParentFullName_RecordID columns as those will associate the records with their Parent contacts.
    4. Once you have a the clean list of leads associated to their ParentFullName records go to QuickBooks and delete those customer:jobs.
    5. After syncing those customer:jobs should be out of your customer list and gone from your QuickBooks file.
    6. From the import/export tools import your leads list to the Customer Lead table.  This part is important as it will flag these records as leads.

    I highly recommend you consider booking time with one of our consultants to help you through this process (or complete it for you).

    If you decide to tackle this yourself test the process thoroughly on small lists and review our import/export help center article and webinar.  It may also be a good idea to backup your QuickBooks file just in case you run into any issues.

    ~C
Page 1 of 1 (3 items)