Table editing

What is table editing?

Table editing is Shoporama's spreadsheet-like tool for updating many products at once. Instead of opening each product individually, you can view all the selected products as rows in a table and edit the fields directly in the cells, just like in Excel or Google Sheets.

The feature was previously called bulk edit, but has been renamed table edit to better describe how it works.

To open table editing

1. Go to Products in the left menu
2. Select the products you want to edit (filter first if necessary)
3. Click Table editor in the action menu
4. Select which columns you want to include and click Apply

Which fields can be edited?

You can choose from many different product fields as columns:

• Prices: price, retail price, cost price, offer period
• Stock: stock level, stock location, package, allow negative stock
• Identification: SKU, secondary SKU, GTIN, MPN
• SEO: meta title, meta description, Google Shopping title, address, canonical, noindex
• Shipping: weight, shipping price, delivery time
• Environmental data: packaging, WEEE category, batteries, EPR number
• Display: online/offline, delete, hide from Google Shopping, Partner Ads and PriceRunner
• Product attributes: all attributes from the product profile

Your field selections are saved locally in the browser so you don't have to select them again next time.

What can you do in the table?

• Click directly in a cell and enter a new value
• Sort on any column by clicking on the header
• Add new products directly in the table with Add row
• Delete products via the delete column
• Put products online or offline
• Include variants as separate rows if you want to edit variant data

Press Cmd+S (Mac) or Ctrl+S (Windows) to save. If you try to navigate away with weekly changes, Shoporama will warn you so you don't lose your work.

When is table editing useful?

Table editing saves time when you need to make consistent changes across many products. Typical usage scenarios:

• Adjusting prices or sale prices before a promotion
• Updating inventory after a count
• Writing or improving SEO fields on an entire category
• Update SKU, GTIN or delivery times for a supplier's products
• Quickly put a group of products offline or online

Table editing and CSV import

For small or medium-sized updates, table editing is the fastest tool because you work directly in admin without having to export and import files. If you need to update thousands of products or fields that are not columns in the table, CSV or JSON import is typically a better solution.