Variants | DataEase Help

How can I delete a list or variants in bulk?

I wanted to replace my old variants and just change the option3 value, but accidently added new variants when i imported a google sheet. How can I delete all those that I just importerd? To delete the variants you just imported, you can follow these steps using DataEase: 1. Export the Products with Variants: - Go to the DataEase app and create a new export. - Select "Basic Columns" and "Inventory/Variants" groups to export. - Apply filters if needed to export only the products with the variants you want to delete. 2. Modify the Exported File: - Open the exported file and locate the variants you want to delete. - Change the Variant Command column value to DELETE for each variant you wish to remove. Ensure you have the necessary identifiers like Variant ID, Variant SKU, or Option Values to correctly identify the variants. 3. Import the Modified File: - Save the changes to your file. - Import the file back into Shopify using DataEase. - The app will process the file and delete the specified variants. For more detailed instructions, you can refer to our tutorial on https://dataease.app/variants/

Last updated on Oct 18, 2025

How can i update variant image in bulk via DataEase

To update variant images in bulk using DataEase, you can follow these steps: 1. Export Your Products: First, export your products with the necessary columns. Make sure to include columns like "Handle", "Variant SKU", "Variant Image", "Image Src", and "Image Command". 2. Prepare Your File: In the exported file, locate the rows for the variants whose images you want to update. Update the "Variant Image" column with the new image URLs for each variant. 3. Set Image Command: Use the "Image Command" column to specify how you want to handle the images. If you want to replace existing images, you can use the "REPLACE" command. However, be cautious with this command as it will delete all existing images for the product and replace them with the ones in your import file. 4. Import the File: Save your changes and import the file back into Shopify using the DataEase app. For more detailed guidance, you can refer to the https://dataease.app/products/

Last updated on Oct 18, 2025

How can I move variants to a different product in bulk?

To move variants from one product to another in bulk using DataEase, you'll need to follow a two-step process. Here's how you can do it: 1. Export Products with Variants: - Use DataEase to export the products that include the variants you want to move. Make sure to include the necessary columns such as Variant ID, Variant SKU, and Variant Command. 2. Edit the Exported File: - For the product you want to move the variant from, set the Variant Command column value to DELETE for the variant you wish to move. - For the product you want to add the variant to, copy the row of the variant from the original product and paste it as a new row under the new product. Remove the Variant ID and Variant Inventory Item ID values for the newly added variant. Set the Variant Command to MERGE for this new variant row. 3. Import the Edited File: - Save your changes and import the file back into Shopify using DataEase. This will delete the variant from the original product and add it to the new product. Please ensure that you have the correct Variant ID or Variant SKU to identify the variants accurately. For more detailed guidance, you can refer to our tutorial on https://dataease.app/variants/

Last updated on Oct 18, 2025

With SKU and EAN how can I tag products with one specific tag?

To tag products using SKU and EAN, you can use the DataEase app to import a file with the necessary columns. Here's how you can do it: 1. Prepare Your Import File: Create a CSV file with the following columns: - Variant SKU: This column should contain the SKU of the product variants you want to tag. - Variant Barcode [ID]: This column should contain the EAN (barcode) of the product variants. - Tags Command: Use the value MERGE in this column to add a new tag without removing existing tags. - Tags: This column should contain the specific tag you want to add to the products. 2. Import the File: Use the DataEase app to import this file into your Shopify store. The app will match the products by SKU and EAN and add the specified tag to them. Here's a simple example of how your CSV file might look: Variant SKU,Variant Barcode [ID],Tags Command,Tags SKU-1001,1234567890123,MERGE,NewTag SKU-1002,2345678901234,MERGE,NewTag This setup will ensure that the tag "NewTag" is added to the products identified by the given SKUs and EANs.

Last updated on Nov 01, 2025

How can i check the price for a particular market?

To check the price for a particular market, you can follow these steps: 1. Export Products with Market Pricing: - Go to the DataEase app and click “New Export”. - In the Export page, select the “Products” checkbox. - Under the “Select Sheets” dropdown, choose “Products”. - In the “Basic Columns” group, select ID and Handle. - In the “Inventory / Variants” group, select Variant ID. - In the “Pricing by Markets” group, select all columns – Included / , Price / , and Compare At Price / . - Click the “Export” button to generate the file. 2. Download and Review the Exported File: - Once the export is complete, download the exported file. - Open the file to see the columns for each market, such as Included / , Price / , and Compare At Price / . 3. Check the Prices: - Locate the specific market columns in the file. - Review the Price / and Compare At Price / columns to see the prices for each product variant in that market.

Last updated on Nov 15, 2025

How can i list a product with same content and everything but only with the different skus?

To list a product with the same content but different SKUs, you can create multiple variants of the same product. Each variant can have a unique SKU. Here's how you can do it using DataEase: 1. Prepare Your Import File Create a CSV file with the necessary columns. Each row will represent a variant of the product. Ensure that the Handle is the same for all rows to group them under the same product. 2. Include Required Columns Your file should include columns like Handle, Title, Option1 Name, Option1 Value, Variant SKU, and any other relevant fields. Here's an example of how your CSV file might look: Handle,Title,Option1 Name,Option1 Value,Variant SKU,Variant Price product-handle,Product Title,Size,Small,SKU-1001,9.99 product-handle,Product Title,Size,Medium,SKU-1002,19.99 product-handle,Product Title,Size,Large,SKU-1003,29.99 4. Import the File Use the DataEase app to import this file. The app will recognize that all rows with the same Handle belong to the same product and will create variants accordingly. For more detailed instructions, you can refer to the tutorial on https://dataease.app/variants/

Last updated on Nov 21, 2025

Hi, how can i use dataease and specially which columns to mass edit existing SKU and means with new SKU and means ean codes?

To mass edit existing SKUs and add new SKUs along with EAN codes, you can follow these steps using DataEase: 1. Export the Products: - In the DataEase app, go to the "Export" section. - Select "Products" and ensure you include "Inventory / Variants" in your export. - Apply any necessary filters to limit the number of products. - Press the "Export" button to start the export. - Download the exported file. 2. Edit the Exported File: - Open the exported file. - Locate the columns you need to update: ID, Handle, Variant ID, Variant SKU, and add a new column for Variant Barcode. - Update the Variant SKU with the new SKUs. - Add the EAN codes in the Variant Barcode column. 3. Prepare the File for Import: - Ensure you only keep the necessary columns: ID, Handle, Variant ID, Variant SKU, and Variant Barcode. - Save the file. 4. Import the Updated File: - Go back to the DataEase app and navigate to the "Import" section. - Upload the updated file. - The app will analyze the file and count how many products you are importing. - Press the "Import" button to start the import. Here is an example of how your file should look: ID*,Handle,Variant ID,Variant SKU,Variant Barcode* 1234567890,product-handle-1,9876543210,new-sku-1,ean-code-1 1234567891,product-handle-2,9876543211,new-sku-2,ean-code-2 1234567892,product-handle-3,9876543212,new-sku-3,ean-code-3

Last updated on Nov 30, 2025

I made a price change in my Excel file, but the updated prices are not reflecting on my website after importing. How should I name the sheet to ensure it works properly?

To apply a 25% discount to your current prices using DataEase, you can follow these steps: 1. Export Products: First, export your products to get the current prices. Make sure to include columns like Handle, Variant SKU, and Variant Price. 2. Calculate Discounted Prices: In your exported file, create a new column to calculate the discounted price. You can use a formula to reduce the Variant Price by 25%. For example, if your current price is in column D, you can use a formula like =D2*0.75 to calculate the new price. 3. Update Prices: Replace the values in the Variant Price column with the new discounted prices. 4. Import Updated File: Save the file and import it back into Shopify using DataEase. Ensure the sheet/tab name is set to "Products" to correctly update the product prices.

Last updated on Nov 30, 2025

How can i group variant by parent if i dont have a handle column ?

To group variants by a parent product without using a Handle column, you can use the ID column if you're updating existing products. However, if you're creating new products and don't have an ID or Handle, it becomes challenging to group variants without a unique identifier. In such cases, it's crucial to have some form of consistent identifier across all rows that belong to the same product. If you don't have a Handle or ID, you might need to reconsider your import strategy to include one of these identifiers to ensure proper grouping.

Last updated on Nov 30, 2025

Hello! If I want to update existing skus and barcodes and variants for product that are already created with the wrong SKU, how can I do this through DataEase. Which columns are needed?

To update existing SKUs and Barcodes for variants in products that are already created, you will need to identify the variants correctly. Here are the steps and columns you need: 1. Export the current product data to get the necessary identifiers: - Export Products with Basic Columns and Inventory/Variants. - Ensure you include Variant ID and Variant SKU in the export. 2. Prepare your import file with the following columns: - ID or Handle (to identify the product) - Variant ID (to identify the specific variant) - Variant SKU (to update the SKU) - Variant Barcode (to update the Barcode) Here is an example of how your import file should look: ID,Handle,Variant ID,Variant SKU,Variant Barcode 1234567890,product-handle-1,9876543210,new-sku-1,new-barcode-1 1234567890,product-handle-1,9876543211,new-sku-2,new-barcode-2

Last updated on Nov 30, 2025