On a product overview, open Excel.
Import is for an administrator or a superuser.
- Choose Import.
- Choose the Excel file and choose Import. The log is shown on the page.
- Each row is matched on GTIN (D8165) and Target market (D8255). See Creating and Maintaining Excel Profiles for how the sheet is set up.
To clear a field, put @Delete in the cell. See How to Delete Field Content with '@Delete' During Excel Import.
Choose Imported files in the Excel menu to open an earlier import and read its log.
To export, choose Export and pick the fields, or choose a saved profile under the divider. Tick products to export those. With no products ticked, a search exports the products that match.
Two extra columns can mark the imported rows to be sent to the data pool. See Can I use Excel sheets to automatically upload products to GS1?.