· DataEase · Tutorials  · 2 min read

Add Product Type in Shopify

Assign or change the Product Type for many products at once by editing the productType field and importing via DataEase.


Steps:

1. Export products

In DataEase, create a New Export → Products. Include at minimum: id, handle, productType (optionally title). Use filters (tag, vendor, collection, status) to target the right items.

2. Edit the file

For rows you want to change, set command = UPDATE and put the desired value into productType (e.g., “T-Shirts”, “Accessories”). To clear the type, leave productType empty (””).

3. Import & validate

In DataEase, create a New Import, upload the file, map columns, and run Validation. Open the validation file and check the “Validation Status” column; fix any issues.

4. Import & validate

Create a New Import in DataEase, upload the file, map columns, and run Validation. Open the validation file and review the “Validation Status” column; fix any issues.

5. Run the import

After completion, download the result file and spot-check products in the admin/storefront (filters/collections) to confirm Product Type is applied.

Tips

  • Matching: prefer Product ID; use handle only if ID is missing.
  • Product Type is a free-text label for grouping and reporting. It’s separate from Shopify’s Product Category (taxonomy); update Category via its own field if needed.
  • Keep naming consistent (e.g., “T-Shirts” vs “Tshirts”) for clean analytics and filters.

Minimal CSV (example) / Set Product Type by handle

handlecommandproductType
linen-shirtUPDATEApparel

Minimal CSV (example) / Clear Product Type

idcommandproductType
456UPDATE

References