Skip to content

Mass edit records using CSV/XLSX #2960

Open
@adrianthedev

Description

@adrianthedev

Users can add some filters to narrow down the search and then export a CSV file with all those records.
Then, their non-technical users can make updates to that CSV and re-upload it.
Avo should then upsert the records it finds based on a (configurable) attribute.

Some more information from a customer who implemented it by themselves:

So what i implement for mass creation is:
Download a template
It includes the columns and an example
Users fill it up
Upload csv
Users upload the filled up template
For example. We have the product model. Where for creation you must define: name, sku, weight, height, width, depth, images (this one is tricky part of this feature)
For the has_many images, I just define a maximum amount (in this case, for example, 3)
You can download a template (in csv) like this one:


name,sku,weight,height,width,depth,images_1,images_2,images_3
example product,EXAMPLE_SKU,10,11,12,13,http.....1,http.....2,http.....3

I actually use .xsls (excel) files, which is easier to use in my company, but I suppose you could configure it

And for mass editing, you can define a key (or multiple) and fill up the spreadsheet and upload it

CleanShot 2024-07-09 at 01 35 44@2x

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions