1. Explanation of Column Headers: https://help.shopify.com/en/manual/products/import-export/using-csv#product-csv-file-format
  2. Import Product Export CVS  and Product Template CVS to Google Sheets – Comma separate import setting
  3. Keep both open in two windows
  4. Select All > Format > Text Wrapping > Clip
  5. On Template, insert row below header, Copy and paste entire column so old header is in blank row, Delete this row
  6. Copy
  7. Columns
    1. “Handle” – “ProductURL”
      1. Find and Replace to remove: http://VIMALATREASURES.ORG/  –  .aspx ??
    2. “Title” – “Name”
    3. Body (HTML) – LongDescription
    4. Vendor – ?
    5. Tags – MetaKeywords
      1. Keep Commas
    6. Published – Enable
    7. Options and Variants – blank
    8. Image Src – LargeImagePath
    9. Image position, Image alt text, Gift Card – blank
    10. SEO Title – Meta Title
    11. SEO Description – MetaDescription
    12. Skip Google shopping and Variant stuff
    13. Cost per item – CustomerPrice
  8. Questions for Shopify
    1. Variant Grams and Variant Weight Unit
    2. Variant image and Image Src
    3. Variant inventory tracker – Do we need to add anything if we are going to use QuickBooks?
    4. Short Description?
  9. Questions for Lisbeth
    1. ManufacturerPartNumber and ManufacturerName
    2. Look at weight
    3. product ID
  10. Remember to Delete row with old headers