VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: malik0206 on March 06, 2015, 13:34:23 PM

Title: VM3 Export Order CSV format for fulfilment companies
Post by: malik0206 on March 06, 2015, 13:34:23 PM
Hi Guys

Can anyone please point me to the right direction...i'm currently trying to export all the order in to CSV file format which needs to be sent to a fulfilment company so need full order details

   Product Name
   Sizes
   Stock levels (per size)
   SKU
   Barcode
   Price
   Full Billing Address
   Full Delivery Address

I have searched for an order export component but found none so far, if you know of any please let me know or if anyone can build me a component to do this then also please message me

Thanks

I need this ASAP

Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: GJC Web Design on March 07, 2015, 01:48:24 AM
have done this for other clients .. e.g. as an admin module  - click to export as a csv file
various settings possible

Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: frisco75 on April 14, 2015, 17:26:36 PM
Quote from: GJC Web Design on March 07, 2015, 01:48:24 AM
have done this for other clients .. e.g. as an admin module  - click to export as a csv file
various settings possible
I am interested too, I would like to export the data of orders (#order,name of customer, adress, shipping adress, products, prices, etc). Is it possible ?
Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: jenkinhill on April 14, 2015, 18:00:04 PM
As said so many times. CSVI.  http://www.csvimproved.com
Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: frisco75 on April 14, 2015, 18:18:37 PM
Quote from: jenkinhill on April 14, 2015, 18:00:04 PM
As said so many times. CSVI.  http://www.csvimproved.com
I m sorry but are you sure ? Because i take a look before on their website and I saw that the fields to export were :
Product Description
Product Dimensions
Product Images
Product Information
Product Internal Note
Product Meta Information
Product Pricing
Product Status
Shipment method
Shipment method Configuration
And i didn't see about the name of the shopper, # of the order, etc
Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: jenkinhill on April 14, 2015, 20:30:33 PM
You did not see this?  http://www.csvimproved.com/en/support/export/930-advanced-order-xml-export
Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: frisco75 on April 14, 2015, 21:00:16 PM
Quote from: jenkinhill on April 14, 2015, 20:30:33 PM
You did not see this?  http://www.csvimproved.com/en/support/export/930-advanced-order-xml-export

I saw that, Kelvyn ! But I saw also that it export it as an .xml and i want it as a .csv because i use it after in Excel.  I was working before with Interaminds Reports but it is not available for VM3.
Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: jenkinhill on April 14, 2015, 21:03:17 PM
That is just an example of some of the data that can be exported. You choose the format of the output data.
Title: Re: VM3 Export Order CSV format for fulfilment companies
Post by: frisco75 on April 14, 2015, 21:11:27 PM
Quote from: jenkinhill on April 14, 2015, 21:03:17 PM
That is just an example of some of the data that can be exported. You choose the format of the output data.

Ahhhhhh thanks a lot, Kelvyn  ;-)