Wix Stores - Email notification with order csv attached?

My client has asked if they can have the order csv attached to the order notification email they receive.

They want to import the csv into their back end system, which will create an order. I was hoping someone can help, is there a way of getting the order csv attached to the order notification email or a workaround. If not, I think that this would be a great feature to add.

Thanks in advance, Mike

Hey Mike - This is a good question. I’ve seen it a few times, so I’ve asked our Product Expert to look into this for us. =)

Hi Brett, thank for the reply. I look forward to hearing back from you :blush::+1:t3:

Hello @mikemeehan ,

There are a few things I’d like to clarify, which back end system are you referring to and what flow are you trying to create?

This information will help me to investigate further on the feature you are trying to implement :slight_smile:

Hi @randya ,

They have a custom back end system called the Visual Business. They have a folder on their server that they drop CSV’s into and the system will then read the info and create orders. They receive orders for other customers that are in the same format.

What they want to have happen, is when an order is made on the website then the order notification email is sent to the dedicated email. They receive a CSV of the order attached to the email, the person who receives it can then drop the file into the folder on the server.

If you need any more info please ask away :blush:

@mikemeehan This sounds like it would be done outside of Wix as Velo is about coding the website itself, not creating apps for external use. To have an email sent out for your use to upload to a private server would be outside the scope of Wix.

With Velo you can do something along the lines such as sending out a specialized email with a file depending on the user submission, however the additional steps described are out of scope.

Hey @randya thanks for getting back to me. Sorry I think I have caused a misunderstanding with describing the whole work flow.

What I was curious about was only inside the Wix system. Specifically if the Wix system is able to automate a process that is currently manual. When my client recieves the order notification email from Wix. They login to Wix, go to Store Orders and select the latest order then export the file, which is in CSV file format.

I was curious if the Wix system can attach the order’s CSV file to the order notification email.

Would this be possible?

Thank you again for the help

@mikemeehan You are not able to do this to the Wix Notification email however you are able to use Velo to listen to Order Paid Event and send a secondary email with the data. On the event you can get all the order data and do what you want with it.

@mikemeehan You are not able to do this to the Wix Notification email however you are able to use Velo to listen to Order Paid Event and send a secondary email with the data. On the event you can get all the order data and do what you want with it.