Categories
View Replies (12)

Resolved Picking List Anomaly

  1. Monica7
    Monica7
  2. RO CSVI
  3. Tuesday, 31 May 2016
  4.  Subscribe via email
Am finalizing a picking list for Virtuemart,

Fields used are:

order_number
full_name
product_quantity
order_item_sku

With no Grouping or Sorting the export is returning 2 of all items purchased.

Have refined results greatly by using a variety of grouping and sorting combinations yet the exports / order history are still not a 100% match.

Any suggestions here?

Mon
0
Responses (12)
rolandd
rolandd
Accepted Answer Pending Moderation
Glad to hear all is fixed.

Looks like I'm all done now, so probably won't chat for another year or so
Oh the loneliness :dry:
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. # 1
Monica7
Monica7
Accepted Answer Pending Moderation
No... I sent mine without seeing that :)

Good news. Your virtuemart_order_item_id trick has fixed it.

Great stuff! :laugh:

Thanks for all your help.

Looks like I'm all done now, so probably won't chat for another year or so - Thanks again! ;)
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Mon,

Did you see my reply?

The reason is the SQL query, there are no duplicates in the fields if you check all the fields the database sees. That is why we need to apply the correct grouping.
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. # 3
Monica7
Monica7
Accepted Answer Pending Moderation
Tharuna,

Before I do that, if I drop it into Excel and hit Remove Duplicates it's perfect (ends up with exactly half the rows & is a perfect match to our order history).

Any idea what setting could be causing it to output 2 of everything?

Mon
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Mon,

Just another thought, add the field virtuemart_order_item_id to your template but set the state to unpublished since you don't want it to show up in the export file. Set the group by field to the virtuemart_order_item_id. Run the export after that and let me know how it goes.
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. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I need to look into your database records to help you more here. Can you send me a private message of the database dump of your virtuemart tables? I will have a look at it.
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. # 6
Monica7
Monica7
Accepted Answer Pending Moderation
Adding grouping by virtuemart_product_id and virtuemart_order_id returns 1 line/1 item per order only regardless of how many items were purchased...
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
How about adding both virtuemart_product_id and virtuemart_order_id to group by fields?
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. # 8
Monica7
Monica7
Accepted Answer Pending Moderation
It does help but am still getting 2 of every item... So if a customer ordered one item it's shown twice on two separate lines...
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Monica,
Try to add group by field as virtuemart_product_id and sort by order_number, i think that should 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. # 10
Monica7
Monica7
Accepted Answer Pending Moderation
Hi Tharuna,

I tried your suggested grouping and sorting but the export excluded multiple items (only one item was shown per order).

The attached were created without any grouping or sorting.

Mon
Attachments (2)
item-anomaly.gif item-anomaly.gif
com_csvi.log.84.zip
  1. more than a month ago
  2. RO CSVI
  3. # 11
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you try to add group by field as virtuemart_order_id and sort by order_number and see if it solves the duplicates? If not post the debug log of the export and the sample export file here to check.
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. # 12
  • Page :
  • 1


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