· 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
| handle | command | productType |
|---|---|---|
| linen-shirt | UPDATE | Apparel |
Minimal CSV (example) / Clear Product Type
| id | command | productType |
|---|---|---|
| 456 | UPDATE |