Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Exporting Order and Shipping address Data to Excel Rate Topic   - - - - -

 
  • jain1980
  • Senior Member
  • Members
  • Join Date: 16-Dec 08
  • 299 posts

Posted 01 June 2013 - 11:19 AM #1

We are automating our address label printing process and as per our Printing service provider, they need the printing data in CSV or Excel format. We need to export the following fields from the order data into a single excel file :

Order Number, First Name, Last Name, Address Line 1, Address Line 2, City, Pincode, State, Country, Phone number, Product Name, Product Options, Qty.

We would appreciate any help or pointers on how to achieve this in Cs-cart V 3.0.2.

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4662 posts

Posted 01 June 2013 - 11:31 AM #2

Admin>export>orders, select which fields you require and export awaaaaaay!.

John

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • jain1980
  • Senior Member
  • Members
  • Join Date: 16-Dec 08
  • 299 posts

Posted 01 June 2013 - 11:59 AM #3

Admin>export>orders, select which fields you require and export awaaaaaay!.

John


Thanks John. I had already tried that option but it has to be done in 2 separate excel files. Also we are getting a lot of other unwanted data in the extra fields when we export the order items although we need only the Product name, Qty and the product options (from the extras fields) from the data. Would it be possible to write a simple script to achieve this and export the required data into a single excel file?

 
  • McNeilis
  • Advanced Member
  • Members
  • Join Date: 11-Dec 13
  • 57 posts

Posted 23 January 2014 - 07:18 PM #4

I'm also interested in being able to export that exact data. I'm looking for a way to not have to do it in two separate files also. Has anyone found out how?

Maybe also an option to add weight or something? I'm looking to export orders and enter them into ShipStation.

 
  • zeero6
  • Senior Member
  • Members
  • Join Date: 25-Jan 07
  • 649 posts

Posted 23 January 2014 - 08:01 PM #5

So it can't be done by exporting all and than clean the excel file by removing the unwanted fields?
Just an idea.

Version 4.9.3 SP1


 
  • McNeilis
  • Advanced Member
  • Members
  • Join Date: 11-Dec 13
  • 57 posts

Posted 23 January 2014 - 08:11 PM #6

Well you can export all, but on the orders tab it has all the information to where the order would need to go. But no product info on what needs to be sent. That is on the order items tab. So when I go to export, they have to be two separate exports. They aren't going to an excel file for me either for some reason, but a notes tab program. Is there a way I can make it an excel file?

I could export it to two separate files and do some copying and pasting, but would rather not have the extra step.

I just don't know why it is in two separate tabs, I wish all the info would be in the available fields section and we could add and take away as we please.