Pervasive DataSolutions Logo

Duplicate products

Last post 05-06-2010 3:34 PM by nformby. 18 replies.
Page 1 of 2 (19 items) 1 2 Next >
Sort Posts: Previous Next
  • 01-08-2010 11:06 AM

    Duplicate products

    Answer

    For some reason there are a bunch of duplicate products.  Is there some way to merge them or fix this?

  • 01-08-2010 11:10 AM In reply to

    Re: Duplicate products

    Answer

    Salesforce does not offer merging of products.

    Were the products created in both QuickBooks and Salesforce manually?

  • 01-08-2010 11:16 AM In reply to

    Re: Duplicate products

    Answer

    Nope, the products were created in QB and from there put into SF.  Have no idea how or why there are duplicate products.  If I can't delete them or merge them can I make them inactive so they dont show up?

  • 01-08-2010 11:25 AM In reply to

    Re: Duplicate products

    Answer

    Do the duplicate products have the same Item ListIDs?

  • 01-08-2010 11:49 AM In reply to

    Re: Duplicate products

    Answer

    yes

  • 01-08-2010 12:05 PM In reply to

    Re: Duplicate products

    Answer

    It could be possible that, at one point, when DataSynch ran that it could not connect to Salesforce causing DataSynch to not be able to see that the Products were already matched. Are there a lot of them? You would need to manually delete the duplicate since Salesforce does not offer merging.

  • 01-08-2010 12:09 PM In reply to

    Re: Duplicate products

    Answer

    thanks.

  • 04-08-2010 1:15 PM In reply to

    Re: Duplicate products

    Answer

    It appears that now the duplicate products have different ID no's.  We rescently changed some product codes, adding a .02 or .05 after them.  It looks to me like the original product's in SF were update with the new product no's, but, new product were also created.  So for instance I now have two product with the same product code of 6003.05.

    Action Product Name Product Code Product Description Product Family
    Edit | Deactivate Turn-key ~ Tech Sup/Labor 6003.05 Turn-key~Technical Supervision/Labor as per the following "Scope of Work". Does not include any parts or materials. Service
    Edit | Deactivate Turnkey ~ Technical Supervision/Labor - (Suggested) $1,200/8 hr. day (including travel days) plus normal expenses. Availability of technical supervision must be confirmed prior to order placement and cannot be reserved until receipt of purchase order. 6003.05 Turnkey ~ Technical Supervision/Labor - (Suggested) $1,200/8 hr. day (including travel days) plus normal expenses.
    Availability of technical supervision must be confirmed prior to order placement and cannot be reserved until receipt of purchase order.
    Service

    This is the original one.

    Product Detail

       

    Product Name
    Turn-key ~ Tech Sup/Labor
    Product Family
    Service
    Product Code
    6003.05
    Active
     
    Product Type
    Supervision/Labor
    Billing Method
    Fixed
    Unit of Measure
    Job
    Taxable sfdcPage.setHelp('Product2.00N30000002s4ja', 'Check if this product is taxable in the state of CA.');
     
    Product Description
    Turn-key~Technical Supervision/Labor as per the following "Scope of Work". Does not include any parts or materials.
    Created By
    Nikola Formby, 11/13/2008 2:51 PM
    Last Modified By
    Nikola Formby, 4/8/2010 10:52 AM
     

    QuickBooks Information:

    Average Cost
     
    Quantity On Hand
     
    Cost
    $16,200.00
    QB Item Type
    Service
    Item ListID
    80000722-1226601459
       
     

    This is the new one.

    Product Detail

       

    Product Name
    Turnkey ~ Technical Supervision/Labor - (Suggested) $1,200/8 hr. day (including travel days) plus normal expenses. Availability of technical supervision must be confirmed prior to order placement and cannot be reserved until receipt of purchase order.
    Product Family
    Service
    Product Code
    6003.05
    Active
     
    Product Type
    Supervision
    Billing Method
     
    Unit of Measure
    Job
    Taxable sfdcPage.setHelp('Product2.00N30000002s4ja', 'Check if this product is taxable in the state of CA.');
     
    Product Description
    Turnkey ~ Technical Supervision/Labor - (Suggested) $1,200/8 hr. day (including travel days) plus normal expenses.
    Availability of technical supervision must be confirmed prior to order placement and cannot be reserved until receipt of purchase order.
    Created By
    Nikola Formby, 3/12/2009 2:59 PM
    Last Modified By
    Nikola Formby, 3/24/2010 3:18 PM
     

    QuickBooks Information:

    Average Cost
     
    Quantity On Hand
     
    Cost
    $120,266.00
    QB Item Type
    Non-inventory Part
    Item ListID
    1A0000-1112919909
       
     
  • 04-08-2010 2:03 PM In reply to

    Re: Duplicate products

    Answer

     Do both of those products have the same Item List ID in Salesforce?

  • 04-08-2010 2:13 PM In reply to

    Re: Duplicate products

    Answer

    No they are different, I tried to copy and paste what each one says... can you not see?

  • 04-08-2010 2:26 PM In reply to

    Re: Duplicate products

    Answer

    My apologies, I was having a bit of trouble understanding the data.

     

    I would then not call those duplicates. Each product is unique in QuickBooks. They might have the same name in Salesforce ( we will get to this in a bit) , but they are uniquely represented in QuickBooks.

    It is very possible that one of those items was renamed in QuickBooks and set to inactive. Please remember that DataSynch will not synch inactive QuickBooks Items.

    It is also possible that the QuickBooks Item was created, synched, and then later deleted from QuickBooks.

    The newly created Product in Salesforce is most likely the accurate QuickBooks item.


  • 04-08-2010 4:19 PM In reply to

    Re: Duplicate products

    Answer

    Nothing was deleted and nothing was newly created.  The product code was changed from 6003 to 6003.05.  Nothing was made inactive and I did the change during a time that the synch was not in process. There is only 1 item in QB, how can there be 2 items in SF with 2 seperate ID's?

     

  • 04-08-2010 4:30 PM In reply to

    Re: Duplicate products

    Answer
    Each record in QB has its own ID, generated by QB. No record will have the same ID as another nor will a single record have two IDs. Please ensure that your items were not set to Inactive. You can do this by going to the Items list, clicking on the Item drop-down and select "Show Inactive Items."
  • 05-06-2010 1:40 PM In reply to

    Re: Duplicate products

    Answer

    I just added a few part numbers into QB which created new products in SF.  Not sure why or how but there are two of each of the products I just created.  I only clicked on the add button once for each item so not sure why or how this is happening.  Each one shows being added today but they are have different ItemListID's.

    Keyword:"DuraFlex I 17.5"

    Product Name Product CodeSorted Ascending Standard Price Product Description Product Family
      17.5 Rotor -DuraFlex Cold-End Circumferential Seal Set (14 Seals) 1301C-I-17.5 $3,094.00 17.5 Rotor -DuraFlex Cold-End Circumferential Seal Set (14 Seals)  
      17.5 Rotor -DuraFlex Cold-End Circumferential Seal Set (14 Seals) 1301C-I-17.5 $3,094.00 17.5 Rotor -DuraFlex Cold-End Circumferential Seal Set (14 Seals)  
      17.5 Rotor -DuraFlex Hot-End Circumferential Seal Set (14 Seals) 1301H-I-17.5 $3,094.00 17.5 Rotor -DuraFlex Hot-End Circumferential Seal Set (14 Seals)  
      17.5 Rotor -DuraFlex Hot-End Circumferential Seal Set (14 Seals) 1301H-I-17.5 $3,094.00 17.5 Rotor -DuraFlex Hot-End Circumferential Seal Set (14 Seals)  
      17.5 Rotor - DuraFlex Cold-End Bypass Seal Set (14 Seals) 1401C-I-17.5 $3,094.00 17.5 Rotor - DuraFlex Cold-End Bypass Seal Set (14 Seals)  
      17.5 Rotor - DuraFlex Cold-End Bypass Seal Set (14 Seals) 1401C-I-17.5 $3,094.00 17.5 Rotor - DuraFlex Cold-End Bypass Seal Set (14 Seals)  
      17.5 Rotor - DuraFlex Hot-End Bypass Seal Set (14 Seals) 1401H-I-17.5 $3,094.00 17.5 Rotor - DuraFlex Hot-End Bypass Seal Set (14 Seals)  
      17.5 Rotor - DuraFlex Hot-End Bypass Seal Set (14 Seals) 1401H-I-17.5 $3,094.00 17.5 Rotor - DuraFlex Hot-End Bypass Seal Set (14 Seals)
  • 05-06-2010 3:11 PM In reply to

    Re: Duplicate products

    Answer
    Can you include the created dates on that listing please?
Page 1 of 2 (19 items) 1 2 Next >

Copyright © 2009 Pervasive Software, Inc. All Rights Reserved. All Pervasive brand and product names are trademarks or registered trademarks of Pervasive Software Inc. in the United States and other countries. All other marks are the property of their respective owners. Your transaction secured by high-grade AES-256 encryption.