Categories
View Replies (25)

Resolved Export orders based on Order status

  1. MesquiteMan
    MesquiteMan
  2. RO CSVI
  3. Friday, 19 February 2016
  4.  Subscribe via email
Joomla! 3.4.8, VM 3.0.12, CSVIPro 6.5.2, CSVI VM Plugin 6.5.2

I use a program called shipworks to manage my shipping. When I ship an item with shipworks, it connects directly to the VM database and changes the order status to shipped but the Status of ordered products stays what it was before. Unfortunately, there is no way around this. Is it possible to do an export of orders and their items based on the order status, then make changes to the Status of ordered products and import so that the Status of ordered products is updated to be the same as the order status? If so, can you tell me what VM choice to make and what fields are to be used?

I have tried with a template using VM Order Items and there is a field there called order status. I use it to filter for certain order status codes such as shipped but it returns orders that have an order status of shipped but where the Status of ordered products is confirmed. I was under the impression that order status was the order status, not the Status of ordered products. If I can do an export of all the orders with a status of shipped with all of their Status of ordered products, then I can make the change of the Status of ordered products to shipped and re-upload. Then I will be able to get the data I am looking for.

Here you can see the fields I have chosen for my template. It is returning the Status of ordered products rather than the order status on export.
status.jpg

This is what I am calling the Status of ordered products:
productstatus.jpg

This is what I want to be able to filter by:
status1.jpg
0
Responses (25)
MesquiteMan
MesquiteMan
Accepted Answer Pending Moderation
Oh yeah, in case you question it, after doing this one, I deleted it and created a new one. This time I added the VM Order ID filed and placed it at the top in case that matters. Still got the same results.
  1. more than a month ago
  2. RO CSVI
  3. # 21
MesquiteMan
MesquiteMan
Accepted Answer Pending Moderation
I have been using CSVI since way back in VM1.1 days! I like having the code and the status name. Don't know why but I do!

If I do a template using operation=order rather than order items, I should be able to get the information I need, correct? At least the available fields make it look like I could. However, when I choose one item to filter by, I get a HUGE long list of the same item shown. Here are screen shots:

Here is how I have the operations section set
operations.jpg

Here are the fields I have chosen
fieldsnew.jpg

Here is the filter contents:
selection.jpg

I forgot to get a shot but I clicked on the last item CJC1R. I then clicked save and when I came back to the options page, I have a HUGE list of duplicate entries of the same item. For the screen shot, I zoomed as far out as Firefox will allow and it still will not all fit on the screen!
longlist.jpg

Of course if I try the export, I get a no data results.
Attachments (4)
operations.jpg operations.jpg
fieldsnew.jpg fieldsnew.jpg
longlist.jpg longlist.jpg
selection.jpg selection.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

This gets confusing with the similar names.
Very much so :)

When I do the export, I get the product status, not the order status.
Correct because there is no field to export the order status only the product status.

You are not doing anything wrong. The order item export does not export the order status only the product status. The order export only exports the order status.

I need the order status. For my export, I need the product sku, product name, customer name, date, order id, and order status.
That cannot be done as it is now. The order status is not available in the order item export at this point. I can look into adding it in. Also need to think of an appropriate name as order_status is already in use ;)

In your list of fields you can omit either order_status or order_status_name because they are the same thing. The order_status is just the code and the order_status_name is the full name of the order status.
Kind regards,

RolandD

=========================
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. # 23
MesquiteMan
MesquiteMan
Accepted Answer Pending Moderation
Roland,

This gets confusing with the similar names. Let's call it the order status. This is the overall status of the order itself. Let's call the order status beside each item when you open the order in VM the product status.

When editing the template, in the operation section, I have the action=Export, Component=Virtuemart, and operation=order item. For fields I have the following:
fields1.jpg

When I do the export, I get the product status, not the order status. I need the order status. For my export, I need the product sku, product name, customer name, date, order id, and order status.

What am I doing wrong?
Attachments (1)
fields1.jpg fields1.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 24
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Is it possible to do an export of orders and their items based on the order status, then make changes to the Status of ordered products and import so that the Status of ordered products is updated to be the same as the order status?
You can do an export of the order items, not the order export. This has a filter called Order status which you can set to the status of the order items you want. The export will then export only the order items that match the set status.

You will need to export the fields order_item_sku, virtuemart_order_id, order_status_name (or order_status). These are the minimal fields you need to run the import. In your exported file you only need to change the value of the order_status_name (or order_status).

If I can do an export of all the orders with a status of shipped with all of their Status of ordered products
This is not possible, the order export does not export the status of individual order items.

Then I will be able to get the data I am looking for.
Can you use the scenario I explained above?
Kind regards,

RolandD

=========================
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. # 25
  • Page :
  • 1
  • 2


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