CrossY Posted October 18, 2013 Share Posted October 18, 2013 (edited) Hi there, During the transition of the database 1.4 > 1.5 there has been a weird thing happening: all the products combinations now have a reference number, which we don't use. Since its about 1000 or so combinations, it's a bitch to remove them manually. However, I don't have any database knowlegde. Is it possible to empty all entries for the red row/column (not sure what it's called)? Thanks in advance! Regards, Dave Edited October 18, 2013 by CrossY (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted October 18, 2013 Share Posted October 18, 2013 you can run this simple sql query: update ps15_product_attribute set reference = '' Link to comment Share on other sites More sharing options...
CrossY Posted October 18, 2013 Author Share Posted October 18, 2013 (edited) Brilliant, thanks! [solved] Just for future reference (so I can Google this stuff more accurate), what is that actually called? A row? Column? Edited October 18, 2013 by CrossY (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted October 18, 2013 Share Posted October 18, 2013 code above? sql query and "reference" is a column Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now