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?
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?
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?
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?
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?
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?
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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?
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?
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.
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.
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.
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.
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
Donate
You don't have enough funds in your account Top up