What's your biggest current challenge? Have your say in Community Polls along the right column.

Re: Order Export - Edited Orders

How can I track edited orders in my clothing store's CSV export?

AmyEmms
Visitor
3 0 6

I have the occasional customer request to change style or size of the clothes they order from my shop.

 

When I export the orders into CSV to create a work list, the original items I've removed still show as being part of the order and there's no way of easily seeing which items were removed. Is there a way of removing the item or tagging it in some way, so that these products can be recognised? 

 

It also becomes a nightmare when trying to work out how much has been sold of individual products, if these removed ones are still showing. Surely I'm doing something wrong and this isn't how it's been purposefully built? 

Replies 6 (6)

productsync
Shopify Partner
740 38 161

Hey

You are right in that the original order line remains and actually shows quantity 1 where it should be 0. You could edit the quantity to a random value like 999 but if you have inventory controls on than that won't be best option.

We found this problem ourselves developing one of our order processing integrations. One of our processes actually edits the order and removes the original line and replace with new ones. If it is a big issue we could work out an automation to help you with this process. You may not even need the csv file.

Regards

Tom

 

LukaszWiktor
Shopify Partner
315 24 124

Hi @AmyEmms,

I agree that it's confusing and troublesome that orders exported to CSV include removed items. I guess it wasn't purposefully built this way but it was an oversight from Shopify. When they added the ability to edit orders they didn't update the export feature.

Internally, in the Shopify API, order line items have 2 fields denoting quantity. There is quantity and fulfillable_quantity. Removed items have fulfillable_quantity set to 0, while the quantity field keeps the original quantity. Unfortunately, the built-in CSV export doesn't include the fulfillable_quantity field.

If you are open to solving this problem with an app, then you could use Exporteo. It's the app I developed to export orders in a customizable format, including fields not available in the build-in CSV export. I'm happy to help you with setting it up.

Hope this helps,
Lukasz

I'm a software engineer. I make things happen automatically.
Check out my apps Exporteo, Fulfilleo, Stockeo, and Personal Discount.
dooug
Excursionist
14 0 14

This is hugely problematic. 

My case:

1. I export orders to report what items I need to stock. 

2. The export includes orders' line items that have been removed. There's no indication of what has been removed or not. 

3. my numbers can possibly be accurate without me going through and fixing the numbers, which defeats the whole point of exporting data!

This is very disappointing. 

EuronicsIreland
Visitor
3 0 0

Hi Lukasz, 

Does your app solve this particular problem as listed? I am looking to get a report with products purchased and total amount paid by the customer, but without the Removed products. 

Thanks

LukaszWiktor
Shopify Partner
315 24 124

Hi @EuronicsIreland,

Yes, it's possible to set up Exporteo to export orders without removed items. The app includes a default CSV template. To exclude removed items, you just need to add a condition to check if the fulfillable quantity is greater than zero:

 

{%- for line_item in order.line_items %}
{%- if line_item.fulfillable_quantity > 0 %}
...
{%- endif %}
{%- endfor %}

 

LukaszWiktor_0-1634752270320.png

I'm happy to help you with the configuration if you don't feel comfortable with Liquid code.

Thanks,
Lukasz

I'm a software engineer. I make things happen automatically.
Check out my apps Exporteo, Fulfilleo, Stockeo, and Personal Discount.

iCodeDood
Visitor
2 0 5

Huge oversight by Shopify. Should be resolved