All things Shopify and commerce
I'm considering migrating my small "hand built" website to Shopify.
I need to know if the CSV order export contains fields for Line Item Properties (custom product options) as well as normal product Variants (options).
The Shopify documentation doesn't make this clear to me.
I'm a small shop and really want to avoid paying $25 a month for an app to gain access to my data.
Thanks!
Solved! Go to the solution
This is an accepted solution.
Hello @eferg
Shopify native orders export does not contain Line Item Properties.
Normal product variants are exported as a part of "Lineitem name".
For example, "Lineitem name" would be "Test Product - Small / Blue", "Small" would be one option and "Blue" would be 2nd option.
If you are open to using apps, then you can use Excelify app to export your Orders to CSV or Excel XLSX file formats.
In Excelify exported Orders file, regular options would be in a separate column "Line: Variant Title" and custom options (properties) would be in "Line: Properties" column.
Here is an example how Order might look in Shopify:
And here are the same fields selected in the Excelify exported CSV file:
If you have any more questions please feel free to contact us directly by any means listed in our "Contact Us" page.
Thank you,
----------------
Renars
Excelify.io
This is an accepted solution.
Hello @eferg
Shopify native orders export does not contain Line Item Properties.
Normal product variants are exported as a part of "Lineitem name".
For example, "Lineitem name" would be "Test Product - Small / Blue", "Small" would be one option and "Blue" would be 2nd option.
If you are open to using apps, then you can use Excelify app to export your Orders to CSV or Excel XLSX file formats.
In Excelify exported Orders file, regular options would be in a separate column "Line: Variant Title" and custom options (properties) would be in "Line: Properties" column.
Here is an example how Order might look in Shopify:
And here are the same fields selected in the Excelify exported CSV file:
If you have any more questions please feel free to contact us directly by any means listed in our "Contact Us" page.
Thank you,
----------------
Renars
Excelify.io
Thanks Renars - Your Free version will work for my small shop as I'll not need to export more than 10 orders at a time.
eferg
Hey eferg,
Unfortunately, Shopify's built-in order CSV export doesn't include the Lineitem Properties data.
As for the variant options, they're merged together under the "Lineitem Name" field (basically "Product Title - Variant Title", where "Variant Title" is the combination of variant options separated by a "/") as Renars mentioned.
Our app EZ Exporter can export Lineitem Properties and Variant Options as well. You can also export all properties/options in one column or place each property/option in a separate column in the CSV/Excel file.
Please feel free to reach out to us if you have any questions about this.
Are you ready to take your business to the next level? Look no further than the latest ...
By SarahF_Shopify Apr 15, 2024We’re keeping the ball rolling to make sure you’re always ahead of the game. So buckle ...
By JasonH Apr 8, 2024Portrait of Stephen positioned next to an image of planet Earth, with the Stephen's World ...
By JasonH Mar 18, 2024