Download ready-made sample file massorder.xlsx
Instruction:
1. Specify the information in the cells as follows:
| A | B | C | D | E | F | |
| 1 | 999 | | | https://link.com | | | =RANDBETWEEN(350;500) | =CONCATENATE(A1;B1;C1;D1;E1) |
where the following information is specified in the cells:
- A - service id from the list of services on the site,
- B and D - vertical line separating parameters,
- C - link to send likes (subscribers),
- E – the formula for the number of likes (subscribers), where 350 is the lower limit, 500 is the upper limit,
- F – formula for obtaining the total line of the mass order.
2. To create several orders at the same time, you need to create a table like:
| A | B | C | D | E | F | |
| 1 | 999 | | | https://link.com | | | =RANDBETWEEN(350;500) | =CONCATENATE(A1;B1;C1;D1;E1) |
| 2 | =A1 | =B1 | https://link.com | =D1 | =E1 | =F1 |
3. After that, pull the lower right corner of each of the cells A2, B1, D1, E1, F1 down by as many cells, the number of which is equal to the number of orders for this service.
As a result, in column F we get lines of the form:
999|https://link.com|431
999|https://site.com|386
4. Select all cells filled in column F, starting from the first and ending with the last.
5. Right-click on any of the cells and select "Copy" from the menu
6. Paste the received parameters into the field for creating a mass order on the site.
7. Check the absence of empty lines at the beginning and at the end. If empty lines are present, you must remove them.
8. Confirm the order.
Read more:
VK Shops: How to Turn Content into Sales
