I
I
Ilya2018-02-26 20:30:53
PHP
Ilya, 2018-02-26 20:30:53

How to make a purchase option in excel-price?

Hello. On the site, using PHPExcel, I generate a price list, about 30k positions. It is necessary to make it possible to select and order goods directly in excel. What I came up with:
A separate column in which the buyer specifies the quantity. A buy button that contains a link to the site. This link has a get parameter that contains a json string with the SKUs and the quantity of ordered items. On the server, json is decrypted and the order is placed.
Problem:
How to substitute parameters in the get link? I need something about concatenating rows, but the standard excel functions didn't help me. It seems to have found a suitable UNITE function. But, for example, in my 2016 excel`e it is not.
I thought about writing my own VBA function (and even found a ready-made function), but how to make friends with PHPExcel? Yes, and the user will pop up a message like "malicious macros", which is also not good.
Does anyone have any ideas how to organize it differently? Thank you.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg, 2018-02-26
@402d

let them send the completed price list to the mail and / or the form of uploading it to the site.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question