Shopware resources and help articles

Simple and to the point. Optimized by the community.

Export UUIDs in CSV Friendly Format

0
by Thomas Holm Thomsen, last modified on September 11th, 2021

When exporting data fra the Shopware database to CSV, the Shopware binary IDs will not be readable in the CSV by default.

Add Lower(Hex(id)) in the select query to convert the IDs to readable Hex.

Example:

SELECT Lower(Hex(`id`))
FROM   `product`

Discussion

0 comments

We use cookies to measure the performance of this website. Do you want to accept these cookies?