Output session variable on Sales Items Export CSV

Ask the community
, ,
1

Hi Everyone, new here and have been searching for an answer to something I assume is simple, but am struggling with it :frowning:

I have a session variable being set by user selection on a page, just before they add products to the basket, and that works fine.

When the order is submitted, what I need to be able to do is to output that session variable on the Sales->Export-Items CSV file. I can’t find a way to output this value to a field I don’t use on the CSV.

Any help of ways to achieve this appreciated!
Thanks

2

I think you need to be a little bit more specific. How about a screenshot of what field you mean on your website.
Or you can try to find it in the CMS Store/Order.

image
image1614×296 12.8 KB

3

Hi! Thanks for your reply - any blank field at Product level will do, so for example, I don’t use WEIGHT or SKU (they are blank on my orders) so I would like to assign the session variable to one of those fields…

4

Hi,

Is the purpose of the session variable just to allow the user to add additional details about the specific product they’re purchasing, before they complete the order?

5

Yes, it is to collect some more information in relation to the product they are purchasing - I am already using the 2 custom fields available at product level to collect other user specific attributes. If WIX enabled 3 to be used, I would not have an issue, but only 2 are available on the product setup page, so I am looking for another solution.
I already capture the data I want in a session variable, but can’t find a way to output that onto the CSV report that is exported from the Sales Data.

Any suggestions appreciated!