Hi,
I use a web based system in order to order products from my wholesalers and then send an email to the location receiving the stock letting them know what I have ordered. The information on the lines that are ordered is in the format of a table. An example is shown below:
| Product |
Pack |
Price |
Quantity |
Total |
OOS |
|
|
Widgets
(Some Details)
More details |
28 |
£14.81 |
10 |
£148.10 |
|
|
|
|
|
|
|
|
|
|
|
After I send an email to the location, they have to enter the goods received into our stock control system. The stock control system allows for importing of data but since we deal with a number of wholesalers, the product notation is not always the same so we cannot do a straight import based on matching a product code.
I want to know whether the following is possible in Zoho Creator and also how to go about doing this:
- Table copied from wholesaler website.
- Table emailed to Zoho Creator
- Zoho Creator transforms data into correct format by doing some sort of lookup.
- Zoho Creator emails me back a copy in the correct format for import into my stock control system.
Your assistance in this matter is much appreciated.
Kind regards,
Shaheed