Skip to content

Instantly share code, notes, and snippets.

@aamnah
Created February 26, 2015 07:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aamnah/e94d27812c02e905fa02 to your computer and use it in GitHub Desktop.
Save aamnah/e94d27812c02e905fa02 to your computer and use it in GitHub Desktop.
MySQL command to Update Store Details for all existing Orders in an Opencart store
# Update store_id, store_name and store_url for all existing orders
#####################################################################
# store_id can be checked with `SELECT * FROM oc_store`. Default store = 0
UPDATE oc_order SET store_id=0, store_name="Store Name", store_url="http://domain.com";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment