Print Page | Close Window

Exporting to CSV Printed From: RomanCart.com Forum Category: RomanCart Forum Name: Administration Forum Description: Using the Admin Control Panel URL: http://forums.romancart.com/forum_posts.asp?TID=13676 Printed Date: 02 October 2023 at 6:59am Topic: Exporting to CSV Posted By: rscass Subject: Exporting to CSV Date Posted: 26 June 2018 at 9:40am I've mentioned this elsewhere, but maybe the feature already exists and I've missed it? Is it possible to select individual records in sales manager and export them to CSV, rather than a whole day's sales? I want to select sales records for items not yet shipped so that I can export a CSV file, quickly, to Royal Mail. At present, I export sales by date and then trawl through them deleting previously completed orders line by line. Many thanks. Replies: Posted By: Support Date Posted: 26 June 2018 at 9:43am Hi, Unfortunately not, however you can have order information sent to a url of your choice as it takes place. (See 'tools'/'options'/'general). You could then write a handler in php or similar to use that data as required. With the csv export, you'll need to wite a process e.g. an excel macro or python script to parse the data and extract the records you require. Many Thanks Support Posted By: rscass Date Posted: 26 June 2018 at 9:50am Support wrote: Hi, Unfortunately not, however you can have order information sent to a url of your choice as it takes place. (See 'tools'/'options'/'general). You could then write a handler in php or similar to use that data as required. Woooosssshhhhh - straight over my head! Writing scripts to handle data is your job :) I am just a simple Brummie with two O-levels and a CSE in woodwork. Support wrote: With the csv export, you'll need to wite a process e.g. an excel macro or python script to parse the data and extract the records you require. Many Thanks Support If I could do that, I suspect the entire day's sales, as they are, would do quite nicely. Thank you for your reply anyway, even though I still haven't figured out what you actually said. Posted By: Support Date Posted: 26 June 2018 at 2:17pm Hi, Essentially, we just export all the data we have. There is an infinite number of things you could do with it, so we don't get involved in that, we leave it up to you. You might want to have a play with excel or similar as you import the file and change it as required. Many Thanks Support Posted By: rscass Date Posted: 27 June 2018 at 10:21am I have made it workable by setting up an export definition and only exporting the fields I need for Royal Mail. Including Royal Mail's shipping code in the shipping service name (which the customer selects in the basket) will also help. It would just be easier to specify which sales to export rather than having to weed them out from a spreadsheet one by one. Perhaps you could give it some consideration in the future?

Print Page | Close Window