1. Richard
  2. RO CSVI
  3. Monday, 30 March 2020
  4.  Subscribe via email
Hi.
I am interested in RO CSVI.
i need to find a component that will export the following fields from Virtuemart
First name - Last Name - Shipping Address 1 - Shipping address city - Shipping address postcode - Product name - SKU - Price - Product weight

I have tried the demo trying to export an order "Example VirtueMart Order Export" but it doesnt seem to have the fields at the top of the spreadsheet that relate to an order at all. The only columns it seems to export that i need are the price and the Sku - nothing about address or even name of the customer?

Am i doing it wrong or is it because there are no orders in the demo?
Attachments (1)
Accepted Answer Pending Moderation
Hello,
Am i doing it wrong or is it because there are no orders in the demo?

Yes it is because there are no orders on demo site.

You can import an order in VirtueMart using Example VirtueMart Order Import template and then export it using Example VirtueMart Order Export template on demo site. You can use the sample import file from VirtueMart Order import document for import.

Let me know if you need any more clarifications.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
The sample imnport csv doesnt open?

https://rolandd.com/images/rocsvi/order.csv
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
You are not able to download the file from the link or open the downloaded file?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
It must have been a Chrome thing, i have downloaded it in Firefox but there is not enough content in the csv for me to see if this works.
Is it possible to get a decent demo of this without all this back and forwards messaging please?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
I have imported few order records on demo site. You can now run the export with Example VirtueMart Order Export template. Our demo site resets every 6 hours so you may need to check the export before the reset happens else the imported records will be removed. Let me know if you need any more help.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
The export i get is still empty - here is a video of my process am i doing it wrong?

https://share.getcloudapp.com/6quB4A6m
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
The user address information you are looking for can be exported using Example VirtueMart Order Export template but you are using Example VirtueMart Order item Export template in your video and so export is empty. Please select Example VirtueMart Order Export and run the export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Yes noted and got that right this time but still getting an empty csv is this the one you populated?

https://share.getcloudapp.com/BluB6e1p
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Yes that is the one i populated. Can you try the export now? I see 5 records on export(Screenshot attached).
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Ok yes thanks i got the data this time.
I cant see any settings anywhere like for instance the range of export ie : download the last 24hrs of orders etc - are there any variables available?
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
I cant see any settings anywhere like for instance the range of export ie : download the last 24hrs of orders etc - are there any variables available?

Yes, you can see those settings in template. To see that go to RO CSVI Templates page, in the filter search box enter Example VirtueMart Order Export, this will list out Order export template, click on the name of the template and look for Options tab. Click on the tab to see the options available for Order export. Date range field is for exporting order based on range.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Yes i can see that now thank you.
In the Fields tab i can see the list of available fields and have searched through the Template fields list where i can unpublish etc the ones now needed, there dont appear to be the following in there that i would need to be able to upload them to the UK Royal Mail website:

First name (ok) - Last Name (only give full name?) - Shipping Address 1 (ok) - Shipping address city (ok) - Shipping address postcode (zip i assume so ok) - Product name (is this Title? ) - SKU (Not found??) - Price (is this order_total ?? ) - Product weight (not found)


So from the above there doesnt appear to be the option to export the SKU or the Weight, apart from some other issues?

Is this correct or achievable please?
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
The fields on Fields tab are for demo purpose and you can add more fields to the export. Click on Edit template fields button on Fields tab, it will take you to RO CSVI Template fields page where you can add more fields to export template. You can check and add the available fields for the export template by clicking on Quick add button on top or by clicking New button.

First name (ok) - Last Name (only give full name?) - Shipping Address 1 (ok) - Shipping address city (ok) - Shipping address postcode (zip i assume so ok) - Product name (is this Title? ) - SKU (Not found??) - Price (is this order_total ?? ) - Product weight (not found)

For SKU you can use product_sku or order_item_sku field, for Product weight use product_weight field and for Price if you are looking for total order price then you can use order_total and if you are looking for product price you can use product_item_price.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hi I have bought the product now and making good progress.
I have setup the fields as i need them - 9 columns.

Product name is set to title - this isnt working what should i use for this?
I have about 10 orders for today which i have done a test export from, each order might have a few products within it. the csv file is running to cell 1141 !!!
Obviously i have somethign setup wrong, is it obvious to you from the description or would you need to have a look?
thanks
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Annie,
Product name is set to title - this isnt working what should i use for this?

You need to use order_item_name field to get Product name

I have about 10 orders for today which i have done a test export from, each order might have a few products within it. the csv file is running to cell 1141 !!!

In your VirtueMart Order export template settings on File tab set Text enclosure field to ", save the template and run the export. See if that helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Thanks product name is now working.

This time though i got 1825 columns !! If i upload the csv to here is it seen by everyone?
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello Annie,
I have set this post to private, your files will not be seen by anyone. Please post your export file, export debug log and template XML to check.

To get the debug log check How to collect debug information? document.

To get your template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select your export template and download the XML file. Post the XML file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!