1b.app
Link copied -

process product price

good afternoon. is it possible to massively change the prices of the products of the process using the xls file, for example (the prices are different)?
Original question is available on version: ru

Answers:

through the product loading block in progress
it loads from Excel and replaces prices
05.02.2021, 17:03
Original comment available on version: ru

I mean through the panel of mass operations at once in all selected processes
05.02.2021, 17:09
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
I mean through the panel of mass operations at once in all selected processes

no such possibility now
you can make a block of mass operations like this
will take about 6 hours
05.02.2021, 17:57
Original comment available on version: ru

Can you describe in general terms how it will work?
05.02.2021, 18:06
Original comment available on version: ru

there will be a specific file format (column names that you need to specify in excel) by type
productid productprice productcount and so on
all the processes that you have selected are processed. Tobish, the system parses the file, looks for products in them by id and updates the fields specified in the file
05.02.2021, 18:08
Original comment available on version: ru

process product id different from product id?
05.02.2021, 18:15
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
process product id different from product id?

in general, yes
but there are both id
05.02.2021, 18:16
Original comment available on version: ru


Ustimenko Igor
OneBox CTO wrote:
but there are both id

where exactly?
05.02.2021, 18:18
Original comment available on version: ru


Chubenko Mikhail
Client wrote:

Ustimenko Igor
OneBox CTO wrote:
but there are both id

where exactly?

in the process)
05.02.2021, 18:21
Original comment available on version: ru

when adding a process product in a subprocess, will it have a different id?
08.02.2021, 15:40
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
when adding a process product in a subprocess, will it have a different id?

process product id - yes
no product id
08.02.2021, 16:15
Original comment available on version: ru

In this case, in order to massively rewrite the price of a product in a subprocess, you must first export the xls file (to get the process product id), and then import it back with the updated price. Do I get it right?
08.02.2021, 16:44
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
In this case, in order to massively rewrite the price of a product in a subprocess, you must first export the xls file (to get the process product id), and then import it back with the updated price. Do I get it right?

yes, or update by productid
then it will update wherever you have chosen for the found product
08.02.2021, 16:52
Original comment available on version: ru

it is supposed to be one product (service) but with a different price in different processes
08.02.2021, 16:55
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
it is supposed to be one product (service) but with a different price in different processes

it will be possible to display the process product id column in the process
and then you will clearly see it in order to put it in the file
08.02.2021, 17:01
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
it is supposed to be one product (service) but with a different price in different processes

I mean that by product id it will probably not be possible to update
08.02.2021, 17:10
Original comment available on version: ru


Chubenko Mikhail
Client wrote:

Chubenko Mikhail
Client wrote:
it is supposed to be one product (service) but with a different price in different processes

I mean that by product id it will probably not be possible to update

you need to have a sign by which to distinguish it.
Of course, you can specify the process + product id, but then I don’t see the point of refinement
08.02.2021, 18:02
Original comment available on version: ru


Ustimenko Igor
OneBox CTO wrote:
it will be possible to display the process product id column in the process

in the product table you mean?
18.02.2021, 12:37
Original comment available on version: ru


Ustimenko Igor
OneBox CTO wrote:
there will be a specific file format (column names that you need to specify in excel) by type
productid productprice productcount and so on
all the processes that you have selected are processed. Tobish, the system parses the file, looks for products in them by id and updates the fields specified in the file

Will it work for export too?
18.02.2021, 12:56
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
in the product table you mean?

Yes

Chubenko Mikhail
Client wrote:
Will it work for export too?

no export we did not discuss
18.02.2021, 13:31
Original comment available on version: ru


Ustimenko Igor
OneBox CTO wrote:
no export we did not discuss

in principle it is not necessary

Chubenko Mikhail
Client wrote:
there will be a specific file format (column names that you need to specify in excel) by type
productid productprice productcount and so on

the main thing is to be able to overwrite the price and quantity
hence the question: when we overwrite the price and quantity of process products by uploading an xls file, will their cost be recalculated automatically?
18.02.2021, 14:22
Original comment available on version: ru


Chubenko Mikhail
Client wrote:
the main thing is to be able to overwrite the price and quantity
hence the question: when we overwrite the price and quantity of process products by uploading an xls file, will their cost be recalculated automatically?

yes automatically
18.02.2021, 15:41
Original comment available on version: ru



Chubenko Mikhail
Client wrote:
let's do this fix

there were several options, let's summarize what we end up doing
21.02.2021, 15:45
Original comment available on version: ru


Ustimenko Igor
OneBox CTO wrote:
there will be a specific file format (column names that you need to specify in excel) by type
productid productprice productcount and so on
all the processes that you have selected are processed. Tobish, the system parses the file, looks for products in them by id and updates the fields specified in the file

A block for the panel of mass operations, with the help of which you can overwrite the quantity and price of products of selected processes by downloading an xls file. And display the process product id field in the product table
22.02.2021, 10:35
Original comment available on version: ru


Chubenko Mikhail
Client wrote:

Ustimenko Igor
OneBox CTO wrote:
there will be a specific file format (column names that you need to specify in excel) by type
productid productprice productcount and so on
all the processes that you have selected are processed. Tobish, the system parses the file, looks for products in them by id and updates the fields specified in the file

A block for the panel of mass operations, with the help of which you can overwrite the quantity and price of products of selected processes by downloading an xls file. And display the process product id field in the product table

OK
looking for a process product by process product id, or order + product id?
22.02.2021, 13:09
Original comment available on version: ru


Hello, the revision has been completed, the block is called "Change process products using an XLS file"
22.03.2021, 18:23
Original comment available on version: ru

I don't see the orderproductid field in the products table
23.03.2021, 11:17
Original comment available on version: ru

please explain how the block works
23.03.2021, 12:56
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment