mountainscenes Posted December 28, 2005 Share Posted December 28, 2005 Is there a way I can innitiate a percentage price increase/reduction for all products without editing each individual product? It seems this would be a common need, but I have not been able to find any threads on the subject. Thanks in advance. Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted December 28, 2005 Share Posted December 28, 2005 if this is a one time thing I would recommend doing it from the DB rather than the OSC User Interface the table name is products , and the field that you need to change is the products_price at the end of the day the code will be good Link to comment Share on other sites More sharing options...
mountainscenes Posted December 29, 2005 Author Share Posted December 29, 2005 if this is a one time thing I would recommend doing it from the DB rather than the OSC User Interface the table name is products , and the field that you need to change is the products_price Unless I am missing something, making the changes in the DB still requires individual field changes within a new window. I don't see how this is any faster than the OSC Interface. There has to be a better way to incorporate % price changes to all products. I see myself having to do this at least once a year. Link to comment Share on other sites More sharing options...
roughrider Posted December 29, 2005 Share Posted December 29, 2005 Unless I am missing something, making the changes in the DB still requires individual field changes within a new window. I don't see how this is any faster than the OSC Interface. There has to be a better way to incorporate % price changes to all products. I see myself having to do this at least once a year. Excellent point & I'm looking forward to a positive answer. Ride It Like You Stole It Link to comment Share on other sites More sharing options...
kwalker Posted December 29, 2005 Share Posted December 29, 2005 You can change your prices all at once by: BACKUP YOUR DATA 1ST!! 1. Download the products table 2. Open the table in Excel 3. Open Notepad 4. Inside of Excel, you need to put your formula in a "blank" cell 5. After the formula has been created, "highlight" the 1st price all the way down the rows until you highlight the last price, then apply the formula to the highlighted cells. 6. After the formula has been applied, highlight the "same cells", and then copy/paste into Notepad. 7. DELETE the formula cell in Excel,,, (it'll change your prices back to where they were) 8. Switch to Notepad, and highlight ONLY the data, DON'T use the "select all" function... just highlight the data. and after you copy it, switch back to Excel, and highlight the same cells again, and then paste into the column. 9. Save the Excel file... close it,,, upload it,,,,, and you're finished. It'll take just a few minutes to do. Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
mountainscenes Posted December 29, 2005 Author Share Posted December 29, 2005 You can change your prices all at once by: BACKUP YOUR DATA 1ST!! 1. Download the products table 2. Open the table in Excel 3. Open Notepad 4. Inside of Excel, you need to put your formula in a "blank" cell 5. After the formula has been created, "highlight" the 1st price all the way down the rows until you highlight the last price, then apply the formula to the highlighted cells. 6. After the formula has been applied, highlight the "same cells", and then copy/paste into Notepad. 7. DELETE the formula cell in Excel,,, (it'll change your prices back to where they were) 8. Switch to Notepad, and highlight ONLY the data, DON'T use the "select all" function... just highlight the data. and after you copy it, switch back to Excel, and highlight the same cells again, and then paste into the column. 9. Save the Excel file... close it,,, upload it,,,,, and you're finished. It'll take just a few minutes to do. Kevin Thanks Kevin! I haven't tried it yet but it makes perfect sense! :thumbsup: Don Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.