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)?
Оригинальный вопрос доступен на версии: ru

Answers:

through the product loading block in progress
it loads from Excel and replaces prices
05.02.2021, 17:03
Оригинальный комментарий доступен на версии: ru

I mean through the panel of mass operations at once in all selected processes
05.02.2021, 17:09
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru

Can you describe in general terms how it will work?
05.02.2021, 18:06
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru

process product id different from product id?
05.02.2021, 18:15
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru


Ustimenko Igor
OneBox CTO wrote:
but there are both id

where exactly?
05.02.2021, 18:18
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru

when adding a process product in a subprocess, will it have a different id?
08.02.2021, 15:40
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru

it is supposed to be one product (service) but with a different price in different processes
08.02.2021, 16:55
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru

let's do this fix
19.02.2021, 15:52
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: 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
Оригинальный комментарий доступен на версии: ru

Yes
22.02.2021, 14:13
Оригинальный комментарий доступен на версии: ru

Hello, the revision has been completed, the block is called "Change process products using an XLS file"
22.03.2021, 18:23
Оригинальный комментарий доступен на версии: ru

I don't see the orderproductid field in the products table
23.03.2021, 11:17
Оригинальный комментарий доступен на версии: ru

please explain how the block works
23.03.2021, 12:56
Оригинальный комментарий доступен на версии: 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