Jump to content

SQL command to copy unit price to wholesale price?


Recommended Posts

So I just realized after importing 40,000 products over the last 6 months that I have been putting our "supplier" price (the price we buy for) in the unit price field. (stupid, I know). I would like to move all of those prices to the CORRECT field of wholesale price. I would rather not have to export and re-import everything. Could someone provide me with a SQL command to automate this for me?

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...