To change a CSV file that doesn't match the Shopify CSV standard, you'll need to adjust the column headers and structure to align with the required format. Here's how you can do it:
-
Identify the Required Format: First, download the DataEase Demo template to see the correct column headers and structure needed for Shopify imports.
-
Adjust Column Headers: Open your CSV file in a spreadsheet editor like Excel or Google Sheets. Rename the column headers to match those in the DataEase template. For example, if you have a column named "Ean" and Shopify uses "Variant Barcode," you'll need to rename it accordingly.
-
Ensure Correct Delimiters: Make sure your CSV file is comma-separated, as Shopify requires this format. If your file uses a different delimiter (like a semicolon), you can change it by using the "Find and Replace" feature in a text editor or spreadsheet software.
-
Remove Unnecessary Columns: If there are columns in your file that don't have a corresponding field in Shopify, you can remove them or consider storing that data in Metafields if needed. You can learn more about Metafields in our Metafields documentation.
-
Save and Import: Once your file is adjusted, save it as a CSV file and try importing it again using the DataEase app.
For more detailed guidance, you can refer to our tutorial on https://dataease.app/products/