· DataEase · Documentation  · 2 min read

Collections

A Collection groups products so shoppers can find them faster—think “Running Shoes” or “Summer Sale.”
DataEase lets you:

  • Create or rename hundreds of collections in one upload.
  • Add or remove products or rules in bulk.
  • Change sort order, images, and SEO text quickly.

Shopify collection guide.

Table of Contents

  1. Export
  2. Import
  3. Field reference
  4. Filters

2. Export

  1. Pick CSV or Excel.
  2. Choose Collection as the entity.
  3. Select the fields you need—title, collectionType, ruleColumn, etc.
  4. Run the task and download your file.

Step-by-step: Export guide

3. Import

Supported commands in command: CREATE, UPDATE, REPLACE, DELETE, IGNORE
Line-item commands (rules or products): CREATE, MERGE, UPDATE, DELETE, IGNORE

  • For manual collections use product lines (productId).
  • For smart collections use rule lines (ruleColumn / ruleCondition…).

Tip: Only collections with sortOrder = MANUAL let you set productPosition.

  1. Download the sample file: Collection-import-sample.xlsx
  2. Fill required fields: title and handle for CREATE; include id or handle for UPDATE/DELETE.
  3. Map columns in DataEase, upload, and start the import.

Full steps: Import guide

4. Field reference

Basic

id

Collection ID. Needed for UPDATE, REPLACE, or DELETE.

command

Action for the collection row: CREATE, UPDATE, REPLACE, DELETE, IGNORE.

title

Name shown to shoppers.

handle

URL-friendly string. Must be unique.

descriptionHtml

Rich-text description with HTML.

templateSuffix

Alternate Liquid template (without .liquid).

sortOrder

Default product order: ALPHA_ASC, BEST_SELLING, MANUAL, etc.

updatedAt

Last-modified date (ISO 8601). Export only.

SEO

seoTitle

Custom page-title tag.

seoDescription

Custom meta-description.

Image

imageUrl

URL of the featured image.

imageAltText

Alt text for the image.

imageHeight

Image height (px). Export only.

imageWidth

Image width (px). Export only.

Line-item (rule or product)

itemCommand

CREATE, MERGE, UPDATE, DELETE, or IGNORE for this line.

Smart-collection rule fields

ruleColumn

Product attribute for the rule (e.g., TITLE, TAG, VENDOR).

ruleCondition

Value the rule compares to, like Shoes.

ruleConditionObjectId

Extra info for some rule types (e.g., category ID).

ruleRelation

Operator: EQUALS, CONTAINS, NOT_EQUALS, etc.

appliedDisjunctively

true = match ANY rule; false = match ALL rules.

Manual-collection product fields

productId

ID of a product to include.

productPosition

Position number (works only if sortOrder = MANUAL).

productTitle

Product title. Export only.

productHandle

Product handle. Export only.

Publication

publicationScope

Sales channels where the collection is published.

Metafields

metafields

Extra app fields. See Metafields guide.

5. Filters

CollectionType

Filter by smart or custom.

Handle

Export collections where handle contains the text you enter.

Id

Export a single collection by id.

ProductId

Export collections that include a specific productId.

ProductPublicationStatus

Filter by product publish status inside the collection.

PublishableStatus

Choose ready, scheduled, or unpublished collections.

PublishedAt

Date range when the collection became visible.

PublishedStatus

true for published, false for hidden.

Title

Export collections whose title contains your text.

UpdatedAt

Filter by last-updated date range.

Need help? Our support team answers within 24 hours.

Share: