Skip to main content
Acenda
Log in Book a Demo
Book a Demo
Acenda Admin trainingCatalog & Products2:41

Create items with a catalog import

Create or update many items at once by exporting your catalog, preparing the spreadsheet, and uploading it with New Import. Importing a Super Template is the preferred way to add new items to Acenda, but understanding the import tool on its own still helps, so we recommend watching our Super Template videos too.

What you'll learn

  1. Export your catalog and clear it to a blank template
  2. Fix group, UPC, image and custom field columns
  3. Upload with New Import and pick the update option

Where to find it

The menu path in Acenda Admin.

Data Transfers > Exports and Data Transfers > Imports

Transcript

Importing a Super Template is the preferred way to add new items to Acenda. It still helps to understand the import tool on its own.

A catalog import adds or updates many items from one spreadsheet. Start from an export of your own catalog, so the headings match.

In the sidebar, under Data Transfers, click Exports. Set Export Type to Catalog and click Export. Create at least one product by hand first, so the file has the right attribute headings.

Download the file from the Generated Files table, then delete every row below the headings. That's your blank template. Also delete the five system columns at the start: ID, created at, created by, updated at and updated by.

Excel is preferred, and CSV in UTF-8 is also accepted. Only the first tab is imported. In the group column, enter product, variant or kit. For each variant row, enter the parent SKU in the group skus point zero column.

Excel often turns a long UPC into scientific notation, so format that column as Number with zero decimal places. To keep existing images, leave the image columns out. A blank cell in a custom field column clears that field. To keep a custom field unchanged, delete its column from the file.

Now go to Data Transfers, Imports, and click New Import. Choose Catalog as the Import Type, upload your file, match your headings to Acenda fields, and tick each attribute you want to use. For new items only, leave every box unticked. To update existing items and add new ones, tick Overwrite any current records that have the same ID. To only update existing items, tick Only update existing records, then click Start Import.

Importing doesn't list items on a marketplace. Channel mapping is a separate step.

To recap: export a blank template, prepare the columns, and upload it with New Import. For new items, also watch our Super Template videos. Questions? Chat with Acenda support in Acenda Admin, or visit acenda.com/help.

Open the transcript as plain text

Watch next

All training videos →
2:39 Channels & IntegrationsAdd new items with Super TemplatesCreate brand-new items on a sales channel by filling in a blank Super Template and importing it. 3:03 Imports & ExportsSave a file as CSV UTF-8Save your import file as CSV UTF-8, or import an Excel file directly, so accents and symbols come through correctly in Acenda.

Want to see how onboarding works?

Book a Demo

Or contact us.

Acenda provides these resources as a courtesy. While we strive for accuracy, they may contain mistakes, errors, or omissions, and information may become outdated. Vendors should use their best judgment, consult an attorney as appropriate, and confirm current requirements with the applicable sales channel.