Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
Forum Search
Google Site Search
 All Forums
 General
 Suggestions - NOT QUESTIONS
 update pID and stats
Author « Topic »  

atlend
Advanced Member

USA
338 Posts

Posted - 11/04/2024 :  09:14:37  
There are times where there is a typo or something in a pID that you need to change after something has been selling. It would be great if it was able to be changed and also to update in past orders so that things like stats are not affected. I might be wrong on this, but I believe that now if you change a pID, you will have to remember to run stats for both pIDs because it essentially sees them as two different items. If you wanted to give people the option to update all past orders, then maybe when updating a pID on the product page there would be a checkbox if you either wanted or did not want to update all past orders with the new pID. Thanks!

dbdave
ECT Moderator

USA
10481 Posts

Posted - 11/04/2024 :  11:17:31  
I have a script you can run for .asp versions (if you are on a SQL server database) I can share with you, that will fix those.

Perhaps Vince can setup a tool in the admin to fix these, as it happens to us too.

David

atlend
Advanced Member

USA
338 Posts

Posted - 02/24/2025 :  17:18:13  
For anyone looking in the future, you can run this script in your database and it appears to work.


UPDATE cart
SET name = 'new_pId'
WHERE cartProdID = 'old_pId'
AND created_at < '2018-01-01';


This example changes all records before a certain date. David, is there anything I am overlooking? It seems like it is just a matter of adjusting the records in the cart database.

dbdave
ECT Moderator

USA
10481 Posts

Posted - 02/24/2025 :  18:23:38  
Hi, that works if you just have one or two and you know what they are.
Thanks,
David
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000