General Architecture Import Export Content

Study Notes

Imports and exports are handled as integration jobs, which can be monitored on the Job page.
Jobs can be initiated by clicking Upload or Download in the Admin Console.
Import and export data is subject to XLSX file format limits of 1,048,576 rows and 16,384 columns.

To import data, click Upload on pages like Products, Categories, or Users.
Import templates can be downloaded by clicking Download Template.
Import template cells should be formatted as text and all sample rows except for column headers should be removed.
When importing, you can choose various options:
- Validate file before importing: Checks for errors in the import data and stops the import process if any are found.
  - This option commits each row individually to the database and reverses the change, potentially leading to errors for data dependent on previous rows.
  - Highly recommended to be used sparingly due to the increased processing time.
- Ignore blank cells: Ignores blank cells and doesn't overwrite existing cells.
- Update existing records: Pushes changes from the import file to existing records.
- Ignore modified date: Allows imported data to override existing data, even if the record has been changed since the last export.
After selecting import options, click Import to start the import process.
Imports are executed in the background, allowing you to perform other tasks in the Admin Console.
Any errors encountered during the import process will be displayed on the Admin Console screen.

To unassign related product data, navigate to Products > Upload > Product Related Product.
Download the template, complete the required information, and mark the Unassign column as True for related products you want to unassign.
After completing the information, browse for the file and select the desired import options.

Access the Export page by clicking Download on a list page.
Select the data you want to export, including options for Selected Products, Filtered Products, or All Products.
Select the columns to include in the export. There is no limit to the number of columns you can select.
Save your column selection preferences for future exports by clicking Save as Default Selections.
Click Export to start the export process.
Exports run in the background, allowing you to perform other tasks in the Admin Console.

Once an import or export job has begun, you can monitor its status by navigating to Administration > All Jobs History.

Podcast