Link Google tables with PRM and New Post.
Needed to:
1.To upload the order information from the PRO to the Google table.
Create a new mail on the order data from the table.
2nd Analysis of sales data
Three Check the status of the shipment and draw them into a separate column.
4 . The line with the status of the shipment, stored for more than 3 days - distinguish by color.
and 5. Sendings that have begun with paid storage - make in a different color.
6.Send SMS by template with the number attached to the client through turbosms
The sales and order status are calculated in the Google Table.
Needed to:
1.To upload the order information from the PRO to the Google table.
Create a new mail on the order data from the table.
Three Check the status of the shipment and draw them into a separate column.
4 . The line with the status of the shipment, stored for more than 3 days - distinguish by color.
and 5. Sendings that have begun with paid storage - make in a different color.
6.Send SMS by template with the number attached to the client through turbosms
7 . Make a summary analysis of sales data daily: how many leads by sales sources closed,monthly:the amount of the sold goods in the art section( the data all in the Google table is available)
ИСПРАВЛЯЮ ОШИБКУ В ТЗ:
Учет продаж и состояние заказов ведется в гугл таблице.
Необходимо:
1.Подгружать информацию о заказе из ПРОМа в гугл таблицу.
2.Создавать накладную Новой Почты по данным заказа из таблицы.
3. Проверять статусы посылки и выводить их в отдельную колонку.
4. Строку со статусом посылки, хранящейся более 3 дней - выделять цветом.
5. Посылки, у которых началось платное хранение - выделать другим цветом.
6.Рассылать смс по шаблону с номером накладной клиенту через turbosms
7. Вывести сводный анализ по данным продаж-ежедневно: сколько лидов по источникам продаж закрылось,ежемесячно:количество проданного товара в разрезе арт( данные все в гугл табл есть)
Client's review of cooperation with Andrew Kr
Link Google tables with PRM and New Post.Google tables is a very cool, many underestimated tool.If you have complex business processes and there is no CRM system installed on them, then use this tool to quickly count and eliminate damage from the human factor.Andrei possesses this tool well.If he doesn’t know how to solve a task today – trust him, give time to find its solution and he will solve it in the best way and bring you a lot of very useful ideas to improve the results of the tasks.My project as a result of working with Andrew became more serious and a small account table in the Google account became a quality account system.What our "Sales" table knows, thanks to its creator:
All information from the Promo will be filled into the table automatically.(Errors + timewith the manager)
- not exceeding the table manager checks the order through a specially emerging window(realised offer of Andrey), checks during the call with the buyer, with confirmed order-this creates the TTN and "o,wonder" manager doesn't have to go to the Promo and change the status, transfer information from the Promo to the table and back, the scripts do everything themselves.(Errors + timewith the manager)
-All the plushes and the process of working the table itself in one review not to describe, just believe it works as it should.All the information is stored on the company’s Google disk with one large set, which allows you to better control sales and create any forms of reporting.As a result of the work on the project, we found a great employee.We continue cooperation.Advice to future customers – don’t rush the executive, take into account his proposals – he’s the case says)
Andrei, thank you for your cooperation.
Freelancer's review of cooperation with Anastasiya Sergeyeva
Link Google tables with PRM and New Post.It’s very easy and pleasant to work with Anastasia. It was an interesting task!
Always on contact, quick answers and correct details. It’s hard to work, but it’s good.
I will be glad to work again.
-
237 Good day, I have experience working with Google Table, I'm glad to take this work. I will be happy to cooperate!
-
1412 8 0 1 Good morning, I can do, I have experience working with various API including NP, turbosms, google sheets.
-
336 4 1 Good day . I don’t have a ready solution yet, but there’s an idea how all to realize, we can first discuss the details because you need to understand which tools with promotions you are still using and which are not. I am interested in more information on the last point.
-
250 8 0 Welcome to! Immediately I will say I didn’t have to work with Prom and N.Posta, but the experience of working with API is, I hit both, as if nothing is not understood. I love to do my job.
Everything should be discussed in a detailed conversation.
-
4302 215 0 1 Good night, there’s a lot of experience working with API tables and API prom, but I can only do partly, not all tasks. Write to the page to discuss details if you are interested
-
164 Good day, there is the experience of working on the registration of the electronic mail in the personal office of New Post, the control of the mailing, the formulation of returns, re-addressing, the conduct of the claim work on the lost mailing and compensation by the carrier.
There is also experience with tables.
Everything needs to be detailed, time and cost. I think it’s not a job for a day.
-
Есть готовый продукт api.in.ua
-
Current freelance projects in the category Data Processing
Digitization and structuring of official questions from the Traffic RulesLooking for a performer for technical work: transferring the official publicly available database of questions from the Traffic Rules (TR) into a structured Google spreadsheet and organizing accompanying images. Data Source Only the official state source — the Main Service… Information Gathering, Data Processing ∙ 17 hours 5 minutes back ∙ 16 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 21 hours 34 minutes back ∙ 7 proposals |
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 2 days 19 hours back ∙ 9 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 9 days 19 hours back ∙ 20 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 10 days 13 hours back ∙ 18 proposals |