Import and export product brands

Create CSVs require: Name. Other columns are optional. Blank slugs are generated from the brand name. An existing brand name is skipped and reported. A name repeated in the same file, or a supplied slug that is already in use or repeated in the same file, is reported as an error, and so is __CLEAR__ in any column. Fix every error in the preview before you start the import.

Update CSVs use the ID column from an export. The ID identifies which brand each row updates. Blank fields keep the current value. If a row changes the slug, you can choose to create a redirect from the old URL. Fix every error in the preview before you start the update.

To clear an optional value in Update mode, enter __CLEAR__ in Description, SEO Title, SEO Description, or Image URL. Entering it in Template Handle resets the brand to default_brand. ID, Name and Slug cannot be cleared: __CLEAR__ in those columns is a row error. A field that still has translations can't be cleared until its translations are removed.

An unchanged Template Handle from an export is accepted even if that template is no longer in your active theme. A different handle must exist in the active theme.

Importing an Image URL needs Media write access. You can import text-only brands without Media write access, and clearing an existing image in an Update CSV does not upload a file.

Use Image URL to import a JPEG, PNG, GIF, or WebP image from a public http:// or https:// address. Preview checks the CSV value, and every preview error must be fixed before the job can start; the image itself is downloaded only after you start the job. During processing, Tringify checks the response, file size, image bytes, dimensions, malware scan, and your storage quota before saving it to the media library.

When several rows in the same job use the exact same Image URL, Tringify downloads and stores that image once and reuses the same media file for those rows. An exported Tringify Image URL also reuses the existing file when it still belongs to your store. Files from another store are never reused.

For an Update CSV, leave Image URL blank to keep the current image, keep or paste a URL to set the image, or enter __CLEAR__ to remove it.

The Update wizard shows the current image URL entry limit for one job. Every non-empty Image URL cell counts toward that limit, including repeated URLs and existing Tringify media URLs. Blank cells and, in an Update CSV, __CLEAR__ do not count. If the file exceeds the limit, the preview shows an error and the job can't start.

If an image cannot be downloaded or accepted, that row is reported as an error and its brand is not created or updated. Other valid rows continue. The completed job reports downloaded and failed media totals, and the audit log records one brand job result instead of one entry for every imported file.

CSV files use UTF-8. Exports start with a byte order mark (BOM) so spreadsheet apps recognize the encoding, and imports accept files with or without one. A file with text that isn't valid UTF-8, such as one saved in another encoding, is rejected with the line of the first problem. Save it as UTF-8 (in Excel, CSV UTF-8) and upload it again.

A value that starts with =, +, @ or %, or with a tab or line break, is exported with an apostrophe in front so spreadsheet apps show it as text instead of running it as a formula. So is a value that starts with -, except a plain number such as -12.50, which stays a number. A value that really starts with an apostrophe is exported with a second one. Importing the file removes the added apostrophe, so these values come back unchanged.

A value that is exactly __CLEAR__ is also exported with an apostrophe in front, and so is none in a column where it clears a value, such as Quantity Pricing. On import it is read as that text, not as an instruction to clear a value. In other columns none is exported as it is.