Transform proCSV file before importing

Shopify Discussion
1

Hi,

I have a supplier that provides me a little drop shipping, I can automate their export but it’s not in a format for shopify so it needs to be edited before importing - This will be things like copying data from one column to another, updating inventory numbers as they provide a description. I’m looking to automate this process.

Are there any methods people use to auto transform their data before importing?

Thanks

2

Hi,

Some common methods and tools used to automate this process:

For Small and Medium Complexity

  1. Spreadsheet Automation with Google Sheets or Excel
  2. Zapier - It allows you to set up automated workflows between apps

For Larger Complexity or Volume: Consider using Python scripting or an ETL tool

3

Thanks. I was looking at Zapier as a possible option, as im only looking at once a day it’s likely i can sit within the free version.

Im not sure my setup will be big enough to warrant a python or an ETL too