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