Hi!
I need to figure out a way to export orders from my shopify store with a column for which collection the item came from. For example: If somebody bought a Shirt from Collection 1 and a Hat from Collection 2, in the same order. The current export template shows all of the items ordered, per order, but does not distinguish which collection they were ordered from.
The ability to do this, by way of a column exception or 3rd party app, is essential to my business.
I’d appreciate any help!
Hi There,
What you are looking for doesn’t really exist, because that’s not the way products and collections work. Products can be part of multiple collections and Shopify doesn’t track which collection was viewed when added to the cart.
What is it about knowing the collection that makes it essential? There is probably a better day to achieve your goal.
The way our business works, we need to account for all products sold from each individual collection. Each collection represents a different client that’s allowing us to brand items for them and we need to be able to provide an accounting of which products sold and as we scale, having a sortable export, or a simple way to sort upon export, will be required.
The best way to handle this then would be to have some other indicator that represents the collection. For example, you could use vendor or a tag to represent the client. Then you could use smart collections to actually maintain the collections.
But you will never be able to report on the collection a product was sold from, because that’s not something Shopify tracks.
I can’t imagine i’m reinventing the wheel here. Is there no 3rd party app or other that will add a “collections” column to list it for each item sold? There’s no way my store is the first one that allows customers to buy products from different collections in the same order.
What happens if a product is in four collections? What would you expect to be exported for that product?
I totally understand that question. From our POV, our collections wouldn’t work like that. After much searching, one of my partners was just able to find a 3rd party app that exports that info we need.
This is not included in the basic order exports, though may be possible to use in reports( mainly just referrers).
Merchants can see the available columns here https://help.shopify.com/en/manual/orders/manage-orders/exporting-orders
Hi @GGLLC your looking for analytics, or attribution, either through the urls used (ala referrer, or sourceName order property for web or POS or drafts etc , utm parameters, etc etc etc).
Or passed into the order as line-item-propertes, or as cart-attributes; or in some cases a free utility-product added to the order to indicate some sort of state.
If you need more advanced order exports, there’s matrixify , ez-exporter, etc for spreadsheet centric workflows.
For really bespoke data exports see automation apps shopify-flow(export info to googlesheets or a http api) or more advanced usemechanic https://tasks.mechanic.dev/?q=order%20csv
Good Hunting.
Hi @PaulNewton
Thank you for mentioning Matrixify app here.
Indeed you can use our app to export Orders data from your Shopify store, though currently, we do not export what collections data for the Orders export.
@GGLLC I will sure note this on our side for future developments, but to better understand your specific requirements, would it work for you to just see what collections the purchased product is currently in at the time of doing the export?
The issue here is that this would not show historic data, for example, if collections have changed for the products since the order was placed. Shopify does not natively store this data or provide in the Orders API, so really apps could only get the current line items linked Products collections.
Hi there @GGLLC ,
Based on your requirements, we can create a report that shows the associated collections of products along with the order name for any particular date. If this is what you’re looking for, install Report Pundit on a free trial, and we can set up this report for you to export.
Please feel free to ask if you have any more questions.
Cheers!
Team Report Pundit