Bulk product updates through an export and reimport round trip
Key Takeaway
The export CSV and the import CSV share the same header format, so you can edit an exported product file and import it straight back to update many products at once.
In a B2B Commerce store, you can change many products at once with a round trip: export the products to a CSV file, edit the file, and import it back. The product workspace decides which products and fields go into the export. Before you rely on the round trip, know two limits. One import session takes fewer products than an export can hold, and translations aren't exported.
Why the export file works as an import file
The export and import CSV files share the same header format. To make bulk updates, you edit the export CSV and then use it as the import CSV, much like downloading a spreadsheet, changing cells, and uploading it again.
The product workspace shapes the export file. Filters and sorting that you apply in the workspace carry into the file. The file also includes all standard and custom product fields that appear in the workspace.
Because the file already uses the import header format and holds the product fields from the workspace, you can edit it and use it directly as the import CSV. You can also filter the workspace first, so the export holds only the products you plan to change.
Ana runs a B2B store that sells safety equipment. She needs to change a custom field, shown in the product workspace, that tracks the safety rating on 200 helmet products. In the product workspace, she filters the list to those helmets and sorts them by name. Then she exports the products. The CSV file holds the same 200 helmets in the same order, with the standard and custom product fields that the workspace shows, including the safety rating field. She updates the safety rating column, saves the file, and uploads it as the import CSV without changing any headers.