1b.app
Link copied -

need an estimate of the improvement according to the price lists

Client box - http://box.agro-him.com.ua/admin/shop/users/4/
The client has a need to send out one template (file) using
automatic action "Send price list" with a certain interval
time.
Initially, the client will prepare a price list template in "exel". It is necessary to automate the unloading of product prices into the template
price list by article, namely, columns will be added in the line with the article
with the price (the number of prices may change). The price template will be loaded into
box already filled in with the article, maker, name, and the system
should pull up a correspondingly determined price in the line with the article. AT
as a result of refinement, they want to get the possibility of the send action
price list, with current prices for now.
Also, the client wants to know where the file with the price template should be located?
how many hours does it take to finish?
Original question is available on version: ru

Answers:

And why in such a situation do you need a template with articles? Can't you just leave the desired header and add a standard unloading from below to this header?
07.09.2020, 12:41
Original comment available on version: ru

The list of products in the price list is divided into product groups and by manufacturer, so each product must be in a specific line, so if you just leave the header and do the unloading, then everything will be unloaded alphabetically, which does not suit us, so we found a way out with articles and binding a string to them, as far as possible?
07.09.2020, 13:02
Original comment available on version: ru

In action, there is an opportunity to group products into categories, doesn't it suit you?
07.09.2020, 13:31
Original comment available on version: ru

We have seen the standard functions, but some points do not quite suit us, we want to understand the cost of this refinement.
07.09.2020, 14:04
Original comment available on version: ru

What you need, as far as I understand: take the article from the first column and substitute the selected fields from the action settings in the rest. Please drop a link to an example of your template, I will be able to estimate the cost of finalizing the action for it.
07.09.2020, 14:18
Original comment available on version: ru


I repeat once again, we will upload a ready-made price list template, in which we will put down the Article (column 1), Manufacturer (column 2), Product name (column 3), the price will be almost completely filled, there will be everything except prices, and prices should already to catch up with a certain product by article, there will be several prices, the box allows you to adjust their number, but it is necessary that the prices appear alternately in the columns after the name.
07.09.2020, 14:42
Original comment available on version: ru

In 6 hours you can make the functionality you need. It will be possible to apply a file template to the action and specify in which columns the values of which fields should be written.
07.09.2020, 14:44
Original comment available on version: ru

Great, we agree to finalize in 6 hours, I will describe all the nuances in as much detail as possible to make sure that we understand each other correctly.
We need to automatically send our price templates to email addresses using an action, the file itself must be placed somewhere in the box, and it must be possible to delete the template file with the price list and upload a new template. In the price template, we need the entire design of the file to remain as it was loaded into the box, before loading we will fill in all the necessary columns and rows, only the columns with prices will be empty, the system should automatically put the right price in the line with the article, as a rule there are several of them, columns and rows will be added / removed in the price list, therefore, it is necessary to make the system pull up prices in the column we need. AT
As a result of the revision, we want to get the ability to send the price list, with the current prices for now, which will automatically be put down in the desired price column.
08.09.2020, 10:50
Original comment available on version: ru

It is important that when filling in the price list, the name of the product that will be in the price template was not automatically replaced by the name of the product that is in the box (similarity by article), only prices in the right order should be uploaded to this file.
08.09.2020, 10:59
Original comment available on version: ru

Accepted, the invoice has already been sent to you
08.09.2020, 15:49
Original comment available on version: ru

I ask you to contact me by phone with a specialist who will do the revision.
10.09.2020, 18:55
Original comment available on version: ru

Hello, what exactly do you want to discuss? Tz we agreed, the invoice was issued. If you have any additions / wishes, you can write them here - I will answer you.
11.09.2020, 10:56
Original comment available on version: ru

Good afternoon, I want us to understand each other correctly, in my phrase "we are loading the price template" - literally we are loading our price list (exel file), and not the price templates that the box itself has. All right?
14.09.2020, 12:30
Original comment available on version: ru

Yes, you upload your exel file and we will fill in the indicated columns with prices
14.09.2020, 12:32
Original comment available on version: ru

Excellent, I also wanted to hear from you how this action will take place in stages? Where will this file be uploaded? Will we be able to constantly change prices (download similar ones)? I didn’t quite understand your phrase “we will fill in the specified columns with prices”, we need the columns to be able to change places and, accordingly, that we ourselves choose which column to load which price.
14.09.2020, 12:40
Original comment available on version: ru

1. You will upload the file to the action itself, go into the action - upload your file, it is saved there. The file will change as many times as you like.
2. Settings for which price to load (to which column on the invoice) will be in effect
Those. come in, upload a file, choose a price, specify which column to load it on the account, choose the second price - choose which column to load it in, and so on. We logged in tomorrow, uploaded another file, selected other columns, everything is working with the new file.
14.09.2020, 13:03
Original comment available on version: ru

Great, and, accordingly, the price will be tied to the line with Article ?
15.09.2020, 12:24
Original comment available on version: ru


Okay, let's pay the bill.
15.09.2020, 12:58
Original comment available on version: ru

There is a problem with the invoice, please contact us.
18.09.2020, 13:01
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