Products | DataEase Help

How can bulk import products from scratch onto my Shopify?

For starters i need product name, Sizes (S,M,L,XL) and the respective stock per size. What's the fastest way i can do this? To bulk import products from scratch into Shopify with the details you mentioned (product name, sizes, and stock per size), you can use the DataEase app. Here's a step-by-step guide to get you started: 1. Prepare Your Import File: - Create an Excel XLSX or CSV file. - Include the following columns: Title, Option1 Name, Option1 Value, Variant Inventory Qty. - For your sizes, you can set Option1 Name as "Size" and Option1 Value as "S", "M", "L", "XL" for each variant. - Specify the stock quantity in the Variant Inventory Qty column for each size. Here's a simple example of how your file might look: Title,Option1 Name,Option1 Value,Variant Inventory Qty Product A,Size,S,10 Product A,Size,M,15 Product A,Size,L,20 Product A,Size,XL,5 2. Import the File Using DataEase: - Open the DataEase app in your Shopify store. - Go to the "Import" section. - Drag and drop your prepared file or click "Add File" to upload it. - Ensure the app recognizes your sheet as "Products". - Review the data to ensure everything looks correct. 3. Start the Import: - Once you're satisfied with the setup, click the "Import" button. - Monitor the import process to ensure it completes successfully. For more detailed guidance, you can check out the https://dataease.app/products/

Last updated on Oct 18, 2025

How can i upload a product file so the tags update?

To update product tags using a file, you can follow these steps with the DataEase app: 1. Prepare Your File: You need a file with at least the following columns: - Variant SKU (or Handle if you prefer to identify products by their handle) - Tags - Tags Command (optional, but useful if you want to specify how tags should be updated) 2. Tags Command Options: - Use MERGE in the Tags Command column to add new tags to existing ones without removing the current tags. - Use REPLACE if you want to replace all existing tags with the new ones listed in your file. Be cautious with this option as it will remove all current tags. 3. Import the File: - Go to the DataEase app and navigate to the Import section. - Upload your prepared file. - Review the import settings and ensure everything looks correct. - Start the import process. 4. Check Import Results: - After the import, check the Import Results file to ensure all tags were updated as expected. If there are any failed items, the Import Results file will provide comments on why they failed. For more detailed instructions, you can refer to the tutorial on https://dataease.app/products/

Last updated on Oct 18, 2025

How can i undo an import?

Unfortunately, there is no direct way to undo an import job in DataEase. If you have a previous export or backup file, you can use that to restore the data to its previous state. If you don't have a backup, you might need to manually fix the data or re-import the correct data.

Last updated on Oct 18, 2025

How can i add new photo to previous image by using DataEase?

To add a new photo to an existing product's images using DataEase, you can follow these steps: 1. Export Current Product Data: First, export your product data to get the current list of images. Make sure to include columns like Handle, Image Src, and Image Position. 2. Prepare Your Import File: In your import file, you will need to add a new row for the new image you want to add. Use the same Handle as the existing product to ensure the image is added to the correct product. 3. Add New Image Details: - In the Image Src column, provide the URL of the new image you want to add. - If you want to specify the order of the images, use the Image Position column to set the position of the new image. If you leave it blank, the image will be added at the end. 4. Import the File: Once your file is ready, import it back into Shopify using the DataEase app. Make sure to use the MERGE command in the Image Command column to add the new image without affecting existing images. Here's a simple example of how your import file might look: Handle,Image Src,Image Position,Image Command product-handle-1, http://example.com/new-image.jpg,,MERGE This process will add the new image to the existing images of the product.

Last updated on Oct 18, 2025

How to Reuse the Same 11 Images Across 200 Shopify Products (Without Duplicates) Using DataEase?

I have 200 products that I would like to import into the store. All 200 products should have the same 11 images. I have uploaded the images once in the Shopify backend and copied and pasted the URLs into my upload file (the same URL for each product). However, when I then upload the products, Shopify creates each image again, so that I now have all 11 images 200 times each in the backend. However, I only want all 200 products to access the same image. how can I do this? To ensure that all 200 products access the same set of 11 images without duplicating them in Shopify, you should use the Image Command column with the MERGE value in your import file. This will prevent Shopify from creating duplicate images for each product. Here's how you can set it up: 1. Prepare Your Import File: - Include the necessary columns: ID or Handle (to identify the product), Image Src (the URL of the image), and Image Command. - In the Image Command column, use the value MERGE for each product. This tells Shopify to keep existing images and only add new ones if they don't already exist. 2. Example of Your Import File: Handle,Image Src,Image Command product-1,https://yourstore.com/image1.jpg,MERGE product-1,https://yourstore.com/image2.jpg,MERGE ... product-200,https://yourstore.com/image11.jpg,MERGE 3. Import the File: - Upload your prepared file using DataEase. This setup should ensure that the images are linked to each product without creating duplicates.

Last updated on Oct 18, 2025

How can I update only part of products?

To update only specific parts of your products, you need to include columns in your import file that identify the product and the specific fields you want to update. Here’s a general approach: 1. Identify the Product and Variant: - Use columns like ID, Handle, Variant ID, or Variant SKU to identify the product and variant you want to update. 2. Include Only the Fields You Want to Update: - For example, if you want to update the price and stock level, your columns might look like this: ID,Variant ID,Variant Price,Variant Inventory Qty 3. Use the MERGE Command: - By default, DataEase assumes the MERGE command, which updates the specified fields without affecting others. For more detailed guidance, you can refer to the https://dataease.app/products/ tutorial

Last updated on Oct 18, 2025

How can i change a CSV File which is not matching the Shopify CSV Standard?

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: 1. Identify the Required Format: First, download the DataEase Demo template to see the correct column headers and structure needed for Shopify imports. 2. 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. 3. 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. 4. 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. 5. 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/

Last updated on Oct 18, 2025

How can I import using .jpg or .png ?

To import images in formats like .jpg or .png, you need to ensure that these images are hosted online and accessible via a direct URL. Here's how you can do it: 1. Host Your Images Online: - Use a service like Amazon S3, Dropbox, or Shopify's Files section to host your images. Make sure the URLs are publicly accessible. 2. Prepare Your Import File: - Create a CSV or Excel file with columns such as Handle and Image Src. - In the Image Src column, include the URLs of your .jpg or .png images. 3. Import Using DataEase: - Upload this CSV or Excel file to the DataEase app in your Shopify store. - Start the import process.

Last updated on Oct 18, 2025

How can I export specific products instead of all products?

To export specific products instead of all products using DataEase, you can apply filters to your export. Here's how you can do it: 1. Create a New Export: In the DataEase app, start by creating a new export and select "Products" as the entity you want to export. 2. Apply Filters: Click on the Filters button under the "Products" section. You can filter products by various criteria such as: - Product Handle: Export products with specific handles. - Product Title: Export products whose titles contain specific text. - SKU: If you have a list of SKUs, you can enter them separated by commas to export only those products. 3. Customize Columns: If needed, you can also customize which columns to include in your export by using the "Customize Columns" section. 4. Start Export: Once you've set your filters and selected the columns, click the "Export" button to start the export process. For more detailed instructions, you can check out the https://dataease.app/products/#filter

Last updated on Oct 18, 2025

How can I add inventory into locations?

To add inventory into locations, you can follow these steps: 1. Export Your Products: - In the DataEase app, go to the "Export" section. - Select "Products" from the "Select Sheets" drop-down. - Check the following checkboxes: - Basic Columns - Inventory / Variants - Multi-Location Inventory Levels - Click the "Export" button to start the export process. 2. Edit the Exported File: - Download the exported file once the export is complete. - Delete unnecessary columns, keeping only the following: - ID - Handle - Variant ID - Variant SKU or Variant Barcode - Inventory Available: (for the locations you want to update) - Inventory Available Adjust: (if you want to adjust inventory) 3. Update Inventory Levels: - Fill in the Inventory Available: column with the desired inventory quantities for each location. - If you want to adjust inventory instead of setting it, use the Inventory Available Adjust: column. 4. Save & Import: - Save the edited file. - Go back to the DataEase app and import the file in the "Import" section. - The app will analyze the file and count how many products you are importing. - Press the "Import" button to start the import. For detailed steps, you can refer to this tutorial: https://dataease.app/products/1..

Last updated on Oct 18, 2025

How can I remove some of the images attached to products through DataEase?

To remove some of the images attached to products using DataEase, you can follow these steps: 1. Export your products with the necessary columns: ID, Handle, Image Src, and Media Command. This will give you a file with all the images currently associated with your products. 2. Edit the exported file: - Find the rows with the images you want to delete. - For each row with the image you want to delete, set the Media Command column value to DELETE. 3. Save the file and import it back using the DataEase app. Here's a quick example of how your file should look: ID,Handle,Image Src,Media Command 12345,example-product,https://example.com/image1.jpg,DELETE 12345,example-product,https://example.com/image2.jpg,MERGE In this example: - The image at https://example.com/image1.jpg will be deleted. - The image at https://example.com/image2.jpg will be kept (or added if it doesn't exist). For more detailed steps, you can refer to the https://dataease.app/products/

Last updated on Oct 20, 2025

How can I import image files? I have around 6000 images.

To import a large number of image files, like your 6000 images, you'll need to host them online with publicly accessible URLs. Here's a step-by-step guide to help you through the process: 1. Host Your Images Online: - You can use platforms like Amazon S3 or Shopify's own Files section to host your images. 2. Prepare Your Import File: - Create an import file (CSV or Excel) with at least the following columns: ID and/or Handle, and Media Src. - In the Media Src column, include the URLs of your hosted images. 3. Import Using DataEase: - Go to the DataEase app in your Shopify store. - Upload your prepared file in the Import section. - Start the import process and monitor for any errors or warnings.

Last updated on Oct 20, 2025

I need to to option bulk update as I noticed some of our SKUs has messy and mismatched option value. For example, Colour: 50ml Size: Blue. How can I fix this?

To fix mismatched option values in your SKUs, you can use DataEase to bulk update the option values. Here's how you can do it: 1. Export Products: - In the DataEase app, create a new export. - Select to export Products with Basic Columns and Inventory / Variants. - This will give you a file with all the necessary details, including the option values. 2. Edit the Exported File: - Open the exported file and locate the columns for Option1 Value, Option2 Value, and Option3 Value. - Correct the mismatched option values, such as changing "Colour: 50ml" to the correct values like "Colour: Blue" and "Size: 50ml". 3. Prepare for Import: - Ensure you keep the following columns in your file: ID, Handle, Variant ID, Variant SKU, and all columns that start with “Option …”. - Remove any unnecessary columns to speed up the import process. 4. Import the Updated File: - Go back to the DataEase app and import the updated file in the Import section. - The app will analyze the file and update the option values for your products. It's always a good idea to test the import with a few products first to ensure everything is set up correctly. If you encounter any errors during the import, you can download the Import Results file to see detailed error messages. For more detailed guidance, you can check out our tutorial on https://dataease.app/products/

Last updated on Oct 25, 2025

I’m currently evaluating DataEase for a Magento 2 to Shopify migration. I’ve exported products from Magento. However, I can see that the format of the file exported from Magento is different from what DataEase expects. How can I best proceed?

DataEase supports importing files in any format. After you upload a file, the app will automatically try to match the column names and contents to the corresponding Shopify fields and will suggest a configuration. You can then adjust which data should be imported from which column by clicking the pencil icon next to each field. This allows you to import a file with any structure and define exactly where each piece of data should come from during the import.

Last updated on Nov 01, 2025

How can I bulk import product installation guides using metafields in Shopify?

To bulk import product installation guides using metafields in Shopify, you can follow these steps using the DataEase app: 1. Set Up Metafield Definitions: - First, ensure you have set up the metafield definitions for your installation guides in Shopify Admin. You can do this by going to Shopify Admin -> Settings -> Custom Data -> Metafields. - Create a new metafield definition for your installation guides. For example, you might use a namespace like installation and a key like guide. 2. Prepare Your CSV File: - Create a CSV file with at least the following columns: - Handle: The unique identifier for each product. - Metafield: installation.guide [type]: Replace [type] with the appropriate type for your installation guide (e.g., single_line_text_field for URLs or multi_line_text_field for text content). Example CSV: Handle,Metafield: installation.guide [single_line_text_field] product-1,https://example.com/guide1.pdf product-2,https://example.com/guide2.pdf 3. Import the CSV File: - Go to the DataEase app in your Shopify store. - In the “Home” screen, locate the “Import” section. - Click on the “Add File” button to add your CSV file or drag & drop it onto the app screen. - The app will upload and analyze your file. Ensure it recognizes your import sheet as “Products”. - Check the total count of items to be imported and verify that the data looks correct. - Click on the “Import” button to start the import process. For more detailed instructions, you can refer to our tutorial on managing Shopify metafields: https://dataease.app/metafields/

Last updated on Nov 06, 2025

Need to import preset choices for a single line text field. How can I do that?

To import preset choices for a single line text field in DataEase, you need to ensure that the Metafield is correctly set up in your Shopify store and that your import file is formatted correctly. Here's how you can do it: 1. Check Metafield Definition: First, make sure that the Metafield in your Shopify store is defined as a single_line_text_field with preset choices. You can verify this in your Shopify Admin under Settings > Metafields. 2. Format Your Import File: In your import file, the column header for the Metafield should include the type. For example, if your Metafield is custom.category, the column header should be Metafield: custom.category [single_line_text_field]. 3. Ensure Correct Values: The values you are importing must match one of the preset choices exactly. This includes being case-sensitive and free of extra spaces. 4. Import the File: Once your file is ready, you can import it using the DataEase app. If you encounter any errors, double-check that the values match the preset choices and that the column header is correctly formatted.

Last updated on Nov 06, 2025

How I can convert variants to separate products?

To convert variants to separate products, you can follow these steps: 1. Export Your Products: Use the DataEase app to export your products. Make sure to include the "Basic Columns" and "Inventory/Variants" in your export. 2. Modify the Exported File: - Handle: Change the handle for each variant so that each variant has a unique handle. This will ensure that each variant is treated as a separate product. - Product ID: Remove the Product ID for each row to indicate that these are new products. - Variant ID: Remove the Variant ID for each row to indicate that these are new variants. - Title: Adjust the title if necessary to reflect the new product names. 3. Import the Modified File: Import the modified file back into Shopify using the DataEase app. This will create new products for each variant. 4. Delete Old Products: After confirming that the new products have been created correctly, you can delete the old products. You can do this by filtering them in Shopify Admin by their tags or using the DataEase app to bulk delete them.

Last updated on Nov 06, 2025

How can I export inventory quantities by location, and then upload an adjustment for a certain location?

To export inventory quantities by location and then upload an adjustment for a certain location using DataEase, follow these steps: Export Inventory Quantities by Location 1. Export Products: - In the DataEase app, go to the "Export" section. - Select "Products" from the "Select Sheets" drop-down. - Check the following checkboxes: - Basic Columns - Inventory / Variants - Multi-Location Inventory Levels - Click the "Export" button to start the export process. 2. Download and Review the Exported File: - Once the export is complete, download the exported file. - In the file, you will see columns named Inventory Available: ... for each location, showing the inventory quantities for each product variant at that specific location. Upload an Inventory Adjustment for a Certain Location 1. Prepare the File for Import: - Open the exported file and delete unnecessary columns. You only need the following columns: - ID - Handle - Variant ID - Variant SKU or Variant Barcode (optional, but preferred for easier identification) - Inventory Available Adjust: [Location Name] (replace [Location Name] with the actual name of the location you want to adjust) 2. Adjust Inventory Quantities: - In the Inventory Available Adjust: [Location Name] column, enter the adjustment quantities for each product variant. Use positive numbers to increase and negative numbers to decrease the inventory. 3. Import the Adjusted File: - Save the updated file. - Go back to the DataEase app and import the file in the "Import" section. - The app will analyze the file and count how many products you are importing. - Press the "Import" button to start the import.

Last updated on Nov 06, 2025

If I want to update only certain metafields (meta title, meta description, warranty, etc.) how can I accomplish this in an import/export scenario without losing data?

To update only certain metafields like meta title, meta description, and warranty without affecting other data, you can follow these steps: 1. Export the Necessary Data: Use DataEase to export your products, including the metafields you want to update. Make sure to include the ID or Handle column to identify the products and the specific metafield columns you want to update, such as Metafield: title_tag, Metafield: description_tag, and Metafield: warranty. 2. Edit the Exported File: - Open the exported file in a spreadsheet editor. - Update the values in the metafield columns you want to change. - Ensure you do not add or modify any other columns that are not necessary for your update. 3. Prepare the Import File: - Keep only the columns necessary for your update: ID or Handle and the metafield columns you are updating. - Do not include any other columns to avoid overwriting data you don't intend to change. 4. Import the Updated File: - In the DataEase app, go to the "Import" section and upload your updated file. - The app will analyze the data. Ensure it shows the correct entity (Products) and that the item count is correct. - Click the "Import" button to start the import process.

Last updated on Nov 15, 2025

We are importing from woocommerce and our namespace and key has spaces in it, for example: 'woo_attribute.Inclusief lichtbron'. How can I edit/import these?

When importing metafields with spaces in the namespace or key, you need to escape the spaces with a backslash (). For example, your metafield woo_attribute.Inclusief lichtbron should be formatted as woo_attribute.Inclusief\ lichtbron. Here's how you can do it: 1. Export your data from WooCommerce. 2. In the exported file, locate the columns with the metafields that have spaces in the namespace or key. 3. Replace the spaces with \ (backslash followed by a space). For example, woo_attribute.Inclusief lichtbron becomes woo_attribute.Inclusief\ lichtbron. 4. Save the file and import it into Shopify using the DataEase app.

Last updated on Nov 15, 2025

Trying to update our size chart in our pdps in our metafeilds how can I do that in the DataEase doc? will one column be update and the other column be the updated size chart?

To update your size chart in your product detail pages (PDPs) using Metafields in DataEase, you can follow these steps: 1. Export the Products with Metafields: - In the DataEase app, create a new export. - Select the export format DataEase: Excel. - Select the Products sheet. - Under the Basic Columns column group, select ID and Handle. - Under the Metafields column group, select the Metafields you want to update (e.g., your size chart Metafield). 2. Edit the Metafield Values: - In the exported file, locate the column for your size chart Metafield. The column header will be in the format Metafield: namespace.key [type]. - Update the values in this column with your new size chart information. 3. Import the Updated File: - Save the edited file. - In the DataEase app, go to the Import section and upload your edited file. - The app will analyze the data. Ensure that it shows the correct entity (Products) and that the item count is correct. - Click the Import button to start the import. Here is an example of what your file might look like: ID,Handle,Metafield: custom.size_chart [multi_line_text_field] 1234567890,example-product,"New size chart content here" Make sure to only include the columns ID, Handle, and the Metafield you are updating to avoid overwriting other data.

Last updated on Nov 15, 2025

I need to bulk upload and change the handle field without creating product duplications, how can i do this?

To bulk upload and change the handle field without creating product duplications, follow these steps: 1. Export Existing Products: - In the DataEase app, create a new export and select to export Products with only ID and Handle under Basic Columns. - Click the “Export” button to start the export and download the file once finished. 2. Prepare the Import File: - Edit the exported file and set new Handles for your Products in the file. - Ensure that the ID column remains unchanged to avoid creating duplicates. 3. Import Product Handles Bulk Update File: - Go back into the DataEase app and upload your edited file in the import section. - By default, the app will create a redirect from the old Handle to the new one. You can turn this off in the import Options if needed. For detailed instructions, you can refer to our tutorial: https://dataease.app/products/

Last updated on Nov 21, 2025

How can I upload an image as an URL metafield for each product? So not as a product image but as an additional image?

To upload an image as a URL metafield for each product, you can follow these steps: 1. Create a Metafield Definition: - First, create a metafield definition in your Shopify store for the image URL. You can do this in the Shopify admin under Settings -> Custom data -> Products -> Add definition. - Choose a namespace and key for your metafield, for example, custom and additional_image_url. - Set the type to URL. 2. Prepare Your Import File: - Create a CSV or Excel file with at least the following columns: - Handle (to identify the product) - Metafield: custom.additional_image_url [url] (to store the image URL) Here's an example of how your file might look: Handle,Metafield: custom.additional_image_url [url] product-1,https://example.com/image1.jpg product-2,https://example.com/image2.jpg 3. Import the File Using DataEase: - Go to the DataEase app in your Shopify store. - Click on Import. - Upload your CSV or Excel file. - Review the import settings and make any necessary adjustments. - Click on Import to start the import process. For more detailed instructions on managing Shopify metafields, you can refer to the DataEase tutorial: https://dataease.app/metafield_definition/

Last updated on Nov 21, 2025

How can I export all products and just a single metafield and its values?

To export all products and just a single metafield and its values, follow these steps: 1. Open the DataEase app and create a new export. 2. Select the "Products" checkbox. 3. Under "Select Columns", click on "Metafields" to expand it. 4. Next to the "Metafields" tag, you will see a pencil button. Click on it. 5. In the filter settings, choose the criteria for the Metafields you want to export. For example, you can select "Namespace" and set it to "equals to any of" and then type in the namespace of the metafield you want to export. 6. Click "Apply" to save the filter settings. 7. Click the "Export" button to start the export process. This will export all products along with the specific metafield and its values. For more detailed information, you can refer to this tutorial: https://dataease.app/metafield_definition/

Last updated on Nov 30, 2025

Hello, how can I update product's SKU? what columns should I use? Is it okay only with title, variant command and variant sku?

To update a product's SKU, you need to use the following columns: - ID or Handle - Variant ID - Variant SKU If you want to ensure that only the SKU is updated without affecting other product information, you can use the MERGE command, which is the default if the Command column is left blank. Here's an example of how your import file should look: ID,Handle,Variant ID,Variant SKU,Command 1234567890,product-handle,9876543210,NEW-SKU,MERGE

Last updated on Nov 30, 2025