Sign in Register
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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies