Skip to content

Latest commit

 

History

History
30 lines (19 loc) · 1021 Bytes

README.md

File metadata and controls

30 lines (19 loc) · 1021 Bytes

woocommerce-shopify-migrate

Ruby scripts to migrate WooCommerce products to Shopify

These scripts form an ETL process to migrate scripts to Shopify. They have been used in the following environment:

Product data is exported with https://wordpress.org/plugins/woocommerce-exporter/

The ETL process is as follows:

  1. Export WooCommerce data to CSV in Wordpress with stock settings. If the Ruby CSV library is unable to parse this file, use something like Microsoft Excel to re-save into a standard CSV format. Rename this file to woocommerce_export.csv.

  2. Export image attachment Cloudfront URLs using a direct DB query (included in 'attachments.rb') as wp_postmeta.csv.

  3. Put everything in the same working directory and run irb there.

  4. Execute the following commands:

load 'attachments.rb'
run
load 'transform.rb'
run
  1. This will generate table.csv, which is ready for upload to Shopify