Answers.Body: <p>Sorry - your best bet is a big pot of coffee and just getting it done via the GUI! That's because there are quite a few places in the database that are touched when storing price options. Even with phpMyAdmin access (like you have) it's going to be a lot of copying of rows - then updating IDs - carefully linking them properly to the other tables involved in Pricesets. Something is likely going to be out of place. Best to use the GUI. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T22:42:59.843Z
Answers.Text: Thanks, I figured this was the answer, but I also figured it was worth avoiding carpal tunnel syndrome by asking the question. Also, this sounds like it would be a worthy extension to be made (or perhaps core functionality).
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T22:52:40.137Z
Answers.Text: Yes - that would indeed be useful - I think a lot of us have been there - done that!
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T22:25:50.373Z
Answers.LastActivityDate: 2016-05-25T22:25:50.373Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>Currently one can Clone an entire Price Set, however it is not possible AFAIK to clone Price Fields with their Price Options. </p>
  
  <p>Does anyone have a clever way to do this, front end or backend?</p>
  
  <p>My situation: I am creating a large amount of fields, but many are just copies. Such as Person 1 Data, Person 2 Data, Person 3 Data. I need to clone everything EXCEPT the Price Field Title.</p>
  
  <p>Thanks! (and take pity on my wrists and mouse)</p>
  
Tags: <civievent><price-sets>
Title: How to Clone a Price Set Field and Its Options
ThreadText: # How to Clone a Price Set Field and Its Options
  
  (Asked by: username_0 on 2016-05-25)
  
  Currently one can Clone an entire Price Set, however it is not possible AFAIK to clone Price Fields with their Price Options.
  
  Does anyone have a clever way to do this, front end or backend?
  
  My situation: I am creating a large amount of fields, but many are just copies. Such as Person 1 Data, Person 2 Data, Person 3 Data. I need to clone everything EXCEPT the Price Field Title.
  
  Thanks! (and take pity on my wrists and mouse)
  
  **Tags:** civievent, price-sets
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-05-25. Score: 3 | Accepted answer
  
  Sorry - your best bet is a big pot of coffee and just getting it done via the GUI! That's because there are quite a few places in the database that are touched when storing price options. Even with phpMyAdmin access (like you have) it's going to be a lot of copying of rows - then updating IDs - carefully linking them properly to the other tables involved in Pricesets. Something is likely going to be out of place. Best to use the GUI.
  
  > **Comments:**
  > **username_0**: Thanks, I figured this was the answer, but I also figured it was worth avoiding carpal tunnel syndrome by asking the question. Also, this sounds like it would be a worthy extension to be made (or perhaps core functionality).  
  > **username_1**: Yes - that would indeed be useful - I think a lot of us have been there - done that!  
  
  ---
  
  