When you export a CSV file from your Shopify admin, it opens as a. Special characters don't always work correctly in CSV files that are exported, edited with another spreadsheet program, and then re-imported into Shopify. After you've made your changes, export the CSV file to your computer. To use Google Sheets, you must import the CSV file into the program. Shopify recommends that you use Google Sheets to work with your CSV files. Look like this in a spreadsheet program: Note In a CSV file, each entry represents a cell in a spreadsheet, each line represents a new row, and each comma indicates where one entry ends and another one begins.įor example, the entries in this customer CSV file: To see more videos, visit our YouTube channel. csv files are larger than these limits, then you will need to import the information in batches. csv file, there is a file size limit of 15MB per file for products and inventory, and 1MB per file for customer data. Shopify can't recover corrupted files for you. If you save your file after forgetting to confirm its UTF-8 encoding, then your data will be corrupted when you upload it as a new spreadsheet. If you are updating a CSV file export, then remember to confirm the UTF-8 encoding to avoid generating unwanted special characters in your file. They can be useful in many situations, such as when you are switching to Shopify from another ecommerce platform, need to import a list of customer accounts, or want to upload products by using a spreadsheet.ĬSV files might seem intimidating at first, but after you understand their format and how they work, you might decide to use them for a variety of tasks.
You can use CSV files to import and export products, customers, inventory, orders (export only), and discounts (export only). CSV filesĬSV stands for comma-separated values, a file format (.csv) for spreadsheets. If you need details about using CSV files with inventory, then see Exporting or importing inventory with a CSV file.
If you need details about using CSV files with products, then see Importing and exporting products. This section provides you with some general guidance on using CSV files.
0 kommentar(er)
