Skip to main content

Open Bulk Editor docs

Safe CSV guide

Learn how Safe CSV matches Shopify products and variants, handles blanks and clear values, separates creation, and records results.

Update existing products and variants

Map a CSV column to Product ID, Handle, Variant ID, or SKU for matching. Product ID and Handle resolve products. Variant ID and a store-unique SKU resolve variants.

Cell valueMeaning
BlankLeave the Shopify value unchanged.
__CLEAR__Set the supported field to an empty value.
__NULL__Set a supported nullable field to null.
Any other valueValidate and plan that value for the mapped field.

A SKU that matches more than one variant is blocked. An unmatched row is reported and never creates a new product. Save a mapping profile when the same supplier or system sends files with the same columns.

Create new products

Create mode expects a Shopify-style product CSV. Handle groups the rows for one product. The flow reads product fields from the first available values, groups variants, accepts public image URLs, and can create initial inventory when a location is selected.

The entire file is treated as CREATE. Existing handles are not overwritten. New-product creation uses a snapshot backup and does not promise a complete automatic rollback.

Preview binding

The preview records the store, file metadata, mode, mapping, and inventory location. Change any of them and preview the file again.

Result files

Keep the result CSV with row status, errors, and created IDs. Keep the backup journal for update mode until you are satisfied with the Shopify result.