Skip to content

Instantly share code, notes, and snippets.

@rsisco

rsisco/generate_rewrite_data.sql

Created October 24, 2018 20:55
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 rsisco/26f4fe94152917ad8f3cc5043c3ad3da to your computer and use it in GitHub Desktop.
Save rsisco/26f4fe94152917ad8f3cc5043c3ad3da to your computer and use it in GitHub Desktop.
Download ZIP
Select data needed for generating URL rewrites for M2
Raw
generate_rewrite_data.sql
# Select data needed for generating URL rewrites for M2
SELECT url AS old_uri, '' AS new_uri, category_id, product_id, sku FROM m1_url_export WHERE store_id = ?;
@rsisco
Copy link
Author

rsisco commented Oct 24, 2018

USAGE:

  1. Run ​this Gist on M1 prod for each store ID and export the results for each to their own CSV
  2. Export Google Analytics data for domain to CSV
  3. Run ​this Gist to create tables in a NON-PRODUCTION database
  4. Import exported data into their respective tables
  5. Run ​this Gist to generate a list of URLs that are in GA but don't have URL rewrites in M1, this is to make sure we are capturing all paths possible
  6. Run ​this Gist to export the M1 URL rewrites for the purpose of mapping to new ones with.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment