When Exporting Order Items, Same Item Appears But In Different Languages

General General Questions
1

Hi

Currently I’m using two languages in my store.

The problem I encountered is that when I export order items,

the same item appears twice in different languages.

E.G.

			
Order ID

		
		
			
Item ID

		
		
			
Date

		
		
			
Store

		
		
			
Note

		
		
			
First Name

		
		
			
Last Name

		
		
			
User Id

		
		
			
Billing Country

		
		
			
Billing Zipcode

		
		
			
Billing State

		
		
			
Billing Address

		
		
			
Billing Address2

		
		
			
Billing Phone

		
		
			
Email

		
		
			
Shipping Firstname

		
		
			
Shipping Lastname

		
		
			
Shipping Country

		
		
			
Shipping Zipcode

		
		
			
Shipping State

		
		
			
Shipping Address

		
		
			
Shipping Address2

		
		
			
Shipping Phone

		
		
			
Payment Id

		
		
			
Shipping Id

		
		
			
Subtotal

		
		
			
Total

		
		
			
Shipping Cost

		
		
			
Payment Surcharge

		
		
			
Discount

		
		
			
Detail

		
		
			
Status

		
		
			
Product code

		
		
			
Product Name

		
		
			
Price

		
		
			
Quantity

		
		
			
Product Options Variants

		
	
			
1388

		
		
			
1110503342

		
		
			
1489140477

		
		
			
1

		
		
			
 

		
		
			
日本

		
		
			
太郎

		
		
			
1

		
		
			
JP

		
		
			
107-0052

		
		
			
東京都

		
		
			
赤坂1-2-34

		
		
			
CS第二ビル7F

		
		
			
01-2345-6789

		
		
			
shota.irieda@mebuku.co.jp

		
		
			
日本

		
		
			
太郎

		
		
			
JP

		
		
			
107-0052

		
		
			
東京都

		
		
			
赤坂1-2-34

		
		
			
CS第二ビル7F

		
		
			
01-2345-6789

		
		
			
6

		
		
			
8

		
		
			
730

		
		
			
2470

		
		
			
1740

		
		
			
0

		
		
			
0

		
		
			
 

		
		
			
O

		
		
			
B00F3IUN27

		
		
			
Packard Bell OneTwo

		
		
			
730

		
		
			
1

		
		
			
 

		
	
			
1388

		
		
			
1110503342

		
		
			
1489140477

		
		
			
1

		
		
			
 

		
		
			
日本

		
		
			
太郎

		
		
			
1

		
		
			
JP

		
		
			
107-0052

		
		
			
東京都

		
		
			
赤坂1-2-34

		
		
			
CS第二ビル7F

		
		
			
01-2345-6789

		
		
			
shota.irieda@mebuku.co.jp

		
		
			
日本

		
		
			
太郎

		
		
			
JP

		
		
			
107-0052

		
		
			
東京都

		
		
			
赤坂1-2-34

		
		
			
CS第二ビル7F

		
		
			
01-2345-6789

		
		
			
6

		
		
			
8

		
		
			
730

		
		
			
2470

		
		
			
1740

		
		
			
0

		
		
			
0

		
		
			
 

		
		
			
O

		
		
			
B00F3IUN27

		
		
			
パッカード・ベル OneTwo

		
		
			
730

		
		
			
1

I want the above to be like:

			
Order ID

		
		
			
Item ID

		
		
			
Date

		
		
			
Store

		
		
			
Note

		
		
			
First Name

		
		
			
Last Name

		
		
			
User Id

		
		
			
Billing Country

		
		
			
Billing Zipcode

		
		
			
Billing State

		
		
			
Billing Address

		
		
			
Billing Address2

		
		
			
Billing Phone

		
		
			
Email

		
		
			
Shipping Firstname

		
		
			
Shipping Lastname

		
		
			
Shipping Country

		
		
			
Shipping Zipcode

		
		
			
Shipping State

		
		
			
Shipping Address

		
		
			
Shipping Address2

		
		
			
Shipping Phone

		
		
			
Payment Id

		
		
			
Shipping Id

		
		
			
Subtotal

		
		
			
Total

		
		
			
Shipping Cost

		
		
			
Payment Surcharge

		
		
			
Discount

		
		
			
Detail

		
		
			
Status

		
		
			
Product code

		
		
			
Product Name

		
		
			
Price

		
		
			
Quantity

		
		
			
Product Options Variants

		
	
			
1388

		
		
			
1110503342

		
		
			
1489140477

		
		
			
1

		
		
			
 

		
		
			
日本

		
		
			
太郎

		
		
			
1

		
		
			
JP

		
		
			
107-0052

		
		
			
東京都

		
		
			
赤坂1-2-34

		
		
			
CS第二ビル7F

		
		
			
01-2345-6789

		
		
			
shota.irieda@mebuku.co.jp

		
		
			
日本

		
		
			
太郎

		
		
			
JP

		
		
			
107-0052

		
		
			
東京都

		
		
			
赤坂1-2-34

		
		
			
CS第二ビル7F

		
		
			
01-2345-6789

		
		
			
6

		
		
			
8

		
		
			
730

		
		
			
2470

		
		
			
1740

		
		
			
0

		
		
			
0

		
		
			
 

		
		
			
O

		
		
			
B00F3IUN27

		
		
			
パッカード・ベル OneTwo

		
		
			
730

		
		
			
1

Is there a way to limit to only one language?

This does not happen when I export products.

Thank you in advance.

2

Sorry, the table didn't come out right.

Please ignore the E.G.

Basically, when I export order items, same item gets exported twice since I'm using two languages.

I want to limit this to one language. Please advise.

Thank you in advance.

3

You can open generated file in Excel, sort items by Language and delete unnecessary items

4

Seems like the export should allow one to select either the store language or the cart language. I.e.the default language of the store or the language the order was placed in. Not sure I understand the usefulness of exporting order items once for each language....