My suppliers csv files have been used to create a MySQL database.
This in turn is used to dynamically generate all of my product pages.
Now I want to remove three of the manufacturers entirely and two "types of products" however, unfortunately I don't know how to do this myself and, I'm too scared to try in case of messing everything up.
When I login to the DB I see "phpMyAdmin 2.6.2"
Evidently, it's possible to search by doing something like as follows:
"Run SQL query/queries on database _"
No doubt it'll be possible to identify all of the products by any given manufacturer and then delete them en masse.
As to the "types of products" I simply want to remove all of the "oversize" and "hazardous" products. Once again these can easily be identified and presumably removed quite simply/swiftly.
Lastly, I want you to explain/show me how to remove an individual item myself.
For example lets say I wanted to remove:
[url removed, login to view]
I'd do the search using the SKU code i.e. UC1254.
So in conclusion you would just tell me how to do this.
If you have any questions about the job please do not hesitate to ask.