Bulk Product Management in the Web Portal

Add many products or launch many sales at once from the Web Portal, instead of editing one product at a time.

1. Bulk Uploading Products

On the Products page in the Web Portal (portal.membrzs.com), click Bulk Upload Products.

  1. Click Download CSV template to get a starter spreadsheet with the correct column headers.
  2. Fill in one row per product. Only name and price are required — every other column (pricing_type, unit_label, bundle_qty, bundle_price, category, barcode, emoji, description, is_tax_exempt, track_inventory, status) is optional.
    • category can be any text — a new category is created automatically the first time you use its name, and existing categories are matched by name (no duplicates).
    • pricing_type must be unit or weight; status must be active, seasonal, or archived.
  3. Save the file as CSV and upload it in the Bulk Upload Products dialog. A preview table shows the parsed rows before you commit anything.
  4. Click Import. Each row is processed independently — a typo in one row won't block the rest of your catalog from importing. A results table shows exactly which rows were created and which failed, with a reason for each failure.

Freemium accounts: if your import would push you past the free plan's product limit, the import fills your remaining slots and reports the rest as failed rows (with an upgrade message) rather than failing the whole batch.

2. Bulk Uploading Sales

Also on the Products page, click Bulk Upload Sales to put many products on sale at once (e.g. a weekend-wide markdown across your catalog).

  1. Click Download current catalog first — this exports your live product list, including each product's real ID, name, barcode, and current price. Sale rows need to point at a specific existing product, and product names aren't guaranteed unique, so this export is the safest way to get the right identifier.
  2. In the exported spreadsheet (or your own, using the Download CSV template button), fill in sale_price and ends_at for each product you want on sale, and starts_at if it shouldn't start immediately. Keep the id column populated — that's what each row is matched against. If you don't have the id, a barcode can be used instead, but only if that barcode belongs to exactly one product in your catalog.
  3. Upload the CSV, preview the rows, and click Import. As with product import, each row succeeds or fails independently, with a results table showing which products actually went on sale.

Uploading a new sale for a product that's already on sale corrects that sale in place — it does not create a duplicate or wipe out your sale history. Sale pricing is vendor-wide and time-bound, not tied to a single market session, and pausing/resuming an individual sale is still managed from that product's own row on the Products page (not through bulk upload).

Frequently Asked Questions

Who can perform this action?

Owners and Managers can access the Web Portal's Products page, including both bulk upload flows.

What happens if some rows in my CSV are wrong?

Nothing else is affected. Bulk upload is row-by-row — valid rows are created/updated, and invalid rows are listed individually with the specific reason they failed so you can fix and re-upload just those.

Need additional help?

If you have questions, visit Membrzs Support or contact our team via the Contact page.