Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Neil Hodges 338 posts 987 karma points
    May 01, 2019 @ 08:18
    Neil Hodges
    0

    Tea Commerce - Exporting Orders into a CSV

    Hi

    Long shot but has anyone built into the back office an option to export Orders into a CSV before?

    I guess I can roll my own, create a new Dashboard and spit out a CSV using GetOrders from a button click but wanted to check is there a more elegant way to do this or if someone else has done similar?

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    May 01, 2019 @ 08:26
    Matt Brailsford
    100

    Hi Neil,

    There isn't anything out of the box, but I received this from the Tea Solutions guys a while ago when I needed the same:

    https://www.dropbox.com/s/lfgsc01sljgh7nn/TC_CSV_EXPORT.zip?dl=0

    I used it on a project myself and merged it into the App_Plugins\TeaCommerce\Views\Orders\SearchOrders.aspx view so it was accessible via the orders section. You'll have to be careful that it doesn't get replaced if you upgrade though.

    Hope this helps

    Matt

    PS I can't recall if it was just drop in code or if it ended up tweaking it, but hopefully it's at least a starting point.

    Copy Link
  • Neil Hodges 338 posts 987 karma points
    May 01, 2019 @ 10:31
    Neil Hodges
    0

    HI Matt

    Thanks for this, When you say merge into SearchOrders, is it a case of dropping the files into the Orders folder and referencing it in SearchOrders.aspx? Not sure I follow.

    Copy Link
  • Neil Hodges 338 posts 987 karma points
    May 01, 2019 @ 10:59
    Neil Hodges
    0

    Ah, scratch that I get it now.

      <uc1:OrderCSVExport runat="server" id="OrderCSVExport" />

    into the SearchOrders.aspx works.

    Thanks Matt :)

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    May 01, 2019 @ 12:26
    Matt Brailsford
    0

    Yea, that's the one.

    Glad you got it working 👍

    Copy Link
  • Tim 45 posts 199 karma points
    Jun 22, 2020 @ 10:59
    Tim
    0

    Hi Matt,

    Do you still have the example code for the CSV export? The dropbox link doesn't work any more and I'm looking into doing something similar for a TC site!

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    Jun 22, 2020 @ 11:59
    Matt Brailsford
    0

    Hey Tim,

    Try this one https://www.dropbox.com/s/lfgsc01sljgh7nn/TCCSVEXPORT.zip?dl=0

    /Matt

    PS I've updated the Original link too

    Copy Link
  • Tim 45 posts 199 karma points
    Jun 22, 2020 @ 12:06
    Tim
    1

    Thanks Matt, you're an absolute star :)

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft