1. mile2tech
  2. RO CSVI
  3. Friday, 06 January 2017
  4.  Subscribe via email
Hi,
I have this strange problem. The guy order 3 products at once but only one product is extract to our shipping company. How to change this or fix it?

For example: Product 1, Product 2 Product 3 order

When we extract this orders inside the CSV file we see only Product 1

Thanks
Accepted Answer Pending Moderation
Before the system will just create the same orders with the same number but with different products inside order_item_sku, But now is only one. I guess this is because of the patch i apply here:

https://csvimproved.com/forum?view=topic&catid=44&id=33625

So can we fix that in some way?

Re: Is not from the patch i just test with the original file and is exporting only one product per order
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
In the old system

8463 code 1 name 2address. Alpena Michigan 49707 United States Phone email 8 Credit Card C FedEx Company Inc. CPTE -KIT
8463 code 1 name 2address. Alpena Michigan 49707 United States Phone email 8 Credit Card C FedEx Company Inc. CISSO -KIT

Now we see only one

8463 code 1 name 2address. Alpena Michigan 49707 United States Phone email 8 Credit Card C FedEx Company Inc. CPTE -KIT
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Have a look at the Group by and sort by fields documentation. You may have it group by a field that is not unique enough, causing items to disappear.
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
Accepted Answer Pending Moderation
My group is by virtuemart_order_id. What you suggest to be my group filed?


This are my fields

1 virtuemart_order_id
2 order_number
3 product_quantity
4 full_name
5 address_1
6 address_2
7 city
8 state_name
9 zip
10 country_name
11 phone_1
12 email
13 virtuemart_shipmentmethod_id
14 payment_name
15 order_status
16 shipment_name
17 company
18 order_item_sku

I try order_number and full_name also but is not working
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
I change Group to Sort fields by virtuemart_order_id and i think is working now
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,

The virtuemart_order_id is still the same if you have multiple records but you can group on multiple fields as well. So a good combination is virtuemart_order_id and order_item_sku as well I think.
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. # 6
  • Page :
  • 1


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